SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt1 ON ( wp_tota44soje_posts.ID = mt1.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt2 ON ( wp_tota44soje_posts.ID = mt2.post_id ) WHERE 1=1 AND ( wp_tota44soje_postmeta.meta_key = 'wpcf-price' AND ( ( mt1.meta_key = 'wpcf-ribbon' AND mt1.meta_value IN ('Active','Under Contract','Sold') ) AND ( mt2.meta_key = 'wpcf-listing-type' AND mt2.meta_value = 'resale' ) )) AND wp_tota44soje_posts.post_type = 'properties' AND ((wp_tota44soje_posts.post_status = 'publish')) GROUP BY wp_tota44soje_posts.ID ORDER BY FIELD(mt1.meta_value, 'Active', 'Under Contract', 'Sold'), CAST(wp_tota44soje_postmeta.meta_value AS SIGNED) DESC LIMIT 0, 9
54
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1742424597 ) [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] => 371 ) [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, 6.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,500,000 USD | 82,493,978 MXN | 4,787 A/C SQ FT 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] => 2025-03-19T22:40:09.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] => 4500000 ) [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] => 4500000 ) [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] => 12009 ) [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] => 1742843467:21 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1740435646 ) [ffd_listing_title] => Array ( [0] => Cabaña #01 Upper ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-4712 ) [ffd_salesforce_id] => Array ( [0] => a09Pk000008EXxCIAW ) [ffd_totalarea_pb] => Array ( [0] => 2800 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 3 ) [wpcf-bedrooms] => Array ( [0] => 3 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Cabanas ) [ffd_createddate] => Array ( [0] => 2024-10-04T17:33:39.000+0000 ) [ffd_days_on_market] => Array ( [0] => 146 ) [ffd_description_pb] => Array ( [0] => This second-floor luxury condominium with vaulted high ceilings, sliding pocket doors and a private corner location enjoys breathtaking views of the ocean, golf course, and mountains, as well as Punta Gorda and the evening lights of San José del Cabo. Located within walking distance of Querencia´s Club Village, it combines luxury living with a world-class lifestyle. This three 3 bedroom and 3 bath 2,800-square-foot condominium offers an open floor plan and includes a myriad of elevated architectural and design details throughout. Cabaña 1 is completely ready and comes fully-furnished -- a must-see for the buyer who is looking for move-in ready today.Cabaña #01 Upper Las Cabañas Condominium 3,275,000 USD | 65,925,750 MXN | 2,800 A/C SQ FT 3 Beds 3 Full Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2025-02-24T22:15:27.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] => 3275000 ) [ffd_listing_price_pesos] => Array ( [0] => 65925750 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.7071078 ) [ffd_community_lot_number] => Array ( [0] => 1 ) [wpcf-lotsize] => Array ( [0] => 3673.42 ) [wpcf-lot-size-sqm] => Array ( [0] => 341.27 ) [wpcf-mls] => Array ( [0] => 24-4712 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 2800 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000008EXxCIAW ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Cabaña #01 Upper ) [wpcf-squarefeet] => Array ( [0] => 3673.42 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 3275000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Cabaña #01 Upper Condominium 24-4712ResaleLas CabanasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 11153 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/cabana-01-upper-2/ ) [ffd_media] => Array ( [0] => a:9:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/qud1yanvt/A-TEMPLATE%20WEBSITE8.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/o759sst6x/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/i57cit94y/A-TEMPLATE%20WEBSITE7.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/x6yc56amd/A-TEMPLATE%20WEBSITE11.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/ubv25m1ma/A-TEMPLATE%20WEBSITE3.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/5vlcp1bxz/A-TEMPLATE%20WEBSITE6.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/95r7qwa87/A-TEMPLATE%20WEBSITE12.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/18hhyf6bk/A-TEMPLATE%20WEBSITE15.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/tfssqtjd7/A-TEMPLATE%20WEBSITE16.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003GsViy/qud1yanvt/A-TEMPLATE%20WEBSITE8.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000008EXxCIAW ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1888 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1740514230 ) [ffd_listing_title] => Array ( [0] => Verandas A301 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-5576 ) [ffd_salesforce_id] => Array ( [0] => a09Pk00000ALIXGIA5 ) [ffd_totalarea_pb] => Array ( [0] => 4130.98 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 3 ) [wpcf-bedrooms] => Array ( [0] => 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] => Verandas ) [ffd_createddate] => Array ( [0] => 2024-12-04T20:46:27.000+0000 ) [ffd_days_on_market] => Array ( [0] => 84 ) [ffd_description_pb] => Array ( [0] => This partially-furnished Verandas Penthouse maintains its Latin roots with a fun, colorful, cozy transitional style that is synonymous with Mexico! The living room features lofty 13' coffered ceilings, a charming kitchen and living area that expands seamlessly onto a shaded terrace, capturing the azure waters of the Sea of Cortez. Veranda A-301 has custom finishes and features throughout, located steps away from Querencia´s world-class Clubhouse Village, making the amenities truly an extension of your home. This unit will be looking over holes #1 and #18 of the new golf course at Querencia, also designed by Tom Fazio.Verandas A301 Verandas Condominium 3,100,000 USD | 62,922,374 MXN | 4,131 A/C SQ FT 4 Beds 3 Full Baths 2 Half Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 2 ) [ffd_lastmodifieddate] => Array ( [0] => 2025-02-25T20:05:09.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03094 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3100000 ) [ffd_listing_price_pesos] => Array ( [0] => 62922374 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.75024 ) [ffd_community_lot_number] => Array ( [0] => 301.3 ) [wpcf-lotsize] => Array ( [0] => 4306.47 ) [wpcf-lot-size-sqm] => Array ( [0] => 400.08 ) [wpcf-mls] => Array ( [0] => 24-5576 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a09Pk00000ALIXGIA5 ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas A301 ) [wpcf-squarefeet] => Array ( [0] => 4306.47 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 3100000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas A301 Condominium 24-5576ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 11458 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-a301/ ) [ffd_media] => Array ( [0] => a:12:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/vyn772jjy/A-TEMPLATE%20WEBSITE4.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/w201sesbs/A-TEMPLATE%20WEBSITE3.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/y39dsu61h/A-TEMPLATE%20WEBSITE12.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/4qz4j182e/A-TEMPLATE%20WEBSITE9.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/ocj6ohyu9/A-TEMPLATE%20WEBSITE10.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/3popwywdv/A-TEMPLATE%20WEBSITE11.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/6pgxvradi/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/ifltwxqmr/A-TEMPLATE%20WEBSITE5.jpg";i:8;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/0ejm6ju1s/A-TEMPLATE%20WEBSITE.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/al8uf9ml3/A-TEMPLATE%20WEBSITE2.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/b49257qu7/A-TEMPLATE%20WEBSITE6.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/6fbzzn4p5/A-TEMPLATE%20WEBSITE8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/vyn772jjy/A-TEMPLATE%20WEBSITE4.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk00000ALIXGIA5 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000Kt8H2 ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1738184468 ) [ffd_listing_title] => Array ( [0] => Montaña 17 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-4473 ) [ffd_salesforce_id] => Array ( [0] => a09Pk000008kwveIAA ) [ffd_totalarea_pb] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Montaña #17 ) [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] => 2024-10-18T20:07:54.000+0000 ) [ffd_days_on_market] => Array ( [0] => 107 ) [ffd_description_pb] => Array ( [0] => This exceptional lot is located in an exclusive neighborhood, offering breathtaking panoramic ocean views. Just a short distance from the Querencia Beach Club amenities, enjoy convenient access to pools, dining, fitness center, sports lounge and more. Additionally, the lot is ideally situated near scenic hiking and biking trails, allowing you to embrace the natural beauty of the area while staying active. With a pre-padded and walled foundation, it's ready to accommodate a luxurious single-level home. This is a rare opportunity to build your dream retreat in a peaceful setting, with everything you need just moments away.Montaña 17 La Montaña Homesite 2,800,000 USD | 56,812,000 MXN Lot Size 22981.5 sq ft 2135.05 sq m
Querencia property owners will have the opportunity to purchase Golf or Social memberships Golf & Beach Club. Whether you're a golf enthusiast, beach lover, or seeking tranquility, Querencia Golf & Beach Club represents the perfect Cabo lifestyle. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2025-01-28T17:27:08.000+0000 ) [wpcf-latitude] => 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] => ) [ffd_listingprice_pb] => Array ( [0] => 2800000 ) [ffd_listing_price_pesos] => Array ( [0] => 56812000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => ) [ffd_community_lot_number] => Array ( [0] => 22 ) [wpcf-lotsize] => Array ( [0] => 22981.5 ) [wpcf-lot-size-sqm] => Array ( [0] => 2135.05 ) [wpcf-mls] => Array ( [0] => 24-4473 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000008kwveIAA ) [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] => Montaña 17 ) [wpcf-squarefeet] => Array ( [0] => 22981.5 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 2800000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Montaña 17 Homesite 24-4473ResaleLa MontañaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => ) [pba__WebsiteId__c] => Array ( [0] => 11176 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/montana-17/ ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000008kwveIAA ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8744 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000Kt8H2 ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_media] => Array ( [0] => a:6:{i:0;s:118:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003Ok8zo/kwsmmigjp/A-TEMPLATE%20WEBSITE5-2.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003Ok8zo/2me0h7h32/A-TEMPLATE%20WEBSITE-2.jpg";i:2;s:118:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003Ok8zo/ygwc7i84y/A-TEMPLATE%20WEBSITE3-2.jpg";i:3;s:118:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003Ok8zo/dpr4vmo5u/A-TEMPLATE%20WEBSITE6-2.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003Ok8zo/d2vjwpbtb/A-TEMPLATE%20WEBSITE7.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003Ok8zo/m3phax6oz/A-TEMPLATE%20WEBSITE8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003Ok8zo/kwsmmigjp/A-TEMPLATE%20WEBSITE5-2.jpg ) [_edit_lock] => Array ( [0] => 1733176118:21 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1738184415 ) [ffd_listing_title] => Array ( [0] => El Campo #04 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-4357 ) [ffd_salesforce_id] => Array ( [0] => a09Pk000008D0qPIAS ) [ffd_totalarea_pb] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => El Campo ) [ffd_createddate] => Array ( [0] => 2024-10-03T23:41:47.000+0000 ) [ffd_days_on_market] => Array ( [0] => 117 ) [ffd_description_pb] => Array ( [0] => Experience elevated living at the apex of Querencia. The El Campo enclave includes 11 substantial lots overlooking the 7th hole on the award-winning Tom Fazio course.El Campo #04 El Campo Homesite 1,850,000 USD | 37,628,394 MXN Lot Size 24908 sq ft 2314.03 sq m
The El Campo 4 homesite spans over 39,891 square feet of land allowing you to build an incredibly spacious home in an ideal location within Querencia. Surrounded by the trifecta of Baja beauty: sea, golf and mountain views, and located minutes away from the Clubhouse, the upcoming Canyon Club and award-winning 18-hole golf course, El Campo 4 provides easy access to Querencia’s amenities, including restaurants, pools, fitness center, Men's and Women's Spas, pickleball and tennis court, Kids & Teens Clubs and so much more! Build your dream home in one of the most coveted locations within Querencia.
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] => 2025-01-28T17:25:51.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0769 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 1850000 ) [ffd_listing_price_pesos] => Array ( [0] => 37628394 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70915 ) [ffd_community_lot_number] => Array ( [0] => 4 ) [wpcf-lotsize] => Array ( [0] => 24908 ) [wpcf-lot-size-sqm] => Array ( [0] => 2314.03 ) [wpcf-mls] => Array ( [0] => 24-4357 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 4916 ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000008D0qPIAS ) [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 Campo #04 ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 1850000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean El Campo #04 Homesite 24-4357ResaleEl CampoActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 11111 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-campo-04-2/ ) [ffd_media] => Array ( [0] => a:14:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/xzuvodt94/A-TEMPLATE%20WEBSITE2.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/rkoyhrh6f/A-TEMPLATE%20WEBSITE3.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/3jp6k6o32/A-TEMPLATE%20WEBSITE6.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/lq8mxye93/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/s1n155jz5/A-TEMPLATE%20WEBSITE8.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/d912vtic2/A-TEMPLATE%20WEBSITE7.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/6oq5cblcs/A-TEMPLATE%20WEBSITE5.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/fhz5o6h1t/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/7h9sovlr5/A-TEMPLATE%20WEBSITE12.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/j5hd2a1g7/A-TEMPLATE%20WEBSITE11.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/rq4pb1ocn/A-TEMPLATE%20WEBSITE10.jpg";i:11;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/7vpaa4pye/A-TEMPLATE%20WEBSITE.jpg";i:12;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/ogyd8y1zw/3.jpg";i:13;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/nbqei0wdf/6.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/xzuvodt94/A-TEMPLATE%20WEBSITE2.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000008D0qPIAS ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8668 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1730742561:21 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1738184471 ) [ffd_listing_title] => Array ( [0] => El Parque 43 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk00000AIhQXIA1 ) [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 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] => El Parque ) [ffd_createddate] => Array ( [0] => 2024-12-03T19:20:53.000+0000 ) [ffd_days_on_market] => Array ( [0] => 57 ) [ffd_description_pb] => Array ( [0] => Imagine a place where life unfolds seamlessly—where family and friends gather, nature inspires, and luxury living thrives. Nestled within the prestigious Querencia community, El Parque offers an unparalleled lifestyle centered around 20 acres of beautifully maintained parkland. This exclusive enclave comprises 43 single-family homesites, each thoughtfully designed to blend privacy, serenity and connectivity.El Parque 43 El Parque Homesite 1,850,000 USD | 37,628,394 MXN Lot Size 25060 sq ft 2328.15 sq m
Parque 43 homesite is in a corner lot, offering privacy and the perfect foundation for your dream custom home. Located just steps from the Querencia Club Village, it places you within walking distance of the community’s world-class amenities while preserving a sense of tranquility.
Whether you're envisioning quiet mornings with a view of the sunrise over the mountains or evenings spent entertaining on a terrace overlooking the golf course, this lot offers endless possibilities. At El Parque, you’re not just building a home—you’re creating a lifestyle in one of the most sought-after communities in Los Cabos.
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] => 2025-01-28T17:26:23.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] => 1850000 ) [ffd_listing_price_pesos] => Array ( [0] => 37628394.12 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 43 ) [wpcf-lotsize] => Array ( [0] => 25060 ) [wpcf-lot-size-sqm] => Array ( [0] => 2328.15 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk00000AIhQXIA1 ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => El Parque 43 ) [wpcf-squarefeet] => Array ( [0] => 25060 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 1850000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => El Parque 43 Homesite ResaleEl ParqueActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 11518 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-parque-43/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/r0n82wa3t/A-TEMPLATE%20WEBSITE2.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/s2xnwtkmv/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/3o4rv0idv/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/uk1oxholt/A-TEMPLATE%20WEBSITE5.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/2brg5whsd/A-TEMPLATE%20WEBSITE9.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/qm6x3elqa/A-TEMPLATE%20WEBSITE8.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/3fy67wslc/A-TEMPLATE%20WEBSITE4.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/lcyk5eebz/A-TEMPLATE%20WEBSITE7.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/qw0dgtxwv/A-TEMPLATE%20WEBSITE6.jpg";i:9;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/byk13bdc9/A-TEMPLATE%20WEBSITE.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003kXBGf/r0n82wa3t/A-TEMPLATE%20WEBSITE2.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk00000AIhQXIA1 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8746 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1742308801 ) [ffd_listing_title] => Array ( [0] => La Vista #13 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk00000BlSnJIAV ) [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] => 2025-01-20T19:03:35.000+0000 ) [ffd_days_on_market] => Array ( [0] => 57 ) [ffd_description_pb] => Array ( [0] => La Vista 13 is an exceptional homesite situated in the prestigious Querencia community. This expansive lot offers ample space to design and build the home of your dreams, allowing for endless creativity and customization. Nestled on the mountainside, La Vista 13 boasts stunning panoramic views of the lush Querencia golf course, the majestic surrounding mountains, and the serene Palmilla community. While partial views of the Sea of Cortez can be enjoyed from elevated areas of your future home, the tranquil landscape creates a breathtaking and serene setting. La Vista 13 located within close proximity to Querencia's fully completed Beach Club. Whether you're envisioning a serene retreat or a modern masterpiece, this lot provides the ideal foundation to bring your dream home to life. 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] => 2025-03-18T14:32:19.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.02064 ) [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] => 990000 ) [ffd_listing_price_pesos] => Array ( [0] => 20327064.52 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.72351 ) [ffd_community_lot_number] => Array ( [0] => 13 ) [wpcf-lotsize] => Array ( [0] => 69465.25 ) [wpcf-lot-size-sqm] => Array ( [0] => 6453.53 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk00000BlSnJIAV ) [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 #13 ) [wpcf-squarefeet] => Array ( [0] => 69465.25 ) [wpcf-view] => Array ( [0] => Golf Course ) [wpcf-price] => Array ( [0] => 990000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Golf Course La Vista #13 Homesite ResaleLa VistaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 11980 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-vista-13/ ) [ffd_media] => Array ( [0] => a:23:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/xkc55lgwv/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/gf1hl0o3h/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/6h5rnzg7h/A-TEMPLATE%20WEBSITE4.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/bneb4onfj/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/99kb1xg8v/DJI_20250113130407_0074_D.JPG";i:5;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/75j05ryhj/DJI_20250113130229_0048_D.JPG";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/cunqlgnhl/A-TEMPLATE%20WEBSITE12.jpg";i:7;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/x5by6jjc6/DJI_20250113130150_0034_D.JPG";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/6zbokhj87/A-TEMPLATE%20WEBSITE11.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/q3rqm66cl/A-TEMPLATE%20WEBSITE10.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/5nwrkqoet/A-TEMPLATE%20WEBSITE13.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/eg604r5eu/A-TEMPLATE%20WEBSITE5.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/8p6egmyka/A-TEMPLATE%20WEBSITE6.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/d7t7ebh9r/A-TEMPLATE%20WEBSITE7.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/6e98mdri4/A-TEMPLATE%20WEBSITE8.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/75r50ovr5/A-TEMPLATE%20WEBSITE9.jpg";i:16;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/i3elddekv/DJI_20250113130110_0029_D.JPG";i:17;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/bnlgk3hv2/DJI_20250113130205_0039_D.JPG";i:18;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/ggte2upob/DJI_20250113130759_0084_D.JPG";i:19;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/kxf1vjyrk/DJI_20250113130853_0100_D.JPG";i:20;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/ix6g4qeeu/DJI_20250113131017_0107_D.JPG";i:21;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/o63bsgvt1/DJI_20250113131728_0140_D.JPG";i:22;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/4t86zzijz/DJI_20250113131755_0145_D.JPG";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050urD/xkc55lgwv/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk00000BlSnJIAV ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1880 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )La Vista #13 La Vista Homesite 990,000 USD | 20,327,065 MXN Lot Size 69465.25 sq ft 6453.53 sq m
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1742835003 ) [ffd_listing_title] => Array ( [0] => La Vista #15 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 25-1081 ) [ffd_salesforce_id] => Array ( [0] => a09Pk00000CvCQbIAN ) [ffd_totalarea_pb] => Array ( [0] => 8794.11 ) [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] => 7 ) [wpcf-bedrooms] => Array ( [0] => 7 ) [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 Vista ) [ffd_createddate] => Array ( [0] => 2025-02-24T17:05:04.000+0000 ) [ffd_days_on_market] => Array ( [0] => 31 ) [ffd_description_pb] => Array ( [0] => La Vista 15: A Masterpiece of Light, Space and Ocean ViewsLa Vista #15 La Vista Single Family Home 10,750,000 USD | 219,694,385 MXN | 8,794 A/C SQ FT 7 Beds 7 Full Baths 1 Half Baths
Perched within one of the most coveted locations in San Jose del Cabo, La Vista 15 is a newly-built estate that seamlessly blends modern luxury with breathtaking natural beauty. Spanning approximately 8,000+ square feet of air-conditioned space, this seven-bedroom residence — including a spa and a dedicated nanny’s quarters - sits on a 55,000 sq. ft. lot and is designed for effortless indoor-outdoor living.
From the moment you step through the grand spacious foyer, you are welcomed by a stunning display of natural light that includes skylights, arches, and a striking water feature — setting the tone for this custom home. The thoughtful design maximizes space and inspires welcoming and luminous ambiance throughout.
Unrivaled Ocean Views & Elevated Living
The main level, situated on the second floor, features an open-concept kitchen and living, and dining areas that takes full advantage of sweeping, unobstructed views of the bay. Floor-to-ceiling steel-framed sliding doors seamlessly connect the interiors with a stunning outdoor terrace, complete with a barbecue, lounge area, and a sunken seating nook within the pool area, where the ocean views blend seamlessly into the horizon.
This second floor hosts four of the home’s seven main bedrooms: two primary suites with breathtaking ocean views and two additional bedrooms facing the lush garden area, offering serene privacy.
On the lower level, discover a four-bunk bedroom, a fourth garden-view bedroom, laundry room, utility room and the nanny’s quarters, which is tucked away for additional privacy and has its own kitchenette. This floor also features a family lounge, an expansive terrace, a private sauna and a cold plunge pool, all overlooking a beautifully landscaped garden.
A Private Sanctuary of Wellness & Entertainment
Other standout features include:
-Fully furnished with high-end, custom interiors by De Miguel, a renowned design firm from Mexico City
-Top-of-the-line appliances & finishes throughout
-Expansive pantry, oversized laundry room and utility room
-Maid’s quarters/nanny’s room for added convenience
This exceptional home captures the essence of modern coastal luxury, offering a unique combination of privacy, sophistication, and seamless indoor-outdoor living.
If you’re looking for a turnkey, one-of-a-kind retreat with dramatic ocean views and unparalleled design, La Vista 15 is a rare opportunity in Los Cabos.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2025-03-24T16:48:36.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.02125 ) [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] => 10750000 ) [ffd_listing_price_pesos] => Array ( [0] => 219694385.25 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.72146 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => 55112.94 ) [wpcf-lot-size-sqm] => Array ( [0] => 5120.16 ) [wpcf-mls] => Array ( [0] => 25-1081 ) [ffd_website_status_2] => Array ( [0] => Under Contract ) [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] => a09Pk00000CvCQbIAN ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Under Contract ) [ffd_name] => Array ( [0] => La Vista #15 ) [wpcf-squarefeet] => Array ( [0] => 11207.16 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 10750000 ) [ffd_sort_by] => Array ( [0] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => Ocean La Vista #15 Single Family Home 25-1081ResaleLa VistaUnder Contract ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 11971 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-vista-15/ ) [ffd_media] => Array ( [0] => a:19:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/4l7ix2f87/n-TEMPLATE%20WEBSITE5.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/hsoitoxpm/A-TEMPLATE%20WEBSITE13.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/3wczfmnng/A-TEMPLATE%20WEBSITE14.jpg";i:3;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/gd6prm0pi/n-TEMPLATE%20WEBSITE.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/san6gb2co/n-TEMPLATE%20WEBSITE2.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/5k0baey2l/n-TEMPLATE%20WEBSITE3.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/ungap6noj/n-TEMPLATE%20WEBSITE4.jpg";i:7;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/xn5dwx5hx/A-TEMPLATE%20WEBSITE.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/cwn0bo8ic/A-TEMPLATE%20WEBSITE10.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/cu8sc3l5f/A-TEMPLATE%20WEBSITE12.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/ztjlxpx5l/A-TEMPLATE%20WEBSITE11.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/22jbg1t7j/A-TEMPLATE%20WEBSITE8.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/thb69dzsk/A-TEMPLATE%20WEBSITE9.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/svx9iotj6/A-TEMPLATE%20WEBSITE5.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/cq7zdd45v/A-TEMPLATE%20WEBSITE7.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/6b8tqc72c/A-TEMPLATE%20WEBSITE6.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/oepwukmok/A-TEMPLATE%20WEBSITE2.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/navkxvplm/A-TEMPLATE%20WEBSITE4.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/bo6clwhbu/A-TEMPLATE%20WEBSITE3.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001hRJ6/4l7ix2f87/n-TEMPLATE%20WEBSITE5.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk00000CvCQbIAN ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1880 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1742412020:10 ) )
Under ContractUnder Contract
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1742835004 ) [ffd_listing_title] => Array ( [0] => La Montaña #10 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000006KhqAIAS ) [ffd_totalarea_pb] => Array ( [0] => 5340 ) [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_community] => Array ( [0] => La Montaña ) [ffd_createddate] => Array ( [0] => 2024-08-12T20:54:58.000+0000 ) [ffd_days_on_market] => Array ( [0] => 224 ) [ffd_description_pb] => Array ( [0] => Come home to La Montaña 10, a single-family residence within Querencia with incredible views of the Sea of Cortez. Designed and built by Querencia's in-house team, enter through a private courtyard and into the 4 bedrooms, 4.5 bath, plus family room coastal contemporary villa. With custom finishes throughout, La Montaña 10 was designed to maximize views and social spaces both inside and out.La Montaña #10 La Montaña Single Family Home 6,725,000 USD | 136,046,750 MXN | 5,340 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Outdoor features include an expansive terrace, pool with hot tub, fire pit and outdoor fireplace pavilion. La Montaña 10 offers garage parking for 3 cars and a carport for 2 golf carts and is situated amongst a collection of 29 distinctive homesites in the heart of Querencia.
The tiered elevations allow sweeping views of mountains, arroyos & the crystalline vistas of the Sea of Cortez. Querencia property owners will have the opportunity to purchase Golf or Social memberships Golf & Beach Club. Whether you're a golf enthusiast, beach lover, or seeking tranquility, Querencia Golf & Beach Club represents the perfect Cabo lifestyle. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2025-03-24T16:49:59.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] => 6725000 ) [ffd_listing_price_pesos] => Array ( [0] => 136046750 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 10 ) [wpcf-lotsize] => Array ( [0] => 20860 ) [wpcf-lot-size-sqm] => Array ( [0] => 1937.96 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => Under Contract ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000006KhqAIAS ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Under Contract ) [ffd_name] => Array ( [0] => La Montaña #10 ) [wpcf-squarefeet] => Array ( [0] => 8995 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 6725000 ) [ffd_sort_by] => Array ( [0] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => La Montaña #10 Single Family Home ResaleLa MontañaUnder Contract ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 11175 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-montana-10-2/ ) [ffd_media] => Array ( [0] => a:14:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/bj3p0blqc/A-TEMPLATE%20WEBSITE10.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/9ttdik51s/A-TEMPLATE%20WEBSITE4.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/ixvs1z3ot/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/ez84yh5cy/A-TEMPLATE%20WEBSITE2.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/9e3d399oy/A-TEMPLATE%20WEBSITE11.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/2hp4h8fnb/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/mijrxy32z/A-TEMPLATE%20WEBSITE12.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/p7lc18mdh/A-TEMPLATE%20WEBSITE6.jpg";i:8;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/b4fbha7z0/A-TEMPLATE%20WEBSITE.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/drk65j33q/A-TEMPLATE%20WEBSITE9.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/i7ljxnotv/A-TEMPLATE%20WEBSITE7.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/0quqanqnt/A-TEMPLATE%20WEBSITE8.jpg";i:12;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/8xod8ctrv/Clubhouse-4.jpg";i:13;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/ceyt5qdyy/Clubhouse-3.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho4/bj3p0blqc/A-TEMPLATE%20WEBSITE10.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000006KhqAIAS ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8744 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1733169464:21 ) )
Under ContractUnder Contract
"*" indicates required fields