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 = '1888' ) )) 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/a0Cj000000420U4/ddiq96mbu/A-TEMPLATE%20WEBSITE14.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/nud30nv5l/A-TEMPLATE%20WEBSITE11.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/qcwo4fg0t/A-TEMPLATE%20WEBSITE18.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/4b53sjfp7/A-TEMPLATE%20WEBSITE2.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/4k5vnysd6/A-TEMPLATE%20WEBSITE.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/5yz8yiplv/A-TEMPLATE%20WEBSITE10.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/tc99fcl82/A-TEMPLATE%20WEBSITE12.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/jmeh5o90g/A-TEMPLATE%20WEBSITE13.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/iqnx8nc1m/A-TEMPLATE%20WEBSITE15.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/trr37vjzd/A-TEMPLATE%20WEBSITE16.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/1k5ay1dzc/A-TEMPLATE%20WEBSITE17.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/dziegwv3s/A-TEMPLATE%20WEBSITE3.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/6o85t6qq6/A-TEMPLATE%20WEBSITE4.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/nr1nf90ff/A-TEMPLATE%20WEBSITE5.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/085g7wxpj/A-TEMPLATE%20WEBSITE6.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/nj48gt7wh/A-TEMPLATE%20WEBSITE7.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/mqop3oth4/A-TEMPLATE%20WEBSITE8.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/42to8lpmh/A-TEMPLATE%20WEBSITE9.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Cabaña #06 Upper
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 23-2250
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000KJsR3QAL
)
[ffd_totalarea_pb] => Array
(
[0] => 2800
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Km. 27.5 Transpeninsular Hwy.
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 3
)
[wpcf-bedrooms] => Array
(
[0] => 3
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Las Cabanas
)
[ffd_createddate] => Array
(
[0] => 2023-05-04T21:40:17.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 343
)
[ffd_description_pb] => Array
(
[0] => Conveniently located within steps of the Querencia Clubhouse, this second-floor luxury condominium features vaulted ceilings, sliding pocket doors and a private corner location. Cabaña 6 is move-in ready and offers 3 bedrooms and 3 baths, is fully furnished and is truly the epitome of luxury living within a world-class community.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.)
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => no
)
[wpcf-half-bathrooms] => Array
(
[0] =>
)
[ffd_lastmodifieddate] => Array
(
[0] => 2024-01-08T16:15:08.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.03163
)
[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] => 2400000
)
[ffd_listing_price_pesos] => Array
(
[0] => 40800000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.74773
)
[ffd_community_lot_number] => Array
(
[0] =>
)
[wpcf-lotsize] => Array
(
[0] =>
)
[wpcf-lot-size-sqm] => Array
(
[0] => 0
)
[wpcf-mls] => Array
(
[0] => 23-2250
)
[ffd_website_status_2] => Array
(
[0] => Under Contract
)
[wpcf-acarea] => Array
(
[0] => 2800
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000LsPqqQAF
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a093Z00000KJsR3QAL
)
[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] => Cabaña #06 Upper
)
[wpcf-squarefeet] => Array
(
[0] => 4149.27
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 2400000
)
[ffd_sort_by] => Array
(
[0] => B
)
[ffd_website_status] => Array
(
[0] => Under Contract
)
[wpcf-keywords] => Array
(
[0] => Ocean Cabaña #06 Upper Condominium 23-2250ResaleLas CabanasUnder Contract
)
[ffd_yearbuilt_pb] => Array
(
[0] => 2007
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 9642
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/cabana-06-upper/
)
[ffd_media] => Array
(
[0] => a:18:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/ddiq96mbu/A-TEMPLATE%20WEBSITE14.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/nud30nv5l/A-TEMPLATE%20WEBSITE11.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/qcwo4fg0t/A-TEMPLATE%20WEBSITE18.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/4b53sjfp7/A-TEMPLATE%20WEBSITE2.jpg";i:4;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/4k5vnysd6/A-TEMPLATE%20WEBSITE.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/5yz8yiplv/A-TEMPLATE%20WEBSITE10.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/tc99fcl82/A-TEMPLATE%20WEBSITE12.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/jmeh5o90g/A-TEMPLATE%20WEBSITE13.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/iqnx8nc1m/A-TEMPLATE%20WEBSITE15.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/trr37vjzd/A-TEMPLATE%20WEBSITE16.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/1k5ay1dzc/A-TEMPLATE%20WEBSITE17.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/dziegwv3s/A-TEMPLATE%20WEBSITE3.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/6o85t6qq6/A-TEMPLATE%20WEBSITE4.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/nr1nf90ff/A-TEMPLATE%20WEBSITE5.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/085g7wxpj/A-TEMPLATE%20WEBSITE6.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/nj48gt7wh/A-TEMPLATE%20WEBSITE7.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/mqop3oth4/A-TEMPLATE%20WEBSITE8.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/42to8lpmh/A-TEMPLATE%20WEBSITE9.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000420U4/ddiq96mbu/A-TEMPLATE%20WEBSITE14.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000KJsR3QAL
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1888
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000LsPqq
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850505
)
)
Cabaña #06 Upper Las Cabañas Condominium 2,400,000 USD | 40,800,000 MXN | 2,800 A/C SQ FT 3 Beds 3 Full Baths Under ContractUnder Contract
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/b3yv8xtf4/17.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/q8ddo9zap/6.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/fyxxbzn7u/10.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/ya8ggfr3c/20.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/o5sy40bha/16.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/y238uajfo/1%20copia.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/7fufoog6n/13.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/wjl29ord9/14.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/bysd3jmzm/5.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/n0r4g6xvt/4.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/l5u29ojy9/11.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/gka1iflr9/12.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/25v3ee3ep/19.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Cabaña #01 Upper
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] =>
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000KateOQAR
)
[ffd_totalarea_pb] => Array
(
[0] => 2800
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Km. 27.5 Transpeninsular Hwy.
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 3
)
[wpcf-bedrooms] => Array
(
[0] => 3
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Las Cabanas
)
[ffd_createddate] => Array
(
[0] => 2022-07-12T18:00:03.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 639
)
[ffd_description_pb] => Array
(
[0] => This second floor luxury condominium with vaulted high ceilings, sliding pocket doors, and a private corner location enjoys a breathtaking views of the mountains, ocean, golf, and the evening lights of San José del Cabo. Located next to Querencia´s Club Village, this three 3 bedroom and 3 bath villa combines luxury living with world class lifestyle
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => no
)
[wpcf-half-bathrooms] => Array
(
[0] =>
)
[ffd_lastmodifieddate] => Array
(
[0] => 2022-11-09T23:01:04.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.03189
)
[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] => 1900000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.74691
)
[ffd_community_lot_number] => Array
(
[0] => 1
)
[wpcf-lotsize] => Array
(
[0] =>
)
[wpcf-lot-size-sqm] => Array
(
[0] => 0
)
[wpcf-mls] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] => Sold
)
[wpcf-acarea] => Array
(
[0] => 2800
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] =>
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a093Z00000KateOQAR
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Sold
)
[ffd_name] => Array
(
[0] => Cabaña #01 Upper
)
[wpcf-squarefeet] => Array
(
[0] => 3673.42
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-price] => Array
(
[0] => 1900000
)
[ffd_sort_by] => Array
(
[0] => C
)
[ffd_website_status] => Array
(
[0] => Sold
)
[wpcf-keywords] => Array
(
[0] => Ocean Cabaña #01 Upper Condominium ResaleLas CabanasSold
)
[ffd_yearbuilt_pb] => Array
(
[0] => 2007
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 9502
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/cabana-01-upper/
)
[ffd_media] => Array
(
[0] => a:13:{i:0;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/b3yv8xtf4/17.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/q8ddo9zap/6.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/fyxxbzn7u/10.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/ya8ggfr3c/20.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/o5sy40bha/16.jpg";i:5;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/y238uajfo/1%20copia.jpg";i:6;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/7fufoog6n/13.jpg";i:7;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/wjl29ord9/14.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/bysd3jmzm/5.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/n0r4g6xvt/4.jpg";i:10;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/l5u29ojy9/11.jpg";i:11;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/gka1iflr9/12.jpg";i:12;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/25v3ee3ep/19.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/b3yv8xtf4/17.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000KateOQAR
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1888
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_listing_price_pesos] => Array
(
[0] =>
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850504
)
)
Cabaña #01 Upper Las Cabañas Condominium | 2,800 A/C SQ FT 3 Beds 3 Full Baths SoldSold
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/t6yuhtjod/2.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/bzlcy59nu/3.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/gvmw0c1o4/11.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/zd6tcr60z/1.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/xcez6ekhq/6.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/hsnnhwzln/10.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/lkebt309l/12.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/wzbetm8f6/4.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/hl9y8ajn6/5.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/i02sq52pe/7.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/bjlq5cp4i/8.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/1kzggsbdt/9.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Cabaña #06 Lower
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 22-415
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000JWoTmQAL
)
[ffd_totalarea_pb] => Array
(
[0] => 2800
)
[wpcf-property-features] => Array
(
[0] =>
)
[ffd_address_pb] => Array
(
[0] => Km. 27.5 Transpeninsular Hwy.
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[wpcf-bathrooms] => Array
(
[0] => 3
)
[wpcf-bedrooms] => Array
(
[0] => 3
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_actual_close_date] => Array
(
[0] =>
)
[ffd_colistingagentmlsid] => Array
(
[0] =>
)
[ffd_colistingagentname] => Array
(
[0] =>
)
[ffd_colistingofficemlsid] => Array
(
[0] =>
)
[ffd_createddate] => Array
(
[0] => 2022-01-27T16:54:48.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 808
)
[ffd_description_pb] => Array
(
[0] => This spacious ground-level mountain view cabaña not only overlooks the Las Cabañas pool and community area, but also features a private entrance, as well. Inside, the 3 bedroom residence features an airy, open floor plan and updated appliances. The exceptionally landscaped green space and expansive terrace allow for seamless indoor and outdoor living.
)
[wpcf-highlights] => Array
(
[0] =>
)
[ffd_displayaddress] => Array
(
[0] =>
)
[featured] => Array
(
[0] => no
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[ffd_lastmodifieddate] => Array
(
[0] => 2022-09-06T20:32:43.000+0000
)
[wpcf-latitude] => Array
(
[0] => 23.03163
)
[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] => 1695000
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[wpcf-longitude] => Array
(
[0] => -109.74773
)
[ffd_community_lot_number] => Array
(
[0] => 6.1
)
[wpcf-lotsize] => Array
(
[0] =>
)
[wpcf-lot-size-sqm] => Array
(
[0] => 0
)
[wpcf-mls] => Array
(
[0] => 22-415
)
[ffd_website_status_2] => Array
(
[0] => Sold
)
[wpcf-acarea] => Array
(
[0] => 2800
)
[wpcf-property-type] => Array
(
[0] => condo
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a093Z00000JWoTmQAL
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-ribbon] => Array
(
[0] => Sold
)
[ffd_name] => Array
(
[0] => Cabaña #06 Lower
)
[wpcf-squarefeet] => Array
(
[0] => 4149.25
)
[wpcf-view] => Array
(
[0] => Mountain
)
[wpcf-price] => Array
(
[0] => 1695000
)
[ffd_sort_by] => Array
(
[0] => C
)
[ffd_website_status] => Array
(
[0] => Sold
)
[wpcf-keywords] => Array
(
[0] => Mountain Cabaña #06 Lower Condominium 22-415ResaleLas CabanasSold
)
[ffd_yearbuilt_pb] => Array
(
[0] => 2007
)
[ffd_postalcode_pb] => Array
(
[0] => 234
)
[pba__WebsiteId__c] => Array
(
[0] => 9297
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/cabana-06-lower/
)
[ffd_media] => Array
(
[0] => a:12:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/t6yuhtjod/2.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/bzlcy59nu/3.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/gvmw0c1o4/11.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/zd6tcr60z/1.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/xcez6ekhq/6.jpg";i:5;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/hsnnhwzln/10.jpg";i:6;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/lkebt309l/12.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/wzbetm8f6/4.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/hl9y8ajn6/5.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/i02sq52pe/7.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/bjlq5cp4i/8.jpg";i:11;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/1kzggsbdt/9.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/t6yuhtjod/2.jpg
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000JWoTmQAL
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_edit_lock] => Array
(
[0] => 1645713776:10
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1888
)
[ffd_community] => Array
(
[0] => Las Cabanas
)
[ffd_listing_price_pesos] => Array
(
[0] =>
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850505
)
)
Cabaña #06 Lower Las Cabañas Condominium | 2,800 A/C SQ FT 3 Beds 3 Full Baths 1 Half Baths SoldSold
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/m2pypmml8/4.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/dyu4b6gvq/8.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/41b4ua83g/10.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/l68sct47c/1.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/jmijv69l5/7.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/b27wthny5/9.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/phdth3o30/5.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/u8zf3ox65/11.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/0nxtmyc8s/2.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/l9lf1h7hg/6.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/mte9p2b58/3.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Cabaña 7 Upper
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 20-3117
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000IjmPaQAJ
)
[ffd_totalarea_pb] => Array
(
[0] => 2800
)
[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] => 2020-01-02T19:59:57.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 1562
)
[ffd_description_pb] => Array
(
[0] => Querencia Cabaña 7 Upper is an elegantly furnished, three-bedroom, three-bath spacious townhome conveniently located within walking distance to the 70,000 sq. ft. sprawling Querencia Club Village. The dynamic view corridor from this spacious townhome stretches Punta Gorda, showcasing the Sparkling San Jose city lights to the canyons surrounding the Querencia community. A must-see, this unit will move quickly.
)
[ffd_lastmodifieddate] => Array
(
[0] => 2022-05-09T06:09:38.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 1150000
)
[ffd_community_lot_number] => Array
(
[0] => #07 Upper
)
[ffd_listing_agent_1] => Array
(
[0] => 005f100000I1eqJAAR
)
[ffd_listing_agent_2] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_id] => Array
(
[0] => a093Z00000IjmPaQAJ
)
[ffd_name] => Array
(
[0] => Cabaña 7 Upper
)
[ffd_website_status_2] => Array
(
[0] => Sold
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 7896
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/cabana-7-upper/
)
[ffd_media] => Array
(
[0] => a:11:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/m2pypmml8/4.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/dyu4b6gvq/8.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/41b4ua83g/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/l68sct47c/1.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/jmijv69l5/7.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/b27wthny5/9.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/phdth3o30/5.jpg";i:7;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/u8zf3ox65/11.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/0nxtmyc8s/2.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/l9lf1h7hg/6.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/mte9p2b58/3.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000421Me/m2pypmml8/4.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_sort_by] => Array
(
[0] => C
)
[ffd_website_status] => Array
(
[0] => Sold
)
[_edit_lock] => Array
(
[0] => 1635289822:5
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1888
)
[_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] => a093Z00000IjmPaQAJ
)
[wpcf-property-type] => Array
(
[0] => condo
)
[wpcf-ribbon] => Array
(
[0] => Sold
)
[wpcf-lotsize] => Array
(
[0] => 1264.69816
)
[wpcf-lot-size-sqm] => Array
(
[0] => 117.49
)
[wpcf-mls] => Array
(
[0] => 20-3117
)
[wpcf-squarefeet] => Array
(
[0] => 1264.7
)
[wpcf-acarea] => Array
(
[0] => 2800
)
[wpcf-bedrooms] => Array
(
[0] => 3
)
[wpcf-bathrooms] => Array
(
[0] => 3
)
[wpcf-latitude] => Array
(
[0] => 50.55383
)
[wpcf-longitude] => Array
(
[0] => 22.66585
)
[wpcf-agent-1] => Array
(
[0] => 005f100000I1eqJ
)
[wpcf-agent-2] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-keywords] => Array
(
[0] => Cabaña 7 Upper Condominium 20-3117ResaleLas CabanasSold
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[wpcf-price] => Array
(
[0] => 1150000
)
[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] =>
)
[wpcf-half-bathrooms] => 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] =>
)
[wpcf-view] => Array
(
[0] =>
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
[ffd_community] => Array
(
[0] => Las Cabanas
)
[ffd_listing_price_pesos] => Array
(
[0] =>
)
[_yoast_indexnow_last_ping] => Array
(
[0] => 1712850506
)
)
Cabaña 7 Upper Las Cabañas Condominium | 2,800 A/C SQ FT 3 Beds 3 Full 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