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_belongs_neighborhoods_id' AND mt2.meta_value = '1896' ) )) 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
22
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1713892182 ) [ffd_listing_title] => Array ( [0] => Las Colinas 54 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000001fec1IAA ) [ffd_totalarea_pb] => Array ( [0] => 4787.44 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Colinas 14, Querencia, San Jose del Cabo, Baja California Sur, Mexico ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 6 ) [wpcf-bedrooms] => Array ( [0] => 6 ) [ffd_city_pb] => Array ( [0] => ) [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] => 2024-03-13T17:26:05.000+0000 ) [ffd_days_on_market] => Array ( [0] => 41 ) [ffd_description_pb] => Array ( [0] => Casa Brisa de Cabo, a private Villa which sits ideally nestled within a private canyon perched high above the Sea of Cortez through almost an acre of land in the gated community of Querencia. A haven inspired by the blue-water views from both master bedrooms, the great room and the main terrace. This 6 bedroom, 5.5 bath home stretches to nearly 4,800 A/C sq. ft. of living space. Outside, the entertaining space is made complete with a palapa covered outdoor dining room, infinity pool and intimate courtyard with fireplace. Nestled in Querencia's most picturesque section - Las Colinas, this coastal gem merges traditional design with the tranquility of the surroundings.Las Colinas 54 Las Colinas Single Family Home 4,950,000 USD | 82,493,978 MXN 6 Beds 6 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] => 2024-04-23T16:57:34.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.07348 ) [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] => 4950000 ) [ffd_listing_price_pesos] => Array ( [0] => 82493977.5 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.71476 ) [ffd_community_lot_number] => Array ( [0] => 54 ) [wpcf-lotsize] => Array ( [0] => 34552.44 ) [wpcf-lot-size-sqm] => Array ( [0] => 3210.03 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a09Pk000001fec1IAA ) [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 54 ) [wpcf-squarefeet] => Array ( [0] => 8026.96 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 4950000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Las Colinas 54 Single Family Home ResaleLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => ) [pba__WebsiteId__c] => Array ( [0] => 10326 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-54/ ) [ffd_media] => Array ( [0] => a:13:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/bxjnsadz0/A-TEMPLATE%20WEBSITE11.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/appzpg0jd/A-TEMPLATE%20WEBSITE12.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/kbi81x7lo/A-TEMPLATE%20WEBSITE13.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/lqci1oxjq/A-TEMPLATE%20WEBSITE10.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/ckirj5umz/A-TEMPLATE%20WEBSITE2.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/kvswqpyik/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/2koql03sf/A-TEMPLATE%20WEBSITE8.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/q3v19z7fs/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/axdnt5ek3/A-TEMPLATE%20WEBSITE.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/datt9uvvt/A-TEMPLATE%20WEBSITE3.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/p8o1cwgdm/A-TEMPLATE%20WEBSITE4.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/4cqb0kcme/A-TEMPLATE%20WEBSITE6.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/s5570z3ul/A-TEMPLATE%20WEBSITE7.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/bxjnsadz0/A-TEMPLATE%20WEBSITE11.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000001fec1IAA ) [_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] => ) [_edit_lock] => Array ( [0] => 1711050332:17 ) )
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 ( [_yoast_indexnow_last_ping] => Array ( [0] => 1712850489 ) [ffd_listing_title] => Array ( [0] => Las Colinas 14 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-1261 ) [ffd_salesforce_id] => Array ( [0] => a09Pk000001ePOvIAM ) [ffd_totalarea_pb] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Colinas 14, Querencia, San Jose del Cabo, Baja California Sur, Mexico ) [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] => 2024-03-12T20:18:30.000+0000 ) [ffd_days_on_market] => Array ( [0] => 45 ) [ffd_description_pb] => Array ( [0] => Las Colinas 14 is an incredible homesite within the Querencia Community with breathtaking coastal views where you can build your dream home. With most of the excavation and retaining walls already completed by previous owner, this eliminates the additional expense and time needed so you can start building and enjoying your home sooner.Las Colinas 14 Las Colinas 1,890,000 USD | 31,752,000 MXN
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 piece of paradise.
) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2024-04-04T18:46:39.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.07348 ) [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] => 1890000 ) [ffd_listing_price_pesos] => Array ( [0] => 31752000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.71476 ) [ffd_community_lot_number] => Array ( [0] => Colinas 14 ) [wpcf-lotsize] => Array ( [0] => 25373.98 ) [wpcf-lot-size-sqm] => Array ( [0] => 2357.32 ) [wpcf-mls] => Array ( [0] => 24-1261 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000001ePOvIAM ) [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 14 ) [wpcf-squarefeet] => Array ( [0] => 25373.98 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 1890000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Las Colinas 14 24-1261ResaleLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 10324 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-14-2/ ) [ffd_media] => Array ( [0] => a:12:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/ljr5nmls4/5.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/x6b0kj6dd/4.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/isuo6gjsg/6.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/h8j0glpvy/7.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/6hdkjt5c4/8.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/e6wfl9jfz/9.jpg";i:6;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/1lvti0a9b/A-TEMPLATE%20WEBSITE.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/dzwbv4oa8/A-TEMPLATE%20WEBSITE2.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/73yyqk79w/A-TEMPLATE%20WEBSITE3.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/abclu7nnv/A-TEMPLATE%20WEBSITE4.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/xujuq4109/A-TEMPLATE%20WEBSITE5.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/okp6vm4o4/A-TEMPLATE%20WEBSITE6.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/ljr5nmls4/5.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000001ePOvIAM ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1711050265:17 ) [_edit_last] => Array ( [0] => 17 ) [_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 ) [_ffd_listing_price_pesos] => Array ( [0] => field_64480a754ad5b ) [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_focuskeywords] => Array ( [0] => [] ) [_yoast_wpseo_keywordsynonyms] => Array ( [0] => [""] ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => 1 ) [_yoast_wpseo_wordproof_timestamp] => Array ( [0] => ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) )
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] => 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] => Las Colinas #37 (Casa Amanecer) ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 21-4315 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWg6YQAT ) [ffd_totalarea_pb] => Array ( [0] => 5465.54 ) [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] => 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_createddate] => Array ( [0] => 2021-12-21T20:58:36.000+0000 ) [ffd_days_on_market] => Array ( [0] => 842 ) [ffd_description_pb] => Array ( [0] => An amazing opportunity to own a panoramic ocean view and energy-efficient residence within the masterplanned community of Querencia. The main and lower levels have a frameless glass railing, serving up vistas of endless ocean views from all the bedrooms and even the kitchen, living room and dining room. This elegant, turn-key 4-bedroom, 4.5-bathroom home offers tremendous value. It was built with myriad of elegant details, an open-concept floorplan integrating a large living room, spacious dining room and a chef's kitchen with pristine granite countertops. The upper-level patio offers relaxing and lounging areas with a swimming pool and hot tub and the lower-level terrace has an entertaining area with pool table, TV and a comfortable seating area. The house also includes a state-of-the-art media room with a large screen TV. The garage is conveniently located on the main level with convenient access to the house. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2022-05-09T06:09:48.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.07356 ) [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] => 3285000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.71538 ) [ffd_community_lot_number] => Array ( [0] => 37 ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 21-4315 ) [ffd_website_status_2] => Array ( [0] => Sold ) [wpcf-acarea] => Array ( [0] => 5466 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWg6YQAT ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Sold ) [ffd_name] => Array ( [0] => Las Colinas #37 (Casa Amanecer) ) [wpcf-squarefeet] => Array ( [0] => 9765.24 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3285000 ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [wpcf-keywords] => Array ( [0] => Ocean Las Colinas #37 (Casa Amanecer) Single Family Home 21-4315ResaleLas ColinasSold ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23450 ) [pba__WebsiteId__c] => Array ( [0] => 9249 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-37-casa-amanecer/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/w7yuwg63y/10.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/4i1k5n5uc/1%20copia.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/ray2bup6k/2.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/gg2a5j7ut/3.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/yk8o70aj3/4.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/ymvq3f795/5.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/dbyemyl4i/6.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/8kwonmjqh/7.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/494fitigu/8.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/ay6e9mh83/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/w7yuwg63y/10.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWg6YQAT ) [wpcf-agent-1] => Array ( [0] => 0053Z00000Kt8H2 ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Colinas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [ffd_listing_price_pesos] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850491 ) )Las Colinas #37 (Casa Amanecer) Las Colinas Single Family Home | 5,466 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas #82 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 21-3375 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000ItIAsQAN ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_createddate] => Array ( [0] => 2021-05-17T20:02:39.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1060 ) [ffd_description_pb] => Array ( [0] => This collection of homesites within the award-winning Querencia community are situated on hilltops overlooking the Sea of Cortez with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. Located just beyond the gated entrance of the private, masterplanned community, the homesites at Las Colinas provide the ideal canvas for your truly custom home.Las Colinas #82 Las Colinas Homesite Lot Size 37797 sq ft 3511.46 sq m
Querencia is a private golf and beach resort community home to the award-winning Tom Fazio-designed 18-hole golf course that has been named the best golf course in Mexico by Golfweek magazine and is consistently ranked in the top 100 worldwide by Golf Digest.
Beyond golf, there is so much to enjoy at our #1 rated private community in Cabo. Explore our 1,800 acres of coastline, cliffside and desert to enjoy thoughtfully curated amenities both on land and at sea -- from more than 10 miles of hiking and biking trails, fitness and wellness classes, to stand up paddling and kayaking. Querencia is also home to multiple dining options, a world-class Spa and so much more.
Golf and Social Members are available. ) [featured] => Array ( [0] => no ) [ffd_lastmodifieddate] => Array ( [0] => 2022-05-09T06:09:56.000+0000 ) [ffd_listingprice_pb] => Array ( [0] => 3000000 ) [ffd_community_lot_number] => Array ( [0] => 82 ) [ffd_website_status_2] => Array ( [0] => Sold ) [ffd_listing_agent_1] => Array ( [0] => 005j000000AuC6YAAV ) [ffd_id] => Array ( [0] => a093Z00000ItIAsQAN ) [ffd_name] => Array ( [0] => Las Colinas #82 ) [wpcf-squarefeet] => Array ( [0] => 37797 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [ffd_media] => Array ( [0] => a:24:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/bpb35glhm/8.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/7zbgmqb72/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/ehohhluss/10.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/pmcuaii2b/11.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/px2u3yn6w/2.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/kg224o3hm/3.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/s9s9i0my0/4.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/rpwvln46h/5.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/kv08oq3tg/6.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/c7o6ab1ia/7.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/lektp6vdw/9.jpg";i:11;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/rryywhytr/Clubhouse-3.jpg";i:12;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/pk6blo114/Clubhouse-4.jpg";i:13;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/ptywbh9hj/golf-2.jpg";i:14;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/o9ifknxhs/Golf-5.jpg";i:15;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/mhb8aqbqe/Mountain%20Bike.jpg";i:16;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/jva33dmsg/Pickleball.jpg";i:17;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/63putagr0/Querencia%20Beach%20Club.jpg";i:18;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/4ld8mlphc/slide.jpg";i:19;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/qftgudknt/surf-2.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/p8m5ziv4w/surf-3.jpg";i:21;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/4o7pbht2h/trails-2.jpg";i:22;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/ljx1l8et3/trampoline.jpg";i:23;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/n7eiyf2ea/Yoga%20Querencia.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/bpb35glhm/8.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [pba__WebsiteId__c] => Array ( [0] => 8796 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-82/ ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [_edit_lock] => Array ( [0] => 1635288843: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] => field_608827aae073c ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_yoast_wpseo_primary_category] => Array ( [0] => ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000ItIAsQAN ) [wpcf-property-type] => Array ( [0] => lot ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Sold ) [wpcf-lotsize] => Array ( [0] => 37797 ) [wpcf-lot-size-sqm] => Array ( [0] => 3511.46 ) [wpcf-price] => Array ( [0] => 3000000 ) [wpcf-mls] => Array ( [0] => 21-3375 ) [wpcf-latitude] => Array ( [0] => 23.02823 ) [wpcf-longitude] => Array ( [0] => -109.72755 ) [wpcf-agent-1] => Array ( [0] => 005j000000AuC6Y ) [wpcf-keywords] => Array ( [0] => Ocean Las Colinas #82 Homesite 21-3375DeveloperLas ColinasSold ) [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_yearbuilt_pb] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Colinas ) [ffd_listing_price_pesos] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850513 ) )
SoldSold
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 ) )