Discover Our Properties
SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt1 ON ( wp_tota44soje_posts.ID = mt1.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt2 ON ( wp_tota44soje_posts.ID = mt2.post_id ) WHERE 1=1 AND ( wp_tota44soje_postmeta.meta_key = 'wpcf-price' AND ( ( mt1.meta_key = 'wpcf-ribbon' AND mt1.meta_value IN ('Active','Under Contract','Sold') ) AND ( mt2.meta_key = 'wpcf-listing-type' AND mt2.meta_value = 'developer' ) )) 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
137
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/rz7zvb253/A-TEMPLATE%20WEBSITE.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/40ty3hcgr/A-TEMPLATE%20WEBSITE10.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/1zoepwm5u/A-TEMPLATE%20WEBSITE2.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/unijgvx3x/A-TEMPLATE%20WEBSITE3.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/idt463vt6/A-TEMPLATE%20WEBSITE17.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h8hbbgt2y/A-TEMPLATE%20WEBSITE4.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/0rvlsktzd/A-TEMPLATE%20WEBSITE16.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7rrnt7d1z/A-TEMPLATE%20WEBSITE15.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9wf8a3zhq/A-TEMPLATE%20WEBSITE18.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/sk61xp1f2/A-TEMPLATE%20WEBSITE19.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/lanc9lix2/A-TEMPLATE%20WEBSITE20.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/a0yrnk6cr/A-TEMPLATE%20WEBSITE11.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7jv1c1yf2/A-TEMPLATE%20WEBSITE12.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/k7uktv0fn/A-TEMPLATE%20WEBSITE13.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/g9e0xk2oc/A-TEMPLATE%20WEBSITE14.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/l08lgfln0/A-TEMPLATE%20WEBSITE5.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/fu01nec1w/A-TEMPLATE%20WEBSITE8.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/zolndnp7l/A-TEMPLATE%20WEBSITE7.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/403ih1ghs/A-TEMPLATE%20WEBSITE9.jpg [19] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/q5lcscn1s/A-TEMPLATE%20WEBSITE22.jpg [20] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mshycubwg/A-TEMPLATE%20WEBSITE21.jpg [21] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/015pr15cw/A-TEMPLATE%20WEBSITE24.jpg [22] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h06pixcdw/A-TEMPLATE%20WEBSITE25.jpg [23] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9ov4diznp/A-TEMPLATE%20WEBSITE26.jpg [24] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/le7q8myhm/A-TEMPLATE%20WEBSITE6.jpg [25] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/ns7gahnbq/A-TEMPLATE%20WEBSITE27.jpg [26] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/d481dk7lb/A-TEMPLATE%20WEBSITE28.jpg [27] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/j136isshw/A-TEMPLATE%20WEBSITE29.jpg [28] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/nif80q33n/A-TEMPLATE%20WEBSITE30.jpg [29] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tqoi2fzra/A-TEMPLATE%20WEBSITE31.jpg [30] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/495zsyqlq/A-TEMPLATE%20WEBSITE32.jpg [31] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/5bplookua/A-TEMPLATE%20WEBSITE-beachclub4.jpg [32] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tgn5n0p5r/A-TEMPLATE%20WEBSITE-beachclub3.jpg [33] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/edv316i9i/A-TEMPLATE%20WEBSITE-beach6.jpg [34] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mubnz02c2/A-TEMPLATE%20WEBSITE-beachclub.jpg [35] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/3akjmljnc/A-TEMPLATE%20WEBSITE-beachclub2.jpg [36] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/qlzqkchb1/A-TEMPLATE%20WEBSITE-beach5.jpg [37] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/b854v7fei/A-TEMPLATE%20WEBSITE-beach.jpg [38] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/xclj8i22z/A-TEMPLATE%20WEBSITE-beach3.jpg [39] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/8a5llup8p/A-TEMPLATE%20WEBSITE-beach4.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1740432591
)
[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] => 320
)
[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-02-24T21:23:32.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] =>
)
[wpcf-acarea] => Array
(
[0] =>
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000LsPqqQAF
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk000002GVRiIAO
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[ffd_name] => Array
(
[0] => Ocean Residence B 202
)
[wpcf-squarefeet] => Array
(
[0] => 3237
)
[wpcf-view] => Array
(
[0] =>
)
[wpcf-price] => Array
(
[0] => 6500000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean Residence B 202 Condominium DeveloperOcean ResidencesActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23406
)
[pba__WebsiteId__c] => Array
(
[0] => 10382
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/ocean-residence-b-202/
)
[ffd_media] => Array
(
[0] => a:40:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/rz7zvb253/A-TEMPLATE%20WEBSITE.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/40ty3hcgr/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/1zoepwm5u/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/unijgvx3x/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/idt463vt6/A-TEMPLATE%20WEBSITE17.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h8hbbgt2y/A-TEMPLATE%20WEBSITE4.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/0rvlsktzd/A-TEMPLATE%20WEBSITE16.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7rrnt7d1z/A-TEMPLATE%20WEBSITE15.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9wf8a3zhq/A-TEMPLATE%20WEBSITE18.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/sk61xp1f2/A-TEMPLATE%20WEBSITE19.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/lanc9lix2/A-TEMPLATE%20WEBSITE20.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/a0yrnk6cr/A-TEMPLATE%20WEBSITE11.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7jv1c1yf2/A-TEMPLATE%20WEBSITE12.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/k7uktv0fn/A-TEMPLATE%20WEBSITE13.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/g9e0xk2oc/A-TEMPLATE%20WEBSITE14.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/l08lgfln0/A-TEMPLATE%20WEBSITE5.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/fu01nec1w/A-TEMPLATE%20WEBSITE8.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/zolndnp7l/A-TEMPLATE%20WEBSITE7.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/403ih1ghs/A-TEMPLATE%20WEBSITE9.jpg";i:19;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/q5lcscn1s/A-TEMPLATE%20WEBSITE22.jpg";i:20;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mshycubwg/A-TEMPLATE%20WEBSITE21.jpg";i:21;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/015pr15cw/A-TEMPLATE%20WEBSITE24.jpg";i:22;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h06pixcdw/A-TEMPLATE%20WEBSITE25.jpg";i:23;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9ov4diznp/A-TEMPLATE%20WEBSITE26.jpg";i:24;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/le7q8myhm/A-TEMPLATE%20WEBSITE6.jpg";i:25;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/ns7gahnbq/A-TEMPLATE%20WEBSITE27.jpg";i:26;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/d481dk7lb/A-TEMPLATE%20WEBSITE28.jpg";i:27;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/j136isshw/A-TEMPLATE%20WEBSITE29.jpg";i:28;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/nif80q33n/A-TEMPLATE%20WEBSITE30.jpg";i:29;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tqoi2fzra/A-TEMPLATE%20WEBSITE31.jpg";i:30;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/495zsyqlq/A-TEMPLATE%20WEBSITE32.jpg";i:31;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/5bplookua/A-TEMPLATE%20WEBSITE-beachclub4.jpg";i:32;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tgn5n0p5r/A-TEMPLATE%20WEBSITE-beachclub3.jpg";i:33;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/edv316i9i/A-TEMPLATE%20WEBSITE-beach6.jpg";i:34;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mubnz02c2/A-TEMPLATE%20WEBSITE-beachclub.jpg";i:35;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/3akjmljnc/A-TEMPLATE%20WEBSITE-beachclub2.jpg";i:36;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/qlzqkchb1/A-TEMPLATE%20WEBSITE-beach5.jpg";i:37;s:121:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/b854v7fei/A-TEMPLATE%20WEBSITE-beach.jpg";i:38;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/xclj8i22z/A-TEMPLATE%20WEBSITE-beach3.jpg";i:39;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/8a5llup8p/A-TEMPLATE%20WEBSITE-beach4.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/rz7zvb253/A-TEMPLATE%20WEBSITE.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000002GVRiIAO
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 8670
)
[_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 6,500,000 USD | 130,671,652 MXN | 2,679 A/C SQ FT 4 Beds 4 Full Baths 
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/9ovq097mt/A-PROPERTY%20BASE2.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/7g16ozoll/A-PROPERTY%20BASE3.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/snsnco4tq/A-PROPERTY%20BASE.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/ys0z90ugy/A-PROPERTY%20BASE5.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/rka2omqsu/A-PROPERTY%20BASE6.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/900ewncks/A-PROPERTY%20BASE4.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1738184464
)
[ffd_listing_title] => Array
(
[0] => El Lago Descendant 7
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 24-3111
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000000v5xRIAQ
)
[ffd_totalarea_pb] => Array
(
[0] => 4326
)
[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-07T19:19:37.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 357
)
[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 Descendant villas feature two levels of distinctive living spaces. First, a street-level entrance with a two-car garage and double golf cart parking on the same level as the primary bedroom and ensuite bath, gourmet kitchen, dining and great room and terrace overlooking the Querencia lake, Sea of Cortez, mountains and arroyo. Upstairs, find 3 additional bedrooms* and a central family room that extends to the expansive outdoor terrace with outdoor dining area and pool.
*Note: A 3-bedroom Descendant option is available along with the following upgrades: hot tub, firepit, fireplace, BBQ and 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-01-28T17:38:41.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] => 4645000
)
[ffd_listing_price_pesos] => Array
(
[0] => 83610000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.7071078
)
[ffd_community_lot_number] => Array
(
[0] => D7
)
[wpcf-lotsize] => Array
(
[0] => 8842.5
)
[wpcf-lot-size-sqm] => Array
(
[0] => 821.5
)
[wpcf-mls] => Array
(
[0] => 24-3111
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 4191
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk000000v5xRIAQ
)
[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 Descendant 7
)
[wpcf-squarefeet] => Array
(
[0] => 5405
)
[wpcf-view] => Array
(
[0] => Golf Course
)
[wpcf-price] => Array
(
[0] => 4645000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Golf Course El Lago Descendant 7 Single Family Home 24-3111DeveloperEl LagoActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 10680
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-lago-descendant-7/
)
[ffd_media] => Array
(
[0] => a:6:{i:0;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/9ovq097mt/A-PROPERTY%20BASE2.jpg";i:1;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/7g16ozoll/A-PROPERTY%20BASE3.jpg";i:2;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/snsnco4tq/A-PROPERTY%20BASE.jpg";i:3;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/ys0z90ugy/A-PROPERTY%20BASE5.jpg";i:4;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/rka2omqsu/A-PROPERTY%20BASE6.jpg";i:5;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/900ewncks/A-PROPERTY%20BASE4.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001Bwevx/9ovq097mt/A-PROPERTY%20BASE2.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000000v5xRIAQ
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9607
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
El Lago Descendant 7 El Lago Single Family Home 4,645,000 USD | 83,610,000 MXN | 4,326 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths 
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/n53pbp232/A-TEMPLATE%20WEBSITE8.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/25dddqgk7/A-TEMPLATE%20WEBSITE9.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/28vpdmxd3/A-TEMPLATE%20WEBSITE.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/ffm10ak3g/A-TEMPLATE%20WEBSITE10.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/5jzbs4ut6/A-TEMPLATE%20WEBSITE2.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/x8xg1yyin/A-TEMPLATE%20WEBSITE3.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/663nadi1c/A-TEMPLATE%20WEBSITE4.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/6iipov11m/A-TEMPLATE%20WEBSITE5.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/ltrc39l1t/A-TEMPLATE%20WEBSITE6.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/f6hqqtbqi/A-TEMPLATE%20WEBSITE7.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1738184460
)
[ffd_listing_title] => Array
(
[0] => El Lago Ascendant 8
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 24-730
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000000uxWrIAI
)
[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:07:41.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 357
)
[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 3 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.
*Note: A 4-bedroom Ascendant option is available along with the following upgrades: hot tub, firepit, fireplace, BBQ and 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-01-28T17:39:59.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] => 4600000
)
[ffd_listing_price_pesos] => Array
(
[0] => 80500000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.7071078
)
[ffd_community_lot_number] => Array
(
[0] => A8
)
[wpcf-lotsize] => Array
(
[0] => 7573
)
[wpcf-lot-size-sqm] => Array
(
[0] => 703.55
)
[wpcf-mls] => Array
(
[0] => 24-730
)
[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] => a09Pk000000uxWrIAI
)
[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 8
)
[wpcf-squarefeet] => Array
(
[0] => 6578
)
[wpcf-view] => Array
(
[0] => Golf Course
)
[wpcf-price] => Array
(
[0] => 4600000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Golf Course El Lago Ascendant 8 Single Family Home 24-730DeveloperEl LagoActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 10311
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-lago-ascendant-8/
)
[ffd_media] => Array
(
[0] => a:10:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/n53pbp232/A-TEMPLATE%20WEBSITE8.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/25dddqgk7/A-TEMPLATE%20WEBSITE9.jpg";i:2;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/28vpdmxd3/A-TEMPLATE%20WEBSITE.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/ffm10ak3g/A-TEMPLATE%20WEBSITE10.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/5jzbs4ut6/A-TEMPLATE%20WEBSITE2.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/x8xg1yyin/A-TEMPLATE%20WEBSITE3.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/663nadi1c/A-TEMPLATE%20WEBSITE4.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/6iipov11m/A-TEMPLATE%20WEBSITE5.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/ltrc39l1t/A-TEMPLATE%20WEBSITE6.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/f6hqqtbqi/A-TEMPLATE%20WEBSITE7.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBb8/n53pbp232/A-TEMPLATE%20WEBSITE8.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000000uxWrIAI
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9607
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_edit_lock] => Array
(
[0] => 1708028558:10
)
)
El Lago Ascendant 8 El Lago Single Family Home 4,600,000 USD | 80,500,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/a0CPk00001BwND3/ai36kqtyb/A-TEMPLATE%20WEBSITE2.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/ptn5zlvxs/A-TEMPLATE%20WEBSITE10.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/chocr60ti/A-TEMPLATE%20WEBSITE3.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/zcnm6u7ne/A-TEMPLATE%20WEBSITE4.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/ht0egw72a/A-TEMPLATE%20WEBSITE.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/w4t84ixtc/A-TEMPLATE%20WEBSITE5.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/yxafpez8w/A-TEMPLATE%20WEBSITE7.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/3m24lyukm/A-TEMPLATE%20WEBSITE9.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/ik14eh3i5/A-TEMPLATE%20WEBSITE6.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/kp0ejaqrd/A-TEMPLATE%20WEBSITE8.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1738184461
)
[ffd_listing_title] => Array
(
[0] => El Lago Ascendant 7
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 24-729
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000000ux3pIAA
)
[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:04:20.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 357
)
[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 3 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.
*Note: A 4-bedroom Ascendant option is available along with the following upgrades: hot tub, firepit, fireplace, BBQ and 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-01-28T17:40:23.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] => 4550000
)
[ffd_listing_price_pesos] => Array
(
[0] => 79625000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.7071078
)
[ffd_community_lot_number] => Array
(
[0] => A7
)
[wpcf-lotsize] => Array
(
[0] => 7158
)
[wpcf-lot-size-sqm] => Array
(
[0] => 665
)
[wpcf-mls] => Array
(
[0] => 24-729
)
[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] => a09Pk000000ux3pIAA
)
[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 7
)
[wpcf-squarefeet] => Array
(
[0] => 6578
)
[wpcf-view] => Array
(
[0] => Golf Course
)
[wpcf-price] => Array
(
[0] => 4550000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Golf Course El Lago Ascendant 7 Single Family Home 24-729DeveloperEl LagoActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 10310
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-lago-ascendant-7/
)
[ffd_media] => Array
(
[0] => a:10:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/ai36kqtyb/A-TEMPLATE%20WEBSITE2.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/ptn5zlvxs/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/chocr60ti/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/zcnm6u7ne/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/ht0egw72a/A-TEMPLATE%20WEBSITE.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/w4t84ixtc/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/yxafpez8w/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/3m24lyukm/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/ik14eh3i5/A-TEMPLATE%20WEBSITE6.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/kp0ejaqrd/A-TEMPLATE%20WEBSITE8.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwND3/ai36kqtyb/A-TEMPLATE%20WEBSITE2.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000000ux3pIAA
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9607
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
El Lago Ascendant 7 El Lago Single Family Home 4,550,000 USD | 79,625,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/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/njqc3bpy6/A-TEMPLATE%20WEBSITE8.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/4gmrsgoqd/A-TEMPLATE%20WEBSITE9.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/wmakq6tpy/A-TEMPLATE%20WEBSITE.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/1iidtgm1w/A-TEMPLATE%20WEBSITE10.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] => 1738184459
)
[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] => 357
)
[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 3 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.
*Note: A 3-bedroom Ascendant option is available along with the following upgrades: hot tub, firepit, fireplace, BBQ and 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-01-28T17:40:52.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] => 4500000
)
[ffd_listing_price_pesos] => Array
(
[0] => 78750000
)
[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] => 4500000
)
[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:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/njqc3bpy6/A-TEMPLATE%20WEBSITE8.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/4gmrsgoqd/A-TEMPLATE%20WEBSITE9.jpg";i:6;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/wmakq6tpy/A-TEMPLATE%20WEBSITE.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwBNT/1iidtgm1w/A-TEMPLATE%20WEBSITE10.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,500,000 USD | 78,750,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/mqxm92wpd/A-TEMPLATE%20WEBSITE2.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/wnbbzbox0/A-TEMPLATE%20WEBSITE.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/z5ea04us8/A-TEMPLATE%20WEBSITE10.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] => 1738184460
)
[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] => 357
)
[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 3 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.
*Note: A 3-bedroom Ascendant option is available along with the following upgrades: hot tub, firepit, fireplace, BBQ and 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-01-28T17:41:18.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] => 4450000
)
[ffd_listing_price_pesos] => Array
(
[0] => 77875000
)
[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] => 4450000
)
[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:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/mqxm92wpd/A-TEMPLATE%20WEBSITE2.jpg";i:4;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/wnbbzbox0/A-TEMPLATE%20WEBSITE.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJZq/z5ea04us8/A-TEMPLATE%20WEBSITE10.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,450,000 USD | 77,875,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/tdvje71kn/A-TEMPLATE%20WEBSITE2.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/w77ecklqe/A-TEMPLATE%20WEBSITE.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/p6vsvj3ys/A-TEMPLATE%20WEBSITE3.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/jdmpf4bab/A-TEMPLATE%20WEBSITE10.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] => 1738184461
)
[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] => 3
)
[wpcf-bedrooms] => Array
(
[0] => 3
)
[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] => 357
)
[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 2 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.
*Note: A 4-bedroom Ascendant option is available along with the following upgrades: hot tub, firepit, fireplace, BBQ and 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-01-28T17:41:46.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] => 4300000
)
[ffd_listing_price_pesos] => Array
(
[0] => 75250000
)
[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] => 4300000
)
[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:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/tdvje71kn/A-TEMPLATE%20WEBSITE2.jpg";i:4;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/w77ecklqe/A-TEMPLATE%20WEBSITE.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/p6vsvj3ys/A-TEMPLATE%20WEBSITE3.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001BwJvC/jdmpf4bab/A-TEMPLATE%20WEBSITE10.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,300,000 USD | 75,250,000 MXN | 4,608 A/C SQ FT 3 Beds 3 Full Baths 1 Half Baths 
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/9ibo2yvtp/3.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/yw8qirjsn/9.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/pful4qagx/2.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/jmnuy4coe/1%20copia.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/tmi5cmj4a/10.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/of9db6mww/4.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/jj53vq2qv/5.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/0dwryo0nh/6.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/xywa8kmlk/7.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/52eulsyiw/8.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Verandas C-202
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 23-461
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000JWl0AQAT
)
[ffd_totalarea_pb] => Array
(
[0] => 3868.54
)
[ffd_address_pb] => Array
(
[0] => Carretera Transpeninsular Km. 27.5
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_createddate] => Array
(
[0] => 2022-01-15T18:57:37.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 1136
)
[ffd_description_pb] => Array
(
[0] => An exceptional Querencia residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez and San Jose del Cabo, Veranda C-202 is a spacious 4 bedroom, 4.5 bath with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The residence is located just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, providing easy access to Querencia’s amenities, including restaurants, pools, fitness center, Men's and Women's Spas, pickleball and tennis court, Kids & Teens Clubs and more.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family.
Photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary.
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => no
)
[ffd_lastmodifieddate] => Array
(
[0] => 2025-02-24T22:04:27.000+0000
)
[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] => 4250000
)
[ffd_community_lot_number] => Array
(
[0] => 202
)
[ffd_website_status_2] => Array
(
[0] =>
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a093Z00000JWl0AQAT
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[ffd_name] => Array
(
[0] => Verandas C-202
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 9259
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/verandas-c-202/
)
[ffd_media] => Array
(
[0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/9ibo2yvtp/3.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/yw8qirjsn/9.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/pful4qagx/2.jpg";i:3;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/jmnuy4coe/1%20copia.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/tmi5cmj4a/10.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/of9db6mww/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/jj53vq2qv/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/0dwryo0nh/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/xywa8kmlk/7.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/52eulsyiw/8.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/9ibo2yvtp/3.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_edit_lock] => Array
(
[0] => 1648488732:10
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1899
)
[_edit_last] => Array
(
[0] => 10
)
[_ffd_website_status_2] => Array
(
[0] => field_608827aae073c
)
[_featured] => Array
(
[0] => field_615b2b0a187e6
)
[_wpcf-ribbon] => Array
(
[0] => field_61a62a2ab65ac
)
[wpcf-tripple-icon] => Array
(
[0] => default
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000JWl0AQAT
)
[wpcf-property-type] => Array
(
[0] => condo
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[wpcf-lot-size-sqm] => Array
(
[0] => 511.99
)
[wpcf-price] => Array
(
[0] => 4250000
)
[wpcf-mls] => Array
(
[0] => 23-461
)
[wpcf-squarefeet] => Array
(
[0] => 5511.06
)
[wpcf-acarea] => Array
(
[0] => 3869
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[wpcf-latitude] => Array
(
[0] => 23.03112
)
[wpcf-longitude] => Array
(
[0] => -109.75026
)
[wpcf-keywords] => Array
(
[0] => Ocean Verandas C-202 Condominium 23-461DeveloperVerandasActive
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[_yoast_wpseo_estimated-reading-time-minutes] => Array
(
[0] =>
)
[wpcf-property-features] => Array
(
[0] =>
)
[wpcf-highlights] => Array
(
[0] =>
)
[wpcf-lotsize] => Array
(
[0] => 5511.06
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Verandas
)
[ffd_listing_price_pesos] => Array
(
[0] => 72250000
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1740435007
)
)
Verandas C-202 Verandas Condominium 4,250,000 USD | 72,250,000 MXN | 3,869 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths 
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/uydn6yfz3/7.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/34cgo1mbz/1%20copia.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/vsq3m3kyy/10.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/2aze57j6j/2.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/4hwg9xpcm/3.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/sn4w6ze49/4.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/zohjejsgr/5.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/hzc8hql7e/6.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/8tx88msli/8.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/gay72oun9/9.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Verandas C-201
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 23-462
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000JWl0EQAT
)
[ffd_totalarea_pb] => Array
(
[0] => 3868.54
)
[ffd_address_pb] => Array
(
[0] => Carretera Transpeninsular Km. 27.5
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_createddate] => Array
(
[0] => 2022-01-15T18:56:51.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 1136
)
[ffd_description_pb] => Array
(
[0] => An exceptional Querencia residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez and San Jose del Cabo, Veranda C-201 is a spacious 4 bedroom, 4.5 bath with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The residence is located just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, providing easy access to Querencia’s amenities, including restaurants, pools, fitness center, Men's and Women's Spas, pickleball and tennis court, Kids & Teens Clubs and more.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family.
Photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary.
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => no
)
[ffd_lastmodifieddate] => Array
(
[0] => 2025-02-24T22:01:23.000+0000
)
[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] => 4250000
)
[ffd_community_lot_number] => Array
(
[0] => 201
)
[ffd_website_status_2] => Array
(
[0] =>
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a093Z00000JWl0EQAT
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[ffd_name] => Array
(
[0] => Verandas C-201
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 9257
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/verandas-c-201/
)
[ffd_media] => Array
(
[0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/uydn6yfz3/7.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/34cgo1mbz/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/vsq3m3kyy/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/2aze57j6j/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/4hwg9xpcm/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/sn4w6ze49/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/zohjejsgr/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/hzc8hql7e/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/8tx88msli/8.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/gay72oun9/9.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/uydn6yfz3/7.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_edit_lock] => Array
(
[0] => 1682443926:19
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1899
)
[_edit_last] => Array
(
[0] => 10
)
[_ffd_website_status_2] => Array
(
[0] => field_608827aae073c
)
[_featured] => Array
(
[0] => field_615b2b0a187e6
)
[_wpcf-ribbon] => Array
(
[0] => field_61a62a2ab65ac
)
[wpcf-tripple-icon] => Array
(
[0] => default
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000JWl0EQAT
)
[wpcf-property-type] => Array
(
[0] => condo
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[wpcf-lot-size-sqm] => Array
(
[0] => 510.15
)
[wpcf-price] => Array
(
[0] => 4250000
)
[wpcf-mls] => Array
(
[0] => 23-462
)
[wpcf-squarefeet] => Array
(
[0] => 5491.26
)
[wpcf-acarea] => Array
(
[0] => 3869
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[wpcf-latitude] => Array
(
[0] => 23.03112
)
[wpcf-longitude] => Array
(
[0] => -109.75026
)
[wpcf-keywords] => Array
(
[0] => Ocean Verandas C-201 Condominium 23-462DeveloperVerandasActive
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[_yoast_wpseo_estimated-reading-time-minutes] => Array
(
[0] =>
)
[wpcf-property-features] => Array
(
[0] =>
)
[wpcf-highlights] => Array
(
[0] =>
)
[wpcf-lotsize] => Array
(
[0] => 5491.26
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Verandas
)
[ffd_listing_price_pesos] => Array
(
[0] => 72250000
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1740435006
)
)
Verandas C-201 Verandas Condominium 4,250,000 USD | 72,250,000 MXN | 3,869 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths Click to Load More
Loading More Properties...
"*" indicates required fields