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
48
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1712850484 ) [ffd_listing_title] => Array ( [0] => El Parque #8 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000000TDebIAG ) [ffd_totalarea_pb] => Array ( [0] => 4305.6 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Parque 8 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => El Parque ) [ffd_createddate] => Array ( [0] => 2023-12-28T20:37:23.000+0000 ) [ffd_days_on_market] => Array ( [0] => 105 ) [ffd_description_pb] => Array ( [0] => El Parque 8 represents a truly exceptional real estate opportunity situated in the enclave of El Parque. This modern 4-bedroom, 5-bathroom home offers an oversized lot with a private cul-de-sac and convenient guest parking. Designed for seamless indoor-outdoor living, El Parque 8 provides breathtaking views of both sunrises and sunsets. The open living spaces promote cross ventilation, ensuring a refreshing ambiance throughout the year. Notably, hidden hurricane shutters safeguard the main living areas and covered terraces during inclement weather, while a generator system ensures emergency power supply.El Parque #8 El Parque Single Family Home 5,600,000 USD | 95,200,000 MXN 4 Beds 4 Full Baths 1 Half Baths
Each bedroom offers remarkable views, private terraces and luxurious ensuite bathrooms. The two primary bedrooms feature outdoor showers, enhancing the spa-like experience. The property includes a two-car garage leading to a spacious laundry and pantry room with a workstation and wine cellar. This area transitions into the main kitchen which is connected to the expansive great room and BBQ terrace. Adjacent to the terrace is a raised organic garden, perfect for cultivating fresh produce.
The pool terrace provides an uninterrupted view of the ocean and mountains, creating a relaxing backdrop. Enjoy the saltwater pool, spa, and sauna while soaking in the tranquility and beauty of the home. With a preapproved plan and the potential for a guest house, El Parque 8 offers a unique opportunity for customization and versatility.
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2024-02-27T19:29:09.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.06125 ) [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] => 5600000 ) [ffd_listing_price_pesos] => Array ( [0] => 95200000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.69693 ) [ffd_community_lot_number] => Array ( [0] => 8 ) [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] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000000TDebIAG ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => El Parque #8 ) [wpcf-squarefeet] => Array ( [0] => 6518.78 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 5600000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => El Parque #8 Single Family Home ResaleEl ParqueActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 10108 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-parque-8/ ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000000TDebIAG ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8746 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000Kt8H2 ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_media] => Array ( [0] => a:16:{i:0;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/05fvkpv8s/a-template%20website2%202.JPG";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/p4tlo5an9/a-template%20website13.JPG";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/hjfnugt1f/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/5ea1wt29d/A-TEMPLATE%20MLS-2.jpg";i:4;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/8gmx9ia0f/a-template%20website5%202.JPG";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/jnbg4xpu6/A-TEMPLATE%20WEBSITE1.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/u6xxqz8vd/a-template%20website7.JPG";i:7;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/f4ylnfx4a/a-template%20website6%202.JPG";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/qlvczybra/a-template%20website12.JPG";i:9;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/lx2oe97cs/a-template%20website4%202.JPG";i:10;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/dx3t2m9hr/a-template%20website3%202.JPG";i:11;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/1i8nkhbg6/a-template%20website%202.JPG";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/0qu18swnh/a-template%20website9.JPG";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/pvzst5kjf/a-template%20website8.JPG";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/ym9dr2zef/a-template%20website11.JPG";i:15;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/v1g9w01dw/a-template%20website10.JPG";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000tyycQ/05fvkpv8s/a-template%20website2%202.JPG ) )
Array ( [ffd_listing_title] => Array ( [0] => Laderas #04 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-3742 ) [ffd_salesforce_id] => Array ( [0] => a09Pk0000007tPZIAY ) [ffd_totalarea_pb] => Array ( [0] => 5468 ) [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] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Laderas ) [ffd_createddate] => Array ( [0] => 2023-10-02T22:30:11.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => Laderas 4 is a single-level family home centrally located midway from the Clubhouse and the Beach Club in the Laderas enclave within Querencia. This modern residence offers four bedrooms, four full baths and one-half bath amidst an open floorplan that flows seamlessly. One of the bedrooms has been converted into a separate “Casita", complete with a private entrance from the main house, a full kitchen, living room and carport. This residence also includes a fully-equipped gym and a study. Experience custom carpentry throughout, along with expansive storage space in each of the bedrooms. Outside, enjoy a generous terrace with pool, jacuzzi, pavilion, fire pit and outdoor bath.Laderas #04 Laderas Single Family Home 5,400,000 USD | 99,069,800 MXN | 3,817 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Laderas 4 is within walking distance to Querencia's more than 12 miles of hiking and biking trails, including the Querencia suspension bridge. Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.)
) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2024-03-02T19:23:06.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.02597 ) [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] => 5400000 ) [ffd_listing_price_pesos] => Array ( [0] => 99069800 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.73061 ) [ffd_community_lot_number] => Array ( [0] => 4 ) [wpcf-lotsize] => Array ( [0] => 16953.16 ) [wpcf-lot-size-sqm] => Array ( [0] => 1575 ) [wpcf-mls] => Array ( [0] => 23-3742 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3817 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk0000007tPZIAY ) [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] => Laderas #04 ) [wpcf-squarefeet] => Array ( [0] => 6676 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 5400000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Laderas #04 Single Family Home 23-3742ResaleLaderasActive ) [ffd_yearbuilt_pb] => Array ( [0] => 2016 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9785 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/laderas-04/ ) [ffd_media] => Array ( [0] => a:11:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/4nk3wng1k/A-TEMPLATE%20WEBSITE6.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/n0xbmj3z0/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/1bie5wuqs/A-TEMPLATE%20WEBSITE7.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/r3pzx9dx9/A-TEMPLATE%20WEBSITE2.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/ceh05ziqm/A-TEMPLATE%20WEBSITE11.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/bwprlmu4l/A-TEMPLATE%20WEBSITE.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/ulnds8fj8/A-TEMPLATE%20WEBSITE3.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/4ovpzr1r3/A-TEMPLATE%20WEBSITE4.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/2hvprhopw/A-TEMPLATE%20WEBSITE5.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/fzo0ipoko/A-TEMPLATE%20WEBSITE8.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/b39eg4d9z/A-TEMPLATE%20WEBSITE9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004B7Mw/4nk3wng1k/A-TEMPLATE%20WEBSITE6.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk0000007tPZIAY ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 5338 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1702408704:21 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850506 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1713892182 ) [ffd_listing_title] => Array ( [0] => Las Colinas 54 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000001fec1IAA ) [ffd_totalarea_pb] => Array ( [0] => 4787.44 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Colinas 14, Querencia, San Jose del Cabo, Baja California Sur, Mexico ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 6 ) [wpcf-bedrooms] => Array ( [0] => 6 ) [ffd_city_pb] => Array ( [0] => ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Colinas ) [ffd_createddate] => Array ( [0] => 2024-03-13T17:26:05.000+0000 ) [ffd_days_on_market] => Array ( [0] => 41 ) [ffd_description_pb] => Array ( [0] => Casa Brisa de Cabo, a private Villa which sits ideally nestled within a private canyon perched high above the Sea of Cortez through almost an acre of land in the gated community of Querencia. A haven inspired by the blue-water views from both master bedrooms, the great room and the main terrace. This 6 bedroom, 5.5 bath home stretches to nearly 4,800 A/C sq. ft. of living space. Outside, the entertaining space is made complete with a palapa covered outdoor dining room, infinity pool and intimate courtyard with fireplace. Nestled in Querencia's most picturesque section - Las Colinas, this coastal gem merges traditional design with the tranquility of the surroundings.Las Colinas 54 Las Colinas Single Family Home 4,950,000 USD | 82,493,978 MXN 6 Beds 6 Full Baths 1 Half Baths
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] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2024-04-23T16:57:34.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.07348 ) [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] => 4950000 ) [ffd_listing_price_pesos] => Array ( [0] => 82493977.5 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.71476 ) [ffd_community_lot_number] => Array ( [0] => 54 ) [wpcf-lotsize] => Array ( [0] => 34552.44 ) [wpcf-lot-size-sqm] => Array ( [0] => 3210.03 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a09Pk000001fec1IAA ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Las Colinas 54 ) [wpcf-squarefeet] => Array ( [0] => 8026.96 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 4950000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Las Colinas 54 Single Family Home ResaleLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => ) [pba__WebsiteId__c] => Array ( [0] => 10326 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-54/ ) [ffd_media] => Array ( [0] => a:13:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/bxjnsadz0/A-TEMPLATE%20WEBSITE11.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/appzpg0jd/A-TEMPLATE%20WEBSITE12.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/kbi81x7lo/A-TEMPLATE%20WEBSITE13.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/lqci1oxjq/A-TEMPLATE%20WEBSITE10.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/ckirj5umz/A-TEMPLATE%20WEBSITE2.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/kvswqpyik/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/2koql03sf/A-TEMPLATE%20WEBSITE8.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/q3v19z7fs/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/axdnt5ek3/A-TEMPLATE%20WEBSITE.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/datt9uvvt/A-TEMPLATE%20WEBSITE3.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/p8o1cwgdm/A-TEMPLATE%20WEBSITE4.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/4cqb0kcme/A-TEMPLATE%20WEBSITE6.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/s5570z3ul/A-TEMPLATE%20WEBSITE7.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QvMtW/bxjnsadz0/A-TEMPLATE%20WEBSITE11.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000001fec1IAA ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1711050332:17 ) )
Array ( [ffd_listing_title] => Array ( [0] => Cañada #14 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-2486 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KnOEmQAN ) [ffd_totalarea_pb] => Array ( [0] => 3960 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Querencia Golf Club ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San Jose del cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Cañadas ) [ffd_createddate] => Array ( [0] => 2023-06-06T17:32:21.000+0000 ) [ffd_days_on_market] => Array ( [0] => 310 ) [ffd_description_pb] => Array ( [0] => This charming and authentic Mexican villa offers blasting views of the Sea of Cortez, Punta Gorda and the city of San Jose from one of the highest elevations within the Las Cañadas enclave of 16 homes.Cañada #14 Cañadas Single Family Home 4,250,000 USD | 72,250,000 MXN | 3,960 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
This custom home is fully furnished and features thoughtful details throughout and includes a gourmet kitchen and expansive indoor and outdoor living -- both ideal for entertaining. La Cañada 14 is just a short golf cart ride from the heartbeat of the community, the Querencia Club village, home to the 18-hole Tom Fazio course, pickleball, tennis and racket courts, restaurants, fitness and wellness amenities and more.
The purchase of this home includes a whole house generator, hurricane shutters, and an off-road Polaris RZR vehicle.
) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-10-27T19:59:59.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03388 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 4250000 ) [ffd_listing_price_pesos] => Array ( [0] => 72250000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.74074 ) [ffd_community_lot_number] => Array ( [0] => 14 ) [wpcf-lotsize] => Array ( [0] => 14316 ) [wpcf-lot-size-sqm] => Array ( [0] => 1330 ) [wpcf-mls] => Array ( [0] => 23-2486 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3960 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a093Z00000KnOEmQAN ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Cañada #14 ) [wpcf-squarefeet] => Array ( [0] => 5710 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 4250000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Cañada #14 Single Family Home 23-2486ResaleCañadasActive ) [ffd_yearbuilt_pb] => Array ( [0] => 2014 ) [ffd_postalcode_pb] => Array ( [0] => 23401 ) [pba__WebsiteId__c] => Array ( [0] => 9647 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/canada-14/ ) [ffd_media] => Array ( [0] => a:35:{i:0;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/sf8ku1e21/more.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/26w7l4zt4/A-TEMPLATE%20WEBSITE4.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/vv0572zpa/A-TEMPLATE%20WEBSITE17.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/cpww1bq9v/A-TEMPLATE%20WEBSITE9.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/6tby705qi/A-TEMPLATE%20WEBSITE24.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/klfu8kohw/A-TEMPLATE%20WEBSITE.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/46i5firf3/A-TEMPLATE%20WEBSITE10.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/bt17ars2r/A-TEMPLATE%20WEBSITE11.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/59fnsazh7/A-TEMPLATE%20WEBSITE12.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/lsbm91z8b/A-TEMPLATE%20WEBSITE13.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/j00pp19ye/A-TEMPLATE%20WEBSITE14.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/y2e4u8vft/A-TEMPLATE%20WEBSITE15.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/vs4bpiwau/A-TEMPLATE%20WEBSITE16.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/4apr6b4ug/A-TEMPLATE%20WEBSITE18.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/tln94d044/A-TEMPLATE%20WEBSITE19.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/oh8ed6prz/A-TEMPLATE%20WEBSITE2.jpg";i:16;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/hocrps9db/A-TEMPLATE%20WEBSITE20.jpg";i:17;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/qqjuehm6m/A-TEMPLATE%20WEBSITE21.jpg";i:18;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/o1dq18udh/A-TEMPLATE%20WEBSITE22.jpg";i:19;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/gsnibdyre/A-TEMPLATE%20WEBSITE23.jpg";i:20;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/aj7l43ob7/A-TEMPLATE%20WEBSITE25.jpg";i:21;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/y6cizvnt3/A-TEMPLATE%20WEBSITE3.jpg";i:22;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/geo43sfep/A-TEMPLATE%20WEBSITE5.jpg";i:23;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/t4qp46etf/A-TEMPLATE%20WEBSITE6.jpg";i:24;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/9l7lsz4o6/A-TEMPLATE%20WEBSITE7.jpg";i:25;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/f3nan15ge/A-TEMPLATE%20WEBSITE8.jpg";i:26;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/07a00gbv4/more3.jpg";i:27;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/2ty6je8ej/more2.jpg";i:28;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/597cn86j7/A-TEMPLATE%20WEBSITE4.jpg";i:29;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/llw8t0g34/A-TEMPLATE%20WEBSITE35.jpg";i:30;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/nt2pqtqy8/A-TEMPLATE%20WEBSITE33.jpg";i:31;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/lxo2dkpo6/A-TEMPLATE%20WEBSITE32.jpg";i:32;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/ozwjgt5ap/A-TEMPLATE%20WEBSITE3.jpg";i:33;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/lljfwn3kw/A-TEMPLATE%20WEBSITE27.jpg";i:34;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/h1z2g66oj/A-TEMPLATE%20WEBSITE26.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000khva/sf8ku1e21/more.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KnOEmQAN ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1892 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_wp_old_slug] => Array ( [0] => canada-14-2 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850491 ) )
Array ( [ffd_listing_title] => Array ( [0] => Verandas B-302 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-1971 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KJtEPQA1 ) [ffd_totalarea_pb] => Array ( [0] => 3877 ) [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] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_createddate] => Array ( [0] => 2023-05-08T15:56:32.000+0000 ) [ffd_days_on_market] => Array ( [0] => 339 ) [ffd_description_pb] => Array ( [0] => This beautiful collection of multi-family condominium homes are located just steps away from Querencia's world-class Clubhouse Village, making our amenities truly an extension of your Las Verandas home. Encompassing spectacular panoramic ocean, golf and desert views, this luxurious 4-bedroom condominium is beautifully appointed along with its incredible vistas it also offers elevated service and worry free living. Offering a spacious open floor plan which flows to the generous outdoor living spaces. The gourmet kitchen is finished with the finest materials for any chef to make this space their own. Veranda B-302 is move in ready, fully furnished.Verandas B-302 Verandas Condominium 4,200,000 USD | 71,400,000 MXN | 3,877 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-10-27T21:26:41.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03063 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 4200000 ) [ffd_listing_price_pesos] => Array ( [0] => 71400000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.7507 ) [ffd_community_lot_number] => Array ( [0] => 2302 ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 23-1971 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3877 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KJtEPQA1 ) [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] => Verandas B-302 ) [wpcf-squarefeet] => Array ( [0] => 4861 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 4200000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas B-302 Condominium 23-1971ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9638 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-b-302-2/ ) [ffd_media] => Array ( [0] => a:25:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/dahb4glv6/A-TEMPLATE%20WEBSITE16.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/sgxlsvry9/A-TEMPLATE%20WEBSITE20.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/eucauu5qh/A-TEMPLATE%20WEBSITE11.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/gorbc6sco/A-TEMPLATE%20WEBSITE12.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/gxxjn8t8w/A-TEMPLATE%20WEBSITE9.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/m3vnpd4id/A-TEMPLATE%20WEBSITE.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/wttq53qph/A-TEMPLATE%20WEBSITE10.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/zy3z0h6mm/A-TEMPLATE%20WEBSITE13.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/3pctg1b87/A-TEMPLATE%20WEBSITE14.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/2qehg9n52/A-TEMPLATE%20WEBSITE19.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/i818f2ild/A-TEMPLATE%20WEBSITE18.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/i2klrn56v/A-TEMPLATE%20WEBSITE17.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/udahxn2od/A-TEMPLATE%20WEBSITE15.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/ytdgeu9rd/A-TEMPLATE%20WEBSITE6.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/62nsikzvs/A-TEMPLATE%20WEBSITE5.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/3miz9cft5/A-TEMPLATE%20WEBSITE3.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/u71788q9v/A-TEMPLATE%20WEBSITE2.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/pqgopzvpc/A-TEMPLATE%20WEBSITE7.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/qfmtmkdeo/A-TEMPLATE%20WEBSITE8.jpg";i:19;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/9rqxgugxs/A-TEMPLATE%20WEBSITE4.jpg";i:20;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/5txqj8i4r/A-TEMPLATE%20WEBSITE27.jpg";i:21;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/nbtqvcmny/A-TEMPLATE%20WEBSITE8.jpg";i:22;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/etwn0jnbx/A-TEMPLATE%20WEBSITE32.jpg";i:23;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/husqv950v/A-TEMPLATE%20WEBSITE3.jpg";i:24;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/6ihwuf0s5/A-TEMPLATE%20WEBSITE30.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRYF/dahb4glv6/A-TEMPLATE%20WEBSITE16.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KJtEPQA1 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850515 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1713286191 ) [ffd_listing_title] => Array ( [0] => La Montaña #05 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-1851 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KnO5QQAV ) [ffd_totalarea_pb] => Array ( [0] => ) [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] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => La Montaña ) [ffd_createddate] => Array ( [0] => 2023-06-05T18:27:21.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1 ) [ffd_description_pb] => Array ( [0] => La Montaña is a collection of 29 distinctive homesites in the heart of Querencia. The tiered elevation configuration allows for unobstructed sweeping views from each homesite -- from mountain and arroyo views, to the crystalline vistas of the Sea of Cortez.La Montaña #05 La Montaña Homesite 2,400,000 USD | 40,101,600 MXN Lot Size 27542 sq ft 2558.74 sq m
A feature of La Montaña 5, one of the largest lots in this section, is that it is surrounded by lush landscape which promotes privacy. The padded and walled homesite allows for the building of a single-level home between 3,900 - 10,000 A/C SQ FT.
Property owners within Querencia have the opportunity to purchase a 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] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2024-04-16T16:41:27.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] => 2400000 ) [ffd_listing_price_pesos] => Array ( [0] => 40101600 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 5 ) [wpcf-lotsize] => Array ( [0] => 27542 ) [wpcf-lot-size-sqm] => Array ( [0] => 2558.74 ) [wpcf-mls] => Array ( [0] => 24-1851 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a093Z00000KnO5QQAV ) [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] => La Montaña #05 ) [wpcf-squarefeet] => Array ( [0] => 27542 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 2400000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => La Montaña #05 Homesite 24-1851ResaleLa MontañaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 10385 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-montana-05/ ) [ffd_media] => Array ( [0] => a:31:{i:0;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/j4hjwnkxf/1web.jpg";i:1;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/d6ys5m0tr/2web.jpg";i:2;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/run77rqjz/3web.jpg";i:3;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/bwircd8of/4web.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/j7xcyuwqk/A-TEMPLATE%20WEBSITE10.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/wd0es6l0c/A-TEMPLATE%20WEBSITE11.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/5k5sfret6/A-TEMPLATE%20WEBSITE12.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/nhzq3ab6t/A-TEMPLATE%20WEBSITE15.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/dnn1senmd/A-TEMPLATE%20WEBSITE2.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/lfv6m9iu8/A-TEMPLATE%20WEBSITE4.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/8yue9kos1/A-TEMPLATE%20WEBSITE5.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/mur6t9mbi/A-TEMPLATE%20WEBSITE7.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/af809blly/A-TEMPLATE%20WEBSITE6.jpg";i:13;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/tkr78kjeu/1%20copia.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/etjx0ewfd/A-TEMPLATE%20WEBSITE8.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/6g3amuij5/A-TEMPLATE%20WEBSITE9.jpg";i:16;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/tr249npe6/LOTE-5%20website.jpg";i:17;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/782b77p1e/2.jpg";i:18;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/34hdwhsmt/surf-3.jpg";i:19;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/3cnsgb7ut/Pickleball.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/3zjytdbgt/golf-2.jpg";i:21;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/cafagqdat/Clubhouse-4.jpg";i:22;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/nribs2hj9/Clubhouse-3.jpg";i:23;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/hqqfrno2u/surf-2.jpg";i:24;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/l9pnvutdc/Yoga%20Querencia.jpg";i:25;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/y6n5ite4a/Querencia%20Beach%20Club.jpg";i:26;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/v5xfo7yky/Golf-5.jpg";i:27;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/o82702d8k/Mountain%20Bike.jpg";i:28;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/0bopgn6j7/slide.jpg";i:29;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/ag7sr49xo/trails-2.jpg";i:30;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/s1va2pfdt/trampoline.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/j4hjwnkxf/1web.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KnO5QQAV ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8744 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas 77 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000000LUpVIAW ) [ffd_totalarea_pb] => Array ( [0] => ) [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] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_city_pb] => Array ( [0] => Los Cabos ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Colinas ) [ffd_createddate] => Array ( [0] => 2023-11-28T03:12:03.000+0000 ) [ffd_days_on_market] => Array ( [0] => 157 ) [ffd_description_pb] => Array ( [0] => Las Colinas 77 is an incredible homesite within the Querencia Community with breathtaking coastal views where you can build your dream home. Perfectly situated just steps away from the Querencia Beach Club, overlooking the crystal blue Sea of Cortez, with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. As some of the most impressive real estate in all of Los Cabos, the Las Colinas homesites provide the ideal canvas for you to build your dream home.Las Colinas 77 Las Colinas Homesite 2,250,000 USD | 38,599,875 MXN Lot Size 23574.90132 sq ft 2190.18 sq m
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] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-11-29T00:41:11.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0864985 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 2250000 ) [ffd_listing_price_pesos] => Array ( [0] => 38599875 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.7071078 ) [ffd_community_lot_number] => Array ( [0] => Las Colinas ) [wpcf-lotsize] => Array ( [0] => 23574.90132 ) [wpcf-lot-size-sqm] => Array ( [0] => 2190.18 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a09Pk000000LUpVIAW ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Las Colinas 77 ) [wpcf-squarefeet] => Array ( [0] => 23574.90132 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 2250000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Las Colinas 77 Homesite ResaleLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9955 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-77/ ) [ffd_media] => Array ( [0] => a:15:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/2qeemi1bv/3.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/8oeoruyr4/5.jpg";i:2;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/re25fqhfy/1%20copia%202.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/qgoogj9i9/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/urgzfoz10/4.jpg";i:5;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/yv3em9trc/A-TEMPLATE%20WEBSITE.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/he3amhhub/A-TEMPLATE%20WEBSITE10.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/wwq74cy1g/A-TEMPLATE%20WEBSITE2.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/dah2uvll7/A-TEMPLATE%20WEBSITE3.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/n4vtv2cpe/A-TEMPLATE%20WEBSITE4.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/d2ylci957/A-TEMPLATE%20WEBSITE5.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/f30h3ioql/A-TEMPLATE%20WEBSITE6.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/untcmx5iu/A-TEMPLATE%20WEBSITE7.jpg";i:13;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/sywkcc4sy/A-TEMPLATE%20WEBSITE8.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/zu4al5db6/A-TEMPLATE%20WEBSITE9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00000fG2pa/2qeemi1bv/3.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000000LUpVIAW ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850483 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1712850489 ) [ffd_listing_title] => Array ( [0] => Las Colinas 14 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-1261 ) [ffd_salesforce_id] => Array ( [0] => a09Pk000001ePOvIAM ) [ffd_totalarea_pb] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Colinas 14, Querencia, San Jose del Cabo, Baja California Sur, Mexico ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_city_pb] => Array ( [0] => Los Cabos ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Colinas ) [ffd_createddate] => Array ( [0] => 2024-03-12T20:18:30.000+0000 ) [ffd_days_on_market] => Array ( [0] => 45 ) [ffd_description_pb] => Array ( [0] => Las Colinas 14 is an incredible homesite within the Querencia Community with breathtaking coastal views where you can build your dream home. With most of the excavation and retaining walls already completed by previous owner, this eliminates the additional expense and time needed so you can start building and enjoying your home sooner.Las Colinas 14 Las Colinas 1,890,000 USD | 31,752,000 MXN
Perfectly situated just steps away from the Querencia Beach Club, overlooking the crystal blue Sea of Cortez, with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. As some of the most impressive real estate in all of Los Cabos, the Las Colinas homesites provide the ideal canvas for you to build your piece of paradise.
) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2024-04-04T18:46:39.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.07348 ) [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] => 1890000 ) [ffd_listing_price_pesos] => Array ( [0] => 31752000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.71476 ) [ffd_community_lot_number] => Array ( [0] => Colinas 14 ) [wpcf-lotsize] => Array ( [0] => 25373.98 ) [wpcf-lot-size-sqm] => Array ( [0] => 2357.32 ) [wpcf-mls] => Array ( [0] => 24-1261 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000001ePOvIAM ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Las Colinas 14 ) [wpcf-squarefeet] => Array ( [0] => 25373.98 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 1890000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Las Colinas 14 24-1261ResaleLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 10324 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-14-2/ ) [ffd_media] => Array ( [0] => a:12:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/ljr5nmls4/5.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/x6b0kj6dd/4.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/isuo6gjsg/6.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/h8j0glpvy/7.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/6hdkjt5c4/8.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/e6wfl9jfz/9.jpg";i:6;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/1lvti0a9b/A-TEMPLATE%20WEBSITE.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/dzwbv4oa8/A-TEMPLATE%20WEBSITE2.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/73yyqk79w/A-TEMPLATE%20WEBSITE3.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/abclu7nnv/A-TEMPLATE%20WEBSITE4.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/xujuq4109/A-TEMPLATE%20WEBSITE5.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/okp6vm4o4/A-TEMPLATE%20WEBSITE6.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001QSKCP/ljr5nmls4/5.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000001ePOvIAM ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1711050265:17 ) [_edit_last] => Array ( [0] => 17 ) [_wpcf-propertybase-id] => Array ( [0] => field_6241d7e8a5172 ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_wpcf-property-type] => Array ( [0] => field_6241d82da5173 ) [_wpcf-view] => Array ( [0] => field_6241d8dca5174 ) [_wpcf-resale] => Array ( [0] => field_6241dab0a5175 ) [wpcf-neighborhood-subset] => Array ( [0] => ) [_wpcf-neighborhood-subset] => Array ( [0] => field_6241daefa5176 ) [_wpcf-ribbon] => Array ( [0] => field_6241db32a5177 ) [wpcf-lotnumber] => Array ( [0] => ) [_wpcf-lotnumber] => Array ( [0] => field_6241dbaea5178 ) [_wpcf-lotsize] => Array ( [0] => field_6241dbe2a5179 ) [_wpcf-lot-size-sqm] => Array ( [0] => field_6241dbffa517a ) [_wpcf-price] => Array ( [0] => field_6241dc18a517b ) [_ffd_listing_price_pesos] => Array ( [0] => field_64480a754ad5b ) [wpcf-start-price] => Array ( [0] => ) [_wpcf-start-price] => Array ( [0] => field_6241dc2ea517c ) [wpcf-end-price] => Array ( [0] => ) [_wpcf-end-price] => Array ( [0] => field_6241dc3ea517d ) [_wpcf-mls] => Array ( [0] => field_6241dc64a517e ) [wpcf-spec-sheet-file] => Array ( [0] => ) [_wpcf-spec-sheet-file] => Array ( [0] => field_6241dc7da517f ) [wpcf-video] => Array ( [0] => ) [_wpcf-video] => Array ( [0] => field_6241dcd3a5180 ) [_wpcf-squarefeet] => Array ( [0] => field_6241dd3527de8 ) [_wpcf-acarea] => Array ( [0] => field_6241dd8327de9 ) [_wpcf-bedrooms] => Array ( [0] => field_6241dde8b5fa0 ) [_wpcf-bathrooms] => Array ( [0] => field_6241de2bb5fa1 ) [_wpcf-half-bathrooms] => Array ( [0] => field_6241de60b5fa2 ) [wpcf-basement] => Array ( [0] => ) [_wpcf-basement] => Array ( [0] => field_6241de7fb5fa3 ) [wpcf-garage] => Array ( [0] => ) [_wpcf-garage] => Array ( [0] => field_6241dec1b5fa4 ) [wpcf-isfurnished] => Array ( [0] => ) [_wpcf-isfurnished] => Array ( [0] => field_6241df25b5fa5 ) [wpcf-otherroom] => Array ( [0] => ) [_wpcf-otherroom] => Array ( [0] => field_6241df6db5fa6 ) [wpcf-features] => Array ( [0] => ) [_wpcf-features] => Array ( [0] => field_6241dfacb5fa7 ) [wpcf-notes] => Array ( [0] => ) [_wpcf-notes] => Array ( [0] => field_6241dfd3b5fa8 ) [_wpcf-latitude] => Array ( [0] => field_6241e02bb5fa9 ) [_wpcf-longitude] => Array ( [0] => field_6241e04cb5faa ) [_wpcf-agent-1] => Array ( [0] => field_6241e06fb5fab ) [wpcf-agent-2] => Array ( [0] => ) [_wpcf-agent-2] => Array ( [0] => field_6241e080b5fac ) [_wpcf-keywords] => Array ( [0] => field_6241e099b5fad ) [_wpcf-highlights] => Array ( [0] => field_6241e0beb5fae ) [_wpcf-property-features] => Array ( [0] => field_6241e0e0b5faf ) [wpcf-floorplan] => Array ( [0] => ) [_wpcf-floorplan] => Array ( [0] => field_6241e0f7b5fb0 ) [wpcf-siteplan] => Array ( [0] => ) [_wpcf-siteplan] => Array ( [0] => field_6241e112b5fb1 ) [wpcf-brochure] => Array ( [0] => ) [_wpcf-brochure] => Array ( [0] => field_6241e12fb5fb2 ) [wpcf-close-date] => Array ( [0] => ) [_wpcf-close-date] => Array ( [0] => field_6241e145b5fb3 ) [_wpcf-listing-type] => Array ( [0] => field_6241e176b5fb4 ) [_ffd_community] => Array ( [0] => field_62ab426441a36 ) [wpcf-feature-subtitle] => Array ( [0] => ) [_wpcf-feature-subtitle] => Array ( [0] => field_6241e7194766a ) [wpcf-introduction] => Array ( [0] => ) [_wpcf-introduction] => Array ( [0] => field_6241e73e4766b ) [wpcf-tripple-icon] => Array ( [0] => default ) [_wpcf-tripple-icon] => Array ( [0] => field_6241e7634766c ) [_yoast_wpseo_content_score] => Array ( [0] => 90 ) [_yoast_wpseo_focuskeywords] => Array ( [0] => [] ) [_yoast_wpseo_keywordsynonyms] => Array ( [0] => [""] ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => 1 ) [_yoast_wpseo_wordproof_timestamp] => Array ( [0] => ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) )
Array ( [ffd_listing_title] => Array ( [0] => La Vista #09 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-1618 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JYJj5QAH ) [ffd_totalarea_pb] => Array ( [0] => ) [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] => ) [wpcf-bedrooms] => Array ( [0] => ) [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] => La Vista ) [ffd_createddate] => Array ( [0] => 2023-04-11T23:37:54.000+0000 ) [ffd_days_on_market] => Array ( [0] => 365 ) [ffd_description_pb] => Array ( [0] => La Vista 9 is an expansive lot positioned front row of our property on the East face of the mountainside with totally unobstructed views to the Sea of Cortez. At night, enjoy the fabulous lights as the City of San Jose comes alive. La Vista 9 in conveniently located in close proximity to our Beach Club, which will be fully completed this fall for Querencia Members to enjoy!La Vista #09 La Vista Homesite 1,275,000 USD | 21,853,755 MXN Lot Size 51957.4 sq ft 4827 sq m
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-22T18:23:11.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.02179 ) [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] => 1275000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.72034 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => 51957.4 ) [wpcf-lot-size-sqm] => Array ( [0] => 4827 ) [wpcf-mls] => Array ( [0] => 23-1618 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JYJj5QAH ) [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] => La Vista #09 ) [wpcf-squarefeet] => Array ( [0] => 51964.71 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 1275000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean La Vista #09 Homesite 23-1618ResaleLa VistaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9591 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-vista-09/ ) [ffd_media] => Array ( [0] => a:13:{i:0;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/2dqw8ivbq/cover%20pic.jpg";i:1;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/xq0gmd3hk/A-TEMPLATE%20MLS.jpg";i:2;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/d7zn3x9kj/A-TEMPLATE%20MLS12.jpg";i:3;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/3pf2o5x1l/A-TEMPLATE%20MLS10.jpg";i:4;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/xrlnnix2w/A-TEMPLATE%20MLS11.jpg";i:5;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/n6z0dlejb/A-TEMPLATE%20MLS2.jpg";i:6;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/mj0b9ah0s/A-TEMPLATE%20MLS3.jpg";i:7;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/x4tb5nt4n/A-TEMPLATE%20MLS4.jpg";i:8;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/v5rt1kyb8/A-TEMPLATE%20MLS5.jpg";i:9;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/2ad2f77uj/A-TEMPLATE%20MLS6.jpg";i:10;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/vlq1of0y0/A-TEMPLATE%20MLS7.jpg";i:11;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/2ir3tyatn/A-TEMPLATE%20MLS8.jpg";i:12;s:112:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/7efk07snt/A-TEMPLATE%20MLS9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000050sJ9/2dqw8ivbq/cover%20pic.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JYJj5QAH ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1880 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 21853755 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1712850513 ) )
"*" indicates required fields