Discover Our Properties
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-property-type' AND mt2.meta_value = 'lot' ) )) 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
52
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1713286191 ) [ffd_listing_title] => Array ( [0] => La Montaña #05 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-1851 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KnO5QQAV ) [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] => La Montaña ) [ffd_createddate] => Array ( [0] => 2023-06-05T18:27:21.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1 ) [ffd_description_pb] => Array ( [0] => La Montaña is a collection of 29 distinctive homesites in the heart of Querencia. The tiered elevation configuration allows for unobstructed sweeping views from each homesite -- from mountain and arroyo views, to the crystalline vistas of the Sea of Cortez.La Montaña #05 La Montaña Homesite 2,400,000 USD | 40,101,600 MXN Lot Size 27542 sq ft 2558.74 sq m
A feature of La Montaña 5, one of the largest lots in this section, is that it is surrounded by lush landscape which promotes privacy. The padded and walled homesite allows for the building of a single-level home between 3,900 - 10,000 A/C SQ FT.
Property owners within Querencia have the opportunity to purchase a 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] => ) [ffd_lastmodifieddate] => Array ( [0] => 2024-04-16T16:41:27.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] => 2400000 ) [ffd_listing_price_pesos] => Array ( [0] => 40101600 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 5 ) [wpcf-lotsize] => Array ( [0] => 27542 ) [wpcf-lot-size-sqm] => Array ( [0] => 2558.74 ) [wpcf-mls] => Array ( [0] => 24-1851 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a093Z00000KnO5QQAV ) [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 Montaña #05 ) [wpcf-squarefeet] => Array ( [0] => 27542 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 2400000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => La Montaña #05 Homesite 24-1851ResaleLa MontañaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 10385 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-montana-05/ ) [ffd_media] => Array ( [0] => a:31:{i:0;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/j4hjwnkxf/1web.jpg";i:1;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/d6ys5m0tr/2web.jpg";i:2;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/run77rqjz/3web.jpg";i:3;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/bwircd8of/4web.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/j7xcyuwqk/A-TEMPLATE%20WEBSITE10.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/wd0es6l0c/A-TEMPLATE%20WEBSITE11.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/5k5sfret6/A-TEMPLATE%20WEBSITE12.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/nhzq3ab6t/A-TEMPLATE%20WEBSITE15.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/dnn1senmd/A-TEMPLATE%20WEBSITE2.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/lfv6m9iu8/A-TEMPLATE%20WEBSITE4.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/8yue9kos1/A-TEMPLATE%20WEBSITE5.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/mur6t9mbi/A-TEMPLATE%20WEBSITE7.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/af809blly/A-TEMPLATE%20WEBSITE6.jpg";i:13;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/tkr78kjeu/1%20copia.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/etjx0ewfd/A-TEMPLATE%20WEBSITE8.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/6g3amuij5/A-TEMPLATE%20WEBSITE9.jpg";i:16;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/tr249npe6/LOTE-5%20website.jpg";i:17;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/782b77p1e/2.jpg";i:18;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/34hdwhsmt/surf-3.jpg";i:19;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/3cnsgb7ut/Pickleball.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/3zjytdbgt/golf-2.jpg";i:21;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/cafagqdat/Clubhouse-4.jpg";i:22;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/nribs2hj9/Clubhouse-3.jpg";i:23;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/hqqfrno2u/surf-2.jpg";i:24;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/l9pnvutdc/Yoga%20Querencia.jpg";i:25;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/y6n5ite4a/Querencia%20Beach%20Club.jpg";i:26;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/v5xfo7yky/Golf-5.jpg";i:27;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/o82702d8k/Mountain%20Bike.jpg";i:28;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/0bopgn6j7/slide.jpg";i:29;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/ag7sr49xo/trails-2.jpg";i:30;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/s1va2pfdt/trampoline.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/j4hjwnkxf/1web.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KnO5QQAV ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8744 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas 77 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000000LUpVIAW ) [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] => Los Cabos ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Colinas ) [ffd_createddate] => Array ( [0] => 2023-11-28T03:12:03.000+0000 ) [ffd_days_on_market] => Array ( [0] => 157 ) [ffd_description_pb] => Array ( [0] => Las Colinas 77 is an incredible homesite within the Querencia Community with breathtaking coastal views where you can build your dream home. Perfectly situated just steps away from the Querencia Beach Club, overlooking the crystal blue Sea of Cortez, with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. As some of the most impressive real estate in all of Los Cabos, the Las Colinas homesites provide the ideal canvas for you to build your dream home.Las Colinas 77 Las Colinas Homesite 2,250,000 USD | 38,599,875 MXN Lot Size 23574.90132 sq ft 2190.18 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. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-11-29T00:41:11.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0864985 ) [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] => 2250000 ) [ffd_listing_price_pesos] => Array ( [0] => 38599875 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.7071078 ) [ffd_community_lot_number] => Array ( [0] => Las Colinas ) [wpcf-lotsize] => Array ( [0] => 23574.90132 ) [wpcf-lot-size-sqm] => Array ( [0] => 2190.18 ) [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] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a09Pk000000LUpVIAW ) [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] => Las Colinas 77 ) [wpcf-squarefeet] => Array ( [0] => 23574.90132 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 2250000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Las Colinas 77 Homesite ResaleLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9955 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-77/ ) [ffd_media] => Array ( [0] => a:15:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/2qeemi1bv/3.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/8oeoruyr4/5.jpg";i:2;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/re25fqhfy/1%20copia%202.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/qgoogj9i9/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/urgzfoz10/4.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/yv3em9trc/A-TEMPLATE%20WEBSITE.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/he3amhhub/A-TEMPLATE%20WEBSITE10.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/wwq74cy1g/A-TEMPLATE%20WEBSITE2.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/dah2uvll7/A-TEMPLATE%20WEBSITE3.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/n4vtv2cpe/A-TEMPLATE%20WEBSITE4.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/d2ylci957/A-TEMPLATE%20WEBSITE5.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/f30h3ioql/A-TEMPLATE%20WEBSITE6.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/untcmx5iu/A-TEMPLATE%20WEBSITE7.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/sywkcc4sy/A-TEMPLATE%20WEBSITE8.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/zu4al5db6/A-TEMPLATE%20WEBSITE9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/2qeemi1bv/3.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000000LUpVIAW ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850483 ) )
Array ( [ffd_listing_title] => Array ( [0] => La Montaña #02 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-1997 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWBvbQAH ) [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] => La Montaña ) [ffd_createddate] => Array ( [0] => 2021-09-13T21:27:44.000+0000 ) [ffd_days_on_market] => Array ( [0] => 918 ) [ffd_description_pb] => Array ( [0] => La Montaña is a new collection of 29 distinctive homesites in the heart of Querencia. The tiered elevation configuration allows for sweeping views from each homesite – from mountain and arroyo views to the crystalline vistas of the Sea of Cortez. Surrounded by a lush landscape and with privacy in mind, the padded and walled sites allow for the building of single-level homes from approximately 4,500 - 6,000 A/C sq. ft. 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] => ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-10-27T23:20:09.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] => 1500000 ) [ffd_listing_price_pesos] => Array ( [0] => 25500000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 2 ) [wpcf-lotsize] => Array ( [0] => 41193 ) [wpcf-lot-size-sqm] => Array ( [0] => 3826.95 ) [wpcf-mls] => Array ( [0] => 23-1997 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWBvbQAH ) [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 Montaña #02 ) [wpcf-squarefeet] => Array ( [0] => 41193 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 1500000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => La Montaña #02 Homesite 23-1997DeveloperLa MontañaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9655 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-montana-02/ ) [ffd_media] => Array ( [0] => a:25:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/13c76xph9/A-TEMPLATE%20WEBSITE.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/2xgl8was2/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/9kime03ka/A-TEMPLATE%20WEBSITE4.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/w1xrhaeul/A-TEMPLATE%20WEBSITE2.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/colikj03f/A-TEMPLATE%20WEBSITE3.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/x7bq39rdz/A-TEMPLATE%20WEBSITE7.jpg";i:6;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/qlgpm1mxg/1%20copia.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/sgam5q11b/A-TEMPLATE%20WEBSITE6.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/3kymigml5/A-TEMPLATE%20WEBSITE5.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/3qz003uh1/A-TEMPLATE%20WEBSITE9.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/he4iaqpb4/A-TEMPLATE%20WEBSITE8.jpg";i:11;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/8a0ijj6l7/2.jpg";i:12;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/wpft3w9wi/Clubhouse-4.jpg";i:13;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/v3r2ueilh/Clubhouse-3.jpg";i:14;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/tuvgjt0ju/golf-2.jpg";i:15;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/liluztewi/Golf-5.jpg";i:16;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/3nbfezv1g/Mountain%20Bike.jpg";i:17;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/vwg0la7b2/Pickleball.jpg";i:18;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/vf8062129/Querencia%20Beach%20Club.jpg";i:19;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/8ykwbre59/slide.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/lqbgxfn50/surf-3.jpg";i:21;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/bi4nhdnh5/surf-2.jpg";i:22;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/kyo9lohol/trails-2.jpg";i:23;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/gmxdriejg/trampoline.jpg";i:24;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/lo7pyfgv3/Yoga%20Querencia.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlt/13c76xph9/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWBvbQAH ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8744 ) [ffd_record_is_deleted] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850458 ) )La Montaña #02 La Montaña Homesite 1,500,000 USD | 25,500,000 MXN Lot Size 41193 sq ft 3826.95 sq m
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas #65 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-2200 ) [ffd_salesforce_id] => Array ( [0] => a09j0000001utnPAAQ ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_createddate] => Array ( [0] => 2015-03-19T04:19:40.000+0000 ) [ffd_days_on_market] => Array ( [0] => 3388 ) [ffd_description_pb] => Array ( [0] => These incredible Querencia homesites are situated overlooking the crystal blue Sea of Cortez, with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. As some of the most impressive real estate in all of Los Cabos, the homesites at Las Colinas provide the ideal canvas for you to build your dream home.Las Colinas #65 Las Colinas Homesite 1,450,000 USD | 24,650,000 MXN Lot Size 42808 sq ft 3976.99 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. ) [ffd_lastmodifieddate] => Array ( [0] => 2023-08-01T16:49:27.000+0000 ) [ffd_listingprice_pb] => Array ( [0] => 1450000 ) [ffd_community_lot_number] => Array ( [0] => 65 ) [ffd_listing_agent_1] => Array ( [0] => 005j000000AuC6YAAV ) [ffd_id] => Array ( [0] => a09j0000001utnPAAQ ) [ffd_name] => Array ( [0] => Las Colinas #65 ) [wpcf-squarefeet] => Array ( [0] => 42815.39 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 7938 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-65/ ) [ffd_media] => Array ( [0] => a:15:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/x2n4xggmw/A-TEMPLATE%20WEBSITE7.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/db3lc3faw/A-TEMPLATE%20WEBSITE6.jpg";i:2;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/a2cy7zjnv/A-TEMPLATE%20WEBSITE.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/d3rpfcpz8/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/4hv4kzn9w/A-TEMPLATE%20WEBSITE5.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/uuzpm07um/A-TEMPLATE%20WEBSITE2.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/0d8fgrpn1/A-TEMPLATE%20WEBSITE24.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/n92w897xs/A-TEMPLATE%20WEBSITE3.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/a0lruapo4/A-TEMPLATE%20WEBSITE32.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/1u2havbb7/A-TEMPLATE%20WEBSITE35.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/ohaqjeveu/A-TEMPLATE%20WEBSITE19.jpg";i:11;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/4y0h4hn8e/A-TEMPLATE%20WEBSITE.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/0b4v18jpu/A-TEMPLATE%20WEBSITE4.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/wp7jevzj7/A-TEMPLATE%20WEBSITE26.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/7np77t15y/A-TEMPLATE%20WEBSITE6.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc4g/x2n4xggmw/A-TEMPLATE%20WEBSITE7.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [featured] => Array ( [0] => ) [ffd_sort_by] => Array ( [0] => A ) [_edit_lock] => Array ( [0] => 1635289108:5 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [_edit_last] => Array ( [0] => 5 ) [_yoast_wpseo_content_score] => Array ( [0] => 30 ) [ffd_website_status_2] => Array ( [0] => ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_yoast_wpseo_primary_category] => Array ( [0] => ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a09j0000001utnPAAQ ) [wpcf-property-type] => Array ( [0] => lot ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Active ) [wpcf-lotsize] => Array ( [0] => 42808 ) [wpcf-lot-size-sqm] => Array ( [0] => 3976.99 ) [wpcf-price] => Array ( [0] => 1450000 ) [wpcf-mls] => Array ( [0] => 23-2200 ) [wpcf-latitude] => Array ( [0] => 23.0245 ) [wpcf-longitude] => Array ( [0] => -109.72572 ) [wpcf-agent-1] => Array ( [0] => 005j000000AuC6Y ) [wpcf-keywords] => Array ( [0] => Ocean Las Colinas #65 Homesite 23-2200DeveloperLas ColinasActive ) [wpcf-listing-type] => Array ( [0] => Developer ) [ffd_totalarea_pb] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [wpcf-bathrooms] => Array ( [0] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [wpcf-half-bathrooms] => Array ( [0] => ) [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] => ) [wpcf-acarea] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_website_status] => Array ( [0] => ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Colinas ) [ffd_listing_price_pesos] => Array ( [0] => 24650000 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850499 ) )
Array ( [ffd_listing_title] => Array ( [0] => La Vista #09 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-1618 ) [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] => 365 ) [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,275,000 USD | 21,853,755 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] => 2024-01-22T18:23:11.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] => 1275000 ) [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] => 23-1618 ) [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] => 1275000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean La Vista #09 Homesite 23-1618ResaleLa 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:13:{i:0;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/2dqw8ivbq/cover%20pic.jpg";i:1;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/xq0gmd3hk/A-TEMPLATE%20MLS.jpg";i:2;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/d7zn3x9kj/A-TEMPLATE%20MLS12.jpg";i:3;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/3pf2o5x1l/A-TEMPLATE%20MLS10.jpg";i:4;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/xrlnnix2w/A-TEMPLATE%20MLS11.jpg";i:5;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/n6z0dlejb/A-TEMPLATE%20MLS2.jpg";i:6;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/mj0b9ah0s/A-TEMPLATE%20MLS3.jpg";i:7;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/x4tb5nt4n/A-TEMPLATE%20MLS4.jpg";i:8;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/v5rt1kyb8/A-TEMPLATE%20MLS5.jpg";i:9;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/2ad2f77uj/A-TEMPLATE%20MLS6.jpg";i:10;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/vlq1of0y0/A-TEMPLATE%20MLS7.jpg";i:11;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/2ir3tyatn/A-TEMPLATE%20MLS8.jpg";i:12;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/2dqw8ivbq/cover%20pic.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] => 21853755 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850513 ) )
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas #68 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-2222 ) [ffd_salesforce_id] => Array ( [0] => a09f100000FhnhCAAR ) [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] => Las Colinas ) [ffd_createddate] => Array ( [0] => 2018-01-26T21:38:05.000+0000 ) [ffd_days_on_market] => Array ( [0] => 2095 ) [ffd_description_pb] => Array ( [0] => These incredible Querencia homesites are situated overlooking the crystal blue Sea of Cortez, with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. As some of the most impressive real estate in all of Los Cabos, the homesites at Las Colinas provide the ideal canvas for you to build your dream home.Las Colinas #68 Las Colinas Homesite 1,250,000 USD | 21,250,000 MXN Lot Size 35671 sq ft 3313.94 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. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-10-27T23:33:53.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.06362 ) [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] => 1250000 ) [ffd_listing_price_pesos] => Array ( [0] => 21250000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => 68 ) [wpcf-lotsize] => Array ( [0] => 35671 ) [wpcf-lot-size-sqm] => Array ( [0] => 3313.94 ) [wpcf-mls] => Array ( [0] => 23-2222 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 005j000000AuC6YAAV ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09f100000FhnhCAAR ) [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] => Las Colinas #68 ) [wpcf-squarefeet] => Array ( [0] => 35681.07 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 1250000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Las Colinas #68 Homesite 23-2222DeveloperLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9657 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-68/ ) [ffd_media] => Array ( [0] => a:14:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/zg2y00nwj/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/wt9atdn5h/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/wj1oca3vk/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/mnhvkkds2/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/a497fztgs/A-TEMPLATE%20WEBSITE5.jpg";i:5;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/mjf0qmt2q/Clubhouse-3.jpg";i:6;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/rba4xsoi0/dinner.jpg";i:7;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/q90wqmlps/Golf-4.jpg";i:8;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/0l79w076u/Mountain%20Bike.jpg";i:9;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/wnkh8a6w4/Querencia%20Golf.jpg";i:10;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/aaze7enx4/surf.jpg";i:11;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/lgnnkof6s/trails-2.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/45qx1dbvb/trails.jpg";i:13;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/boe7vc3jg/trampoline.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc0r/zg2y00nwj/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09f100000FhnhCAAR ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [wpcf-agent-1] => Array ( [0] => 005j000000AuC6Y ) [ffd_record_is_deleted] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850498 ) )
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas #69 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-2229 ) [ffd_salesforce_id] => Array ( [0] => a09f100000FhnhHAAR ) [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] => Las Colinas ) [ffd_createddate] => Array ( [0] => 2018-01-26T21:39:39.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1931 ) [ffd_description_pb] => Array ( [0] => These incredible Querencia homesites are situated overlooking the crystal blue Sea of Cortez, with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. As some of the most impressive real estate in all of Los Cabos, the homesites at Las Colinas provide the ideal canvas for you to build your dream home.Las Colinas #69 Las Colinas Homesite 1,250,000 USD | 21,250,000 MXN Lot Size 30752 sq ft 2856.95 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. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-10-27T23:34:33.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.06362 ) [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] => 1250000 ) [ffd_listing_price_pesos] => Array ( [0] => 21250000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => 69 ) [wpcf-lotsize] => Array ( [0] => 30752 ) [wpcf-lot-size-sqm] => Array ( [0] => 2856.95 ) [wpcf-mls] => Array ( [0] => 23-2229 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 005j000000AuC6YAAV ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09f100000FhnhHAAR ) [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] => Las Colinas #69 ) [wpcf-squarefeet] => Array ( [0] => 30760.46 ) [wpcf-view] => Array ( [0] => Golf Course ) [wpcf-price] => Array ( [0] => 1250000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Golf Course Las Colinas #69 Homesite 23-2229DeveloperLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9658 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-69/ ) [ffd_media] => Array ( [0] => a:14:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/35zfet14q/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/dtg76s02d/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/pk4dio29m/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/6bw1b497s/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/hsm5saigg/A-TEMPLATE%20WEBSITE5.jpg";i:5;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/1roa1097i/Golf-4.jpg";i:6;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/ce5g223kn/golf.jpg";i:7;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/o69s3lzxw/Mountain%20Bike.jpg";i:8;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/vd5x0xdz2/Pickleball-2.jpg";i:9;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/qnw1getm6/slide.jpg";i:10;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/vf0n6tg3w/surf.jpg";i:11;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/ndxo18gkn/trails.jpg";i:12;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/othi6w8l9/trampoline.jpg";i:13;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/6dtoscr9b/Yoga%20Querencia.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qbz0/35zfet14q/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09f100000FhnhHAAR ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [wpcf-agent-1] => Array ( [0] => 005j000000AuC6Y ) [ffd_record_is_deleted] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850498 ) )
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas #70 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-2242 ) [ffd_salesforce_id] => Array ( [0] => a09f100000FhnhMAAR ) [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] => Las Colinas ) [ffd_createddate] => Array ( [0] => 2018-01-26T21:41:18.000+0000 ) [ffd_days_on_market] => Array ( [0] => 2095 ) [ffd_description_pb] => Array ( [0] => These incredible Querencia homesites are situated overlooking the crystal blue Sea of Cortez, with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. As some of the most impressive real estate in all of Los Cabos, the homesites at Las Colinas provide the ideal canvas for you to build your dream home.Las Colinas #70 Las Colinas Homesite 1,250,000 USD | 21,250,000 MXN Lot Size 33303 sq ft 3093.95 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. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-29T19:31:15.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.06362 ) [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] => 1250000 ) [ffd_listing_price_pesos] => Array ( [0] => 21250000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => 70 ) [wpcf-lotsize] => Array ( [0] => 33303 ) [wpcf-lot-size-sqm] => Array ( [0] => 3093.95 ) [wpcf-mls] => Array ( [0] => 23-2242 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 005j000000AuC6YAAV ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09f100000FhnhMAAR ) [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] => Las Colinas #70 ) [wpcf-squarefeet] => Array ( [0] => 33312.15 ) [wpcf-view] => Array ( [0] => Golf Course ) [wpcf-price] => Array ( [0] => 1250000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Golf Course Las Colinas #70 Homesite 23-2242DeveloperLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9659 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-70/ ) [ffd_media] => Array ( [0] => a:13:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/7mq28ff3p/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/uha97gqhp/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/fp137zjw6/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/mgoc3gxvt/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/2l1qdyo85/A-TEMPLATE%20WEBSITE5.jpg";i:5;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/06pav5rh5/Clubhouse-4.jpg";i:6;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/ouvapj688/surf-2.jpg";i:7;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/h5alfyac8/trampoline.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/te0x1yph6/A-TEMPLATE%20WEBSITE9.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/ljob8300n/A-TEMPLATE%20WEBSITE8.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/re5kpec61/A-TEMPLATE%20WEBSITE4.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/ng0vnpo90/A-TEMPLATE%20WEBSITE3.jpg";i:12;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/gskp5pmkk/A-TEMPLATE%20WEBSITE.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QadI/7mq28ff3p/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09f100000FhnhMAAR ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [wpcf-agent-1] => Array ( [0] => 005j000000AuC6Y ) [ffd_record_is_deleted] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850497 ) )
Array ( [ffd_listing_title] => Array ( [0] => La Montaña #01 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-1996 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWBvXQAX ) [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] => La Montaña ) [ffd_createddate] => Array ( [0] => 2021-09-13T21:25:03.000+0000 ) [ffd_days_on_market] => Array ( [0] => 918 ) [ffd_description_pb] => Array ( [0] => La Montaña is a new collection of 29 distinctive homesites in the heart of Querencia. The tiered elevation configuration allows for sweeping views from each homesite – from mountain and arroyo views to the crystalline vistas of the Sea of Cortez. Surrounded by a lush landscape and with privacy in mind, the padded and walled sites allow for the building of single-level homes from approximately 4,500 - 6,000 A/C sq. ft. 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] => ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-10-27T23:36:28.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] => 1200000 ) [ffd_listing_price_pesos] => Array ( [0] => 20400000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 1 ) [wpcf-lotsize] => Array ( [0] => 33390 ) [wpcf-lot-size-sqm] => Array ( [0] => 3102.03 ) [wpcf-mls] => Array ( [0] => 23-1996 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWBvXQAX ) [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 Montaña #01 ) [wpcf-squarefeet] => Array ( [0] => 33390 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 1200000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => La Montaña #01 Homesite 23-1996DeveloperLa MontañaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9654 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-montana-01/ ) [ffd_media] => Array ( [0] => a:26:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/slpcscgcd/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/4x1kdj7nk/A-TEMPLATE%20WEBSITE5.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/kqf3f8icv/A-TEMPLATE%20WEBSITE4.jpg";i:3;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/ddejecus/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/7nq6cechc/A-TEMPLATE%20WEBSITE6.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/7y6ey665s/A-TEMPLATE%20WEBSITE7.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/2uuzmdfbe/A-TEMPLATE%20WEBSITE9.jpg";i:7;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/m6djxpe31/1%20copia.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/ipn5eymkv/2.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/vtsxys5xa/A-TEMPLATE%20WEBSITE10.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/082i575ii/A-TEMPLATE%20WEBSITE2.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/h1zxsisim/A-TEMPLATE%20WEBSITE8.jpg";i:12;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/ieu48qr54/Clubhouse-4.jpg";i:13;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/fnm77dmol/Clubhouse-3.jpg";i:14;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/8u7pb2klo/golf-2.jpg";i:15;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/ep4be8wa1/Golf-5.jpg";i:16;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/bjpv2johz/Mountain%20Bike.jpg";i:17;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/8ztpqyrzd/Pickleball.jpg";i:18;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/2y1ybf09m/Querencia%20Beach%20Club.jpg";i:19;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/09fc7mkgs/slide.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/vcl49c5qq/surf-3.jpg";i:21;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/0io8b96mv/surf-2.jpg";i:22;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/mz54r8a17/trails-2.jpg";i:23;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/lsgl8zdnm/trampoline.jpg";i:24;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/dsbxz2268/Yoga%20Querencia.jpg";i:25;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/610lgih5l/Clubhouse-2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlo/slpcscgcd/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWBvXQAX ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8744 ) [ffd_record_is_deleted] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850458 ) )La Montaña #01 La Montaña Homesite 1,200,000 USD | 20,400,000 MXN Lot Size 33390 sq ft 3102.03 sq m
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 ) WHERE 1=1 AND ( ( wp_tota44soje_postmeta.meta_key = 'featured' AND wp_tota44soje_postmeta.meta_value = 'yes' )) AND wp_tota44soje_posts.post_type = 'properties' AND ((wp_tota44soje_posts.post_status = 'publish')) GROUP BY wp_tota44soje_posts.ID ORDER BY wp_tota44soje_posts.post_date DESC LIMIT 0, 3
Featured properties
11
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1712868436 ) [ffd_listing_title] => Array ( [0] => Ocean Residence B 202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000002GVRiIAO ) [ffd_totalarea_pb] => Array ( [0] => 2681 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Querencia, San Jose del Cabo, Baja California Sur, Mexico, Los Cabos. ) [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 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] => Ocean Residences ) [ffd_createddate] => Array ( [0] => 2024-04-09T22:57:14.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1 ) [ffd_description_pb] => Array ( [0] => Sleek, spacious and just steps from the sun-drenched shores of the Sea of Cortez, Ocean Residence B-202 is the epitome of modern luxury meets coastal contemporary.Ocean Residence B 202 Ocean Residences Condominium 6,500,000 USD | 106,525,900 MXN 4 Beds 4 Full Baths
Inside, find inspired living within the neutral, yet refined space. This turnkey, brand new 4-bedroom, 4 full-bath residence – one of just a few in the 30-unit complex—is flooded with natural light framing panoramic views of the swimmable beach, one of the best surf breaks in San Jose. Designed with impeccable attention to detail and with top-of-the-line appliances and finishes throughout, Residence B-202 is centrally located within the center of the three Ocean Residence towers.
Rest and luxuriate with views of the ocean from the primary bedroom complete with an oversized spa-like bath with dual-showers and ample closet space. Two additional bedrooms features ensuite baths, while the fourth bedroom has direct access to a full bath.
Designed to maximize storage opportunities, the open concept floorplan features 2,600 sq. ft. of interior space which seamlessly flows through minimalistic floor-to-ceiling, double paned glass doors onto an additional 500 square feet of outdoor living lounge space with outdoor fireplace and heated plunge pool.
Owners of B-202 gain access to convenient underground parking, including two desirable side-by-side parking spaces, additional lock-off storage space and full-time security and access to beachfront living at its finest at the Querencia Beach Club, home to two family pools, four dining experiences, a satellite Querencia Spa, Sports Lounge and oceanfront Fitness Center.
Other Features Include:
Elevator access | SubZero and Wolf appliances | Rosa Morada wood throughout | Fully-furnished, including TVs and hidden mounted soffit speakers | Convenient, electric roll-down, hurricane shutters throughout | External hurricane shutters on terrace
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] => ) [ffd_lastmodifieddate] => Array ( [0] => 2024-04-11T20:39:23.000+0000 ) [wpcf-latitude] => Array ( [0] => 22.90981 ) [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] => 6500000 ) [ffd_listing_price_pesos] => Array ( [0] => 106525900 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.9278 ) [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] => ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000002GVRiIAO ) [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 Residence B 202 ) [wpcf-squarefeet] => Array ( [0] => 3237 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 6500000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Residence B 202 Condominium DeveloperOcean ResidencesActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 10382 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/ocean-residence-b-202/ ) [ffd_media] => Array ( [0] => a:40:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/rz7zvb253/A-TEMPLATE%20WEBSITE.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/40ty3hcgr/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/1zoepwm5u/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/unijgvx3x/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/idt463vt6/A-TEMPLATE%20WEBSITE17.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h8hbbgt2y/A-TEMPLATE%20WEBSITE4.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/0rvlsktzd/A-TEMPLATE%20WEBSITE16.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7rrnt7d1z/A-TEMPLATE%20WEBSITE15.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9wf8a3zhq/A-TEMPLATE%20WEBSITE18.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/sk61xp1f2/A-TEMPLATE%20WEBSITE19.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/lanc9lix2/A-TEMPLATE%20WEBSITE20.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/a0yrnk6cr/A-TEMPLATE%20WEBSITE11.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7jv1c1yf2/A-TEMPLATE%20WEBSITE12.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/k7uktv0fn/A-TEMPLATE%20WEBSITE13.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/g9e0xk2oc/A-TEMPLATE%20WEBSITE14.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/l08lgfln0/A-TEMPLATE%20WEBSITE5.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/fu01nec1w/A-TEMPLATE%20WEBSITE8.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/zolndnp7l/A-TEMPLATE%20WEBSITE7.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/403ih1ghs/A-TEMPLATE%20WEBSITE9.jpg";i:19;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/q5lcscn1s/A-TEMPLATE%20WEBSITE22.jpg";i:20;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mshycubwg/A-TEMPLATE%20WEBSITE21.jpg";i:21;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/015pr15cw/A-TEMPLATE%20WEBSITE24.jpg";i:22;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h06pixcdw/A-TEMPLATE%20WEBSITE25.jpg";i:23;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9ov4diznp/A-TEMPLATE%20WEBSITE26.jpg";i:24;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/le7q8myhm/A-TEMPLATE%20WEBSITE6.jpg";i:25;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/ns7gahnbq/A-TEMPLATE%20WEBSITE27.jpg";i:26;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/d481dk7lb/A-TEMPLATE%20WEBSITE28.jpg";i:27;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/j136isshw/A-TEMPLATE%20WEBSITE29.jpg";i:28;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/nif80q33n/A-TEMPLATE%20WEBSITE30.jpg";i:29;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tqoi2fzra/A-TEMPLATE%20WEBSITE31.jpg";i:30;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/495zsyqlq/A-TEMPLATE%20WEBSITE32.jpg";i:31;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/5bplookua/A-TEMPLATE%20WEBSITE-beachclub4.jpg";i:32;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tgn5n0p5r/A-TEMPLATE%20WEBSITE-beachclub3.jpg";i:33;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/edv316i9i/A-TEMPLATE%20WEBSITE-beach6.jpg";i:34;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mubnz02c2/A-TEMPLATE%20WEBSITE-beachclub.jpg";i:35;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/3akjmljnc/A-TEMPLATE%20WEBSITE-beachclub2.jpg";i:36;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/qlzqkchb1/A-TEMPLATE%20WEBSITE-beach5.jpg";i:37;s:121:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/b854v7fei/A-TEMPLATE%20WEBSITE-beach.jpg";i:38;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/xclj8i22z/A-TEMPLATE%20WEBSITE-beach3.jpg";i:39;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/8a5llup8p/A-TEMPLATE%20WEBSITE-beach4.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/rz7zvb253/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000002GVRiIAO ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8670 ) )
Array ( [ffd_listing_title] => Array ( [0] => El Valle 1 Upper ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JYGq7QAH ) [ffd_totalarea_pb] => Array ( [0] => 3050 ) [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] => 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] => El Valle ) [ffd_createddate] => Array ( [0] => 2023-03-30T18:47:15.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => El Valle is the latest neighborhood designed within the masterplanned Querencia community. A smaller, more intimate enclave set against the backdrop of the vibrant desert mountains, the 12 condominium residences offer a mix of views of the turquoise San Jose bay, Querencia lake and the award-winning Tom Fazio golf course.El Valle 1 Upper El Valle Condominium 3,465,000 USD | 58,905,000 MXN | 3,050 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. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-28T22:02:01.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] => 3465000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 35 ) [wpcf-lotsize] => Array ( [0] => 22948.66 ) [wpcf-lot-size-sqm] => Array ( [0] => 2132 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3050 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_id] => Array ( [0] => a093Z00000JYGq7QAH ) [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 Valle 1 Upper ) [wpcf-squarefeet] => Array ( [0] => 3588 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 3465000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => El Valle 1 Upper Condominium DeveloperEl ValleActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9604 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-valle-1-upper/ ) [ffd_media] => Array ( [0] => a:29:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/tq1hxt5r6/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/uifiwgcnt/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hojxk6ut1/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/zgnw06tqo/A-TEMPLATE%20WEBSITE5.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5d98tiql5/A-TEMPLATE%20WEBSITE6.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/je4iqh7s6/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gotztox5o/A-TEMPLATE%20WEBSITE8.jpg";i:8;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/7j9e91qrc/Clubhouse-2.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/upeuzy8r2/Clubhouse-3.jpg";i:10;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/n4qrwk05e/Clubhouse-4.jpg";i:11;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/0cxtdew1t/Clubhouse.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4hwfbxexi/dinner.jpg";i:13;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4jg6szv38/golf-2.jpg";i:14;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/o1d1bhfrr/Yoga%20Querencia.jpg";i:15;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p41u05p61/trampoline.jpg";i:16;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/xvak4upbw/trails.jpg";i:17;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/vp3pbyasj/trails-2.jpg";i:18;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/efb60lvs3/surf.jpg";i:19;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/ol4v781k1/surf-3.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/31zt4rvy4/surf-2.jpg";i:21;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p8nazbkgc/slide.jpg";i:22;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gcekb0ldt/Querencia%20Golf.jpg";i:23;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5xp1u8wn8/Querencia%20Beach%20Club.jpg";i:24;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8hsjs0szf/Pickleball.jpg";i:25;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/acd2s0967/Pickleball-2.jpg";i:26;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/49vq4ijob/Mountain%20Bike.jpg";i:27;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/bepc4cg6o/golf.jpg";i:28;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8wwe0k7wm/Golf-4.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JYGq7QAH ) [wpcf-agent-1] => Array ( [0] => 0053Z00000Kt8H2 ) [wpcf-agent-2] => Array ( [0] => 0053Z00000KX9ZY ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 58905000 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 9608 ) [_edit_lock] => Array ( [0] => 1701276370:21 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850475 ) )
Array ( [ffd_listing_title] => Array ( [0] => El Valle 6 Lower ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JYL7NQAX ) [ffd_totalarea_pb] => Array ( [0] => 3050 ) [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] => 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] => El Valle ) [ffd_createddate] => Array ( [0] => 2023-04-17T22:39:57.000+0000 ) [ffd_days_on_market] => Array ( [0] => 360 ) [ffd_description_pb] => Array ( [0] => El Valle is the latest neighborhood designed within the masterplanned Querencia community. A smaller, more intimate enclave set against the backdrop of the vibrant desert mountains, the 12 condominium residences offer a mix of views of the turquoise San Jose bay, Querencia lake and the award-winning Tom Fazio golf course.El Valle 6 Lower El Valle Condominium 2,970,000 USD | 50,490,000 MXN | 3,050 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. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-29T19:31:33.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] => 2970000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 35 ) [wpcf-lotsize] => Array ( [0] => 22948.66 ) [wpcf-lot-size-sqm] => Array ( [0] => 2132 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3050 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JYL7NQAX ) [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 Valle 6 Lower ) [wpcf-squarefeet] => Array ( [0] => 3588 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 2970000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => El Valle 6 Lower Condominium DeveloperEl ValleActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9602 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-valle-6-lower/ ) [ffd_media] => Array ( [0] => a:20:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/59da53bl9/A-TEMPLATE%20WEBSITE8.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zb2ykxl8/A-TEMPLATE%20WEBSITE.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/qv0b0b5ir/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/l5ajufh3m/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nrkbi41ve/A-TEMPLATE%20WEBSITE4.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nhvo5ykxt/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/kxit5zdgo/A-TEMPLATE%20WEBSITE6.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/41ulfgs6j/A-TEMPLATE%20WEBSITE7.jpg";i:8;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/xl6wa0998/Clubhouse.jpg";i:9;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/7rkc1miym/dinner.jpg";i:10;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8bbmuy30i/Golf-4.jpg";i:11;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/o18l17egf/golf.jpg";i:12;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8u4cjjqhj/Mountain%20Bike.jpg";i:13;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/vke6ofpck/Pickleball-2.jpg";i:14;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zg8fsi4o/slide.jpg";i:15;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/jiy6m42k9/surf.jpg";i:16;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/6y2arpc7c/trails-2.jpg";i:17;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/ij9e65fmd/trails.jpg";i:18;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5iozycjr3/trampoline.jpg";i:19;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5xcehypmk/Yoga%20Querencia.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/59da53bl9/A-TEMPLATE%20WEBSITE8.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JYL7NQAX ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 50490000 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 9608 ) [_edit_lock] => Array ( [0] => 1690823630:10 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850477 ) )