Discover Our Properties
SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt1 ON ( wp_tota44soje_posts.ID = mt1.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt2 ON ( wp_tota44soje_posts.ID = mt2.post_id ) WHERE 1=1 AND ( wp_tota44soje_postmeta.meta_key = 'wpcf-price' AND ( ( mt1.meta_key = 'wpcf-ribbon' AND mt1.meta_value IN ('Active','Under Contract','Sold') ) AND ( mt2.meta_key = '_wpcf_belongs_neighborhoods_id' AND mt2.meta_value = '1892' ) )) 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
4
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/sf8ku1e21/more.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/26w7l4zt4/A-TEMPLATE%20WEBSITE4.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/vv0572zpa/A-TEMPLATE%20WEBSITE17.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/cpww1bq9v/A-TEMPLATE%20WEBSITE9.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/6tby705qi/A-TEMPLATE%20WEBSITE24.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/klfu8kohw/A-TEMPLATE%20WEBSITE.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/46i5firf3/A-TEMPLATE%20WEBSITE10.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/bt17ars2r/A-TEMPLATE%20WEBSITE11.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/59fnsazh7/A-TEMPLATE%20WEBSITE12.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/lsbm91z8b/A-TEMPLATE%20WEBSITE13.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/j00pp19ye/A-TEMPLATE%20WEBSITE14.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/y2e4u8vft/A-TEMPLATE%20WEBSITE15.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/vs4bpiwau/A-TEMPLATE%20WEBSITE16.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/4apr6b4ug/A-TEMPLATE%20WEBSITE18.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/tln94d044/A-TEMPLATE%20WEBSITE19.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/oh8ed6prz/A-TEMPLATE%20WEBSITE2.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/hocrps9db/A-TEMPLATE%20WEBSITE20.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/qqjuehm6m/A-TEMPLATE%20WEBSITE21.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/o1dq18udh/A-TEMPLATE%20WEBSITE22.jpg [19] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/gsnibdyre/A-TEMPLATE%20WEBSITE23.jpg [20] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/aj7l43ob7/A-TEMPLATE%20WEBSITE25.jpg [21] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/y6cizvnt3/A-TEMPLATE%20WEBSITE3.jpg [22] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/geo43sfep/A-TEMPLATE%20WEBSITE5.jpg [23] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/t4qp46etf/A-TEMPLATE%20WEBSITE6.jpg [24] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/9l7lsz4o6/A-TEMPLATE%20WEBSITE7.jpg [25] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/f3nan15ge/A-TEMPLATE%20WEBSITE8.jpg [26] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/07a00gbv4/more3.jpg [27] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/2ty6je8ej/more2.jpg [28] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/597cn86j7/A-TEMPLATE%20WEBSITE4.jpg [29] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/llw8t0g34/A-TEMPLATE%20WEBSITE35.jpg [30] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/nt2pqtqy8/A-TEMPLATE%20WEBSITE33.jpg [31] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/lxo2dkpo6/A-TEMPLATE%20WEBSITE32.jpg [32] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/ozwjgt5ap/A-TEMPLATE%20WEBSITE3.jpg [33] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/lljfwn3kw/A-TEMPLATE%20WEBSITE27.jpg [34] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/h1z2g66oj/A-TEMPLATE%20WEBSITE26.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Cañada #14
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 23-2486
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000KnOEmQAN
)
[ffd_totalarea_pb] => Array
(
[0] => 3960
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Querencia Golf Club
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[ffd_city_pb] => Array
(
[0] => San Jose del cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Cañadas
)
[ffd_createddate] => Array
(
[0] => 2023-06-06T17:32:21.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 310
)
[ffd_description_pb] => Array
(
[0] => This charming and authentic Mexican villa offers blasting views of the Sea of Cortez, Punta Gorda and the city of San Jose from one of the highest elevations within the Las Cañadas enclave of 16 homes.
This custom home is fully furnished and features thoughtful details throughout and includes a gourmet kitchen and expansive indoor and outdoor living -- both ideal for entertaining. La Cañada 14 is just a short golf cart ride from the heartbeat of the community, the Querencia Club village, home to the 18-hole Tom Fazio course, pickleball, tennis and racket courts, restaurants, fitness and wellness amenities and more.
The purchase of this home includes a whole house generator, hurricane shutters, and an off-road Polaris RZR vehicle.
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => no
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[ffd_lastmodifieddate] => Array
(
[0] => 2023-10-27T19:59:59.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.03388
)
[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_listing_price_pesos] => Array
(
[0] => 72250000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.74074
)
[ffd_community_lot_number] => Array
(
[0] => 14
)
[wpcf-lotsize] => Array
(
[0] => 14316
)
[wpcf-lot-size-sqm] => Array
(
[0] => 1330
)
[wpcf-mls] => Array
(
[0] => 23-2486
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 3960
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_listing_agent_2] => Array
(
[0] => 0053Z00000LsPqqQAF
)
[ffd_id] => Array
(
[0] => a093Z00000KnOEmQAN
)
[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] => Cañada #14
)
[wpcf-squarefeet] => Array
(
[0] => 5710
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 4250000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean Cañada #14 Single Family Home 23-2486ResaleCañadasActive
)
[ffd_yearbuilt_pb] => Array
(
[0] => 2014
)
[ffd_postalcode_pb] => Array
(
[0] => 23401
)
[pba__WebsiteId__c] => Array
(
[0] => 9647
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/canada-14/
)
[ffd_media] => Array
(
[0] => a:35:{i:0;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/sf8ku1e21/more.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/26w7l4zt4/A-TEMPLATE%20WEBSITE4.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/vv0572zpa/A-TEMPLATE%20WEBSITE17.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/cpww1bq9v/A-TEMPLATE%20WEBSITE9.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/6tby705qi/A-TEMPLATE%20WEBSITE24.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/klfu8kohw/A-TEMPLATE%20WEBSITE.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/46i5firf3/A-TEMPLATE%20WEBSITE10.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/bt17ars2r/A-TEMPLATE%20WEBSITE11.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/59fnsazh7/A-TEMPLATE%20WEBSITE12.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/lsbm91z8b/A-TEMPLATE%20WEBSITE13.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/j00pp19ye/A-TEMPLATE%20WEBSITE14.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/y2e4u8vft/A-TEMPLATE%20WEBSITE15.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/vs4bpiwau/A-TEMPLATE%20WEBSITE16.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/4apr6b4ug/A-TEMPLATE%20WEBSITE18.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/tln94d044/A-TEMPLATE%20WEBSITE19.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/oh8ed6prz/A-TEMPLATE%20WEBSITE2.jpg";i:16;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/hocrps9db/A-TEMPLATE%20WEBSITE20.jpg";i:17;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/qqjuehm6m/A-TEMPLATE%20WEBSITE21.jpg";i:18;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/o1dq18udh/A-TEMPLATE%20WEBSITE22.jpg";i:19;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/gsnibdyre/A-TEMPLATE%20WEBSITE23.jpg";i:20;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/aj7l43ob7/A-TEMPLATE%20WEBSITE25.jpg";i:21;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/y6cizvnt3/A-TEMPLATE%20WEBSITE3.jpg";i:22;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/geo43sfep/A-TEMPLATE%20WEBSITE5.jpg";i:23;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/t4qp46etf/A-TEMPLATE%20WEBSITE6.jpg";i:24;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/9l7lsz4o6/A-TEMPLATE%20WEBSITE7.jpg";i:25;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/f3nan15ge/A-TEMPLATE%20WEBSITE8.jpg";i:26;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/07a00gbv4/more3.jpg";i:27;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/2ty6je8ej/more2.jpg";i:28;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/597cn86j7/A-TEMPLATE%20WEBSITE4.jpg";i:29;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/llw8t0g34/A-TEMPLATE%20WEBSITE35.jpg";i:30;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/nt2pqtqy8/A-TEMPLATE%20WEBSITE33.jpg";i:31;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/lxo2dkpo6/A-TEMPLATE%20WEBSITE32.jpg";i:32;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/ozwjgt5ap/A-TEMPLATE%20WEBSITE3.jpg";i:33;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/lljfwn3kw/A-TEMPLATE%20WEBSITE27.jpg";i:34;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/h1z2g66oj/A-TEMPLATE%20WEBSITE26.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/sf8ku1e21/more.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000KnOEmQAN
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1892
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-agent-2] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_wp_old_slug] => Array
(
[0] => canada-14-2
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850491
)
)
Cañada #14 Cañadas Single Family Home 4,250,000 USD | 72,250,000 MXN | 3,960 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths 
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/op7rpnotk/A-TEMPLATE%20WEBSITE6.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/wx69pwvii/A-TEMPLATE%20WEBSITE5.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/uwktnyw2w/A-TEMPLATE%20WEBSITE4.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/fek74c8sd/A-TEMPLATE%20WEBSITE3.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/up41tg8dw/A-TEMPLATE%20WEBSITE2.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/2t1fpgk0r/A-TEMPLATE%20WEBSITE.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/ge4kkw7w7/A-TEMPLATE%20WEBSITE.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/2ppvpq02w/A-TEMPLATE%20WEBSITE2.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/qook5j7y6/A-TEMPLATE%20WEBSITE4.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/1wbv97kjh/A-TEMPLATE%20WEBSITE3.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/fr3pvw5wv/A-TEMPLATE%20WEBSITE7.jpg)Array
(
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850483
)
[ffd_listing_title] => Array
(
[0] => Cañada 11
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 23-4929
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000000R1knIAC
)
[ffd_totalarea_pb] => Array
(
[0] => 3999.71
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Cañada 11, Querencia
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Cañadas
)
[ffd_createddate] => Array
(
[0] => 2023-12-18T22:57:28.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 136
)
[ffd_description_pb] => Array
(
[0] => Casa Rosada is situated in the most serene setting nestled in nature with a backyard extending towards a picturesque canyon. This 4-bedroom gem unveils unobstructed vistas of the sea, canyon, mountains, and twinkling town lights in the evening. Designed for seamless indoor and outdoor living, Casita Rosada's great room flows graciously to the expansive outdoor living area, ideal for entertaining, with dining terrace, outdoor pavilion, and private infinity-edged pool. The design style of this house offers comfort and timeless elegance.
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] => 2024-04-05T17:35:39.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.08798
)
[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] => 4200000
)
[ffd_listing_price_pesos] => Array
(
[0] => 71400000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.71471
)
[ffd_community_lot_number] => Array
(
[0] => 11
)
[wpcf-lotsize] => Array
(
[0] => 14343.08
)
[wpcf-lot-size-sqm] => Array
(
[0] => 1332.52
)
[wpcf-mls] => Array
(
[0] => 23-4929
)
[ffd_website_status_2] => Array
(
[0] => Under Contract
)
[wpcf-acarea] => Array
(
[0] =>
)
[wpcf-property-type] => Array
(
[0] => home
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000Kt8H2QAJ
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk000000R1knIAC
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Under Contract
)
[ffd_name] => Array
(
[0] => Cañada 11
)
[wpcf-squarefeet] => Array
(
[0] => 7950.99
)
[wpcf-view] => Array
(
[0] =>
)
[wpcf-price] => Array
(
[0] => 4200000
)
[ffd_sort_by] => Array
(
[0] => B
)
[ffd_website_status] => Array
(
[0] => Under Contract
)
[wpcf-keywords] => Array
(
[0] => Cañada 11 Single Family Home 23-4929ResaleCañadasUnder Contract
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 10065
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/canada-11/
)
[ffd_media] => Array
(
[0] => a:11:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/op7rpnotk/A-TEMPLATE%20WEBSITE6.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/wx69pwvii/A-TEMPLATE%20WEBSITE5.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/uwktnyw2w/A-TEMPLATE%20WEBSITE4.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/fek74c8sd/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/up41tg8dw/A-TEMPLATE%20WEBSITE2.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/2t1fpgk0r/A-TEMPLATE%20WEBSITE.jpg";i:6;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/ge4kkw7w7/A-TEMPLATE%20WEBSITE.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/2ppvpq02w/A-TEMPLATE%20WEBSITE2.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/qook5j7y6/A-TEMPLATE%20WEBSITE4.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/1wbv97kjh/A-TEMPLATE%20WEBSITE3.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/fr3pvw5wv/A-TEMPLATE%20WEBSITE7.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000pi14R/op7rpnotk/A-TEMPLATE%20WEBSITE6.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000000R1knIAC
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1892
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000Kt8H2
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
)
Cañada 11 Cañadas Single Family Home 4,200,000 USD | 71,400,000 MXN 4 Beds 4 Full Baths 1 Half Baths Under ContractUnder Contract
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/ca9ewz9bh/1.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/imu0unvnm/10.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/s9w3lruok/11.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/fk0lf3lj7/12.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/mvys0o9w3/13.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/okbib8zwh/14.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/4vq4wes0i/15.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/b0xpr3ncs/17.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/d9cdiaqr8/18.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/3ngecyi1o/19.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/vusk0tye0/2.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/vfzijfnpo/3.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/oeewprrgs/4.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/71pfwetex/5.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/vbbuwwkvv/16.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/a4vpboycu/6.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/3598mv3di/7.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/18hcorxdm/8.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/tshdu7hdm/9.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Cañada #09
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 16-1596
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000It8yoQAB
)
[ffd_totalarea_pb] => Array
(
[0] => 4260.3
)
[ffd_address_pb] => Array
(
[0] => Carretera Transpeninsular Km. 27.5
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_createddate] => Array
(
[0] => 2021-04-23T18:07:01.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 1087
)
[ffd_description_pb] => Array
(
[0] => Experience sweeping vistas of the Sea of Cortez, Punta Gorda and San Jose, high atop Querencia's canyon ridge from Cañada 9. Step inside the stone courtyard and experience a coastal contemporary design in this serene custom villa. Cañada 9 offers 5 bedrooms within the light-filled, open floor plan and a gourmet kitchen with Viking and Sub-Zero appliances. Ideal for entertaining, Cañada 9's sprawling outdoor living space includes both covered and uncovered terraces, an infinity-edge pool and jacuzzi, pavilion and outdoor kitchen.
Cañada 9 is just a short golf cart ride away from Querencia sprawling Club village, home to the 18-hole Tom Fazio golf course, 7 restaurants, pools and amenities for all ages.
)
[ffd_lastmodifieddate] => Array
(
[0] => 2022-05-09T06:09:38.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 2525000
)
[ffd_community_lot_number] => Array
(
[0] => 9
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_id] => Array
(
[0] => a093Z00000It8yoQAB
)
[ffd_name] => Array
(
[0] => Cañada #09
)
[ffd_website_status_2] => Array
(
[0] => Sold
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 7911
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/canada-09/
)
[ffd_media] => Array
(
[0] => a:19:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/ca9ewz9bh/1.jpg";i:1;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/imu0unvnm/10.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/s9w3lruok/11.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/fk0lf3lj7/12.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/mvys0o9w3/13.jpg";i:5;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/okbib8zwh/14.jpg";i:6;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/4vq4wes0i/15.jpg";i:7;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/b0xpr3ncs/17.jpg";i:8;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/d9cdiaqr8/18.jpg";i:9;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/3ngecyi1o/19.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/vusk0tye0/2.jpg";i:11;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/vfzijfnpo/3.jpg";i:12;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/oeewprrgs/4.jpg";i:13;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/71pfwetex/5.jpg";i:14;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/vbbuwwkvv/16.jpg";i:15;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/a4vpboycu/6.jpg";i:16;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/3598mv3di/7.jpg";i:17;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/18hcorxdm/8.jpg";i:18;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/tshdu7hdm/9.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/ca9ewz9bh/1.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_sort_by] => Array
(
[0] => C
)
[ffd_website_status] => Array
(
[0] => Sold
)
[_edit_lock] => Array
(
[0] => 1635289670:5
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1892
)
[_edit_last] => Array
(
[0] => 5
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[_ffd_website_status_2] => Array
(
[0] => field_608827aae073c
)
[featured] => Array
(
[0] =>
)
[_featured] => Array
(
[0] => field_615b2b0a187e6
)
[_yoast_wpseo_primary_category] => Array
(
[0] =>
)
[wpcf-tripple-icon] => Array
(
[0] => default
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000It8yoQAB
)
[wpcf-property-type] => Array
(
[0] => home
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Sold
)
[wpcf-lotsize] => Array
(
[0] => 14224.49
)
[wpcf-lot-size-sqm] => Array
(
[0] => 1321.5
)
[wpcf-price] => Array
(
[0] => 2525000
)
[wpcf-mls] => Array
(
[0] => 16-1596
)
[wpcf-squarefeet] => Array
(
[0] => 4716.68
)
[wpcf-acarea] => Array
(
[0] => 4260
)
[wpcf-bedrooms] => Array
(
[0] => 5
)
[wpcf-bathrooms] => Array
(
[0] => 5
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[wpcf-latitude] => Array
(
[0] => 23.03353
)
[wpcf-longitude] => Array
(
[0] => -109.73999
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-keywords] => Array
(
[0] => Ocean Cañada #09 Single Family Home 16-1596ResaleCañadasSold
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[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_listing_agent_2] => Array
(
[0] =>
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Cañadas
)
[ffd_listing_price_pesos] => Array
(
[0] =>
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850494
)
)
Cañada #09 Cañadas Single Family Home | 4,260 A/C SQ FT 5 Beds 5 Full Baths 1 Half Baths SoldSold
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/jn1xp62fk/1.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/434p3v3st/10.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/2b7nyqgvf/11.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/8b0bt1smy/12.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/jyd6kchq5/13.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/3mqu0jmss/14.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/9g5ns9vwz/2.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/67bcz5j9q/3.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/q4h9mqn93/4.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/5yl2hg7rd/5.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/2xlldpq0a/6.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/5epp48gbw/7.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/6p91p5cvq/8.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/grv86olky/9.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Cañada #08
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 21-1037
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000Isvq9QAB
)
[ffd_totalarea_pb] => Array
(
[0] => 4006.44
)
[ffd_address_pb] => Array
(
[0] => Km. 27.5 Transpeninsular Hwy.
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_createddate] => Array
(
[0] => 2021-03-16T17:20:28.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 1122
)
[ffd_description_pb] => Array
(
[0] => Rich with detail, this spectacular 4 bedroom turnkey ready single-family home is perched along a ridge line overlooking a beautiful canyon with expansive views to the Sea of Cortez as the primary vistas yet also offering panoramic secondary vistas of the Querencia Fazio Golf Course and Club Village. This home features indoor & outdoor fireplaces. The Master Suite Bath offers indoor/outdoor showers & French Doors which open to an open-air relaxation garden accented with a cascading water feature that can be enjoyed from the free standing soaker tub. With the open floor plan concept of the great room & kitchen this creates a perfect environment for hosting family and guest. The Cañada neighborhood has proven to be one of the most sought after addresses in Querencia.
)
[ffd_lastmodifieddate] => Array
(
[0] => 2022-05-09T06:09:48.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 2500000
)
[ffd_community_lot_number] => Array
(
[0] => 8
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_listing_agent_2] => Array
(
[0] => 0053Z00000Kt8H2QAJ
)
[ffd_id] => Array
(
[0] => a093Z00000Isvq9QAB
)
[ffd_name] => Array
(
[0] => Cañada #08
)
[ffd_website_status_2] => Array
(
[0] => Sold
)
[ffd_yearbuilt_pb] => Array
(
[0] => 2015
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 7935
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/canada-08/
)
[ffd_media] => Array
(
[0] => a:14:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/jn1xp62fk/1.jpg";i:1;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/434p3v3st/10.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/2b7nyqgvf/11.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/8b0bt1smy/12.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/jyd6kchq5/13.jpg";i:5;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/3mqu0jmss/14.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/9g5ns9vwz/2.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/67bcz5j9q/3.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/q4h9mqn93/4.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/5yl2hg7rd/5.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/2xlldpq0a/6.jpg";i:11;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/5epp48gbw/7.jpg";i:12;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/6p91p5cvq/8.jpg";i:13;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/grv86olky/9.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/jn1xp62fk/1.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_sort_by] => Array
(
[0] => C
)
[ffd_website_status] => Array
(
[0] => Sold
)
[_edit_lock] => Array
(
[0] => 1635289379:5
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1892
)
[_edit_last] => Array
(
[0] => 5
)
[_ffd_website_status_2] => Array
(
[0] => field_608827aae073c
)
[featured] => Array
(
[0] =>
)
[_featured] => Array
(
[0] => field_615b2b0a187e6
)
[_yoast_wpseo_primary_category] => Array
(
[0] =>
)
[wpcf-tripple-icon] => Array
(
[0] => default
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000Isvq9QAB
)
[wpcf-property-type] => Array
(
[0] => home
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Sold
)
[wpcf-lotsize] => Array
(
[0] => 14270.84
)
[wpcf-lot-size-sqm] => Array
(
[0] => 1325.8
)
[wpcf-mls] => Array
(
[0] => 21-1037
)
[wpcf-squarefeet] => Array
(
[0] => 5863.88
)
[wpcf-acarea] => Array
(
[0] => 4006
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[wpcf-latitude] => Array
(
[0] => 23.033318
)
[wpcf-longitude] => Array
(
[0] => -109.739545
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-agent-2] => Array
(
[0] => 0053Z00000Kt8H2
)
[wpcf-keywords] => Array
(
[0] => Ocean Cañada #08 Single Family Home 21-1037ResaleCañadasSold
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[wpcf-price] => Array
(
[0] => 2500000
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[ffd_listofficemlsid] => Array
(
[0] =>
)
[ffd_listofficename] => Array
(
[0] =>
)
[ffd_listing_agent_email] => Array
(
[0] =>
)
[ffd_listing_agent_firstname] => Array
(
[0] =>
)
[ffd_listing_agent_lastname] => Array
(
[0] =>
)
[ffd_listingagentmlsid] => Array
(
[0] =>
)
[ffd_listingagentname] => Array
(
[0] =>
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Cañadas
)
[ffd_listing_price_pesos] => Array
(
[0] =>
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850494
)
)
Cañada #08 Cañadas Single Family Home | 4,006 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths SoldSold
Click to Load More
Loading More 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 ) WHERE 1=1 AND ( ( wp_tota44soje_postmeta.meta_key = 'featured' AND wp_tota44soje_postmeta.meta_value = 'yes' )) AND wp_tota44soje_posts.post_type = 'properties' AND ((wp_tota44soje_posts.post_status = 'publish')) GROUP BY wp_tota44soje_posts.ID ORDER BY wp_tota44soje_posts.post_date DESC LIMIT 0, 3
Featured properties
11
Array( [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] => 1712868436
)
[ffd_listing_title] => Array
(
[0] => Ocean Residence B 202
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] =>
)
[ffd_salesforce_id] => Array
(
[0] => a09Pk000002GVRiIAO
)
[ffd_totalarea_pb] => Array
(
[0] => 2681
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Querencia, San Jose del Cabo, Baja California Sur, Mexico, Los Cabos.
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[ffd_city_pb] => Array
(
[0] => San José del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Ocean Residences
)
[ffd_createddate] => Array
(
[0] => 2024-04-09T22:57:14.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 1
)
[ffd_description_pb] => Array
(
[0] => Sleek, spacious and just steps from the sun-drenched shores of the Sea of Cortez, Ocean Residence B-202 is the epitome of modern luxury meets coastal contemporary.
Inside, find inspired living within the neutral, yet refined space. This turnkey, brand new 4-bedroom, 4 full-bath residence – one of just a few in the 30-unit complex—is flooded with natural light framing panoramic views of the swimmable beach, one of the best surf breaks in San Jose. Designed with impeccable attention to detail and with top-of-the-line appliances and finishes throughout, Residence B-202 is centrally located within the center of the three Ocean Residence towers.
Rest and luxuriate with views of the ocean from the primary bedroom complete with an oversized spa-like bath with dual-showers and ample closet space. Two additional bedrooms features ensuite baths, while the fourth bedroom has direct access to a full bath.
Designed to maximize storage opportunities, the open concept floorplan features 2,600 sq. ft. of interior space which seamlessly flows through minimalistic floor-to-ceiling, double paned glass doors onto an additional 500 square feet of outdoor living lounge space with outdoor fireplace and heated plunge pool.
Owners of B-202 gain access to convenient underground parking, including two desirable side-by-side parking spaces, additional lock-off storage space and full-time security and access to beachfront living at its finest at the Querencia Beach Club, home to two family pools, four dining experiences, a satellite Querencia Spa, Sports Lounge and oceanfront Fitness Center.
Other Features Include:
Elevator access | SubZero and Wolf appliances | Rosa Morada wood throughout | Fully-furnished, including TVs and hidden mounted soffit speakers | Convenient, electric roll-down, hurricane shutters throughout | External hurricane shutters on terrace
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family.
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => yes
)
[wpcf-half-bathrooms] => Array
(
[0] =>
)
[ffd_lastmodifieddate] => Array
(
[0] => 2024-04-11T20:39:23.000+0000
)
[wpcf-latitude] => Array
(
[0] => 22.90981
)
[ffd_listofficemlsid] => Array
(
[0] =>
)
[ffd_listofficename] => Array
(
[0] =>
)
[ffd_listing_agent_email] => Array
(
[0] =>
)
[ffd_listing_agent_firstname] => Array
(
[0] =>
)
[ffd_listing_agent_lastname] => Array
(
[0] =>
)
[ffd_listingagentmlsid] => Array
(
[0] =>
)
[ffd_listingagentname] => Array
(
[0] =>
)
[ffd_listingprice_pb] => Array
(
[0] => 6500000
)
[ffd_listing_price_pesos] => Array
(
[0] => 106525900
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.9278
)
[ffd_community_lot_number] => Array
(
[0] =>
)
[wpcf-lotsize] => Array
(
[0] =>
)
[wpcf-lot-size-sqm] => Array
(
[0] => 0
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] =>
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000LsPqqQAF
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09Pk000002GVRiIAO
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[ffd_name] => Array
(
[0] => Ocean Residence B 202
)
[wpcf-squarefeet] => Array
(
[0] => 3237
)
[wpcf-view] => Array
(
[0] =>
)
[wpcf-price] => Array
(
[0] => 6500000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => Ocean Residence B 202 Condominium DeveloperOcean ResidencesActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23406
)
[pba__WebsiteId__c] => Array
(
[0] => 10382
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/ocean-residence-b-202/
)
[ffd_media] => Array
(
[0] => a:40:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/rz7zvb253/A-TEMPLATE%20WEBSITE.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/40ty3hcgr/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/1zoepwm5u/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/unijgvx3x/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/idt463vt6/A-TEMPLATE%20WEBSITE17.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h8hbbgt2y/A-TEMPLATE%20WEBSITE4.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/0rvlsktzd/A-TEMPLATE%20WEBSITE16.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7rrnt7d1z/A-TEMPLATE%20WEBSITE15.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9wf8a3zhq/A-TEMPLATE%20WEBSITE18.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/sk61xp1f2/A-TEMPLATE%20WEBSITE19.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/lanc9lix2/A-TEMPLATE%20WEBSITE20.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/a0yrnk6cr/A-TEMPLATE%20WEBSITE11.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7jv1c1yf2/A-TEMPLATE%20WEBSITE12.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/k7uktv0fn/A-TEMPLATE%20WEBSITE13.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/g9e0xk2oc/A-TEMPLATE%20WEBSITE14.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/l08lgfln0/A-TEMPLATE%20WEBSITE5.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/fu01nec1w/A-TEMPLATE%20WEBSITE8.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/zolndnp7l/A-TEMPLATE%20WEBSITE7.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/403ih1ghs/A-TEMPLATE%20WEBSITE9.jpg";i:19;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/q5lcscn1s/A-TEMPLATE%20WEBSITE22.jpg";i:20;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mshycubwg/A-TEMPLATE%20WEBSITE21.jpg";i:21;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/015pr15cw/A-TEMPLATE%20WEBSITE24.jpg";i:22;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h06pixcdw/A-TEMPLATE%20WEBSITE25.jpg";i:23;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9ov4diznp/A-TEMPLATE%20WEBSITE26.jpg";i:24;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/le7q8myhm/A-TEMPLATE%20WEBSITE6.jpg";i:25;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/ns7gahnbq/A-TEMPLATE%20WEBSITE27.jpg";i:26;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/d481dk7lb/A-TEMPLATE%20WEBSITE28.jpg";i:27;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/j136isshw/A-TEMPLATE%20WEBSITE29.jpg";i:28;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/nif80q33n/A-TEMPLATE%20WEBSITE30.jpg";i:29;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tqoi2fzra/A-TEMPLATE%20WEBSITE31.jpg";i:30;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/495zsyqlq/A-TEMPLATE%20WEBSITE32.jpg";i:31;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/5bplookua/A-TEMPLATE%20WEBSITE-beachclub4.jpg";i:32;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tgn5n0p5r/A-TEMPLATE%20WEBSITE-beachclub3.jpg";i:33;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/edv316i9i/A-TEMPLATE%20WEBSITE-beach6.jpg";i:34;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mubnz02c2/A-TEMPLATE%20WEBSITE-beachclub.jpg";i:35;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/3akjmljnc/A-TEMPLATE%20WEBSITE-beachclub2.jpg";i:36;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/qlzqkchb1/A-TEMPLATE%20WEBSITE-beach5.jpg";i:37;s:121:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/b854v7fei/A-TEMPLATE%20WEBSITE-beach.jpg";i:38;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/xclj8i22z/A-TEMPLATE%20WEBSITE-beach3.jpg";i:39;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/8a5llup8p/A-TEMPLATE%20WEBSITE-beach4.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/rz7zvb253/A-TEMPLATE%20WEBSITE.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a09Pk000002GVRiIAO
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 8670
)
)
Ocean Residence B 202 Ocean Residences Condominium 6,500,000 USD | 106,525,900 MXN 4 Beds 4 Full Baths 
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] => 2023-07-28T22:02:01.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.05381
)
[ffd_listofficemlsid] => Array
(
[0] =>
)
[ffd_listofficename] => Array
(
[0] =>
)
[ffd_listing_agent_email] => Array
(
[0] =>
)
[ffd_listing_agent_firstname] => Array
(
[0] =>
)
[ffd_listing_agent_lastname] => Array
(
[0] =>
)
[ffd_listingagentmlsid] => Array
(
[0] =>
)
[ffd_listingagentname] => Array
(
[0] =>
)
[ffd_listingprice_pb] => Array
(
[0] => 3465000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.70348
)
[ffd_community_lot_number] => Array
(
[0] => 35
)
[wpcf-lotsize] => Array
(
[0] => 22948.66
)
[wpcf-lot-size-sqm] => Array
(
[0] => 2132
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 3050
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000Kt8H2QAJ
)
[ffd_listing_agent_2] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_id] => Array
(
[0] => a093Z00000JYGq7QAH
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[ffd_name] => Array
(
[0] => El Valle 1 Upper
)
[wpcf-squarefeet] => Array
(
[0] => 3588
)
[wpcf-view] => Array
(
[0] =>
)
[wpcf-price] => Array
(
[0] => 3465000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => El Valle 1 Upper Condominium DeveloperEl ValleActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23406
)
[pba__WebsiteId__c] => Array
(
[0] => 9604
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-valle-1-upper/
)
[ffd_media] => Array
(
[0] => a:29:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/tq1hxt5r6/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/uifiwgcnt/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hojxk6ut1/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/zgnw06tqo/A-TEMPLATE%20WEBSITE5.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5d98tiql5/A-TEMPLATE%20WEBSITE6.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/je4iqh7s6/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gotztox5o/A-TEMPLATE%20WEBSITE8.jpg";i:8;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/7j9e91qrc/Clubhouse-2.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/upeuzy8r2/Clubhouse-3.jpg";i:10;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/n4qrwk05e/Clubhouse-4.jpg";i:11;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/0cxtdew1t/Clubhouse.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4hwfbxexi/dinner.jpg";i:13;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4jg6szv38/golf-2.jpg";i:14;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/o1d1bhfrr/Yoga%20Querencia.jpg";i:15;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p41u05p61/trampoline.jpg";i:16;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/xvak4upbw/trails.jpg";i:17;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/vp3pbyasj/trails-2.jpg";i:18;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/efb60lvs3/surf.jpg";i:19;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/ol4v781k1/surf-3.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/31zt4rvy4/surf-2.jpg";i:21;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p8nazbkgc/slide.jpg";i:22;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gcekb0ldt/Querencia%20Golf.jpg";i:23;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5xp1u8wn8/Querencia%20Beach%20Club.jpg";i:24;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8hsjs0szf/Pickleball.jpg";i:25;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/acd2s0967/Pickleball-2.jpg";i:26;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/49vq4ijob/Mountain%20Bike.jpg";i:27;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/bepc4cg6o/golf.jpg";i:28;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8wwe0k7wm/Golf-4.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000JYGq7QAH
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000Kt8H2
)
[wpcf-agent-2] => Array
(
[0] => 0053Z00000KX9ZY
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_listing_price_pesos] => Array
(
[0] => 58905000
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9608
)
[_edit_lock] => Array
(
[0] => 1701276370:21
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850475
)
)
El Valle 1 Upper El Valle Condominium 3,465,000 USD | 58,905,000 MXN | 3,050 A/C SQ FT 3 Beds 3 Full Baths 1 Half Baths 
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] => 360
)
[ffd_description_pb] => Array
(
[0] => El Valle is the latest neighborhood designed within the masterplanned Querencia community.
A smaller, more intimate enclave set against the backdrop of the vibrant desert mountains,
the 12 condominium residences offer a mix of views of the turquoise San Jose bay, Querencia lake and the award-winning Tom Fazio golf course.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.)
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => yes
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[ffd_lastmodifieddate] => Array
(
[0] => 2023-07-29T19:31:33.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.05381
)
[ffd_listofficemlsid] => Array
(
[0] =>
)
[ffd_listofficename] => Array
(
[0] =>
)
[ffd_listing_agent_email] => Array
(
[0] =>
)
[ffd_listing_agent_firstname] => Array
(
[0] =>
)
[ffd_listing_agent_lastname] => Array
(
[0] =>
)
[ffd_listingagentmlsid] => Array
(
[0] =>
)
[ffd_listingagentname] => Array
(
[0] =>
)
[ffd_listingprice_pb] => Array
(
[0] => 2970000
)
[wpcf-listing-type] => Array
(
[0] => Developer
)
[wpcf-longitude] => Array
(
[0] => -109.70348
)
[ffd_community_lot_number] => Array
(
[0] => 35
)
[wpcf-lotsize] => Array
(
[0] => 22948.66
)
[wpcf-lot-size-sqm] => Array
(
[0] => 2132
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] =>
)
[wpcf-acarea] => Array
(
[0] => 3050
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a093Z00000JYL7NQAX
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[ffd_name] => Array
(
[0] => El Valle 6 Lower
)
[wpcf-squarefeet] => Array
(
[0] => 3588
)
[wpcf-view] => Array
(
[0] =>
)
[wpcf-price] => Array
(
[0] => 2970000
)
[ffd_sort_by] => Array
(
[0] => A
)
[ffd_website_status] => Array
(
[0] =>
)
[wpcf-keywords] => Array
(
[0] => El Valle 6 Lower Condominium DeveloperEl ValleActive
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_postalcode_pb] => Array
(
[0] => 23406
)
[pba__WebsiteId__c] => Array
(
[0] => 9602
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-valle-6-lower/
)
[ffd_media] => Array
(
[0] => a:20:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/59da53bl9/A-TEMPLATE%20WEBSITE8.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zb2ykxl8/A-TEMPLATE%20WEBSITE.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/qv0b0b5ir/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/l5ajufh3m/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nrkbi41ve/A-TEMPLATE%20WEBSITE4.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nhvo5ykxt/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/kxit5zdgo/A-TEMPLATE%20WEBSITE6.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/41ulfgs6j/A-TEMPLATE%20WEBSITE7.jpg";i:8;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/xl6wa0998/Clubhouse.jpg";i:9;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/7rkc1miym/dinner.jpg";i:10;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8bbmuy30i/Golf-4.jpg";i:11;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/o18l17egf/golf.jpg";i:12;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8u4cjjqhj/Mountain%20Bike.jpg";i:13;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/vke6ofpck/Pickleball-2.jpg";i:14;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zg8fsi4o/slide.jpg";i:15;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/jiy6m42k9/surf.jpg";i:16;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/6y2arpc7c/trails-2.jpg";i:17;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/ij9e65fmd/trails.jpg";i:18;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5iozycjr3/trampoline.jpg";i:19;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5xcehypmk/Yoga%20Querencia.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/59da53bl9/A-TEMPLATE%20WEBSITE8.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000JYL7NQAX
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_listing_price_pesos] => Array
(
[0] => 50490000
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 9608
)
[_edit_lock] => Array
(
[0] => 1690823630:10
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850477
)
)
El Valle 6 Lower El Valle Condominium 2,970,000 USD | 50,490,000 MXN | 3,050 A/C SQ FT 3 Beds 3 Full Baths 1 Half Baths