Discover Our Properties
SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt1 ON ( wp_tota44soje_posts.ID = mt1.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt2 ON ( wp_tota44soje_posts.ID = mt2.post_id ) WHERE 1=1 AND ( wp_tota44soje_postmeta.meta_key = 'wpcf-price' AND ( ( mt1.meta_key = 'wpcf-ribbon' AND mt1.meta_value IN ('Active','Under Contract','Sold') ) AND ( mt2.meta_key = 'wpcf-listing-type' AND mt2.meta_value = 'resale' ) )) AND wp_tota44soje_posts.post_type = 'properties' AND ((wp_tota44soje_posts.post_status = 'publish')) GROUP BY wp_tota44soje_posts.ID ORDER BY FIELD(mt1.meta_value, 'Active', 'Under Contract', 'Sold'), CAST(wp_tota44soje_postmeta.meta_value AS SIGNED) DESC LIMIT 0, 9
17
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/xqp4bisn4/2.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/s2rmtejnf/1.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/x1zy7grh4/3.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/ef6kojygw/DJI_0059.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/anniqqi04/_DSC6663-Edit.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/qp6joqa72/_DSC6687.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/nn9aky1i7/_DSC6695-Edit.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/jtuq6gm8l/_DSC6706-Edit.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/sownt8dd6/_DSC6713-Edit.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/9ttvt2a3u/_DSC6737.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/1wpycrvak/_DSC6742-Edit.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/xa5nwqkr2/_DSC6759-Edit.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/uxobxr2wn/_DSC6804.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/ae2shye1a/_DSC6827.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/wcf6rbysi/_DSC6842.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/r0e5v1u8k/_DSC6859.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/74zza2ffk/_DSC6867.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/p3ufmk9ie/_DSC6886.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/u8uj2glp0/_DSC6889.jpg [19] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/0n8dfoh4g/_DSC6892.jpg [20] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/p7b5wztxh/_DSC6902.jpg [21] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/jh3aipsjr/_DSC6930.jpg [22] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/gar9qsvsy/_DSC6938.jpg [23] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/ntjwz18an/_DSC6959.jpg [24] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/9cmvl7kc8/_DSC6979.jpg [25] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/pxvq594ss/_DSC7018.jpg [26] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/8kwkw2ce1/DJI_0049.jpg [27] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/5k7axt3tn/DJI_0095.jpg [28] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/suxojuf2t/DJI_0098.jpg [29] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/olb4j91w3/DJI_0103.jpg [30] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/groyuon4y/DJI_0109.jpg [31] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/w9g8dfnmx/DJI_0114.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Cañada #14
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 21-1815
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000ItERWQA3
)
[ffd_totalarea_pb] => Array
(
[0] => 3960
)
[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-05-06T18:00:21.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 188
)
[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 features thoughtful details throughout and includes a gourmet kitchen and expansive indoor and outdoor living, 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.
)
[ffd_lastmodifieddate] => Array
(
[0] => 2021-11-15T04:41:30.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 2395000
)
[ffd_community_lot_number] => Array
(
[0] => 14
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_id] => Array
(
[0] => a093Z00000ItERWQA3
)
[ffd_name] => Array
(
[0] => Cañada #14
)
[ffd_yearbuilt_pb] => Array
(
[0] => 2014
)
[ffd_postalcode_pb] => Array
(
[0] => 23401
)
[pba__WebsiteId__c] => Array
(
[0] => 7910
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/canada-14/
)
[ffd_media] => Array
(
[0] => a:32:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/xqp4bisn4/2.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/s2rmtejnf/1.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/x1zy7grh4/3.jpg";i:3;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/ef6kojygw/DJI_0059.jpg";i:4;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/anniqqi04/_DSC6663-Edit.jpg";i:5;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/qp6joqa72/_DSC6687.jpg";i:6;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/nn9aky1i7/_DSC6695-Edit.jpg";i:7;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/jtuq6gm8l/_DSC6706-Edit.jpg";i:8;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/sownt8dd6/_DSC6713-Edit.jpg";i:9;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/9ttvt2a3u/_DSC6737.jpg";i:10;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/1wpycrvak/_DSC6742-Edit.jpg";i:11;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/xa5nwqkr2/_DSC6759-Edit.jpg";i:12;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/uxobxr2wn/_DSC6804.jpg";i:13;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/ae2shye1a/_DSC6827.jpg";i:14;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/wcf6rbysi/_DSC6842.jpg";i:15;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/r0e5v1u8k/_DSC6859.jpg";i:16;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/74zza2ffk/_DSC6867.jpg";i:17;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/p3ufmk9ie/_DSC6886.jpg";i:18;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/u8uj2glp0/_DSC6889.jpg";i:19;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/0n8dfoh4g/_DSC6892.jpg";i:20;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/p7b5wztxh/_DSC6902.jpg";i:21;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/jh3aipsjr/_DSC6930.jpg";i:22;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/gar9qsvsy/_DSC6938.jpg";i:23;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/ntjwz18an/_DSC6959.jpg";i:24;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/9cmvl7kc8/_DSC6979.jpg";i:25;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/pxvq594ss/_DSC7018.jpg";i:26;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/8kwkw2ce1/DJI_0049.jpg";i:27;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/5k7axt3tn/DJI_0095.jpg";i:28;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/suxojuf2t/DJI_0098.jpg";i:29;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/olb4j91w3/DJI_0103.jpg";i:30;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/groyuon4y/DJI_0109.jpg";i:31;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/w9g8dfnmx/DJI_0114.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/xqp4bisn4/2.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_featured_listing] => Array
(
[0] => yes
)
[_edit_lock] => Array
(
[0] => 1635289671:5
)
[featured] => Array
(
[0] =>
)
[ffd_sort_by] => Array
(
[0] => A
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1892
)
[_edit_last] => Array
(
[0] => 5
)
[ffd_website_status_2] => Array
(
[0] =>
)
[_ffd_website_status_2] => Array
(
[0] => field_608827aae073c
)
[_featured] => Array
(
[0] => field_615b2b0a187e6
)
[_yoast_wpseo_primary_category] => Array
(
[0] =>
)
[wpcf-tripple-icon] => Array
(
[0] => default
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000ItERWQA3
)
[wpcf-property-type] => Array
(
[0] => home
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[wpcf-lotsize] => Array
(
[0] => 14316
)
[wpcf-lot-size-sqm] => Array
(
[0] => 1330
)
[wpcf-price] => Array
(
[0] => 2395000
)
[wpcf-mls] => Array
(
[0] => 21-1815
)
[wpcf-squarefeet] => Array
(
[0] => 5710
)
[wpcf-acarea] => Array
(
[0] => 3960
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[wpcf-latitude] => Array
(
[0] => 23.03388
)
[wpcf-longitude] => Array
(
[0] => -109.74074
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-keywords] => Array
(
[0] => Ocean Cañada #14 Single Family Home 21-1815ResaleCañadasActive
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[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_website_status] => Array
(
[0] =>
)
)
Cañada #14 Cañadas Single Family Home $2,395,000 | 3,960 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths 
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/19lxj0leh/Club%20Villa%2011%20Querencia%20107.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/wxb321s1z/Club%20Villa%20487-187.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/f3gxik8o8/Club%20Villa%2011%20Querencia%20223.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/5ekiv5zwo/Club%20Villa%2011%20Querencia%20217.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/ct991ewl6/Club%20Villa%2011%20Querencia%20116.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/k89ut4cp5/Club%20Villa%2011%20Querencia%2051.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/k18fttq1k/Club%20Villa%2011%20Querencia%2088.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/0kzhuy3z1/Club%20Villa%2011%20Querencia%20228.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/1q3hga2bf/Club%20Villa%2011%20Querencia%2032.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/noxqrvlgm/club%20villa%2011squid-78.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/jd78f091k/Club%20Villa%20185%20.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/9h68jskl1/Club%20Villa%2011%20Querencia%20100.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/r7saew8gg/Club%20Villa%20204.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/hno51rvco/Club%20Villa%2011%20Querencia%2070.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/5rhiysjbi/Club%20Villa%2011%20Querencia%2097.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/7a2yvtzu1/Club%20Villa%2011%20Querencia%20122%202.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/wtp85a5oq/Club%20Villa%2011%20Querencia%2042.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/vxzekgcii/Club%20Villa%2011%20Querencia%2016.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Club Villa #11
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 20-1182
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000IkO60QAF
)
[ffd_totalarea_pb] => Array
(
[0] => 4048
)
[ffd_address_pb] => Array
(
[0] => Villa 11 Querencia
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[ffd_city_pb] => Array
(
[0] => San Jose del Cabo
)
[ffd_createddate] => Array
(
[0] => 2020-02-20T19:14:26.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 584
)
[ffd_description_pb] => Array
(
[0] => Club Villa 11 is a private respite. Upon entering the lush and meticulously landscaped courtyard you are enveloped in relaxed opulence. Inside, the expansive living space is designed in an open concept; ideal for entertaining friends and family. The custom finishes and interior design are thoughtfully inspired to highlight the stunning view of the Sea of Cortez on display throughout the two-story home. Outside, the extensive natural stone terrace features an infinity-edge pool with jacuzzi and outdoor dining with BBQ. Just steps from the Querencia Clubhouse and Tom Fazio golf, Club Villa 11 is your entre into a community overflowing with activities, camaraderie and amenities. Welcome home.
)
[ffd_lastmodifieddate] => Array
(
[0] => 2021-11-15T04:40:40.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 2200000
)
[ffd_community_lot_number] => Array
(
[0] => 11
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_id] => Array
(
[0] => a093Z00000IkO60QAF
)
[ffd_name] => Array
(
[0] => Club Villa #11
)
[ffd_yearbuilt_pb] => Array
(
[0] => 2007
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 7895
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/club-villa-11/
)
[ffd_media] => Array
(
[0] => a:18:{i:0;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/19lxj0leh/Club%20Villa%2011%20Querencia%20107.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/wxb321s1z/Club%20Villa%20487-187.jpg";i:2;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/f3gxik8o8/Club%20Villa%2011%20Querencia%20223.jpg";i:3;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/5ekiv5zwo/Club%20Villa%2011%20Querencia%20217.jpg";i:4;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/ct991ewl6/Club%20Villa%2011%20Querencia%20116.jpg";i:5;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/k89ut4cp5/Club%20Villa%2011%20Querencia%2051.jpg";i:6;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/k18fttq1k/Club%20Villa%2011%20Querencia%2088.jpg";i:7;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/0kzhuy3z1/Club%20Villa%2011%20Querencia%20228.jpg";i:8;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/1q3hga2bf/Club%20Villa%2011%20Querencia%2032.jpg";i:9;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/noxqrvlgm/club%20villa%2011squid-78.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/jd78f091k/Club%20Villa%20185%20.jpg";i:11;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/9h68jskl1/Club%20Villa%2011%20Querencia%20100.jpg";i:12;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/r7saew8gg/Club%20Villa%20204.jpg";i:13;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/hno51rvco/Club%20Villa%2011%20Querencia%2070.jpg";i:14;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/5rhiysjbi/Club%20Villa%2011%20Querencia%2097.jpg";i:15;s:134:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/7a2yvtzu1/Club%20Villa%2011%20Querencia%20122%202.jpg";i:16;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/wtp85a5oq/Club%20Villa%2011%20Querencia%2042.jpg";i:17;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/vxzekgcii/Club%20Villa%2011%20Querencia%2016.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/19lxj0leh/Club%20Villa%2011%20Querencia%20107.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_sort_by] => Array
(
[0] => A
)
[_edit_lock] => Array
(
[0] => 1635289820:5
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1901
)
[_edit_last] => Array
(
[0] => 5
)
[ffd_website_status_2] => Array
(
[0] =>
)
[_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] => a093Z00000IkO60QAF
)
[wpcf-property-type] => Array
(
[0] => home
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[wpcf-lotsize] => Array
(
[0] => 8230.41
)
[wpcf-lot-size-sqm] => Array
(
[0] => 764.63
)
[wpcf-price] => Array
(
[0] => 2200000
)
[wpcf-mls] => Array
(
[0] => 20-1182
)
[wpcf-squarefeet] => Array
(
[0] => 6209.59
)
[wpcf-acarea] => Array
(
[0] => 4048
)
[wpcf-bedrooms] => Array
(
[0] => 4
)
[wpcf-bathrooms] => Array
(
[0] => 4
)
[wpcf-half-bathrooms] => Array
(
[0] => 1
)
[wpcf-latitude] => Array
(
[0] => 23.02788
)
[wpcf-longitude] => Array
(
[0] => -109.74612
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-keywords] => Array
(
[0] => Ocean Club Villa #11 Single Family Home 20-1182ResaleClub VillasActive
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[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_website_status] => Array
(
[0] =>
)
)
Club Villa #11 Club Villas Single Family Home $2,200,000 | 4,048 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths 
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/2ce1i58w0/Cerrito%208%20hero%20photo.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/vay3wy4pg/thumbnail_Cerritos8.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/p5jn3phfa/Cerrito%208%20p2.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/70ixedrfo/Cerrito%208%20p4.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/vrcyqlu86/El%20Cerrito%20%2308%20p1.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/7dtber1zm/Cerrito%208%20p5.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/m3aesmkt3/Cerrito%208%20p6.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/w2yfnfsku/Cerrito%208%20p7.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/rpqkh3m3q/Cerrito%208%20p8.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/idbfn1t02/Cerrito%208%20p9.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/14kmyxarw/Cerrito%208%20pic3.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => El Cerrito #08
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 20-822
)
[ffd_salesforce_id] => Array
(
[0] => a09f100000I6TCDAA3
)
[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] => 2018-11-01T20:51:59.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 628
)
[ffd_description_pb] => Array
(
[0] => This incredible home site offers some of the most expansive views in Querencia, spanning from the Sea of Cortez to the spectacular Fazio Golf Course and Sierra Laguna Mountains; capturing 270 degrees of Baja's beauty! Nestled in an intimate street that comprises only eight home sites, this idyllic location offers the perfect balance between the Q Beach Club and Q Club Village.
)
[ffd_lastmodifieddate] => Array
(
[0] => 2021-11-15T04:41:22.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 1200000
)
[ffd_community_lot_number] => Array
(
[0] => 8
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_listing_agent_2] => Array
(
[0] =>
)
[ffd_id] => Array
(
[0] => a09f100000I6TCDAA3
)
[ffd_name] => Array
(
[0] => El Cerrito #08
)
[wpcf-squarefeet] => Array
(
[0] => 34441.68
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 7892
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/el-cerrito-08/
)
[ffd_media] => Array
(
[0] => a:11:{i:0;s:121:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/2ce1i58w0/Cerrito%208%20hero%20photo.jpg";i:1;s:114:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/vay3wy4pg/thumbnail_Cerritos8.jpg";i:2;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/p5jn3phfa/Cerrito%208%20p2.jpg";i:3;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/70ixedrfo/Cerrito%208%20p4.jpg";i:4;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/vrcyqlu86/El%20Cerrito%20%2308%20p1.jpg";i:5;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/7dtber1zm/Cerrito%208%20p5.jpg";i:6;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/m3aesmkt3/Cerrito%208%20p6.jpg";i:7;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/w2yfnfsku/Cerrito%208%20p7.jpg";i:8;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/rpqkh3m3q/Cerrito%208%20p8.jpg";i:9;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/idbfn1t02/Cerrito%208%20p9.jpg";i:10;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/14kmyxarw/Cerrito%208%20pic3.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004EVJG/2ce1i58w0/Cerrito%208%20hero%20photo.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[_edit_lock] => Array
(
[0] => 1635289824:5
)
[_edit_last] => Array
(
[0] => 5
)
[ffd_website_status_2] => Array
(
[0] =>
)
[_ffd_website_status_2] => Array
(
[0] => field_608827aae073c
)
[featured] => Array
(
[0] =>
)
[_featured] => Array
(
[0] => field_615b2b0a187e6
)
[_yoast_wpseo_primary_category] => Array
(
[0] =>
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[ffd_sort_by] => Array
(
[0] => A
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 3961
)
[wpcf-tripple-icon] => Array
(
[0] => default
)
[wpcf-propertybase-id] => Array
(
[0] => a09f100000I6TCDAA3
)
[wpcf-property-type] => Array
(
[0] => lot
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[wpcf-lotsize] => Array
(
[0] => 34441.68
)
[wpcf-lot-size-sqm] => Array
(
[0] => 3199.74
)
[wpcf-price] => Array
(
[0] => 1200000
)
[wpcf-mls] => Array
(
[0] => 20-822
)
[wpcf-latitude] => Array
(
[0] => 23.0636
)
[wpcf-longitude] => Array
(
[0] => -109.70242
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-agent-2] => Array
(
[0] => 005j0000000V0it
)
[wpcf-keywords] => Array
(
[0] => El Cerrito #08 Homesite 20-822ResaleEl CerritoActive
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[ffd_totalarea_pb] => Array
(
[0] =>
)
[wpcf-property-features] => Array
(
[0] =>
)
[wpcf-bathrooms] => Array
(
[0] =>
)
[wpcf-bedrooms] => 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-acarea] => Array
(
[0] =>
)
[wpcf-resale] => Array
(
[0] =>
)
[ffd_solddate] => Array
(
[0] =>
)
[ffd_soldprice] => Array
(
[0] =>
)
[ffd_state_pb] => Array
(
[0] =>
)
[wpcf-view] => Array
(
[0] =>
)
[ffd_website_status] => Array
(
[0] =>
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
)
El Cerrito #08 El Cerrito Homesite $1,200,000 Lot Size 34441.68 sq ft 3199.74 sq m 
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/4hdph80sf/4.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/okn41y1s9/3.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/cw2a9tc52/2.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/a4zd3t54q/1%20copia%202.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/zbbgkvv3k/5.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/ygy6cexaf/6.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/xcnx80ska/7.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/gysbvoo7g/8.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/b5ydiprv5/9.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Las Colinas #14
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 21-3338
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000JWIFEQA5
)
[ffd_address_pb] => Array
(
[0] => Km. 27.5 Transpeninsular Hwy.
)
[ffd_mgmt_approved_for_website_publishing] => Array
(
[0] => 1
)
[ffd_city_pb] => Array
(
[0] => S
)
[ffd_createddate] => Array
(
[0] => 2021-10-04T19:04:57.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 47
)
[ffd_description_pb] => Array
(
[0] => Las Colinas #14 is located within minutes of the main gated entrance of the private community of Querencia. The expansive lot is ready to build. Completely padded with blue water views of the Sea of Cortez from the lights of San Jose del Cabo to Palmilla. The homesite is within walking distance to the oceanfront Beach Club set to open first quarter of 2023 and is just a quick drive or golf cart ride to the Querencia Club village complete with restaurants, Spas, pool, Fitness and Wellness center and more.
)
[featured] => Array
(
[0] => no
)
[ffd_lastmodifieddate] => Array
(
[0] => 2021-11-15T04:41:16.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 950000
)
[ffd_community_lot_number] => Array
(
[0] => 14
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_id] => Array
(
[0] => a093Z00000JWIFEQA5
)
[ffd_name] => Array
(
[0] => Las Colinas #14
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[ffd_media] => Array
(
[0] => a:9:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/4hdph80sf/4.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/okn41y1s9/3.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/cw2a9tc52/2.jpg";i:3;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/a4zd3t54q/1%20copia%202.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/zbbgkvv3k/5.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/ygy6cexaf/6.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/xcnx80ska/7.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/gysbvoo7g/8.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/b5ydiprv5/9.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Crnf/4hdph80sf/4.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[pba__WebsiteId__c] => Array
(
[0] => 8666
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/las-colinas-14/
)
[_edit_lock] => Array
(
[0] => 1635288881:5
)
[ffd_sort_by] => Array
(
[0] => A
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1896
)
[_edit_last] => Array
(
[0] => 5
)
[ffd_website_status_2] => Array
(
[0] =>
)
[_ffd_website_status_2] => Array
(
[0] => field_608827aae073c
)
[_featured] => Array
(
[0] => field_615b2b0a187e6
)
[_yoast_wpseo_primary_category] => Array
(
[0] =>
)
[wpcf-tripple-icon] => Array
(
[0] => default
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000JWIFEQA5
)
[wpcf-property-type] => Array
(
[0] => lot
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Active
)
[wpcf-lotsize] => Array
(
[0] => 25373.95
)
[wpcf-lot-size-sqm] => Array
(
[0] => 2357.32
)
[wpcf-price] => Array
(
[0] => 950000
)
[wpcf-mls] => Array
(
[0] => 21-3338
)
[wpcf-latitude] => Array
(
[0] => 23.02454
)
[wpcf-longitude] => Array
(
[0] => -109.72231
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-keywords] => Array
(
[0] => Ocean Las Colinas #14 Homesite 21-3338ResaleLas ColinasActive
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[ffd_totalarea_pb] => Array
(
[0] =>
)
[wpcf-property-features] => Array
(
[0] =>
)
[wpcf-bathrooms] => Array
(
[0] =>
)
[wpcf-bedrooms] => 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-acarea] => 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] =>
)
[wpcf-squarefeet] => Array
(
[0] =>
)
[ffd_website_status] => Array
(
[0] =>
)
[ffd_yearbuilt_pb] => Array
(
[0] =>
)
)
Las Colinas #14 Las Colinas Homesite $950,000 Lot Size 25373.95 sq ft 2357.32 sq m 
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/bpb35glhm/8.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/7zbgmqb72/1%20copia.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/ehohhluss/10.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/pmcuaii2b/11.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/px2u3yn6w/2.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/kg224o3hm/3.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/s9s9i0my0/4.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/rpwvln46h/5.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/kv08oq3tg/6.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/c7o6ab1ia/7.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/lektp6vdw/9.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/rryywhytr/Clubhouse-3.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/pk6blo114/Clubhouse-4.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/ptywbh9hj/golf-2.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/o9ifknxhs/Golf-5.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/mhb8aqbqe/Mountain%20Bike.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/jva33dmsg/Pickleball.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/63putagr0/Querencia%20Beach%20Club.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/4ld8mlphc/slide.jpg [19] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/qftgudknt/surf-2.jpg [20] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/p8m5ziv4w/surf-3.jpg [21] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/4o7pbht2h/trails-2.jpg [22] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/ljx1l8et3/trampoline.jpg [23] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/n7eiyf2ea/Yoga%20Querencia.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Las Colinas #82
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 21-3375
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000ItIAsQAN
)
[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-05-17T20:02:39.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 181
)
[ffd_description_pb] => Array
(
[0] => This collection of homesites within the award-winning Querencia community are situated on hilltops overlooking the Sea of Cortez with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. Located just beyond the gated entrance of the private, masterplanned community, the homesites at Las Colinas provide the ideal canvas for your truly custom home.
Querencia is a private golf and beach resort community home to the award-winning Tom Fazio-designed 18-hole golf course that has been named the best golf course in Mexico by Golfweek magazine and is consistently ranked in the top 100 worldwide by Golf Digest.
Beyond golf, there is so much to enjoy at our #1 rated private community in Cabo. Explore our 1,800 acres of coastline, cliffside and desert to enjoy thoughtfully curated amenities both on land and at sea -- from more than 10 miles of hiking and biking trails, fitness and wellness classes, to stand up paddling and kayaking. Querencia is also home to multiple dining options, a world-class Spa and so much more.
Golf and Social Members are available.
)
[featured] => Array
(
[0] => no
)
[ffd_lastmodifieddate] => Array
(
[0] => 2021-11-15T04:41:20.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 3000000
)
[ffd_community_lot_number] => Array
(
[0] => 82
)
[ffd_website_status_2] => Array
(
[0] => Under Contract
)
[ffd_listing_agent_1] => Array
(
[0] => 005j000000AuC6YAAV
)
[ffd_id] => Array
(
[0] => a093Z00000ItIAsQAN
)
[ffd_name] => Array
(
[0] => Las Colinas #82
)
[wpcf-squarefeet] => Array
(
[0] => 37797
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[ffd_media] => Array
(
[0] => a:24:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/bpb35glhm/8.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/7zbgmqb72/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/ehohhluss/10.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/pmcuaii2b/11.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/px2u3yn6w/2.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/kg224o3hm/3.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/s9s9i0my0/4.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/rpwvln46h/5.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/kv08oq3tg/6.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/c7o6ab1ia/7.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/lektp6vdw/9.jpg";i:11;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/rryywhytr/Clubhouse-3.jpg";i:12;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/pk6blo114/Clubhouse-4.jpg";i:13;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/ptywbh9hj/golf-2.jpg";i:14;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/o9ifknxhs/Golf-5.jpg";i:15;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/mhb8aqbqe/Mountain%20Bike.jpg";i:16;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/jva33dmsg/Pickleball.jpg";i:17;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/63putagr0/Querencia%20Beach%20Club.jpg";i:18;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/4ld8mlphc/slide.jpg";i:19;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/qftgudknt/surf-2.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/p8m5ziv4w/surf-3.jpg";i:21;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/4o7pbht2h/trails-2.jpg";i:22;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/ljx1l8et3/trampoline.jpg";i:23;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/n7eiyf2ea/Yoga%20Querencia.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004Pvd1/bpb35glhm/8.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[pba__WebsiteId__c] => Array
(
[0] => 8796
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/las-colinas-82/
)
[ffd_sort_by] => Array
(
[0] => B
)
[ffd_website_status] => Array
(
[0] => Under Contract
)
[_edit_lock] => Array
(
[0] => 1635288843:5
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1896
)
[_edit_last] => Array
(
[0] => 5
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[_ffd_website_status_2] => Array
(
[0] => field_608827aae073c
)
[_featured] => Array
(
[0] => field_615b2b0a187e6
)
[_yoast_wpseo_primary_category] => Array
(
[0] =>
)
[wpcf-tripple-icon] => Array
(
[0] => default
)
[wpcf-propertybase-id] => Array
(
[0] => a093Z00000ItIAsQAN
)
[wpcf-property-type] => Array
(
[0] => lot
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Under Contract
)
[wpcf-lotsize] => Array
(
[0] => 37797
)
[wpcf-lot-size-sqm] => Array
(
[0] => 3511.46
)
[wpcf-price] => Array
(
[0] => 3000000
)
[wpcf-mls] => Array
(
[0] => 21-3375
)
[wpcf-latitude] => Array
(
[0] => 23.02823
)
[wpcf-longitude] => Array
(
[0] => -109.72755
)
[wpcf-agent-1] => Array
(
[0] => 005j000000AuC6Y
)
[wpcf-keywords] => Array
(
[0] => Ocean Las Colinas #82 Homesite 21-3375ResaleLas ColinasUnder Contract
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[ffd_totalarea_pb] => Array
(
[0] =>
)
[wpcf-property-features] => Array
(
[0] =>
)
[wpcf-bathrooms] => Array
(
[0] =>
)
[wpcf-bedrooms] => 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-acarea] => 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] =>
)
)
Las Colinas #82 Las Colinas Homesite $3,000,000 Lot Size 37797 sq ft 3511.46 sq m Under ContractUnder Contract
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/popeusa53/DJI_0036.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/uu1pbgdwy/DJI_0318.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/5jinhs2po/_DSC8049.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/sjn5nbl2d/DJI_0056.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/4nja12sy9/_DSC9002.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/14kygbdle/_DSC9053.jpg [6] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/6odiy8q0z/_DSC8307.jpg [7] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/q8waudq3r/_DSC8274.jpg [8] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/ih4yeeagd/_DSC8945-Edit.jpg [9] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/pe8juiz5v/_DSC9505.jpg [10] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/0fncb18qz/_DSC9103.jpg [11] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/t9yudw8zz/_DSC9228.jpg [12] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/juxru70g7/_DSC8166.jpg [13] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/x8cs948pq/_DSC9686.jpg [14] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/h7ctajb3w/_DSC8207.jpg [15] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/e1r8d8ttn/DJI_0369.jpg [16] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/2pb5qv14l/_DSC8432.jpg [17] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/i30jdx4et/Laderas_1.mp4.00_00_40_02.Still004.jpg [18] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/g48hjynb2/DJI_0363.JPG [19] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/p1agthmd6cdjci1q10n3141a14912/VILLA%2024.pdf)Array
(
[ffd_listing_title] => Array
(
[0] => Club Villa #24
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 20-578
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000IkCqOQAV
)
[ffd_totalarea_pb] => Array
(
[0] => 7140.98
)
[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] => 2020-02-07T17:41:35.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 230
)
[ffd_description_pb] => Array
(
[0] => Understated opulence abounds upon arrival within the traditional Mexican hacienda-style courtyard, complete with firepit, at Club Villa 24. This impeccable, three-story custom residence is situated on Hole 16 on the private, award-winning Tom Fazio course. Unlike any other villa within Querencia, the residence features a collection of six bedrooms, 4 full and two half baths, along with a finished basement that includes a family room, library, media room, bar and wine cellar. Inside, the expansive gourmet kitchen and pristine formal dining and living rooms open seamlessly to the terrace, fusing the outdoor and indoor living spaces. Enjoy ample alfresco entertaining space that includes an outdoor kitchen, dining area and firepit.
)
[ffd_lastmodifieddate] => Array
(
[0] => 2021-11-15T04:41:33.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 2950000
)
[ffd_community_lot_number] => Array
(
[0] => 24
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_id] => Array
(
[0] => a093Z00000IkCqOQAV
)
[ffd_name] => Array
(
[0] => Club Villa #24
)
[ffd_yearbuilt_pb] => Array
(
[0] => 2010
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 7901
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/club-villa-24/
)
[ffd_media] => Array
(
[0] => a:20:{i:0;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/popeusa53/DJI_0036.jpg";i:1;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/uu1pbgdwy/DJI_0318.jpg";i:2;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/5jinhs2po/_DSC8049.jpg";i:3;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/sjn5nbl2d/DJI_0056.jpg";i:4;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/4nja12sy9/_DSC9002.jpg";i:5;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/14kygbdle/_DSC9053.jpg";i:6;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/6odiy8q0z/_DSC8307.jpg";i:7;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/q8waudq3r/_DSC8274.jpg";i:8;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/ih4yeeagd/_DSC8945-Edit.jpg";i:9;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/pe8juiz5v/_DSC9505.jpg";i:10;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/0fncb18qz/_DSC9103.jpg";i:11;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/t9yudw8zz/_DSC9228.jpg";i:12;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/juxru70g7/_DSC8166.jpg";i:13;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/x8cs948pq/_DSC9686.jpg";i:14;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/h7ctajb3w/_DSC8207.jpg";i:15;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/e1r8d8ttn/DJI_0369.jpg";i:16;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/2pb5qv14l/_DSC8432.jpg";i:17;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/i30jdx4et/Laderas_1.mp4.00_00_40_02.Still004.jpg";i:18;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/g48hjynb2/DJI_0363.JPG";i:19;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/p1agthmd6cdjci1q10n3141a14912/VILLA%2024.pdf";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/popeusa53/DJI_0036.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_website_status_2] => Array
(
[0] => Under Contract
)
[ffd_sort_by] => Array
(
[0] => B
)
[_edit_lock] => Array
(
[0] => 1635289534:5
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1901
)
[_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] => a093Z00000IkCqOQAV
)
[wpcf-property-type] => Array
(
[0] => home
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Under Contract
)
[wpcf-lotsize] => Array
(
[0] => 11077.68
)
[wpcf-lot-size-sqm] => Array
(
[0] => 1029.15
)
[wpcf-price] => Array
(
[0] => 2950000
)
[wpcf-mls] => Array
(
[0] => 20-578
)
[wpcf-squarefeet] => Array
(
[0] => 8831.9
)
[wpcf-acarea] => Array
(
[0] => 7141
)
[wpcf-bedrooms] => Array
(
[0] => 6
)
[wpcf-bathrooms] => Array
(
[0] => 6
)
[wpcf-half-bathrooms] => Array
(
[0] => 2
)
[wpcf-latitude] => Array
(
[0] => 23.02599
)
[wpcf-longitude] => Array
(
[0] => -109.74673
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-keywords] => Array
(
[0] => Ocean Club Villa #24 Single Family Home 20-578ResaleClub VillasUnder Contract
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[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_website_status] => Array
(
[0] => Under Contract
)
)
Club Villa #24 Club Villas Single Family Home $2,950,000 | 7,141 A/C SQFT 6 Beds 6 Full Baths 2 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] => 208
)
[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] => 2021-11-15T04:40:49.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] => Under Contract
)
[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] => B
)
[ffd_website_status] => Array
(
[0] => Under Contract
)
[_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] => Under Contract
)
[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ñadasUnder Contract
)
[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] =>
)
)
Cañada #09 Cañadas Single Family Home $2,525,000 | 4,260 A/C SQFT 5 Beds 5 Full Baths 1 Half Baths Under ContractUnder Contract
Array( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/oec7ellb5/Colinas%2036%20web%201.jpg [1] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/bu3q1bjpf/Colinas%2036%20web%202.jpg [2] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/cfhc2yzaz/Colinas%2036%20web3.jpg [3] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/1hfy2u906/Beach%20Club%20-web%20photo.jpg [4] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/g5wko6j41/Clubhouse%20-web%20photo.jpg [5] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/689vokudn/Golf%20-web%20photo.jpg)Array
(
[ffd_listing_title] => Array
(
[0] => Las Colinas #36
)
[ffd_unique_id] => Array
(
[0] =>
)
[ffd_mls_id] => Array
(
[0] => 20-861
)
[ffd_salesforce_id] => Array
(
[0] => a093Z00000IkO4VQAV
)
[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] => 2020-02-20T18:59:17.000+0000
)
[ffd_days_on_market] => Array
(
[0] => 635
)
[ffd_description_pb] => Array
(
[0] => This homesite offers great access to Querencia Blvd, Q Beach Club and Main entrance. It is nestled in a private cul-de-sac with panoramic views to the Sea of Cortez and the San Jose del Cabo city lights at night. Build your dream home on this lot and belong to one of Cabo's most elite and private communities, Querencia. Home to the award-winning private Tom Fazio Golf Course, Beach Club enclaved in a semi-private swimmable cove, and Q Club Village. Three signature restaurants, kids club, tennis and raquet courts, state-of-the-art fitness and wellness center, 16 miles of hiking and biking trails, as well as programing in place to keep the younger members entertained and the older members relaxed.
)
[ffd_lastmodifieddate] => Array
(
[0] => 2021-11-15T04:40:52.000+0000
)
[ffd_listingprice_pb] => Array
(
[0] => 650000
)
[ffd_community_lot_number] => Array
(
[0] => 36
)
[ffd_listing_agent_1] => Array
(
[0] => 0053Z00000KX9ZYQA1
)
[ffd_id] => Array
(
[0] => a093Z00000IkO4VQAV
)
[ffd_name] => Array
(
[0] => Las Colinas #36
)
[wpcf-squarefeet] => Array
(
[0] => 20831.91
)
[ffd_website_status_2] => Array
(
[0] => Under Contract
)
[ffd_postalcode_pb] => Array
(
[0] => 23400
)
[pba__WebsiteId__c] => Array
(
[0] => 7908
)
[pba__Listing_Website__c] => Array
(
[0] => https://qcabo.com/properties/las-colinas-36/
)
[ffd_media] => Array
(
[0] => a:6:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/oec7ellb5/Colinas%2036%20web%201.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/bu3q1bjpf/Colinas%2036%20web%202.jpg";i:2;s:114:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/cfhc2yzaz/Colinas%2036%20web3.jpg";i:3;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/1hfy2u906/Beach%20Club%20-web%20photo.jpg";i:4;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/g5wko6j41/Clubhouse%20-web%20photo.jpg";i:5;s:114:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/689vokudn/Golf%20-web%20photo.jpg";}
)
[ffd_featured_image] => Array
(
[0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004CznB/oec7ellb5/Colinas%2036%20web%201.jpg
)
[ffd_record_is_deleted] => Array
(
[0] =>
)
[ffd_sort_by] => Array
(
[0] => B
)
[ffd_website_status] => Array
(
[0] => Under Contract
)
[_edit_lock] => Array
(
[0] => 1635289685:5
)
[_wpcf_belongs_neighborhoods_id] => Array
(
[0] => 1896
)
[_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] => a093Z00000IkO4VQAV
)
[wpcf-property-type] => Array
(
[0] => lot
)
[wpcf-view] => Array
(
[0] => Ocean
)
[wpcf-ribbon] => Array
(
[0] => Under Contract
)
[wpcf-lotsize] => Array
(
[0] => 20831.91
)
[wpcf-lot-size-sqm] => Array
(
[0] => 1935.35
)
[wpcf-price] => Array
(
[0] => 650000
)
[wpcf-mls] => Array
(
[0] => 20-861
)
[wpcf-latitude] => Array
(
[0] => 23.02823
)
[wpcf-longitude] => Array
(
[0] => -109.72233
)
[wpcf-agent-1] => Array
(
[0] => 0053Z00000KX9ZY
)
[wpcf-keywords] => Array
(
[0] => Ocean Las Colinas #36 Homesite 20-861ResaleLas ColinasUnder Contract
)
[wpcf-listing-type] => Array
(
[0] => Resale
)
[_yoast_wpseo_content_score] => Array
(
[0] => 30
)
[ffd_totalarea_pb] => Array
(
[0] =>
)
[wpcf-property-features] => Array
(
[0] =>
)
[wpcf-bathrooms] => Array
(
[0] =>
)
[wpcf-bedrooms] => 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-acarea] => 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] =>
)
)
Las Colinas #36 Las Colinas Homesite $650,000 Lot Size 20831.91 sq ft 1935.35 sq m Under ContractUnder Contract
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] => 243
)
[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] => 2021-11-15T04:41:05.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] =>
)
)
Cañada #08 Cañadas Single Family Home | 4,006 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths SoldSold
Click to Load More
Loading More Properties...