plain content
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor
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 ) 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 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
189
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] => 1769199345
)
[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] => 15
)
[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, a generous pool terrace, and unobstructed views of the Sea of Cortés and Punta Gorda, along with four bedrooms.
The secondary casita offers six 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] => 3
)
[ffd_lastmodifieddate] => Array
(
[0] => 2026-01-20T22:17:17.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] => 12500000
)
[ffd_listing_price_pesos] => Array
(
[0] => 224750000
)
[wpcf-listing-type] => Array
(
[0] => Resale: Querencia Listing
)
[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] => 12500000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean Las Colinas #21 Single Family Home Resale: Querencia ListingLas 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] =>
)
)
Las Colinas #21 Las Colinas Single Family Home 12,500,000 USD | 224,750,000 MXN | 6,819 A/C SQ FT 10 Beds 9 Full Baths 3 Half Baths
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/r9m4mp4m9/A-TEMPLATE%20WEBSITE11.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/g1f7xqsju/A-TEMPLATE%20WEBSITE2.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/cybdkn937/A-TEMPLATE%20WEBSITE3.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/mfjojt7xn/A-TEMPLATE%20WEBSITE9.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/wrk886dhn/A-TEMPLATE%20WEBSITE4.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/7syutwvhh/A-TEMPLATE%20WEBSITE12.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/i8hptck9c/A-TEMPLATE%20WEBSITE5.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/8ugdfb6xi/A-TEMPLATE%20WEBSITE.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/y6y6tyv7z/A-TEMPLATE%20WEBSITE10.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/sfz48v3bs/A-TEMPLATE%20WEBSITE6.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/ayp1rfjii/A-TEMPLATE%20WEBSITE8.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/9ivcn749p/A-TEMPLATE%20WEBSITE7.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/30qtb36rw/A-TEMPLATE%20WEBSITE13.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/ifka5h8f1/A-TEMPLATE%20WEBSITE14.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/6ak3vsetg/A-TEMPLATE%20WEBSITE15.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769305714
)
[ffd_listing_title] => Array
(
[0] => 22V (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] => 7
)
[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-01-23T18:11:14.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] =>
)
[wpcf-listing-type] => Array
(
[0] => Resale: Querencia Listing
)
[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] => 22V (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 22V (La Vista 22) Single Family Home 26-293Resale: Querencia ListingLa 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/22v-la-vista-22/
)
[ffd_media] => Array
(
[0] => a:15:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/r9m4mp4m9/A-TEMPLATE%20WEBSITE11.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/g1f7xqsju/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/cybdkn937/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/mfjojt7xn/A-TEMPLATE%20WEBSITE9.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/wrk886dhn/A-TEMPLATE%20WEBSITE4.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/7syutwvhh/A-TEMPLATE%20WEBSITE12.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/i8hptck9c/A-TEMPLATE%20WEBSITE5.jpg";i:7;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/8ugdfb6xi/A-TEMPLATE%20WEBSITE.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/y6y6tyv7z/A-TEMPLATE%20WEBSITE10.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/sfz48v3bs/A-TEMPLATE%20WEBSITE6.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/ayp1rfjii/A-TEMPLATE%20WEBSITE8.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/9ivcn749p/A-TEMPLATE%20WEBSITE7.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/30qtb36rw/A-TEMPLATE%20WEBSITE13.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/ifka5h8f1/A-TEMPLATE%20WEBSITE14.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/6ak3vsetg/A-TEMPLATE%20WEBSITE15.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00005nMN4s/r9m4mp4m9/A-TEMPLATE%20WEBSITE11.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
)
)
22V (La Vista 22) La Vista Single Family Home 12,500,000 USD | 5,566 A/C SQ FT 5 Beds 5 Full Baths 1 Half Baths
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/g0fiqmawh/A-TEMPLATE%20WEBSITE4.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/16t7ay0u1/A-TEMPLATE%20WEBSITE.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/rup4wk98u/A-TEMPLATE%20WEBSITE10.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/sb7iurfhs/A-TEMPLATE%20WEBSITE6.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/xobsgidq8/A-TEMPLATE%20WEBSITE3.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/4c11pmfsx/A-TEMPLATE%20WEBSITE7.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/wwfavfvxl/A-TEMPLATE%20WEBSITE8.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/6b84bd1i5/A-TEMPLATE%20WEBSITE9.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/0m9emkdjb/A-TEMPLATE%20WEBSITE.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/khzhy6r6e/A-TEMPLATE%20WEBSITE2.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/dfbyuy9as/A-TEMPLATE%20WEBSITE4.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769195426
)
[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] => 92
)
[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-01-12T21:08:29.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: Querencia Listing
)
[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 Resale: Querencia ListingEl 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:11:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/g0fiqmawh/A-TEMPLATE%20WEBSITE4.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/16t7ay0u1/A-TEMPLATE%20WEBSITE.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/rup4wk98u/A-TEMPLATE%20WEBSITE10.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/sb7iurfhs/A-TEMPLATE%20WEBSITE6.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/xobsgidq8/A-TEMPLATE%20WEBSITE3.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/4c11pmfsx/A-TEMPLATE%20WEBSITE7.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/wwfavfvxl/A-TEMPLATE%20WEBSITE8.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/6b84bd1i5/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/0m9emkdjb/A-TEMPLATE%20WEBSITE.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/khzhy6r6e/A-TEMPLATE%20WEBSITE2.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/dfbyuy9as/A-TEMPLATE%20WEBSITE4.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] =>
)
)
El Campo #04 El Campo Single Family Home 7,600,000 USD | 140,600,000 MXN | 4,456 A/C SQ FT 5 Beds 5 Full Baths 2 Half Baths
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] => 1769308866
)
[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] => 89
)
[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] => 2025-12-08T22:50:18.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] => 7595000
)
[ffd_listing_price_pesos] => Array
(
[0] => 140507500
)
[wpcf-listing-type] => Array
(
[0] => Resale: Querencia Listing
)
[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] => 7595000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean El Parque 37 Single Family Home 25-4887Resale: Querencia ListingEl 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] =>
)
)
El Parque 37 El Parque Single Family Home 7,595,000 USD | 140,507,500 MXN | 5,956 A/C SQ FT 5 Beds 5 Full Baths 1 Half Baths
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/x8o24nm0j/A-TEMPLATE%20WEBSITE4.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/k9ssr41ec/A-TEMPLATE%20WEBSITE5.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/c6ok2fqgf/A-TEMPLATE%20WEBSITE6.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/qjbqtwzxh/A-TEMPLATE%20WEBSITE7.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/fhtn7sq08/Lago%20Ascendente%20-%20Escalera%20Primer%20Nivel%20%20%281%29%20PB.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/njqc3bpy6/A-TEMPLATE%20WEBSITE8.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/4gmrsgoqd/A-TEMPLATE%20WEBSITE9.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/wmakq6tpy/A-TEMPLATE%20WEBSITE.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/czfcysvxk/A-TEMPLATE%20WEBSITE2.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/mb9v8jpf8/A-TEMPLATE%20WEBSITE3.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769199440
)
[ffd_listing_title] => Array
(
[0] => El Lago Ascendant 6
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 24-728
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000000uwcPIAQ
)
[ffd_totalarea_pb] => Array
(
[0] => 4608
)
[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] => Los Cabos
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => El Lago
)
[ffd_createddate] => Array
(
[0] => 2024-02-07T18:00:38.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 715
)
[ffd_description_pb] => Array
(
[0] => Located centrally within the private Querencia masterplanned community, El Lago features 16 single-family villas with vertical living layouts of two and three levels, maximizing views and social space for families and friends. Inspired by the Baja with welcoming and grounded earth tones, the residences offer modern living and timeless elegance within Los Cabos’ most vibrant private community.
The Ascendant villas feature living spaces – gourmet kitchen, dining, great room and family rooms on the main floor – seamlessly flowing to the outdoor terrace and pool. Upstairs are 4 bedrooms complete with ensuite baths and terraces overlooking the Querencia lake, Sea of Cortez, mountains and arroyo. Find two-car garage and double golf cart parking, storage and flex space on the ground level with the main entrance.
The residence features a hot tub, fire pit, interior and exterior fireplaces, BBQ and a private interior elevator.
View the El Lago brochure here.
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-12-22T23:49:39.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] => 4721000
)
[ffd_listing_price_pesos] => Array
(
[0] => 84978000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.7071078
)
[ffd_community_lot_number] => Array
(
[0] => A6
)
[wpcf-lotsize] => Array
(
[0] => 7418
)
[wpcf-lot-size-sqm] => Array
(
[0] => 689.15
)
[wpcf-mls] => Array
(
[0] => 24-728
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 4608
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk000000uwcPIAQ
)
[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 Lago Ascendant 6
)
[wpcf-squarefeet] => Array
(
[0] => 6578
)
[wpcf-view] => Array
(
[0] => Golf Course
)
[wpcf-price] => Array
(
[0] => 4721000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Golf Course El Lago Ascendant 6 Single Family Home 24-728DeveloperEl LagoActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 10307
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-lago-ascendant-6/
)
[ffd_media] => Array
(
[0] => a:10:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/x8o24nm0j/A-TEMPLATE%20WEBSITE4.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/k9ssr41ec/A-TEMPLATE%20WEBSITE5.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/c6ok2fqgf/A-TEMPLATE%20WEBSITE6.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/qjbqtwzxh/A-TEMPLATE%20WEBSITE7.jpg";i:4;s:162:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/fhtn7sq08/Lago%20Ascendente%20-%20Escalera%20Primer%20Nivel%20%20%281%29%20PB.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/njqc3bpy6/A-TEMPLATE%20WEBSITE8.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/4gmrsgoqd/A-TEMPLATE%20WEBSITE9.jpg";i:7;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/wmakq6tpy/A-TEMPLATE%20WEBSITE.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/czfcysvxk/A-TEMPLATE%20WEBSITE2.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/mb9v8jpf8/A-TEMPLATE%20WEBSITE3.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/x8o24nm0j/A-TEMPLATE%20WEBSITE4.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000000uwcPIAQ
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9607
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
El Lago Ascendant 6 El Lago Single Family Home 4,721,000 USD | 84,978,000 MXN | 4,608 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/q8m98wat7/A-TEMPLATE%20WEBSITE3.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/f1jzii6rw/A-TEMPLATE%20WEBSITE4.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/1xlqi5cbt/A-TEMPLATE%20WEBSITE5.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/yyye3mkft/Lago%20Ascendente%20-%20Escalera%20Planta%20Baja%20%28Garage%29%20PB.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/mqxm92wpd/A-TEMPLATE%20WEBSITE2.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/wnbbzbox0/A-TEMPLATE%20WEBSITE.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/nrg3006ej/A-TEMPLATE%20WEBSITE7.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/amgdx8hag/A-TEMPLATE%20WEBSITE8.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/icgdx67ja/A-TEMPLATE%20WEBSITE9.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/xb1rlcq3j/A-TEMPLATE%20WEBSITE6.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769107974
)
[ffd_listing_title] => Array
(
[0] => El Lago Ascendant 5
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 24-727
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000000uvrdIAA
)
[ffd_totalarea_pb] => Array
(
[0] => 4608
)
[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] => Los Cabos
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => El Lago
)
[ffd_createddate] => Array
(
[0] => 2024-02-07T17:56:06.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 715
)
[ffd_description_pb] => Array
(
[0] => Located centrally within the private Querencia masterplanned community, El Lago features 16 single-family villas with vertical living layouts of two and three levels, maximizing views and social space for families and friends. Inspired by the Baja with welcoming and grounded earth tones, the residences offer modern living and timeless elegance within Los Cabos’ most vibrant private community.
The Ascendant villas feature living spaces – gourmet kitchen, dining, great room and family rooms on the main floor – seamlessly flowing to the outdoor terrace and pool. Upstairs are 4 bedrooms complete with ensuite baths and terraces overlooking the Querencia lake, Sea of Cortez, mountains and arroyo. Find two-car garage and double golf cart parking, storage and flex space on the ground level with the main entrance.
The residence features a hot tub, fire pit, interior and exterior fireplaces, BBQ and a private interior elevator.
View the El Lago brochure here.
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-12-22T21:34:47.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] => 4671000
)
[ffd_listing_price_pesos] => Array
(
[0] => 84078000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.7071078
)
[ffd_community_lot_number] => Array
(
[0] => A5
)
[wpcf-lotsize] => Array
(
[0] => 7168
)
[wpcf-lot-size-sqm] => Array
(
[0] => 665.93
)
[wpcf-mls] => Array
(
[0] => 24-727
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 4608
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk000000uvrdIAA
)
[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 Lago Ascendant 5
)
[wpcf-squarefeet] => Array
(
[0] => 6578
)
[wpcf-view] => Array
(
[0] => Golf Course
)
[wpcf-price] => Array
(
[0] => 4671000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Golf Course El Lago Ascendant 5 Single Family Home 24-727DeveloperEl LagoActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 10308
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-lago-ascendant-5/
)
[ffd_media] => Array
(
[0] => a:10:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/q8m98wat7/A-TEMPLATE%20WEBSITE3.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/f1jzii6rw/A-TEMPLATE%20WEBSITE4.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/1xlqi5cbt/A-TEMPLATE%20WEBSITE5.jpg";i:3;s:163:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/yyye3mkft/Lago%20Ascendente%20-%20Escalera%20Planta%20Baja%20%28Garage%29%20PB.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/mqxm92wpd/A-TEMPLATE%20WEBSITE2.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/wnbbzbox0/A-TEMPLATE%20WEBSITE.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/nrg3006ej/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/amgdx8hag/A-TEMPLATE%20WEBSITE8.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/icgdx67ja/A-TEMPLATE%20WEBSITE9.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/xb1rlcq3j/A-TEMPLATE%20WEBSITE6.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/q8m98wat7/A-TEMPLATE%20WEBSITE3.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000000uvrdIAA
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9607
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
El Lago Ascendant 5 El Lago Single Family Home 4,671,000 USD | 84,078,000 MXN | 4,608 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/wm5qe1q4k/A-TEMPLATE%20WEBSITE8.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/7n7hihbds/A-TEMPLATE%20WEBSITE6.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/trlaea85e/A-TEMPLATE%20WEBSITE4.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/0oouaxal4/Lago%20Ascendente%20-%20Escalera%20Primer%20Nivel%20%20%281%29%20PB.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/tdvje71kn/A-TEMPLATE%20WEBSITE2.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/w77ecklqe/A-TEMPLATE%20WEBSITE.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/p6vsvj3ys/A-TEMPLATE%20WEBSITE3.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/6ocvi7wp1/A-TEMPLATE%20WEBSITE7.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/4dorbgcdi/A-TEMPLATE%20WEBSITE9.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/t113sgq8f/A-TEMPLATE%20WEBSITE5.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769107975
)
[ffd_listing_title] => Array
(
[0] => El Lago Ascendant 4
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 24-726
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000000uncMIAQ
)
[ffd_totalarea_pb] => Array
(
[0] => 4608
)
[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] => Los Cabos
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => El Lago
)
[ffd_createddate] => Array
(
[0] => 2024-02-07T17:50:33.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 715
)
[ffd_description_pb] => Array
(
[0] => Located centrally within the private Querencia masterplanned community, El Lago features 16 single-family villas with vertical living layouts of two and three levels, maximizing views and social space for families and friends. Inspired by the Baja with welcoming and grounded earth tones, the residences offer modern living and timeless elegance within Los Cabos’ most vibrant private community.
The Ascendant villas feature living spaces – gourmet kitchen, dining, great room and family rooms on the main floor – seamlessly flowing to the outdoor terrace and pool. Upstairs are 4 bedrooms complete with ensuite baths and terraces overlooking the Querencia lake, Sea of Cortez, mountains and arroyo. Find two-car garage and double golf cart parking, storage and flex space on the ground level with the main entrance.
The residence features a hot tub, fire pit, interior and exterior fireplaces, BBQ and a private interior elevator.
View the El Lago brochure here.
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-12-22T21:02:35.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] => 4621000
)
[ffd_listing_price_pesos] => Array
(
[0] => 83178000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.7071078
)
[ffd_community_lot_number] => Array
(
[0] => A4
)
[wpcf-lotsize] => Array
(
[0] => 7025
)
[wpcf-lot-size-sqm] => Array
(
[0] => 652.64
)
[wpcf-mls] => Array
(
[0] => 24-726
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 4608
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk000000uncMIAQ
)
[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 Lago Ascendant 4
)
[wpcf-squarefeet] => Array
(
[0] => 6578
)
[wpcf-view] => Array
(
[0] => Golf Course
)
[wpcf-price] => Array
(
[0] => 4621000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Golf Course El Lago Ascendant 4 Single Family Home 24-726DeveloperEl LagoActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 10309
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-lago-ascendant-4/
)
[ffd_media] => Array
(
[0] => a:10:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/wm5qe1q4k/A-TEMPLATE%20WEBSITE8.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/7n7hihbds/A-TEMPLATE%20WEBSITE6.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/trlaea85e/A-TEMPLATE%20WEBSITE4.jpg";i:3;s:162:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/0oouaxal4/Lago%20Ascendente%20-%20Escalera%20Primer%20Nivel%20%20%281%29%20PB.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/tdvje71kn/A-TEMPLATE%20WEBSITE2.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/w77ecklqe/A-TEMPLATE%20WEBSITE.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/p6vsvj3ys/A-TEMPLATE%20WEBSITE3.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/6ocvi7wp1/A-TEMPLATE%20WEBSITE7.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/4dorbgcdi/A-TEMPLATE%20WEBSITE9.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/t113sgq8f/A-TEMPLATE%20WEBSITE5.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/wm5qe1q4k/A-TEMPLATE%20WEBSITE8.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000000uncMIAQ
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9607
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
El Lago Ascendant 4 El Lago Single Family Home 4,621,000 USD | 83,178,000 MXN | 4,608 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/wxqwoosvv/A-TEMPLATE%20WEBSITE2.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/y5rt9dlm6/A-TEMPLATE%20WEBSITE3.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/u05xo21tj/A-TEMPLATE%20WEBSITE.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/4p5q3115n/A-TEMPLATE%20WEBSITE6.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/qr48sjmx4/A-TEMPLATE%20WEBSITE4.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/ivnimuy46/A-TEMPLATE%20WEBSITE5.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/xdmxcfsnj/A-TEMPLATE%20WEBSITE7.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/8duqt8sds/A-TEMPLATE%20WEBSITE9.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/p1nxsr3mz/A-TEMPLATE%20WEBSITE8.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769295344
)
[ffd_listing_title] => Array
(
[0] => El Lago Ascendant 3
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 24-725
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000000uuFdIAI
)
[ffd_totalarea_pb] => Array
(
[0] => 4608
)
[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] => Los Cabos
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => El Lago
)
[ffd_createddate] => Array
(
[0] => 2024-02-07T17:43:32.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 715
)
[ffd_description_pb] => Array
(
[0] => Located centrally within the private Querencia masterplanned community, El Lago features 16 single-family villas with vertical living layouts of two and three levels, maximizing views and social space for families and friends. Inspired by the Baja with welcoming and grounded earth tones, the residences offer modern living and timeless elegance within Los Cabos’ most vibrant private community.
The Ascendant villas feature living spaces – gourmet kitchen, dining, great room and family rooms on the main floor – seamlessly flowing to the outdoor terrace and pool. Upstairs are 4 bedrooms complete with ensuite baths and terraces overlooking the Querencia lake, Sea of Cortez, mountains and arroyo. Find two-car garage and double golf cart parking, storage and flex space on the ground level with the main entrance.
The residence features a hot tub, fire pit, interior and exterior fireplaces, BBQ and a private interior elevator.
View the El Lago brochure here.
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-12-22T20:56:08.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] => 4571000
)
[ffd_listing_price_pesos] => Array
(
[0] => 82278000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.7071078
)
[ffd_community_lot_number] => Array
(
[0] => A3
)
[wpcf-lotsize] => Array
(
[0] => 6983
)
[wpcf-lot-size-sqm] => Array
(
[0] => 648.74
)
[wpcf-mls] => Array
(
[0] => 24-725
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 4608
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk000000uuFdIAI
)
[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 Lago Ascendant 3
)
[wpcf-squarefeet] => Array
(
[0] => 6578
)
[wpcf-view] => Array
(
[0] => Golf Course
)
[wpcf-price] => Array
(
[0] => 4571000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Golf Course El Lago Ascendant 3 Single Family Home 24-725DeveloperEl LagoActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 10304
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-lago-ascendant-3/
)
[ffd_media] => Array
(
[0] => a:9:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/wxqwoosvv/A-TEMPLATE%20WEBSITE2.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/y5rt9dlm6/A-TEMPLATE%20WEBSITE3.jpg";i:2;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/u05xo21tj/A-TEMPLATE%20WEBSITE.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/4p5q3115n/A-TEMPLATE%20WEBSITE6.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/qr48sjmx4/A-TEMPLATE%20WEBSITE4.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/ivnimuy46/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/xdmxcfsnj/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/8duqt8sds/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/p1nxsr3mz/A-TEMPLATE%20WEBSITE8.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNS/wxqwoosvv/A-TEMPLATE%20WEBSITE2.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000000uuFdIAI
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9607
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
El Lago Ascendant 3 El Lago Single Family Home 4,571,000 USD | 82,278,000 MXN | 4,608 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/5338eqgn5/DJI-457.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/5mc9q0td2/_EHV0649.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/cfu4wumih/_EHV0646.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/rznvlk0pj/_EHV0612.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/1ptaog0xv/_EHV0590.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/wsto4l1a8/_EHV0626.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/1l74upprv/_EHV0561.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/36nr0rd0d/_EHV0464.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/addlk9nvs/_EHV0446.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/vrr21k6a7/_EHV0514.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/zv7iombfk/_EHV0496.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/gecr5w99x/_EHV0504.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/oa49h1pvz/_EHV0531.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769215935
)
[ffd_listing_title] => Array
(
[0] => El Rincon 1
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] =>
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk00000N1gJJIAZ
)
[ffd_totalarea_pb] => Array
(
[0] => 4686.3
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Carretera Transpeninsular Km. 27.5
San José del Cabo, B.C.S, Mexico 23400
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[ffd_city_pb] => Array
(
[0] => Los Cabos
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => El Rincon
)
[ffd_createddate] => Array
(
[0] => 2025-11-24T18:18:38.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 65
)
[ffd_description_pb] => Array
(
[0] => Perfectly situated near Querencia’s main entrance and the Beach Club, this one level single family home offers exceptional privacy on a spacious corner lot surrounded by lush gardens, palms, and tranquil water features.
Thoughtfully designed and built by the original owners in 2008 — the property has been kept in immaculate condition. Its generous outdoor spaces include an oversized pool and spacious gardens, creating an ideal setting for relaxing or entertaining.
Inside, the residence features four bedrooms, four-and-a-half baths, and a dedicated office, offering comfortable living for families and guests alike. Warm, inviting, and exceptionally private, this home is a rare opportunity in a prime Querencia location.
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-12-02T21:23:51.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.0246622421474
)
[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] => 4100000
)
[ffd_listing_price_pesos] => Array
(
[0] => 75318492.4
)
[wpcf-listing-type] => Array
(
[0] => Resale: Querencia Listing
)
[wpcf-longitude] => Array
(
[0] => -109.72796114888804
)
[ffd_community_lot_number] => Array
(
[0] => 1
)
[wpcf-lotsize] => Array
(
[0] => 38252.78
)
[wpcf-lot-size-sqm] => Array
(
[0] => 3553.8
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 4900
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000LsPqqQAF
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk00000N1gJJIAZ
)
[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 Rincon 1
)
[wpcf-squarefeet] => Array
(
[0] => 8775.43
)
[wpcf-view] => Array
(
[0] => Mountain
)
[wpcf-price] => Array
(
[0] => 4100000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Mountain El Rincon 1 Single Family Home Resale: Querencia ListingEl RinconActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 12565
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-rincon-1/
)
[ffd_media] => Array
(
[0] => a:13:{i:0;s:102:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/5338eqgn5/DJI-457.jpg";i:1;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/5mc9q0td2/_EHV0649.jpg";i:2;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/cfu4wumih/_EHV0646.jpg";i:3;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/rznvlk0pj/_EHV0612.jpg";i:4;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/1ptaog0xv/_EHV0590.jpg";i:5;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/wsto4l1a8/_EHV0626.jpg";i:6;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/1l74upprv/_EHV0561.jpg";i:7;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/36nr0rd0d/_EHV0464.jpg";i:8;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/addlk9nvs/_EHV0446.jpg";i:9;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/vrr21k6a7/_EHV0514.jpg";i:10;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/zv7iombfk/_EHV0496.jpg";i:11;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/gecr5w99x/_EHV0504.jpg";i:12;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/oa49h1pvz/_EHV0531.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00007CWr4f/5338eqgn5/DJI-457.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk00000N1gJJIAZ
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1869
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
El Rincon 1 El Rincón Single Family Home 4,100,000 USD | 75,318,492 MXN | 4,686 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) WHERE 1=1 AND ( ( wp_tota44soje_postmeta.meta_key = 'featured' AND wp_tota44soje_postmeta.meta_value = 'yes' )) AND wp_tota44soje_posts.post_type = 'properties' AND ((wp_tota44soje_posts.post_status = 'publish')) GROUP BY wp_tota44soje_posts.ID ORDER BY wp_tota44soje_posts.post_date DESC LIMIT 0, 3
10
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/og02inowk/12.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/wd420559a/1.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/vv22k9v8s/11.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/pk1h0qdip/2.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/5jkpte7c9/3.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/hki3xm1xh/4.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/6ji4xmkl1/5.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/qef4n00ot/6.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/t6bwroize/7.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/7rk9wcjv8/8.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/ptn2qtljw/9.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769120693
)
[ffd_listing_title] => Array
(
[0] => Ocean Residence B 202
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] =>
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000002GVRiIAO
)
[ffd_totalarea_pb] => Array
(
[0] => 2679
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Querencia, San Jose del Cabo, Baja California Sur, Mexico, Los Cabos.
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[ffd_city_pb] => Array
(
[0] => San José del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Ocean Residences
)
[ffd_createddate] => Array
(
[0] => 2024-04-09T22:57:14.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 652
)
[ffd_description_pb] => Array
(
[0] => Sleek, spacious and just steps from the sun-drenched shores of the Sea of Cortez, Ocean Residence B-202 is the epitome of modern luxury meets coastal contemporary.
Inside, find inspired living within the neutral, yet refined space. This turnkey, brand new 4-bedroom, 4 full-bath residence – one of just a few in the 30-unit complex—is flooded with natural light framing panoramic views of the swimmable beach, one of the best surf breaks in San Jose. Designed with impeccable attention to detail and with top-of-the-line appliances and finishes throughout, Residence B-202 is centrally located within the center of the three Ocean Residence towers.
Rest and luxuriate with views of the ocean from the primary bedroom complete with an oversized spa-like bath with dual-showers and ample closet space. Two additional bedrooms features ensuite baths, while the fourth bedroom has direct access to a full bath.
Designed to maximize storage opportunities, the open concept floorplan features 2,600 sq. ft. of interior space which seamlessly flows through minimalistic floor-to-ceiling, double paned glass doors onto an additional 500 square feet of outdoor living lounge space with outdoor fireplace and heated plunge pool.
Owners of B-202 gain access to convenient underground parking, including two desirable side-by-side parking spaces, additional lock-off storage space and full-time security and access to beachfront living at its finest at the Querencia Beach Club, home to two family pools, four dining experiences, a satellite Querencia Spa, Sports Lounge and oceanfront Fitness Center.
Other Features Include:
Elevator access | SubZero and Wolf appliances | Rosa Morada wood throughout | Fully-furnished, including TVs and hidden mounted soffit speakers | Convenient, electric roll-down, hurricane shutters throughout | External hurricane shutters on terrace
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family.
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => yes
)
[wpcf-half-bathrooms] => Array
(
[0] =>
)
[ffd_lastmodifieddate] => Array
(
[0] => 2025-11-13T19:21:04.000+0000
)
[wpcf-latitude] => Array
(
[0] => 22.90981
)
[ffd_listofficemlsid] => Array
(
[0] =>
)
[ffd_listofficename] => Array
(
[0] =>
)
[ffd_listing_agent_email] => Array
(
[0] =>
)
[ffd_listing_agent_firstname] => Array
(
[0] =>
)
[ffd_listing_agent_lastname] => Array
(
[0] =>
)
[ffd_listingagentmlsid] => Array
(
[0] =>
)
[ffd_listingagentname] => Array
(
[0] =>
)
[ffd_listingprice_pb] => Array
(
[0] => 6500000
)
[ffd_listing_price_pesos] => Array
(
[0] => 130671652.15
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.9278
)
[ffd_community_lot_number] => Array
(
[0] =>
)
[wpcf-lotsize] => Array
(
[0] => 3237
)
[wpcf-lot-size-sqm] => Array
(
[0] => 300.73
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] => Sold
)
[wpcf-acarea] => Array
(
[0] =>
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000LsPqqQAF
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk000002GVRiIAO
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] => 6300000
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Sold
)
[ffd_name] => Array
(
[0] => Ocean Residence B 202
)
[wpcf-squarefeet] => Array
(
[0] => 3237
)
[wpcf-view] => Array
(
[0] =>
)
[wpcf-price] => Array
(
[0] => 6500000
)
[ffd_sort_by] => Array
(
[0] => C
)
[ffd_website_status] => Array
(
[0] => Sold
)
[wpcf-keywords] => Array
(
[0] => Ocean Residence B 202 Condominium DeveloperOcean ResidencesSold
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23406
)
[pba__WebsiteId__c] => Array
(
[0] => 10382
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/ocean-residence-b-202/
)
[ffd_media] => Array
(
[0] => a:11:{i:0;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/og02inowk/12.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/wd420559a/1.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/vv22k9v8s/11.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/pk1h0qdip/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/5jkpte7c9/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/hki3xm1xh/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/6ji4xmkl1/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/qef4n00ot/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/t6bwroize/7.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/7rk9wcjv8/8.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/ptn2qtljw/9.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGj/og02inowk/12.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000002GVRiIAO
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 8670
)
[_edit_lock] => Array
(
[0] => 1726065644:21
)
[_edit_last] => Array
(
[0] => 21
)
[_wpcf-propertybase-id] => Array
(
[0] => field_6241d7e8a5172
)
[_featured] => Array
(
[0] => field_615b2b0a187e6
)
[_ffd_website_status_2] => Array
(
[0] => field_608827aae073c
)
[_wpcf-property-type] => Array
(
[0] => field_6241d82da5173
)
[_wpcf-view] => Array
(
[0] => field_6241d8dca5174
)
[_wpcf-resale] => Array
(
[0] => field_6241dab0a5175
)
[wpcf-neighborhood-subset] => Array
(
[0] =>
)
[_wpcf-neighborhood-subset] => Array
(
[0] => field_6241daefa5176
)
[_wpcf-ribbon] => Array
(
[0] => field_6241db32a5177
)
[wpcf-lotnumber] => Array
(
[0] =>
)
[_wpcf-lotnumber] => Array
(
[0] => field_6241dbaea5178
)
[_wpcf-lotsize] => Array
(
[0] => field_6241dbe2a5179
)
[_wpcf-lot-size-sqm] => Array
(
[0] => field_6241dbffa517a
)
[_wpcf-price] => Array
(
[0] => field_6241dc18a517b
)
[_ffd_listing_price_pesos] => Array
(
[0] => field_64480a754ad5b
)
[wpcf-start-price] => Array
(
[0] =>
)
[_wpcf-start-price] => Array
(
[0] => field_6241dc2ea517c
)
[wpcf-end-price] => Array
(
[0] =>
)
[_wpcf-end-price] => Array
(
[0] => field_6241dc3ea517d
)
[_wpcf-mls] => Array
(
[0] => field_6241dc64a517e
)
[wpcf-spec-sheet-file] => Array
(
[0] =>
)
[_wpcf-spec-sheet-file] => Array
(
[0] => field_6241dc7da517f
)
[wpcf-video] => Array
(
[0] =>
)
[_wpcf-video] => Array
(
[0] => field_6241dcd3a5180
)
[_wpcf-squarefeet] => Array
(
[0] => field_6241dd3527de8
)
[_wpcf-acarea] => Array
(
[0] => field_6241dd8327de9
)
[_wpcf-bedrooms] => Array
(
[0] => field_6241dde8b5fa0
)
[_wpcf-bathrooms] => Array
(
[0] => field_6241de2bb5fa1
)
[_wpcf-half-bathrooms] => Array
(
[0] => field_6241de60b5fa2
)
[wpcf-basement] => Array
(
[0] =>
)
[_wpcf-basement] => Array
(
[0] => field_6241de7fb5fa3
)
[wpcf-garage] => Array
(
[0] =>
)
[_wpcf-garage] => Array
(
[0] => field_6241dec1b5fa4
)
[wpcf-isfurnished] => Array
(
[0] =>
)
[_wpcf-isfurnished] => Array
(
[0] => field_6241df25b5fa5
)
[wpcf-otherroom] => Array
(
[0] =>
)
[_wpcf-otherroom] => Array
(
[0] => field_6241df6db5fa6
)
[wpcf-features] => Array
(
[0] =>
)
[_wpcf-features] => Array
(
[0] => field_6241dfacb5fa7
)
[wpcf-notes] => Array
(
[0] =>
)
[_wpcf-notes] => Array
(
[0] => field_6241dfd3b5fa8
)
[_wpcf-latitude] => Array
(
[0] => field_6241e02bb5fa9
)
[_wpcf-longitude] => Array
(
[0] => field_6241e04cb5faa
)
[_wpcf-agent-1] => Array
(
[0] => field_6241e06fb5fab
)
[wpcf-agent-2] => Array
(
[0] =>
)
[_wpcf-agent-2] => Array
(
[0] => field_6241e080b5fac
)
[_wpcf-keywords] => Array
(
[0] => field_6241e099b5fad
)
[_wpcf-highlights] => Array
(
[0] => field_6241e0beb5fae
)
[_wpcf-property-features] => Array
(
[0] => field_6241e0e0b5faf
)
[wpcf-floorplan] => Array
(
[0] =>
)
[_wpcf-floorplan] => Array
(
[0] => field_6241e0f7b5fb0
)
[wpcf-siteplan] => Array
(
[0] =>
)
[_wpcf-siteplan] => Array
(
[0] => field_6241e112b5fb1
)
[wpcf-brochure] => Array
(
[0] =>
)
[_wpcf-brochure] => Array
(
[0] => field_6241e12fb5fb2
)
[wpcf-close-date] => Array
(
[0] =>
)
[_wpcf-close-date] => Array
(
[0] => field_6241e145b5fb3
)
[_wpcf-listing-type] => Array
(
[0] => field_6241e176b5fb4
)
[_ffd_community] => Array
(
[0] => field_62ab426441a36
)
[wpcf-feature-subtitle] => Array
(
[0] =>
)
[_wpcf-feature-subtitle] => Array
(
[0] => field_6241e7194766a
)
[wpcf-introduction] => Array
(
[0] =>
)
[_wpcf-introduction] => Array
(
[0] => field_6241e73e4766b
)
[wpcf-tripple-icon] => Array
(
[0] => default
)
[_wpcf-tripple-icon] => Array
(
[0] => field_6241e7634766c
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[_yoast_wpseo_focuskeywords] => Array
(
[0] => []
)
[_yoast_wpseo_keywordsynonyms] => Array
(
[0] => [""]
)
[_yoast_wpseo_estimated-reading-time-minutes] => Array
(
[0] => 2
)
[_yoast_wpseo_wordproof_timestamp] => Array
(
[0] =>
)
)
Ocean Residence B 202 Ocean Residences Condominium | 130,671,652 MXN | 2,679 A/C SQ FT 4 Beds 4 Full Baths SoldSold
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/tq1hxt5r6/A-TEMPLATE%20WEBSITE2.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/uifiwgcnt/A-TEMPLATE%20WEBSITE3.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hojxk6ut1/A-TEMPLATE%20WEBSITE4.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/zgnw06tqo/A-TEMPLATE%20WEBSITE5.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5d98tiql5/A-TEMPLATE%20WEBSITE6.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/je4iqh7s6/A-TEMPLATE%20WEBSITE7.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gotztox5o/A-TEMPLATE%20WEBSITE8.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/7j9e91qrc/Clubhouse-2.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/upeuzy8r2/Clubhouse-3.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/n4qrwk05e/Clubhouse-4.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/0cxtdew1t/Clubhouse.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4hwfbxexi/dinner.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4jg6szv38/golf-2.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/o1d1bhfrr/Yoga%20Querencia.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p41u05p61/trampoline.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/xvak4upbw/trails.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/vp3pbyasj/trails-2.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/efb60lvs3/surf.jpg [19] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/ol4v781k1/surf-3.jpg [20] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/31zt4rvy4/surf-2.jpg [21] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p8nazbkgc/slide.jpg [22] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gcekb0ldt/Querencia%20Golf.jpg [23] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5xp1u8wn8/Querencia%20Beach%20Club.jpg [24] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8hsjs0szf/Pickleball.jpg [25] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/acd2s0967/Pickleball-2.jpg [26] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/49vq4ijob/Mountain%20Bike.jpg [27] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/bepc4cg6o/golf.jpg [28] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8wwe0k7wm/Golf-4.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => El Valle 1 Upper
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] =>
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000JYGq7QAH
)
[ffd_totalarea_pb] => Array
(
[0] => 3050
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Carretera Transpeninsular Km. 27.5
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 3
)
[wpcf-bedrooms] => Array
(
[0] => 3
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => El Valle
)
[ffd_createddate] => Array
(
[0] => 2023-03-30T18:47:15.000+0000
)
[ffd_days_on_market] => Array
(
[0] =>
)
[ffd_description_pb] => Array
(
[0] => El Valle is the latest neighborhood designed within the masterplanned Querencia community.
A smaller, more intimate enclave set against the backdrop of the vibrant desert mountains,
the 12 condominium residences offer a mix of views of the turquoise San Jose bay, Querencia lake and the award-winning Tom Fazio golf course.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.)
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => yes
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[ffd_lastmodifieddate] => Array
(
[0] => 2025-03-18T20:37:42.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.05381
)
[ffd_listofficemlsid] => Array
(
[0] =>
)
[ffd_listofficename] => Array
(
[0] =>
)
[ffd_listing_agent_email] => Array
(
[0] =>
)
[ffd_listing_agent_firstname] => Array
(
[0] =>
)
[ffd_listing_agent_lastname] => Array
(
[0] =>
)
[ffd_listingagentmlsid] => Array
(
[0] =>
)
[ffd_listingagentname] => Array
(
[0] =>
)
[ffd_listingprice_pb] => Array
(
[0] => 3465000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.70348
)
[ffd_community_lot_number] => Array
(
[0] => 35
)
[wpcf-lotsize] => Array
(
[0] => 22948.66
)
[wpcf-lot-size-sqm] => Array
(
[0] => 2132
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] => Sold
)
[wpcf-acarea] => Array
(
[0] => 3050
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000Kt8H2QAJ
)
[ffd_listing_agent_2] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_id] => Array
(
[0] => a093Z00000JYGq7QAH
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Sold
)
[ffd_name] => Array
(
[0] => El Valle 1 Upper
)
[wpcf-squarefeet] => Array
(
[0] => 3588
)
[wpcf-view] => Array
(
[0] =>
)
[wpcf-price] => Array
(
[0] => 3465000
)
[ffd_sort_by] => Array
(
[0] => C
)
[ffd_website_status] => Array
(
[0] => Sold
)
[wpcf-keywords] => Array
(
[0] => El Valle 1 Upper Condominium DeveloperEl ValleSold
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23406
)
[pba__WebsiteId__c] => Array
(
[0] => 9604
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-valle-1-upper/
)
[ffd_media] => Array
(
[0] => a:29:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/tq1hxt5r6/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/uifiwgcnt/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hojxk6ut1/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/zgnw06tqo/A-TEMPLATE%20WEBSITE5.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5d98tiql5/A-TEMPLATE%20WEBSITE6.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/je4iqh7s6/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gotztox5o/A-TEMPLATE%20WEBSITE8.jpg";i:8;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/7j9e91qrc/Clubhouse-2.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/upeuzy8r2/Clubhouse-3.jpg";i:10;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/n4qrwk05e/Clubhouse-4.jpg";i:11;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/0cxtdew1t/Clubhouse.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4hwfbxexi/dinner.jpg";i:13;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4jg6szv38/golf-2.jpg";i:14;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/o1d1bhfrr/Yoga%20Querencia.jpg";i:15;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p41u05p61/trampoline.jpg";i:16;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/xvak4upbw/trails.jpg";i:17;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/vp3pbyasj/trails-2.jpg";i:18;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/efb60lvs3/surf.jpg";i:19;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/ol4v781k1/surf-3.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/31zt4rvy4/surf-2.jpg";i:21;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p8nazbkgc/slide.jpg";i:22;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gcekb0ldt/Querencia%20Golf.jpg";i:23;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5xp1u8wn8/Querencia%20Beach%20Club.jpg";i:24;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8hsjs0szf/Pickleball.jpg";i:25;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/acd2s0967/Pickleball-2.jpg";i:26;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/49vq4ijob/Mountain%20Bike.jpg";i:27;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/bepc4cg6o/golf.jpg";i:28;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8wwe0k7wm/Golf-4.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000JYGq7QAH
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000Kt8H2
)
[wpcf-agent-2] => Array
(
[0] => 0053Z00000KX9ZY
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_listing_price_pesos] => Array
(
[0] => 58905000
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9608
)
[_edit_lock] => Array
(
[0] => 1701276370:21
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769138954
)
)
El Valle 1 Upper El Valle Condominium | 58,905,000 MXN | 3,050 A/C SQ FT 3 Beds 3 Full Baths 1 Half Baths SoldSold
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/59da53bl9/A-TEMPLATE%20WEBSITE8.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zb2ykxl8/A-TEMPLATE%20WEBSITE.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/qv0b0b5ir/A-TEMPLATE%20WEBSITE2.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/l5ajufh3m/A-TEMPLATE%20WEBSITE3.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nrkbi41ve/A-TEMPLATE%20WEBSITE4.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nhvo5ykxt/A-TEMPLATE%20WEBSITE5.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/kxit5zdgo/A-TEMPLATE%20WEBSITE6.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/41ulfgs6j/A-TEMPLATE%20WEBSITE7.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/xl6wa0998/Clubhouse.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/7rkc1miym/dinner.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8bbmuy30i/Golf-4.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/o18l17egf/golf.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8u4cjjqhj/Mountain%20Bike.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/vke6ofpck/Pickleball-2.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zg8fsi4o/slide.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/jiy6m42k9/surf.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/6y2arpc7c/trails-2.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/ij9e65fmd/trails.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5iozycjr3/trampoline.jpg [19] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5xcehypmk/Yoga%20Querencia.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => El Valle 6 Lower
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] =>
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000JYL7NQAX
)
[ffd_totalarea_pb] => Array
(
[0] => 3050
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Carretera Transpeninsular Km. 27.5
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 3
)
[wpcf-bedrooms] => Array
(
[0] => 3
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => El Valle
)
[ffd_createddate] => Array
(
[0] => 2023-04-17T22:39:57.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 1011
)
[ffd_description_pb] => Array
(
[0] => El Valle is the latest neighborhood designed within the masterplanned Querencia community.
A smaller, more intimate enclave set against the backdrop of the vibrant desert mountains,
the 12 condominium residences offer a mix of views of the turquoise San Jose bay, Querencia lake and the award-winning Tom Fazio golf course.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.)
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => yes
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[ffd_lastmodifieddate] => Array
(
[0] => 2025-04-07T21:10:43.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.05381
)
[ffd_listofficemlsid] => Array
(
[0] =>
)
[ffd_listofficename] => Array
(
[0] =>
)
[ffd_listing_agent_email] => Array
(
[0] =>
)
[ffd_listing_agent_firstname] => Array
(
[0] =>
)
[ffd_listing_agent_lastname] => Array
(
[0] =>
)
[ffd_listingagentmlsid] => Array
(
[0] =>
)
[ffd_listingagentname] => Array
(
[0] =>
)
[ffd_listingprice_pb] => Array
(
[0] => 2970000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.70348
)
[ffd_community_lot_number] => Array
(
[0] => 35
)
[wpcf-lotsize] => Array
(
[0] => 22948.66
)
[wpcf-lot-size-sqm] => Array
(
[0] => 2132
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 3050
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a093Z00000JYL7NQAX
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[ffd_name] => Array
(
[0] => El Valle 6 Lower
)
[wpcf-squarefeet] => Array
(
[0] => 3588
)
[wpcf-view] => Array
(
[0] =>
)
[wpcf-price] => Array
(
[0] => 2970000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => El Valle 6 Lower Condominium DeveloperEl ValleActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23406
)
[pba__WebsiteId__c] => Array
(
[0] => 9602
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-valle-6-lower/
)
[ffd_media] => Array
(
[0] => a:20:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/59da53bl9/A-TEMPLATE%20WEBSITE8.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zb2ykxl8/A-TEMPLATE%20WEBSITE.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/qv0b0b5ir/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/l5ajufh3m/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nrkbi41ve/A-TEMPLATE%20WEBSITE4.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nhvo5ykxt/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/kxit5zdgo/A-TEMPLATE%20WEBSITE6.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/41ulfgs6j/A-TEMPLATE%20WEBSITE7.jpg";i:8;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/xl6wa0998/Clubhouse.jpg";i:9;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/7rkc1miym/dinner.jpg";i:10;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8bbmuy30i/Golf-4.jpg";i:11;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/o18l17egf/golf.jpg";i:12;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8u4cjjqhj/Mountain%20Bike.jpg";i:13;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/vke6ofpck/Pickleball-2.jpg";i:14;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zg8fsi4o/slide.jpg";i:15;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/jiy6m42k9/surf.jpg";i:16;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/6y2arpc7c/trails-2.jpg";i:17;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/ij9e65fmd/trails.jpg";i:18;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5iozycjr3/trampoline.jpg";i:19;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5xcehypmk/Yoga%20Querencia.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/59da53bl9/A-TEMPLATE%20WEBSITE8.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000JYL7NQAX
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_listing_price_pesos] => Array
(
[0] => 60885000
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9608
)
[_edit_lock] => Array
(
[0] => 1690823630:10
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1769309578
)
)
El Valle 6 Lower El Valle Condominium 2,970,000 USD | 60,885,000 MXN | 3,050 A/C SQ FT 3 Beds 3 Full Baths 1 Half Baths plain content
"*" indicates required fields

