SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt1 ON ( wp_tota44soje_posts.ID = mt1.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt2 ON ( wp_tota44soje_posts.ID = mt2.post_id ) WHERE 1=1 AND ( wp_tota44soje_postmeta.meta_key = 'wpcf-price' AND ( ( mt1.meta_key = 'wpcf-ribbon' AND mt1.meta_value IN ('Active','Under Contract','Sold') ) AND ( mt2.meta_key = 'wpcf-listing-type' AND mt2.meta_value = 'resale' ) )) AND wp_tota44soje_posts.post_type = 'properties' AND ((wp_tota44soje_posts.post_status = 'publish')) GROUP BY wp_tota44soje_posts.ID ORDER BY FIELD(mt1.meta_value, 'Active', 'Under Contract', 'Sold'), CAST(wp_tota44soje_postmeta.meta_value AS SIGNED) DESC LIMIT 0, 9
38
Array ( [ffd_listing_title] => Array ( [0] => Ocean Residences B-302 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-4782 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKnePQAT ) [ffd_totalarea_pb] => Array ( [0] => 2681 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 3 ) [wpcf-bedrooms] => Array ( [0] => 3 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Ocean Residences ) [ffd_createddate] => Array ( [0] => 2022-12-23T23:00:25.000+0000 ) [ffd_days_on_market] => Array ( [0] => 163 ) [ffd_description_pb] => Array ( [0] => The Ocean Residences at Querencia bring you closer than ever before to the Sea of Cortez. With breathtaking unobstructed sea views, B-302 is the first resale opportunity within the completely sold-out project. The third-floor condominium features an airy, open floorplan and floor-to-ceiling glass doors that flow to the spacious terrace overlooking the Querencia Beach Club. This 3-bedroom residence features an additional office space and is artfully planned to invite the seascape in. Fully furnished by Giotto Mendini. This unit is under construction and is projected to be completed by July 2023.Ocean Residences B-302 Condominium 5,400,000 USD | 97,524,000 MXN | 2,681 A/C SQ FT 3 Beds 3 Full Baths 1 Half Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family.
) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-06-03T19:32:19.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0769 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 5400000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70915 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-4782 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 2681 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKnePQAT ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Ocean Residences B-302 ) [wpcf-squarefeet] => Array ( [0] => 3237 ) [wpcf-view] => Array ( [0] => Oceanfront ) [wpcf-price] => Array ( [0] => 5400000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Oceanfront Ocean Residences B-302 Condominium 22-4782ResaleOcean ResidencesActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9556 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/ocean-residences-b-302/ ) [ffd_media] => Array ( [0] => a:11:{i:0;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/6k3v19ckn/11.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/gkgexk6vp/1.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/ygury4wz5/12.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/pt0lxo4vn/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/z6hji5v2f/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/4sgsdwkdk/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/3ucv6yxss/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/1x9bvnqu6/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/ii568kby7/7.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/qu3fenj1x/8.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/44ex6024q/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/6k3v19ckn/11.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKnePQAT ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_wp_old_slug] => Array ( [0] => ocean-residences-b-302-2 ) [_edit_lock] => Array ( [0] => 1685982710:19 ) [_edit_last] => Array ( [0] => 10 ) [_wpcf-propertybase-id] => Array ( [0] => field_6241d7e8a5172 ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_wpcf-property-type] => Array ( [0] => field_6241d82da5173 ) [_wpcf-view] => Array ( [0] => field_6241d8dca5174 ) [_wpcf-resale] => Array ( [0] => field_6241dab0a5175 ) [wpcf-neighborhood-subset] => Array ( [0] => ) [_wpcf-neighborhood-subset] => Array ( [0] => field_6241daefa5176 ) [_wpcf-ribbon] => Array ( [0] => field_6241db32a5177 ) [wpcf-lotnumber] => Array ( [0] => ) [_wpcf-lotnumber] => Array ( [0] => field_6241dbaea5178 ) [_wpcf-lotsize] => Array ( [0] => field_6241dbe2a5179 ) [_wpcf-lot-size-sqm] => Array ( [0] => field_6241dbffa517a ) [_wpcf-price] => Array ( [0] => field_6241dc18a517b ) [wpcf-start-price] => Array ( [0] => ) [_wpcf-start-price] => Array ( [0] => field_6241dc2ea517c ) [wpcf-end-price] => Array ( [0] => ) [_wpcf-end-price] => Array ( [0] => field_6241dc3ea517d ) [_wpcf-mls] => Array ( [0] => field_6241dc64a517e ) [wpcf-spec-sheet-file] => Array ( [0] => ) [_wpcf-spec-sheet-file] => Array ( [0] => field_6241dc7da517f ) [wpcf-video] => Array ( [0] => ) [_wpcf-video] => Array ( [0] => field_6241dcd3a5180 ) [_wpcf-squarefeet] => Array ( [0] => field_6241dd3527de8 ) [_wpcf-acarea] => Array ( [0] => field_6241dd8327de9 ) [_wpcf-bedrooms] => Array ( [0] => field_6241dde8b5fa0 ) [_wpcf-bathrooms] => Array ( [0] => field_6241de2bb5fa1 ) [_wpcf-half-bathrooms] => Array ( [0] => field_6241de60b5fa2 ) [wpcf-basement] => Array ( [0] => ) [_wpcf-basement] => Array ( [0] => field_6241de7fb5fa3 ) [wpcf-garage] => Array ( [0] => ) [_wpcf-garage] => Array ( [0] => field_6241dec1b5fa4 ) [wpcf-isfurnished] => Array ( [0] => ) [_wpcf-isfurnished] => Array ( [0] => field_6241df25b5fa5 ) [wpcf-otherroom] => Array ( [0] => ) [_wpcf-otherroom] => Array ( [0] => field_6241df6db5fa6 ) [wpcf-features] => Array ( [0] => ) [_wpcf-features] => Array ( [0] => field_6241dfacb5fa7 ) [wpcf-notes] => Array ( [0] => ) [_wpcf-notes] => Array ( [0] => field_6241dfd3b5fa8 ) [_wpcf-latitude] => Array ( [0] => field_6241e02bb5fa9 ) [_wpcf-longitude] => Array ( [0] => field_6241e04cb5faa ) [_wpcf-agent-1] => Array ( [0] => field_6241e06fb5fab ) [wpcf-agent-2] => Array ( [0] => ) [_wpcf-agent-2] => Array ( [0] => field_6241e080b5fac ) [_wpcf-keywords] => Array ( [0] => field_6241e099b5fad ) [_wpcf-highlights] => Array ( [0] => field_6241e0beb5fae ) [_wpcf-property-features] => Array ( [0] => field_6241e0e0b5faf ) [wpcf-floorplan] => Array ( [0] => ) [_wpcf-floorplan] => Array ( [0] => field_6241e0f7b5fb0 ) [wpcf-siteplan] => Array ( [0] => ) [_wpcf-siteplan] => Array ( [0] => field_6241e112b5fb1 ) [wpcf-brochure] => Array ( [0] => ) [_wpcf-brochure] => Array ( [0] => field_6241e12fb5fb2 ) [wpcf-close-date] => Array ( [0] => ) [_wpcf-close-date] => Array ( [0] => field_6241e145b5fb3 ) [_wpcf-listing-type] => Array ( [0] => field_6241e176b5fb4 ) [_ffd_community] => Array ( [0] => field_62ab426441a36 ) [wpcf-feature-subtitle] => Array ( [0] => ) [_wpcf-feature-subtitle] => Array ( [0] => field_6241e7194766a ) [wpcf-introduction] => Array ( [0] => ) [_wpcf-introduction] => Array ( [0] => field_6241e73e4766b ) [wpcf-tripple-icon] => Array ( [0] => default ) [_wpcf-tripple-icon] => Array ( [0] => field_6241e7634766c ) [_yoast_wpseo_content_score] => Array ( [0] => 90 ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [_yoast_wpseo_wordproof_timestamp] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 97524000 ) )
Array ( [ffd_listing_title] => Array ( [0] => Verandas B-302 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KJtEPQA1 ) [ffd_totalarea_pb] => Array ( [0] => 3877 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_createddate] => Array ( [0] => 2023-05-08T15:56:32.000+0000 ) [ffd_days_on_market] => Array ( [0] => 14 ) [ffd_description_pb] => Array ( [0] => This beautiful collection of multi-family condominium homes are located just steps away from Querencia's world-class Clubhouse Village, making our amenities truly an extension of your Las Verandas home. Encompassing spectacular panoramic ocean, golf and desert views, this luxurious 4-bedroom condominium is beautifully appointed along with its incredible vistas it also offers elevated service and worry free living. Offering a spacious open floor plan which flows to the generous outdoor living spaces. The gourmet kitchen is finished with the finest materials for any chef to make this space their own. Veranda B-302 is move in ready, fully furnished.Verandas B-302 Verandas Condominium 4,000,000 USD | 72,240,000 MXN | 3,877 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-05-23T00:50:42.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03063 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 4000000 ) [ffd_listing_price_pesos] => Array ( [0] => 72240000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.7507 ) [ffd_community_lot_number] => Array ( [0] => 2302 ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3877 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KJtEPQA1 ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas B-302 ) [wpcf-squarefeet] => Array ( [0] => 4861 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 4000000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas B-302 Condominium ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9638 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-b-302-2/ ) [ffd_media] => Array ( [0] => a:25:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/dahb4glv6/A-TEMPLATE%20WEBSITE16.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/sgxlsvry9/A-TEMPLATE%20WEBSITE20.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/eucauu5qh/A-TEMPLATE%20WEBSITE11.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/gorbc6sco/A-TEMPLATE%20WEBSITE12.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/gxxjn8t8w/A-TEMPLATE%20WEBSITE9.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/m3vnpd4id/A-TEMPLATE%20WEBSITE.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/wttq53qph/A-TEMPLATE%20WEBSITE10.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/zy3z0h6mm/A-TEMPLATE%20WEBSITE13.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/3pctg1b87/A-TEMPLATE%20WEBSITE14.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/2qehg9n52/A-TEMPLATE%20WEBSITE19.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/i818f2ild/A-TEMPLATE%20WEBSITE18.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/i2klrn56v/A-TEMPLATE%20WEBSITE17.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/udahxn2od/A-TEMPLATE%20WEBSITE15.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/ytdgeu9rd/A-TEMPLATE%20WEBSITE6.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/62nsikzvs/A-TEMPLATE%20WEBSITE5.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/3miz9cft5/A-TEMPLATE%20WEBSITE3.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/u71788q9v/A-TEMPLATE%20WEBSITE2.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/pqgopzvpc/A-TEMPLATE%20WEBSITE7.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/qfmtmkdeo/A-TEMPLATE%20WEBSITE8.jpg";i:19;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/9rqxgugxs/A-TEMPLATE%20WEBSITE4.jpg";i:20;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/5txqj8i4r/A-TEMPLATE%20WEBSITE27.jpg";i:21;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/nbtqvcmny/A-TEMPLATE%20WEBSITE8.jpg";i:22;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/etwn0jnbx/A-TEMPLATE%20WEBSITE32.jpg";i:23;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/husqv950v/A-TEMPLATE%20WEBSITE3.jpg";i:24;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/6ihwuf0s5/A-TEMPLATE%20WEBSITE30.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/dahb4glv6/A-TEMPLATE%20WEBSITE16.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KJtEPQA1 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [ffd_listing_title] => Array ( [0] => Verandas A-301 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KJsQjQAL ) [ffd_totalarea_pb] => Array ( [0] => 3056.04 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_createddate] => Array ( [0] => 2023-05-04T21:22:33.000+0000 ) [ffd_days_on_market] => Array ( [0] => 18 ) [ffd_description_pb] => Array ( [0] => This fully-furnished Verandas Penthouse maintains its Latin roots with a fun, colorful, cozy transitional style that is synonymous with Mexico! The living room features lofty 13' coffered ceilings, a charming kitchen and living area that expands seamlessly onto a shaded terrace, capturing the azure waters of the Sea of Cortez. Veranda A-301 has custom finishes and features throughout, located steps away from Querencia´s world-class Clubhouse Village, making the amenities truly an extension of your home.Verandas A-301 Verandas Condominium 3,495,000 USD | 63,189,600 MXN | 3,056 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-05-22T16:41:29.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03094 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3495000 ) [ffd_listing_price_pesos] => Array ( [0] => 63189600 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.75024 ) [ffd_community_lot_number] => Array ( [0] => 301.3 ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3056 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KJsQjQAL ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas A-301 ) [wpcf-squarefeet] => Array ( [0] => 4308.09 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3495000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Verandas A-301 Condominium ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => 2012 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9634 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-a-301/ ) [ffd_media] => Array ( [0] => a:24:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/hzxcl1sxl/A-TEMPLATE%20WEBSITE15.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/u729kr3iz/A-TEMPLATE%20WEBSITE14.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/vj7meayo7/A-TEMPLATE%20WEBSITE18.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/tjhheiuhf/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/ucjieoeft/A-TEMPLATE%20WEBSITE2.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/c5i3uxx6l/A-TEMPLATE%20WEBSITE17.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/l96q56ptz/A-TEMPLATE%20WEBSITE16.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/ams647n94/A-TEMPLATE%20WEBSITE11.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/vf8twpbv8/A-TEMPLATE%20WEBSITE13.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/lcflhrlj9/A-TEMPLATE%20WEBSITE11.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/7sgew89gi/A-TEMPLATE%20WEBSITE5.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/ckmt323j5/A-TEMPLATE%20WEBSITE10.jpg";i:12;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/e3jy3h5sy/A-TEMPLATE%20WEBSITE.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/w46rgrz7o/A-TEMPLATE%20WEBSITE12.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/1wsnuavzt/A-TEMPLATE%20WEBSITE6.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/cycw5q5rc/A-TEMPLATE%20WEBSITE4.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/i2f5vut3i/A-TEMPLATE%20WEBSITE7.jpg";i:17;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/h1nqbhwb0/A-TEMPLATE%20WEBSITE26.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/juxt5reof/A-TEMPLATE%20WEBSITE9.jpg";i:19;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/pccu1ohkr/A-TEMPLATE%20WEBSITE32.jpg";i:20;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/m5rqxqgd1/A-TEMPLATE%20WEBSITE8.jpg";i:21;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/8mllex6uo/A-TEMPLATE%20WEBSITE3.jpg";i:22;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/woogmy0cw/A-TEMPLATE%20WEBSITE27.jpg";i:23;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/tcmylaivo/A-TEMPLATE%20WEBSITE8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mjaO/hzxcl1sxl/A-TEMPLATE%20WEBSITE15.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KJsQjQAL ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [ffd_listing_title] => Array ( [0] => Verandas A-202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-1050 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KL6i5QAD ) [ffd_totalarea_pb] => Array ( [0] => 3092 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_createddate] => Array ( [0] => 2023-03-07T17:02:46.000+0000 ) [ffd_days_on_market] => Array ( [0] => 64 ) [ffd_description_pb] => Array ( [0] => This beautiful collection of multi-family condominium residences are located just steps away from Querencia´s world-class Clubhouse Village, making our amenities truly an extension of your home. Verandas A 202 features a 4-bedroom distinctive floorplan which offers substantial and luxuriously finished indoor and outdoor living spaces. Move in ready and fully furnished, located just steps away from the Clubhouse.Verandas A-202 Verandas Condominium 3,250,000 USD | 58,695,000 MXN | 3,092 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-05-11T23:43:45.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03086 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3250000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.75023 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 23-1050 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3092 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KL6i5QAD ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas A-202 ) [wpcf-squarefeet] => Array ( [0] => 4243 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3250000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Verandas A-202 Condominium 23-1050ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => 2013 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9576 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-a-202/ ) [ffd_media] => Array ( [0] => a:16:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/ohwmmivxd/A-TEMPLATE%20WEBSITE13.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/5h8dk25o6/A-TEMPLATE%20WEBSITE3.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/m86u830lb/A-TEMPLATE%20WEBSITE4.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/599kz8mrr/A-TEMPLATE%20WEBSITE5.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/fljqebdr0/A-TEMPLATE%20WEBSITE6.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/vxr35o3d9/A-TEMPLATE%20WEBSITE7.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/lt3cerzfz/A-TEMPLATE%20WEBSITE8.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/3aw19s7td/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/iimagvsyz/A-TEMPLATE%20WEBSITE15.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/o5ohm4cp2/A-TEMPLATE%20WEBSITE11.jpg";i:10;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/0mbxwa2te/A-TEMPLATE%20WEBSITE.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/cgzhgm0ae/A-TEMPLATE%20WEBSITE10.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/kn59r5vz3/A-TEMPLATE%20WEBSITE12.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/fh1eayc0j/A-TEMPLATE%20WEBSITE14.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/3ii0wg4t7/A-TEMPLATE%20WEBSITE16.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/f18ytw5ru/A-TEMPLATE%20WEBSITE2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/ohwmmivxd/A-TEMPLATE%20WEBSITE13.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KL6i5QAD ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 58695000 ) )
Array ( [ffd_listing_title] => Array ( [0] => Cabaña #06 Upper ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KJsR3QAL ) [ffd_totalarea_pb] => Array ( [0] => 2800 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 3 ) [wpcf-bedrooms] => Array ( [0] => 3 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Cabanas ) [ffd_createddate] => Array ( [0] => 2023-05-04T21:40:17.000+0000 ) [ffd_days_on_market] => Array ( [0] => 22 ) [ffd_description_pb] => Array ( [0] => Conveniently located within steps of the Querencia Clubhouse, this second-floor luxury condominium features vaulted ceilings, sliding pocket doors and a private corner location. Cabaña 6 is move-in ready and offers 3 bedrooms and 3 baths, is fully furnished and is truly the epitome of luxury living within a world-class community.Cabaña #06 Upper Las Cabañas Condominium 2,400,000 USD | 43,392,000 MXN | 2,800 A/C SQ FT 3 Beds 3 Full Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-05-26T19:53:19.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03163 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 2400000 ) [ffd_listing_price_pesos] => Array ( [0] => 43392000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.74773 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 2800 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KJsR3QAL ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Cabaña #06 Upper ) [wpcf-squarefeet] => Array ( [0] => 4149.27 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 2400000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Cabaña #06 Upper Condominium ResaleLas CabanasActive ) [ffd_yearbuilt_pb] => Array ( [0] => 2007 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9642 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/cabana-06-upper/ ) [ffd_media] => Array ( [0] => a:18:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/ddiq96mbu/A-TEMPLATE%20WEBSITE14.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/nud30nv5l/A-TEMPLATE%20WEBSITE11.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/qcwo4fg0t/A-TEMPLATE%20WEBSITE18.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/4b53sjfp7/A-TEMPLATE%20WEBSITE2.jpg";i:4;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/4k5vnysd6/A-TEMPLATE%20WEBSITE.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/5yz8yiplv/A-TEMPLATE%20WEBSITE10.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/tc99fcl82/A-TEMPLATE%20WEBSITE12.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/jmeh5o90g/A-TEMPLATE%20WEBSITE13.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/iqnx8nc1m/A-TEMPLATE%20WEBSITE15.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/trr37vjzd/A-TEMPLATE%20WEBSITE16.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/1k5ay1dzc/A-TEMPLATE%20WEBSITE17.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/dziegwv3s/A-TEMPLATE%20WEBSITE3.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/6o85t6qq6/A-TEMPLATE%20WEBSITE4.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/nr1nf90ff/A-TEMPLATE%20WEBSITE5.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/085g7wxpj/A-TEMPLATE%20WEBSITE6.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/nj48gt7wh/A-TEMPLATE%20WEBSITE7.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/mqop3oth4/A-TEMPLATE%20WEBSITE8.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/42to8lpmh/A-TEMPLATE%20WEBSITE9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/ddiq96mbu/A-TEMPLATE%20WEBSITE14.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KJsR3QAL ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1888 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [ffd_listing_title] => Array ( [0] => El Parque #25 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JYJrLQAX ) [ffd_totalarea_pb] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => El Parque ) [ffd_createddate] => Array ( [0] => 2023-04-12T18:13:32.000+0000 ) [ffd_days_on_market] => Array ( [0] => 40 ) [ffd_description_pb] => Array ( [0] => A place to gather, enjoy and live. El Parque offers inspired living in the heart of the Querencia community. Here, find an enclave of 43 single-family-homesites anchored by 20-acres of open and maintained park space located just steps from the Querencia Club Village.El Parque #25 El Parque Homesite 1,690,000 USD | 30,497,719 MXN Lot Size 21936.85 sq ft 2038 sq m
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-05-22T17:30:48.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0769 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 1690000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70915 ) [ffd_community_lot_number] => Array ( [0] => 25 ) [wpcf-lotsize] => Array ( [0] => 21936.85 ) [wpcf-lot-size-sqm] => Array ( [0] => 2038 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JYJrLQAX ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => El Parque #25 ) [wpcf-squarefeet] => Array ( [0] => 21936.85 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 1690000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => El Parque #25 Homesite ResaleEl ParqueActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9592 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-parque-25-2/ ) [ffd_media] => Array ( [0] => a:8:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IybrI/96fd8bobz/A-TEMPLATE%20WEBSITE6.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IybrI/22133j740/A-TEMPLATE%20WEBSITE.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IybrI/fbavr0otc/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IybrI/lcnxdcmty/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IybrI/zm9jj0pfm/A-TEMPLATE%20WEBSITE4.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IybrI/kpdgq9bfr/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IybrI/rdyjtgoex/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IybrI/acddgp50k/A-TEMPLATE%20WEBSITE8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IybrI/96fd8bobz/A-TEMPLATE%20WEBSITE6.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JYJrLQAX ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8746 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 30497719 ) )
Array ( [ffd_listing_title] => Array ( [0] => La Vista #09 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JYJj5QAH ) [ffd_totalarea_pb] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_city_pb] => Array ( [0] => San José del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => La Vista ) [ffd_createddate] => Array ( [0] => 2023-04-11T23:37:54.000+0000 ) [ffd_days_on_market] => Array ( [0] => 40 ) [ffd_description_pb] => Array ( [0] => La Vista 9 is an expansive lot positioned front row of our property on the East face of the mountainside with totally unobstructed views to the Sea of Cortez. At night, enjoy the fabulous lights as the City of San Jose comes alive. La Vista 9 in conveniently located in close proximity to our Beach Club, which will be fully completed this fall for Querencia Members to enjoy!La Vista #09 La Vista Homesite 1,475,000 USD | 26,638,500 MXN Lot Size 51957.4 sq ft 4827 sq m
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-05-22T17:29:08.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.02179 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 1475000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.72034 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => 51957.4 ) [wpcf-lot-size-sqm] => Array ( [0] => 4827 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JYJj5QAH ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => La Vista #09 ) [wpcf-squarefeet] => Array ( [0] => 51964.71 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 1475000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean La Vista #09 Homesite ResaleLa VistaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9591 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-vista-09/ ) [ffd_media] => Array ( [0] => a:12:{i:0;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/xq0gmd3hk/A-TEMPLATE%20MLS.jpg";i:1;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/d7zn3x9kj/A-TEMPLATE%20MLS12.jpg";i:2;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/3pf2o5x1l/A-TEMPLATE%20MLS10.jpg";i:3;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/xrlnnix2w/A-TEMPLATE%20MLS11.jpg";i:4;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/n6z0dlejb/A-TEMPLATE%20MLS2.jpg";i:5;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/mj0b9ah0s/A-TEMPLATE%20MLS3.jpg";i:6;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/x4tb5nt4n/A-TEMPLATE%20MLS4.jpg";i:7;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/v5rt1kyb8/A-TEMPLATE%20MLS5.jpg";i:8;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/2ad2f77uj/A-TEMPLATE%20MLS6.jpg";i:9;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/vlq1of0y0/A-TEMPLATE%20MLS7.jpg";i:10;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/2ir3tyatn/A-TEMPLATE%20MLS8.jpg";i:11;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/7efk07snt/A-TEMPLATE%20MLS9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/xq0gmd3hk/A-TEMPLATE%20MLS.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JYJj5QAH ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1880 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 26638500 ) )
Array ( [ffd_listing_title] => Array ( [0] => El Parque #42 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KL516QAD ) [ffd_totalarea_pb] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => El Parque ) [ffd_createddate] => Array ( [0] => 2023-02-27T22:05:27.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => A place to gather, enjoy and live. El Parque lot 42 offers inspired living in the heart of the Querencia community. As part of an enclave of 14 single-family-homesites anchored by 20-acres of open and maintained park space located just steps from the Querencia Club Village, El Parque 42 can be the perfect place for your dream home.El Parque #42 El Parque Homesite 1,350,000 USD | 24,381,000 MXN Lot Size 21761.42 sq ft 2021.7 sq m
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-05-22T17:27:43.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.05381 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 1350000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 42 ) [wpcf-lotsize] => Array ( [0] => 21761.42 ) [wpcf-lot-size-sqm] => Array ( [0] => 2021.7 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => 005f100000I1eqJAAR ) [ffd_id] => Array ( [0] => a093Z00000KL516QAD ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => El Parque #42 ) [wpcf-squarefeet] => Array ( [0] => 21761.42 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 1350000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => El Parque #42 Homesite ResaleEl ParqueActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9573 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-parque-42/ ) [ffd_media] => Array ( [0] => a:12:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/kmy6dpmdl/A-TEMPLATE%20WEBSITE9.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/v0wj4710g/A-TEMPLATE%20WEBSITE15.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/dnuuq5b2v/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/fjbkdu368/A-TEMPLATE%20WEBSITE11.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/yn167wgz8/A-TEMPLATE%20WEBSITE10.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/41q3bare9/A-TEMPLATE%20WEBSITE12.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/z4v1rhxz8/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/md7yz514r/A-TEMPLATE%20WEBSITE8.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/qlh6qfe17/A-TEMPLATE%20WEBSITE13.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/xgbeuhvr9/A-TEMPLATE%20WEBSITE4.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/7hrlvclh2/A-TEMPLATE%20WEBSITE5.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/nrgxjwq19/A-TEMPLATE%20WEBSITE6.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlj/kmy6dpmdl/A-TEMPLATE%20WEBSITE9.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KL516QAD ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8746 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [wpcf-agent-2] => Array ( [0] => 005f100000I1eqJ ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 24381000 ) )
Array ( [ffd_listing_title] => Array ( [0] => La Loma #31 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KJsOCQA1 ) [ffd_totalarea_pb] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_city_pb] => Array ( [0] => San José del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => La Loma ) [ffd_createddate] => Array ( [0] => 2023-05-04T19:52:44.000+0000 ) [ffd_days_on_market] => Array ( [0] => 18 ) [ffd_description_pb] => Array ( [0] => La Loma 31 is an expansive homesite overlooking the Sea of Cortez and the desert mountains in a peaceful and serene enclave located within the masterplanned community of Querencia, home to the award-winning Tom Fazio golf course and an array of amenities. Start building your dream home today.La Loma #31 La Loma Homesite 1,150,000 USD | 20,792,000 MXN Lot Size 45198.36 sq ft 4199.07 sq m
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-05-29T23:14:12.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.02041 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 1150000 ) [ffd_listing_price_pesos] => Array ( [0] => 20792000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.72368 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => 45198.36 ) [wpcf-lot-size-sqm] => Array ( [0] => 4199.07 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KJsOCQA1 ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => La Loma #31 ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => Mountain ) [wpcf-price] => Array ( [0] => 1150000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Mountain La Loma #31 Homesite ResaleLa LomaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9622 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-loma-31/ ) [ffd_media] => Array ( [0] => a:37:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/ibglnp4xr/A-TEMPLATE%20WEBSITE.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/lrgydb2ke/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/yl53alnbo/A-TEMPLATE%20WEBSITE6.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/2llcw6kqu/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/nwd6t7kco/A-TEMPLATE%20WEBSITE9.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/y8zmeu8yf/A-TEMPLATE%20WEBSITE2.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/fgl0a7hrv/A-TEMPLATE%20WEBSITE30.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/k8ig3391y/A-TEMPLATE%20WEBSITE3.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/sh20meby4/A-TEMPLATE%20WEBSITE5.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/u3244cozy/A-TEMPLATE%20WEBSITE7.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/k1ekmtxqt/A-TEMPLATE%20WEBSITE8.jpg";i:11;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/v0eceictx/A-TEMPLATE%20WEBSITE.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/juw8ylugo/A-TEMPLATE%20WEBSITE10.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/42bw94h3o/A-TEMPLATE%20WEBSITE2.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/tjq0vze4r/A-TEMPLATE%20WEBSITE3.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/pgyog4os6/A-TEMPLATE%20WEBSITE4.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/3qvvnwqth/A-TEMPLATE%20WEBSITE5.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/k2v79e0rn/A-TEMPLATE%20WEBSITE6.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/za0gp7ong/A-TEMPLATE%20WEBSITE7.jpg";i:19;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/lezrd8b4z/A-TEMPLATE%20WEBSITE8.jpg";i:20;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/yq07a8zns/A-TEMPLATE%20WEBSITE9.jpg";i:21;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/9sdv51grk/B-TEMPLATE%20WEBSITE.jpg";i:22;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/7tgnmda4x/B-TEMPLATE%20WEBSITE2.jpg";i:23;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/vcstqgttv/B-TEMPLATE%20WEBSITE3.jpg";i:24;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/cvmgmr74n/B-TEMPLATE%20WEBSITE4.jpg";i:25;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/umkgq7icg/B-TEMPLATE%20WEBSITE5.jpg";i:26;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/skrrub0ts/B-TEMPLATE%20WEBSITE6.jpg";i:27;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/hy6d7xsqs/B-TEMPLATE%20WEBSITE7.jpg";i:28;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/0vob8nmnn/B-TEMPLATE%20WEBSITE8.jpg";i:29;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/dfap4cp55/A-TEMPLATE%20WEBSITE22.jpg";i:30;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/p8mggv4ty/A-TEMPLATE%20WEBSITE35.jpg";i:31;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/q830lvoh1/A-TEMPLATE%20WEBSITE6.jpg";i:32;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/qtr1t2sas/A-TEMPLATE%20WEBSITE11.jpg";i:33;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/ccgsd96ws/A-TEMPLATE%20WEBSITE32.jpg";i:34;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/3p8eugvzo/A-TEMPLATE%20WEBSITE3.jpg";i:35;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/hd5nl0nxm/A-TEMPLATE%20WEBSITE.jpg";i:36;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/ozhbk5sbu/A-TEMPLATE%20WEBSITE4.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000051qNf/ibglnp4xr/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KJsOCQA1 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1876 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
"*" indicates required fields