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
51
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/vgo1o6191/A-TEMPLATE%20WEBSITE2.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/pp0bex6vv/A-TEMPLATE%20WEBSITE.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/lixv3xz1h/A-TEMPLATE%20WEBSITE6.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/o4qiv0yjm/A-TEMPLATE%20WEBSITE5.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/p2fhzl373/A-TEMPLATE%20WEBSITE16.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/24lxr48b0/A-TEMPLATE%20WEBSITE3.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/6p8bzdchd/A-TEMPLATE%20WEBSITE15.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/aia234rrw/A-TEMPLATE%20WEBSITE4.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/sz9xgi2zk/A-TEMPLATE%20WEBSITE7.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/20cbtp6ih/A-TEMPLATE%20WEBSITE10.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/bmxjm70cz/A-TEMPLATE%20WEBSITE8.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/y9t95cvno/A-TEMPLATE%20WEBSITE12.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/6jp0w5vgt/A-TEMPLATE%20WEBSITE9.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/1stpq08jh/A-TEMPLATE%20WEBSITE13.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/33d5fa7d1/A-TEMPLATE%20WEBSITE14.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/r9m4mp4m9/A-TEMPLATE%20WEBSITE11.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/g1f7xqsju/A-TEMPLATE%20WEBSITE2.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/cybdkn937/A-TEMPLATE%20WEBSITE3.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/mfjojt7xn/A-TEMPLATE%20WEBSITE9.jpg [19] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/wrk886dhn/A-TEMPLATE%20WEBSITE4.jpg [20] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/7syutwvhh/A-TEMPLATE%20WEBSITE12.jpg [21] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/i8hptck9c/A-TEMPLATE%20WEBSITE5.jpg [22] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/8ugdfb6xi/A-TEMPLATE%20WEBSITE.jpg [23] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/y6y6tyv7z/A-TEMPLATE%20WEBSITE10.jpg [24] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/sfz48v3bs/A-TEMPLATE%20WEBSITE6.jpg [25] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/ayp1rfjii/A-TEMPLATE%20WEBSITE8.jpg [26] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/9ivcn749p/A-TEMPLATE%20WEBSITE7.jpg [27] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/30qtb36rw/A-TEMPLATE%20WEBSITE13.jpg [28] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/ifka5h8f1/A-TEMPLATE%20WEBSITE14.jpg [29] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/6ak3vsetg/A-TEMPLATE%20WEBSITE15.jpg [30] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/9hvk9dbu6/A-TEMPLATE%20WEBSITE11.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1776745890
)
[ffd_listing_title] => Array
(
[0] => La Vista 22
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 26-293
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000OxyS9IAJ
)
[ffd_totalarea_pb] => Array
(
[0] => 5566.04
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] =>
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 5
)
[wpcf-bedrooms] => Array
(
[0] => 5
)
[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] => 2026-01-16T22:22:29.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 94
)
[ffd_description_pb] => Array
(
[0] => Perched along the canyon near the heart of the community, La Vista 22 is a home defined by its elevation, privacy, and extraordinary panoramic views. The residence enjoys sweeping vistas over the golf course, surrounding mountains, and the Sea of Cortez.
Designed for seamless indoor-outdoor living, the main living areas open directly to expansive terraces, a resort-style pool, and outdoor entertaining spaces. The kitchen, dining, and living areas are all oriented toward the view, capturing stunning sunrises and year-round natural beauty, while the sun sets behind the home.
The floor plan offers a thoughtful separation between social and private spaces. The primary living areas are distinct from the bedroom wings, which are arranged around a landscaped courtyard. Two front-facing suites, including the primary bedroom, enjoy the same expansive views, while three additional guest bedrooms—one configured as a bunk room—are surrounded by lush garden areas.
Completed in 2025, La Vista 22 is offered fully furnished and move-in ready, presenting a rare opportunity to enjoy refined architecture, elevated finishes, and one of the most compelling view corridors within the community. La Vista 22 is also being featured this month in Mexican Architectural Digest, a testament to its architectural significance and thoughtful design. Set on an expansive lot of nearly 50,000 square feet, the property offers exceptional flexibility for future expansion. On the opposite side of the driveway, there is ample space to build a guesthouse, for which the architect has already designed a full three-bedroom guest residence, providing a rare opportunity to further enhance the estate while preserving privacy and scale.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships. (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] => 2026-04-20T20:29:47.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.06189
)
[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] => 12500000
)
[ffd_listing_price_pesos] => Array
(
[0] => 225000000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.69321
)
[ffd_community_lot_number] => Array
(
[0] => 1
)
[wpcf-lotsize] => Array
(
[0] => 49024
)
[wpcf-lot-size-sqm] => Array
(
[0] => 4554.48
)
[wpcf-mls] => Array
(
[0] => 26-293
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 5566
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000LsPqqQAF
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk00000OxyS9IAJ
)
[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 22
)
[wpcf-squarefeet] => Array
(
[0] => 49024
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 12500000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean La Vista 22 Single Family Home 26-293ResaleLa VistaActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 12935
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/la-vista-22/
)
[ffd_media] => Array
(
[0] => a:31:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/vgo1o6191/A-TEMPLATE%20WEBSITE2.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/pp0bex6vv/A-TEMPLATE%20WEBSITE.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/lixv3xz1h/A-TEMPLATE%20WEBSITE6.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/o4qiv0yjm/A-TEMPLATE%20WEBSITE5.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/p2fhzl373/A-TEMPLATE%20WEBSITE16.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/24lxr48b0/A-TEMPLATE%20WEBSITE3.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/6p8bzdchd/A-TEMPLATE%20WEBSITE15.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/aia234rrw/A-TEMPLATE%20WEBSITE4.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/sz9xgi2zk/A-TEMPLATE%20WEBSITE7.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/20cbtp6ih/A-TEMPLATE%20WEBSITE10.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/bmxjm70cz/A-TEMPLATE%20WEBSITE8.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/y9t95cvno/A-TEMPLATE%20WEBSITE12.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/6jp0w5vgt/A-TEMPLATE%20WEBSITE9.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/1stpq08jh/A-TEMPLATE%20WEBSITE13.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/33d5fa7d1/A-TEMPLATE%20WEBSITE14.jpg";i:15;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/r9m4mp4m9/A-TEMPLATE%20WEBSITE11.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/g1f7xqsju/A-TEMPLATE%20WEBSITE2.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/cybdkn937/A-TEMPLATE%20WEBSITE3.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/mfjojt7xn/A-TEMPLATE%20WEBSITE9.jpg";i:19;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/wrk886dhn/A-TEMPLATE%20WEBSITE4.jpg";i:20;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/7syutwvhh/A-TEMPLATE%20WEBSITE12.jpg";i:21;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/i8hptck9c/A-TEMPLATE%20WEBSITE5.jpg";i:22;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/8ugdfb6xi/A-TEMPLATE%20WEBSITE.jpg";i:23;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/y6y6tyv7z/A-TEMPLATE%20WEBSITE10.jpg";i:24;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/sfz48v3bs/A-TEMPLATE%20WEBSITE6.jpg";i:25;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/ayp1rfjii/A-TEMPLATE%20WEBSITE8.jpg";i:26;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/9ivcn749p/A-TEMPLATE%20WEBSITE7.jpg";i:27;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/30qtb36rw/A-TEMPLATE%20WEBSITE13.jpg";i:28;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/ifka5h8f1/A-TEMPLATE%20WEBSITE14.jpg";i:29;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/6ak3vsetg/A-TEMPLATE%20WEBSITE15.jpg";i:30;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/9hvk9dbu6/A-TEMPLATE%20WEBSITE11.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/vgo1o6191/A-TEMPLATE%20WEBSITE2.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000OxyS9IAJ
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1880
)
[_wp_old_slug] => Array
(
[0] => 22v-la-vista-22
)
[ffd_matterport_virtual_tour] => Array
(
[0] =>
)
)
La Vista 22 La Vista Single Family Home 12,500,000 USD | 225,000,000 MXN
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/el0vhyfc7/A-TEMPLATE%20WEBSITE11.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/5qadtccjg/A-TEMPLATE%20WEBSITE9.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/seh5m3ac9/A-TEMPLATE%20WEBSITE12.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/dte2g4yjm/A-TEMPLATE%20WEBSITE8.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/ltdrw5nc3/A-TEMPLATE%20WEBSITE5.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/8n74p0au5/A-TEMPLATE%20WEBSITE14.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/6bbkns94h/A-TEMPLATE%20WEBSITE.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/1tdh9cxbf/A-TEMPLATE%20WEBSITE7.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/i30r2ww2q/A-TEMPLATE%20WEBSITE6.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/jyicxglki/A-TEMPLATE%20WEBSITE10.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/5th3igf9a/A-TEMPLATE%20WEBSITE13.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/6tmppxiei/A-TEMPLATE%20WEBSITE2.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/32mum7flt/A-TEMPLATE%20WEBSITE3.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/iiqw4dbhd/A-TEMPLATE%20WEBSITE4.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1776741217
)
[ffd_listing_title] => Array
(
[0] => Las Colinas 21
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] =>
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000OaPQHIA3
)
[ffd_totalarea_pb] => Array
(
[0] => 6819.47
)
[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] => 9
)
[wpcf-bedrooms] => Array
(
[0] => 10
)
[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] => 2026-01-07T19:56:37.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 103
)
[ffd_description_pb] => Array
(
[0] => Casa Sueños is an extraordinary 10-bedroom estate, thoughtfully designed to embrace large-scale living within Querencia. The property welcomes you into the main house and is composed of a separate casita located just steps away, together functioning as one unified residence. The main house features expansive indoor and outdoor living areas, 7 spacious bedrooms, outdoor showers, a generous pool terrace, and unobstructed views of the Sea of Cortés and Punta Gorda.
The secondary casita offers three additional bedrooms and its own comfortable living spaces, providing flexibility and privacy for guests while remaining part of the overall home experience.
Set on an approximately 2,000-square-meter lot, the property includes six parking spaces and enjoys a prime location just a short walk from the Querencia Beach Club, with easy ocean access through Querencia’s private tunnel. With generous scale, flexible living areas, and a location close to the beach, Casa Sueños offers a rare opportunity within the Colinas neighborhood.
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] => 5
)
[ffd_lastmodifieddate] => Array
(
[0] => 2026-03-13T20:00:48.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.02582
)
[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] => 8995000
)
[ffd_listing_price_pesos] => Array
(
[0] => 154113584
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.7228
)
[ffd_community_lot_number] => Array
(
[0] => 21
)
[wpcf-lotsize] => Array
(
[0] => 26561.75
)
[wpcf-lot-size-sqm] => Array
(
[0] => 2467.67
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 8000
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000LsPqqQAF
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk00000OaPQHIA3
)
[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 21
)
[wpcf-squarefeet] => Array
(
[0] => 12180.77
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 8995000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean Las Colinas 21 Single Family Home ResaleLas ColinasActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 12904
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/las-colinas-21/
)
[ffd_media] => Array
(
[0] => a:14:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/el0vhyfc7/A-TEMPLATE%20WEBSITE11.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/5qadtccjg/A-TEMPLATE%20WEBSITE9.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/seh5m3ac9/A-TEMPLATE%20WEBSITE12.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/dte2g4yjm/A-TEMPLATE%20WEBSITE8.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/ltdrw5nc3/A-TEMPLATE%20WEBSITE5.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/8n74p0au5/A-TEMPLATE%20WEBSITE14.jpg";i:6;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/6bbkns94h/A-TEMPLATE%20WEBSITE.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/1tdh9cxbf/A-TEMPLATE%20WEBSITE7.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/i30r2ww2q/A-TEMPLATE%20WEBSITE6.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/jyicxglki/A-TEMPLATE%20WEBSITE10.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/5th3igf9a/A-TEMPLATE%20WEBSITE13.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/6tmppxiei/A-TEMPLATE%20WEBSITE2.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/32mum7flt/A-TEMPLATE%20WEBSITE3.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/iiqw4dbhd/A-TEMPLATE%20WEBSITE4.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000080K90/el0vhyfc7/A-TEMPLATE%20WEBSITE11.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000OaPQHIA3
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1896
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_matterport_virtual_tour] => Array
(
[0] => https://my.matterport.com/show/?m=Fy8vehLkcp6
)
)
Las Colinas 21 Las Colinas Single Family Home 8,995,000 USD | 154,113,584 MXN
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/bri9bjgrr/Template11.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/pddzj283m/A-TEMPLATE%20WEBSITE13.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/g6atzwu7g/A-TEMPLATE%20WEBSITE10.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/ojvat6w81/A-TEMPLATE%20WEBSITE11.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/94aryfm54/Template4.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/jlz5gzjg7/A-TEMPLATE%20WEBSITE6.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/erqqax5e0/A-TEMPLATE%20WEBSITE3.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/ammanqu9w/Template5.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/jtm8mdbgi/Template6.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/bjd1e2q6z/A-TEMPLATE%20WEBSITE7.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/oeafb7oaq/A-TEMPLATE%20WEBSITE8.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/ypiw2n20h/A-TEMPLATE%20WEBSITE9.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/15gn62jb0/Template7.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/sbs3pjihe/Template2.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/6vi3lr1sf/A-TEMPLATE%20WEBSITE2.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/ezha8n1jw/A-TEMPLATE%20WEBSITE.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/so57y2z7a/A-TEMPLATE%20WEBSITE4.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/u0xf9l3rh/Template3.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/4a3j7ao4u/A-TEMPLATE%20WEBSITE12.jpg [19] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/y1bmkyjdx/Template8.jpg [20] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/yo4jmqfsj/Template9.jpg [21] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/tetw0gqa9/Template12.jpg [22] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/4b0ewn2ct/Template13.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1776735084
)
[ffd_listing_title] => Array
(
[0] => La Montaña 11
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] =>
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000QQG8eIAH
)
[ffd_totalarea_pb] => Array
(
[0] => 4488
)
[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] => 5
)
[wpcf-bedrooms] => Array
(
[0] => 5
)
[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] => 2026-02-23T20:26:25.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 59
)
[ffd_description_pb] => Array
(
[0] => Located within the exclusive private residential community of Querencia, this exceptional custom residence sits on an expansive 19,407 sq ft homesite and offers approximately 8,600 sq ft of thoughtfully designed construction.
Showcasing beautiful ocean views and overlooking the renowned Palmilla Golf Course, this home perfectly captures the essence of elevated Baja living. Just a short 10-minute golf cart ride to the beach and Querencia’s private beach club, the location offers both privacy and convenience within one of Los Cabos’ most sought-after communities.
Designed for seamless indoor-outdoor living, the main level features an open-concept layout with generous living and dining areas, a gourmet kitchen with pantry and full service quarters, and an inviting family/biblioteca space. The primary suite is privately positioned and includes dual walk-in closets, a spa-style bath, and direct access to the terrace and pool area.
Two additional guest bedrooms with en-suite baths are located on the main floor, offering comfort and privacy for family and guests. Expansive covered terraces open to a resort-style outdoor setting complete with a pool, jacuzzi, BBQ area, fire features, and multiple lounge spaces designed for entertaining against a backdrop of ocean and golf course views.
The upper level offers additional guest accommodations, office space, TV lounge, and access to rooftop terraces. A spectacular rooftop with firepit creates the perfect setting for sunset gatherings under the Baja sky.
A rare opportunity to own a newly built estate offering ocean views, golf course frontage, and access to Querencia’s world-class amenities — all just minutes from the sand.
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => no
)
[wpcf-half-bathrooms] => Array
(
[0] => 2
)
[ffd_lastmodifieddate] => Array
(
[0] => 2026-03-13T18:58:13.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] => 8500000
)
[ffd_listing_price_pesos] => Array
(
[0] => 153000000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.70348
)
[ffd_community_lot_number] => Array
(
[0] => 11
)
[wpcf-lotsize] => Array
(
[0] => 19332
)
[wpcf-lot-size-sqm] => Array
(
[0] => 1796
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 4488
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk00000QQG8eIAH
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[ffd_name] => Array
(
[0] => La Montaña 11
)
[wpcf-squarefeet] => Array
(
[0] => 8601.76
)
[wpcf-view] => Array
(
[0] =>
)
[wpcf-price] => Array
(
[0] => 8500000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => La Montaña 11 Single Family Home ResaleLa MontañaActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23406
)
[pba__WebsiteId__c] => Array
(
[0] => 13098
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/la-montana-11/
)
[ffd_media] => Array
(
[0] => a:23:{i:0;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/bri9bjgrr/Template11.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/pddzj283m/A-TEMPLATE%20WEBSITE13.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/g6atzwu7g/A-TEMPLATE%20WEBSITE10.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/ojvat6w81/A-TEMPLATE%20WEBSITE11.jpg";i:4;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/94aryfm54/Template4.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/jlz5gzjg7/A-TEMPLATE%20WEBSITE6.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/erqqax5e0/A-TEMPLATE%20WEBSITE3.jpg";i:7;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/ammanqu9w/Template5.jpg";i:8;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/jtm8mdbgi/Template6.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/bjd1e2q6z/A-TEMPLATE%20WEBSITE7.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/oeafb7oaq/A-TEMPLATE%20WEBSITE8.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/ypiw2n20h/A-TEMPLATE%20WEBSITE9.jpg";i:12;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/15gn62jb0/Template7.jpg";i:13;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/sbs3pjihe/Template2.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/6vi3lr1sf/A-TEMPLATE%20WEBSITE2.jpg";i:15;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/ezha8n1jw/A-TEMPLATE%20WEBSITE.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/so57y2z7a/A-TEMPLATE%20WEBSITE4.jpg";i:17;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/u0xf9l3rh/Template3.jpg";i:18;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/4a3j7ao4u/A-TEMPLATE%20WEBSITE12.jpg";i:19;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/y1bmkyjdx/Template8.jpg";i:20;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/yo4jmqfsj/Template9.jpg";i:21;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/tetw0gqa9/Template12.jpg";i:22;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/4b0ewn2ct/Template13.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyho9/bri9bjgrr/Template11.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000QQG8eIAH
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 8744
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_edit_lock] => Array
(
[0] => 1773436216:21
)
[ffd_matterport_virtual_tour] => Array
(
[0] => https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmy.matterport.com%2Fshow%2F%3Fm%3DqRJyVaYi8W7&data=05%7C02%7Cpkimball%40qcabo.com%7Cca4935e0502b4422d84a08de709e961f%7Cf880e461323848298b9a03d16e57bb8d%7C0%7C0%7C639072023624223614%7CUnknow
)
)
La Montaña 11 La Montaña Single Family Home 8,500,000 USD | 153,000,000 MXN
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/g0fiqmawh/A-TEMPLATE%20WEBSITE4.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/6ofq4ro3u/A-TEMPLATE%20WEBSITE6.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/1hwxy9woe/A-TEMPLATE%20WEBSITE5.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/16t7ay0u1/A-TEMPLATE%20WEBSITE.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/4c11pmfsx/A-TEMPLATE%20WEBSITE7.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/sb7iurfhs/A-TEMPLATE%20WEBSITE6.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/6b84bd1i5/A-TEMPLATE%20WEBSITE9.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/wwfavfvxl/A-TEMPLATE%20WEBSITE8.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/n4c4enkcx/A-TEMPLATE%20WEBSITE9.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/xobsgidq8/A-TEMPLATE%20WEBSITE3.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/0m9emkdjb/A-TEMPLATE%20WEBSITE.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/rup4wk98u/A-TEMPLATE%20WEBSITE10.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/khzhy6r6e/A-TEMPLATE%20WEBSITE2.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/dfbyuy9as/A-TEMPLATE%20WEBSITE4.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/qhkbojg1c/A-TEMPLATE%20WEBSITE.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1776735222
)
[ffd_listing_title] => Array
(
[0] => El Campo 04
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] =>
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000LsBiPIAV
)
[ffd_totalarea_pb] => Array
(
[0] => 4456
)
[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] => 5
)
[wpcf-bedrooms] => Array
(
[0] => 5
)
[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] => 2025-10-24T21:49:45.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 180
)
[ffd_description_pb] => Array
(
[0] => Experience elevated living at Querencia’s El Campo enclave, overlooking the 7th hole of the award-winning Tom Fazio course. This exclusive collection of just eleven homesites captures Baja’s most striking elements—mountain silhouettes, desert terrain, and expansive fairways.
Currently under pre-construction, El Campo 4 started building in December 2025 with an estimated completion of 16 months from groundbreaking. Designed and built by Sepúlveda Arquitectos SC, a renowned multidisciplinary firm headquartered in Mexico City, this five-bedroom residence—including a detached casita—embodies the group’s signature approach: refined design, timeless craftsmanship, and a seamless connection between architecture and environment. Sepúlveda Arquitectos’ portfolio includes high-end private residences, mixed-use developments, corporate spaces, and commercial projects across Mexico, positioning them among the country’s leading architectural studios.
Spanning 4,456 sq. ft. of air-conditioned living space, the home embraces open-concept, indoor-outdoor living with expansive social areas that extend to a covered terrace, infinity-edge pool, and elegant water feature. Sunrises and sunsets can be enjoyed year-round from its elevated position. Set apart from neighboring homes, El Campo 4 offers exceptional privacy with uninterrupted golf and mountain views, plus a gentle glimpse of the sea—a serene, secluded retreat in the heart of 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] => 2
)
[ffd_lastmodifieddate] => Array
(
[0] => 2026-04-07T23:15:33.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] => 7600000
)
[ffd_listing_price_pesos] => Array
(
[0] => 140600000
)
[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] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 4456
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000LsPqqQAF
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk00000LsBiPIAV
)
[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] => 24908
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 7600000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean El Campo 04 Single Family Home ResaleEl CampoActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 12518
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-campo-04-3/
)
[ffd_media] => Array
(
[0] => a:15:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/g0fiqmawh/A-TEMPLATE%20WEBSITE4.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/6ofq4ro3u/A-TEMPLATE%20WEBSITE6.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/1hwxy9woe/A-TEMPLATE%20WEBSITE5.jpg";i:3;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/16t7ay0u1/A-TEMPLATE%20WEBSITE.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/4c11pmfsx/A-TEMPLATE%20WEBSITE7.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/sb7iurfhs/A-TEMPLATE%20WEBSITE6.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/6b84bd1i5/A-TEMPLATE%20WEBSITE9.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/wwfavfvxl/A-TEMPLATE%20WEBSITE8.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/n4c4enkcx/A-TEMPLATE%20WEBSITE9.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/xobsgidq8/A-TEMPLATE%20WEBSITE3.jpg";i:10;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/0m9emkdjb/A-TEMPLATE%20WEBSITE.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/rup4wk98u/A-TEMPLATE%20WEBSITE10.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/khzhy6r6e/A-TEMPLATE%20WEBSITE2.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/dfbyuy9as/A-TEMPLATE%20WEBSITE4.jpg";i:14;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/qhkbojg1c/A-TEMPLATE%20WEBSITE.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/g0fiqmawh/A-TEMPLATE%20WEBSITE4.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000LsBiPIAV
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 8668
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_matterport_virtual_tour] => Array
(
[0] =>
)
)
El Campo 04 El Campo Single Family Home 7,600,000 USD | 140,600,000 MXN
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/5xzspa5ah/IMG_7694.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/nquinvsv5/IMG_7123%202.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/tdctyolud/IMG_7100.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/sg7r90n58/IMG_7098.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/r5faab5gg/IMG_7103.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/umr8yjeia/IMG_7105.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/rbrzal0c2/IMG_7110.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/3jtnn20pa/IMG_7107.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/x6lwyvzxk/IMG_7104.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/bndt9k2h4/DJI-243%20%281%29.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/v8tmq1sww/_EHV8682%20%281%29.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/8j6zordz8/_EHV8677%20%281%29.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1776717322
)
[ffd_listing_title] => Array
(
[0] => El Parque 37
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 25-4887
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000M2cEDIAZ
)
[ffd_totalarea_pb] => Array
(
[0] => 5955.67
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] =>
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 5
)
[wpcf-bedrooms] => Array
(
[0] => 5
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => El Parque
)
[ffd_createddate] => Array
(
[0] => 2025-10-29T19:24:20.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 177
)
[ffd_description_pb] => Array
(
[0] => Discover this exceptional new residence perfectly situated within the sought-after El Parque neighborhood of Querencia. Ideally located just a short walk from the clubhouse, this home offers the best of convenience and community living.
Enjoy a large green space directly in front of the property, ideal for families with children or pets to play and explore. The setting captures beautiful golf course, mountain, and ocean views, creating a serene and picturesque backdrop.
Homes in El Parque are among the most desirable in Querencia, known for their proximity to world-class amenities and a strong sense of neighborhood charm. This stunning new house blends modern luxury with relaxed Baja living, an opportunity not to be missed.
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] => 2026-04-20T20:30:04.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.06189
)
[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] => 7395000
)
[ffd_listing_price_pesos] => Array
(
[0] => 133110000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.69321
)
[ffd_community_lot_number] => Array
(
[0] => 37
)
[wpcf-lotsize] => Array
(
[0] => 22859
)
[wpcf-lot-size-sqm] => Array
(
[0] => 2123.67
)
[wpcf-mls] => Array
(
[0] => 25-4887
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 6959
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000Kt8H2QAJ
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk00000M2cEDIAZ
)
[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 37
)
[wpcf-squarefeet] => Array
(
[0] => 20675
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 7395000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean El Parque 37 Single Family Home 25-4887ResaleEl ParqueActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 12523
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-parque-37/
)
[ffd_media] => Array
(
[0] => a:12:{i:0;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/5xzspa5ah/IMG_7694.jpg";i:1;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/nquinvsv5/IMG_7123%202.jpg";i:2;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/tdctyolud/IMG_7100.jpg";i:3;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/sg7r90n58/IMG_7098.jpg";i:4;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/r5faab5gg/IMG_7103.jpg";i:5;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/umr8yjeia/IMG_7105.jpg";i:6;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/rbrzal0c2/IMG_7110.jpg";i:7;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/3jtnn20pa/IMG_7107.jpg";i:8;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/x6lwyvzxk/IMG_7104.jpg";i:9;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/bndt9k2h4/DJI-243%20%281%29.jpg";i:10;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/v8tmq1sww/_EHV8682%20%281%29.jpg";i:11;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/8j6zordz8/_EHV8677%20%281%29.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00006tWmxN/5xzspa5ah/IMG_7694.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000M2cEDIAZ
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 8746
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000Kt8H2
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_matterport_virtual_tour] => Array
(
[0] => https://my.matterport.com/show/?m=XCvvjvWgNTL
)
[_oembed_4d66e3ed5b2a23bd31ba9ef41020021d] => Array
(
[0] =>
)
[_oembed_time_4d66e3ed5b2a23bd31ba9ef41020021d] => Array
(
[0] => 1776455615
)
)
El Parque 37 El Parque Single Family Home 7,395,000 USD | 133,110,000 MXN
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/h6g43y1ez/A-TEMPLATE%20WEBSITE11.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/tac3794jp/A-TEMPLATE%20WEBSITE6.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/fum38ad11/A-TEMPLATE%20WEBSITE.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/gqjrmvfk2/A-TEMPLATE%20WEBSITE2.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/cchir5nsr/A-TEMPLATE%20WEBSITE3.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/qa6cf4ac6/A-TEMPLATE%20WEBSITE4.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/af44w9xjx/A-TEMPLATE%20WEBSITE5.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/ce9os9ko5/A-TEMPLATE%20WEBSITE7.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/d6bgb2u4b/A-TEMPLATE%20WEBSITE8.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/ajpp48oa1/A-TEMPLATE%20WEBSITE9.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/psx2kkgxe/A-TEMPLATE%20WEBSITE10.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1776797525
)
[ffd_listing_title] => Array
(
[0] => Las Colinas #25 (Casa Esteban)
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 26-1316
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000Qu46oIAB
)
[ffd_totalarea_pb] => Array
(
[0] => 7000.1
)
[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] => 6
)
[wpcf-bedrooms] => Array
(
[0] => 6
)
[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] => 2026-03-05T23:08:23.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 47
)
[ffd_description_pb] => Array
(
[0] => Las Colinas 25 is an exceptional six-bedroom estate with unobstructed views of the San Jose coastline stretching to Punta Gorda.
Designed to embrace seamless indoor-outdoor living within Querencia, the home features expansive living areas that open onto a generous pool terrace—ideal for enjoying panoramic ocean views and year-round entertaining.
In the main house, the living areas and the primary bedroom offer breathtaking views to the Sea of Cortez. Four spacious guest suites are privately situated in their own wing, offering comfort and independence, while a separate ground-level studio serves as the sixth bedroom, ideal for guests or staff. The property also includes three parking spaces and is just a short walk to the Querencia Beach Club.
A rare opportunity to own a retreat in one of San José del Cabo most desirable communities.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships. (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] => 2026-03-17T22:05:38.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.0636
)
[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] => 7195000
)
[ffd_listing_price_pesos] => Array
(
[0] => 129510000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.70242
)
[ffd_community_lot_number] => Array
(
[0] => 25
)
[wpcf-lotsize] => Array
(
[0] => 22854.45
)
[wpcf-lot-size-sqm] => Array
(
[0] => 2123.25
)
[wpcf-mls] => Array
(
[0] => 26-1316
)
[ffd_matterport_virtual_tour] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 7000
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_listing_agent_2] => Array
(
[0] => 0053Z00000LQVhoQAH
)
[ffd_id] => Array
(
[0] => a09Pk00000Qu46oIAB
)
[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 #25 (Casa Esteban)
)
[wpcf-squarefeet] => Array
(
[0] => 13015.92
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 7195000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean Las Colinas #25 (Casa Esteban) Single Family Home 26-1316ResaleLas ColinasActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 13136
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/las-colinas-25-casa-esteban/
)
[ffd_media] => Array
(
[0] => a:11:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/h6g43y1ez/A-TEMPLATE%20WEBSITE11.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/tac3794jp/A-TEMPLATE%20WEBSITE6.jpg";i:2;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/fum38ad11/A-TEMPLATE%20WEBSITE.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/gqjrmvfk2/A-TEMPLATE%20WEBSITE2.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/cchir5nsr/A-TEMPLATE%20WEBSITE3.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/qa6cf4ac6/A-TEMPLATE%20WEBSITE4.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/af44w9xjx/A-TEMPLATE%20WEBSITE5.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/ce9os9ko5/A-TEMPLATE%20WEBSITE7.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/d6bgb2u4b/A-TEMPLATE%20WEBSITE8.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/ajpp48oa1/A-TEMPLATE%20WEBSITE9.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/psx2kkgxe/A-TEMPLATE%20WEBSITE10.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00008DbWiG/h6g43y1ez/A-TEMPLATE%20WEBSITE11.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000Qu46oIAB
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1896
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-agent-2] => Array
(
[0] => 0053Z00000LQVho
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
Las Colinas #25 (Casa Esteban) Las Colinas Single Family Home 7,195,000 USD | 129,510,000 MXN
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/jkgzwp41y/A-TEMPLATE%20WEBSITE17.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/48g2da25u/A-TEMPLATE%20WEBSITE9.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/2nyqsc5jr/A-TEMPLATE%20WEBSITE10.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/km3j0p2t3/A-TEMPLATE%20WEBSITE11.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/9kywpf7t3/A-TEMPLATE%20WEBSITE12.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/0g9fdlub5/A-TEMPLATE%20WEBSITE3.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/oftuhdqx4/A-TEMPLATE%20WEBSITE4.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/a76z2r6m1/A-TEMPLATE%20WEBSITE.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/9ng9mgavl/A-TEMPLATE%20WEBSITE2.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/wqjj3jzms/A-TEMPLATE%20WEBSITE7.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/8bvm969wk/A-TEMPLATE%20WEBSITE8.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/a2bo44u1p/A-TEMPLATE%20WEBSITE13.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/a8l6apke0/A-TEMPLATE%20WEBSITE6.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/zr183is9n/A-TEMPLATE%20WEBSITE14.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/85q1zy127/7.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/liord4up3/8.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1776716207
)
[ffd_listing_title] => Array
(
[0] => Verandas C-102
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 26-1651
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000Rm2mMIAR
)
[ffd_totalarea_pb] => Array
(
[0] => 3868.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_community] => Array
(
[0] => Verandas
)
[ffd_createddate] => Array
(
[0] => 2026-03-26T20:38:49.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 20
)
[ffd_description_pb] => Array
(
[0] => Set within the exclusive Verandas enclave, Veranda C-102 is an exceptional fully furnished residence offering elevated canyon views and sweeping panoramas of Punta Gorda, the Sea of Cortez, and San José del Cabo. Thoughtfully designed for effortless luxury living, this expansive open-concept home features 4 bedrooms and 4.5 bathrooms, complemented by a private elevator that opens directly into the residence for an added sense of privacy and exclusivity.
Inside, the home showcases a gourmet kitchen and generous living spaces that seamlessly extend onto an oversized terrace, creating an ideal setting for effortless indoor-outdoor living and entertaining.
Perfectly positioned just steps from the community’s world-class Clubhouse and award-winning 18-hole golf course, this residence offers convenient access to Querencia’s premier amenities, including exceptional dining venues, resort-style pools, fitness center, Men’s and Women’s Spas, pickleball and tennis courts, Kids’ and Teens’ Clubs, The Canyon Club, and much more.
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] => 2026-04-02T23:14:13.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.06142
)
[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] => 4395000
)
[ffd_listing_price_pesos] => Array
(
[0] => 79110000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.70378
)
[ffd_community_lot_number] => Array
(
[0] => 102
)
[wpcf-lotsize] => Array
(
[0] =>
)
[wpcf-lot-size-sqm] => Array
(
[0] => 0
)
[wpcf-mls] => Array
(
[0] => 26-1651
)
[ffd_matterport_virtual_tour] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 3869
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] => 005f100000I1eqJAAR
)
[ffd_listing_agent_2] => Array
(
[0] => 0053Z00000LQVhoQAH
)
[ffd_id] => Array
(
[0] => a09Pk00000Rm2mMIAR
)
[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 C-102
)
[wpcf-squarefeet] => Array
(
[0] => 4789.38
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 4395000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean Verandas C-102 Condominium 26-1651ResaleVerandasActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 13201
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/verandas-c-102-2/
)
[ffd_media] => Array
(
[0] => a:16:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/jkgzwp41y/A-TEMPLATE%20WEBSITE17.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/48g2da25u/A-TEMPLATE%20WEBSITE9.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/2nyqsc5jr/A-TEMPLATE%20WEBSITE10.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/km3j0p2t3/A-TEMPLATE%20WEBSITE11.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/9kywpf7t3/A-TEMPLATE%20WEBSITE12.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/0g9fdlub5/A-TEMPLATE%20WEBSITE3.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/oftuhdqx4/A-TEMPLATE%20WEBSITE4.jpg";i:7;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/a76z2r6m1/A-TEMPLATE%20WEBSITE.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/9ng9mgavl/A-TEMPLATE%20WEBSITE2.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/wqjj3jzms/A-TEMPLATE%20WEBSITE7.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/8bvm969wk/A-TEMPLATE%20WEBSITE8.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/a2bo44u1p/A-TEMPLATE%20WEBSITE13.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/a8l6apke0/A-TEMPLATE%20WEBSITE6.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/zr183is9n/A-TEMPLATE%20WEBSITE14.jpg";i:14;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/85q1zy127/7.jpg";i:15;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/liord4up3/8.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueE/jkgzwp41y/A-TEMPLATE%20WEBSITE17.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000Rm2mMIAR
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1899
)
[wpcf-agent-1] => Array
(
[0] => 005f100000I1eqJ
)
[wpcf-agent-2] => Array
(
[0] => 0053Z00000LQVho
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
Verandas C-102 Verandas Condominium 4,395,000 USD | 79,110,000 MXN
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/lioljpcrv/A-TEMPLATE%20WEBSITE.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/9gcbc3d5s/A-TEMPLATE%20WEBSITE2.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/elyg7skno/A-TEMPLATE%20WEBSITE3.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/cdna8borb/A-TEMPLATE%20WEBSITE7.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/p107e0sf1/A-TEMPLATE%20WEBSITE6.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/5rklgbhgl/A-TEMPLATE%20WEBSITE10.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/zqb43e9jn/A-TEMPLATE%20WEBSITE9.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/wfd44128x/A-TEMPLATE%20WEBSITE4.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/ylcf71z1d/A-TEMPLATE%20WEBSITE5.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/korelm8an/A-TEMPLATE%20WEBSITE8.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1776716306
)
[ffd_listing_title] => Array
(
[0] => Las Colinas 19
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 26-243
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000OsExpIAF
)
[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 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] => 2026-01-14T22:20:52.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 105
)
[ffd_description_pb] => Array
(
[0] => Las Colinas 19 is ideally positioned within one of Querencia’s most sought-after sections, offering expansive coastal views and an exceptional sense of privacy. Located just moments from the Querencia Beach Club, this homesite enjoys panoramic vistas over the crystal-blue Sea of Cortez, stretching across the San José del Cabo coastline toward Punta Gorda. Its elevated setting and proximity to the ocean make it a truly special opportunity for those looking to build a custom home in one of the community’s most desirable locations—close to the sea while remaining within the heart of Querencia.
Querencia is a private golf and beach resort community anchored by the award-winning Tom Fazio–designed 18-hole golf course, consistently ranked among the top courses in the world and named the best golf course in Mexico by Golfweek magazine. In addition, a second Tom Fazio–designed 18-hole course is currently under development, further enhancing the community’s long-term vision. Beyond golf, residents enjoy an exceptional lifestyle with access to the clubhouse, beach club, extensive hiking and biking trails, and the newly opened Canyon Club—designed as a vibrant hub for youth and family-focused amenities.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a wide array of world-class 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] => 2026-02-11T22:56:54.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.02622
)
[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] => 3750000
)
[ffd_listing_price_pesos] => Array
(
[0] => 66937500
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.72235
)
[ffd_community_lot_number] => Array
(
[0] => 19
)
[wpcf-lotsize] => Array
(
[0] => 42851.62
)
[wpcf-lot-size-sqm] => Array
(
[0] => 3981.05
)
[wpcf-mls] => Array
(
[0] => 26-243
)
[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] => a09Pk00000OsExpIAF
)
[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 19
)
[wpcf-squarefeet] => Array
(
[0] => 42851.66556
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 3750000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean Las Colinas 19 Homesite 26-243ResaleLas ColinasActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 12933
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/las-colinas-19/
)
[ffd_media] => Array
(
[0] => a:10:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/lioljpcrv/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/9gcbc3d5s/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/elyg7skno/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/cdna8borb/A-TEMPLATE%20WEBSITE7.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/p107e0sf1/A-TEMPLATE%20WEBSITE6.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/5rklgbhgl/A-TEMPLATE%20WEBSITE10.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/zqb43e9jn/A-TEMPLATE%20WEBSITE9.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/wfd44128x/A-TEMPLATE%20WEBSITE4.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/ylcf71z1d/A-TEMPLATE%20WEBSITE5.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/korelm8an/A-TEMPLATE%20WEBSITE8.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CsUT/lioljpcrv/A-TEMPLATE%20WEBSITE.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000OsExpIAF
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1896
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_matterport_virtual_tour] => Array
(
[0] =>
)
)
Las Colinas 19 Las Colinas Homesite 3,750,000 USD | 66,937,500 MXN Lot Size 42851.62 sq ft 3981.05 sq m
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/4mmjy7d4n/A-TEMPLATE%20WEBSITE.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/yedq6lbca/A-TEMPLATE%20WEBSITE12.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/mdd10n5l6/A-TEMPLATE%20WEBSITE4.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/62tsj48d6/A-TEMPLATE%20WEBSITE6.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/c4beba7x6/A-TEMPLATE%20WEBSITE11.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/tl5y7cvab/A-TEMPLATE%20WEBSITE7.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/hh9m0awge/A-TEMPLATE%20WEBSITE5.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/hhsditvds/A-TEMPLATE%20WEBSITE10.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/5i2syh8ox/A-TEMPLATE%20WEBSITE2.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/qdu9lsjr9/A-TEMPLATE%20WEBSITE3.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/av5w54zc4/A-TEMPLATE%20WEBSITE3.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/hllvudl3r/A-TEMPLATE%20WEBSITE2.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/9y7z2wte6/A-TEMPLATE%20WEBSITE.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/o3zfd0nqb/A-TEMPLATE%20WEBSITE9.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/j2cfvg3lj/A-TEMPLATE%20WEBSITE8.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1776716255
)
[ffd_listing_title] => Array
(
[0] => La Montaña 3
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 25-5635
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000NhvllIAB
)
[ffd_totalarea_pb] => Array
(
[0] =>
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] =>
)
[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] => 2025-12-11T22:22:39.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 132
)
[ffd_description_pb] => Array
(
[0] => Introducing La Montaña Lot #3, an exceptional half-acre homesite located in one of Querencia's most coveted enclaves. Set on a flat terrain, this property showcases wide, vistas of the Sea of Cortez, offering a breathtaking panorama that shifts beautifully throughout the day, from the first light of sunrise to the warm glow of sunset. Situated within the prestigious La Montaña neighborhood, Lot #3 provides an outstanding blend of privacy, natural beauty, and exclusivity. Its generous scale presents an ideal opportunity to design a custom luxury residence with expansive indoor-outdoor living spaces, a resort-style pool terrace, elegant gardens, and the freedom to explore a variety of architectural styles.
This unique property comes with a Social Membership to the club, 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] => 2026-03-21T18:46:45.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.06189
)
[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] => 2385000
)
[ffd_listing_price_pesos] => Array
(
[0] => 42930000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.69321
)
[ffd_community_lot_number] => Array
(
[0] => 3
)
[wpcf-lotsize] => Array
(
[0] => 23164.12
)
[wpcf-lot-size-sqm] => Array
(
[0] => 2152.02
)
[wpcf-mls] => Array
(
[0] => 25-5635
)
[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] => 0053Z00000LsPqqQAF
)
[ffd_id] => Array
(
[0] => a09Pk00000NhvllIAB
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[ffd_name] => Array
(
[0] => La Montaña 3
)
[wpcf-squarefeet] => Array
(
[0] => 23164.12
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 2385000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean La Montaña 3 Homesite 25-5635ResaleLa MontañaActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 12682
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/la-montana-3/
)
[ffd_media] => Array
(
[0] => a:15:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/4mmjy7d4n/A-TEMPLATE%20WEBSITE.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/yedq6lbca/A-TEMPLATE%20WEBSITE12.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/mdd10n5l6/A-TEMPLATE%20WEBSITE4.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/62tsj48d6/A-TEMPLATE%20WEBSITE6.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/c4beba7x6/A-TEMPLATE%20WEBSITE11.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/tl5y7cvab/A-TEMPLATE%20WEBSITE7.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/hh9m0awge/A-TEMPLATE%20WEBSITE5.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/hhsditvds/A-TEMPLATE%20WEBSITE10.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/5i2syh8ox/A-TEMPLATE%20WEBSITE2.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/qdu9lsjr9/A-TEMPLATE%20WEBSITE3.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/av5w54zc4/A-TEMPLATE%20WEBSITE3.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/hllvudl3r/A-TEMPLATE%20WEBSITE2.jpg";i:12;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/9y7z2wte6/A-TEMPLATE%20WEBSITE.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/o3zfd0nqb/A-TEMPLATE%20WEBSITE9.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/j2cfvg3lj/A-TEMPLATE%20WEBSITE8.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007MHlP5/4mmjy7d4n/A-TEMPLATE%20WEBSITE.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000NhvllIAB
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 8744
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000Kt8H2
)
[wpcf-agent-2] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_matterport_virtual_tour] => Array
(
[0] =>
)
)
La Montaña 3 La Montaña Homesite 2,385,000 USD | 42,930,000 MXN Lot Size 23164.12 sq ft 2152.02 sq m "*" indicates required fields

