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
51
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1727735100 ) [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] => 5 ) [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] => 277 ) [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,306 A/C SQ FT 4 Beds 5 Full 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] => 0 ) [ffd_lastmodifieddate] => Array ( [0] => 2024-07-23T22:56:50.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 ) [_edit_lock] => Array ( [0] => 1727732067:21 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1727735113 ) [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] => 201 ) [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, 6.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 | 4,787 A/C SQ FT 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-09-30T20:40: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 ( [_yoast_indexnow_last_ping] => Array ( [0] => 1727735158 ) [ffd_listing_title] => Array ( [0] => Verandas B-302 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000003t2ykIAA ) [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] => 2024-06-05T16:49:08.000+0000 ) [ffd_days_on_market] => Array ( [0] => 118 ) [ffd_description_pb] => Array ( [0] => Discover luxury living with this exquisite collection of multi-family condominium homes, located just steps away from Querencia's world-class Clubhouse Village. Our amenities seamlessly become an extension of your Las Verandas home, offering unparalleled convenience and lifestyle.Verandas B-302 Verandas Condominium 3,950,000 USD | 71,400,000 MXN | 3,877 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
This luxurious 4-bedroom condominium boasts spectacular panoramic views of the ocean, golf course,- and desert landscape. Every detail of this property is thoughtfully designed, combining incredible vistas with elevated service and worry-free living. The expansive open floor plan effortlessly transitions into generous outdoor living spaces, ideal for both relaxation and entertaining. The gourmet kitchen, equipped with top-of-the-line materials, is a chef's dream, ready for you to make it your own.
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-07-24T20:07:39.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] => 3950000 ) [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] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3877 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a09Pk000003t2ykIAA ) [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] => 3950000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas B-302 Condominium ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 10556 ) [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] => a09Pk000003t2ykIAA ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000Kt8H2 ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1729012446 ) [ffd_listing_title] => Array ( [0] => Verandas B-202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000008D2ozIAC ) [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] => 2024-10-04T00:08:45.000+0000 ) [ffd_days_on_market] => Array ( [0] => 10 ) [ffd_description_pb] => Array ( [0] => Discover elevated living within the private collection of multi-family condominium homes at Las Verandas. Verandas B202 is located just steps away from Querencia's world-class Clubhouse and award-winning 18-hole golf course, providing easy access to Querencia’s amenities, including restaurants, pools, fitness center, Men's and Women's Spas, pickleball and tennis court, Kids & Teens Clubs and so much more! The short walk makes it feel like our amenities are truly an extension of your Las Verandas home, offering unparalleled convenience and lifestyle.Verandas B-202 Verandas Condominium 3,950,000 USD | 76,277,581 MXN | 3,877 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
Verandas B202 is a luxurious 4-bedroom condominium with panoramic views of the ocean, golf course and desert landscape. Every detail of this property is thoughtfully designed, combining incredible vistas with elevated service and worry-free living. The expansive open floor plan effortlessly transitions into generous outdoor living spaces, ideal for both relaxation and entertaining. This unit comes fully furnished and equipped with top-of-the-line appliances. Learn more about this turn-key home.
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-10-15T17:12:19.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03064 ) [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] => 3950000 ) [ffd_listing_price_pesos] => Array ( [0] => 76277581 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.75066 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3877 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000008D2ozIAC ) [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-202 ) [wpcf-squarefeet] => Array ( [0] => 4860.98 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 3950000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas B-202 Condominium ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 11112 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-b-202/ ) [ffd_media] => Array ( [0] => a:13:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/oun3tioed/A-TEMPLATE%20WEBSITE6.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/g31brlhds/A-TEMPLATE%20WEBSITE8.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/mfvgf24pf/A-TEMPLATE%20WEBSITE7.jpg";i:3;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/36kd1z1da/A-TEMPLATE%20WEBSITE.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/p7plxcs6a/A-TEMPLATE%20WEBSITE11.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/a5s62tb3r/A-TEMPLATE%20WEBSITE12.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/365hx0q4a/A-TEMPLATE%20WEBSITE13.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/ysr2hl7na/A-TEMPLATE%20WEBSITE3.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/gqr7m16nj/A-TEMPLATE%20WEBSITE2.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/sizqidkuz/A-TEMPLATE%20WEBSITE10.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/d48mn6rxo/A-TEMPLATE%20WEBSITE4.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/v0dxtc85f/A-TEMPLATE%20WEBSITE5.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/y58yi5yc0/A-TEMPLATE%20WEBSITE9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj000000AyRXj/oun3tioed/A-TEMPLATE%20WEBSITE6.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000008D2ozIAC ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1729967134 ) [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] => 194 ) [ffd_description_pb] => Array ( [0] => La Montaña is a collection of 29 distinctive homesites in the heart of Querencia conveniently located near the Querencia Beach Club. 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
Known to be one of the largest lots in this section with more than half an acre of land, La Montaña 5 homesite 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-10-26T18:14:31.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] => 11120 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-montana-05/ ) [ffd_media] => Array ( [0] => a:13:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/c7zn0r09s/A-TEMPLATE%20WEBSITE.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/e5rgbk0ag/A-TEMPLATE%20WEBSITE.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/lg9hz1wol/A-TEMPLATE%20WEBSITE10.jpg";i:3;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/iyajuch5o/A-TEMPLATE%20WEBSITE11.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/cc0opqavl/A-TEMPLATE%20WEBSITE12.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/rale3g3vp/A-TEMPLATE%20WEBSITE2.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/0tymemwcv/A-TEMPLATE%20WEBSITE3.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/daagwx7wh/A-TEMPLATE%20WEBSITE4.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/4yc9cmqfi/A-TEMPLATE%20WEBSITE5.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/uudk388kd/A-TEMPLATE%20WEBSITE6.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/iq7dmv2if/A-TEMPLATE%20WEBSITE7.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/swp74f2qw/A-TEMPLATE%20WEBSITE8.jpg";i:12;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/w8y59m4uv/A-TEMPLATE%20WEBSITE9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000Iyhlv/c7zn0r09s/A-TEMPLATE%20WEBSITE.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] => 329 ) [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] => 2024-08-29T17:58:04.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] => 1727735099 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1729012446 ) [ffd_listing_title] => Array ( [0] => El Campo #04 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000008D0qPIAS ) [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] => El Campo ) [ffd_createddate] => Array ( [0] => 2024-10-03T23:41:47.000+0000 ) [ffd_days_on_market] => Array ( [0] => 11 ) [ffd_description_pb] => Array ( [0] => Experience elevated living at the apex of Querencia. The El Campo enclave includes 11 substantial lots overlooking the 7th hole on the award-winning Tom Fazio course.El Campo #04 El Campo Homesite 2,100,000 USD | 40,535,691 MXN Lot Size 39891 sq ft 3706 sq m
The El Campo 4 homesite spans over 39,891 square feet of land allowing you to build an incredibly spacious home in an ideal location within Querencia. Surrounded by the trifecta of Baja beauty: sea, golf and mountain views, and located minutes away from the Clubhouse, the upcoming Canyon Club and award-winning 18-hole golf course, El Campo 4 provides easy access to Querencia’s amenities, including restaurants, pools, fitness center, Men's and Women's Spas, pickleball and tennis court, Kids & Teens Clubs and so much more! Build your dream home in one of the most coveted locations within Querencia.
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-10-15T17:13:35.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0769 ) [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] => 2100000 ) [ffd_listing_price_pesos] => Array ( [0] => 40535691 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70915 ) [ffd_community_lot_number] => Array ( [0] => 4 ) [wpcf-lotsize] => Array ( [0] => 39891 ) [wpcf-lot-size-sqm] => Array ( [0] => 3706 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 4916 ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000008D0qPIAS ) [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 Campo #04 ) [wpcf-squarefeet] => Array ( [0] => 7590 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 2100000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean El Campo #04 Homesite ResaleEl CampoActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 11111 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-campo-04-2/ ) [ffd_media] => Array ( [0] => a:14:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/xzuvodt94/A-TEMPLATE%20WEBSITE2.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/rkoyhrh6f/A-TEMPLATE%20WEBSITE3.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/3jp6k6o32/A-TEMPLATE%20WEBSITE6.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/lq8mxye93/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/s1n155jz5/A-TEMPLATE%20WEBSITE8.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/d912vtic2/A-TEMPLATE%20WEBSITE7.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/6oq5cblcs/A-TEMPLATE%20WEBSITE5.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/fhz5o6h1t/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/7h9sovlr5/A-TEMPLATE%20WEBSITE12.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/j5hd2a1g7/A-TEMPLATE%20WEBSITE11.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/rq4pb1ocn/A-TEMPLATE%20WEBSITE10.jpg";i:11;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/7vpaa4pye/A-TEMPLATE%20WEBSITE.jpg";i:12;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/ogyd8y1zw/3.jpg";i:13;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/nbqei0wdf/6.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYk/xzuvodt94/A-TEMPLATE%20WEBSITE2.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000008D0qPIAS ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8668 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1727735111 ) [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] => 217 ) [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 Homesite 1,890,000 USD | 31,752,000 MXN Lot Size 25373.98 sq ft 2357.32 sq m
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-08-29T18:06:17.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] => lot ) [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 Homesite 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 ( [_yoast_indexnow_last_ping] => Array ( [0] => 1727735115 ) [ffd_listing_title] => Array ( [0] => Las Colinas 7 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-2292 ) [ffd_salesforce_id] => Array ( [0] => a09Pk0000031AEvIAM ) [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] => 2024-05-08T22:15:51.000+0000 ) [ffd_days_on_market] => Array ( [0] => 152 ) [ffd_description_pb] => Array ( [0] => Las Colinas 7 is an expansive 23,000 sq ft homesite within the masterplanned community of Querencia. Offering spectacular panoramic views of Punta Gorda, the Sea of Cortez, and the mountains, the homesite is Perfectly situated just steps away from the Querencia Beach Club. Colinas 7 overlooks the crystal blue Sea of Cortez with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. Las Colinas 7 provides the ideal canvas to build your piece of paradise.Las Colinas 7 Las Colinas Homesite 1,799,000 USD | 30,417,420 MXN Lot Size 22913.56666 sq ft 2128.74 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] => 2024-05-20T00:46:08.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] => 1799000 ) [ffd_listing_price_pesos] => Array ( [0] => 30417420.04 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.7071078 ) [ffd_community_lot_number] => Array ( [0] => 7 ) [wpcf-lotsize] => Array ( [0] => 22913.56666 ) [wpcf-lot-size-sqm] => Array ( [0] => 2128.74 ) [wpcf-mls] => Array ( [0] => 24-2292 ) [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] => a09Pk0000031AEvIAM ) [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 7 ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 1799000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Las Colinas 7 Homesite 24-2292ResaleLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 10436 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-7/ ) [ffd_media] => Array ( [0] => a:11:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/lmixnehj4/A-TEMPLATE%20WEBSITE.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/3as2kar6u/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/xrz7jg75e/A-TEMPLATE%20WEBSITE11.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/di0cfubcv/A-TEMPLATE%20WEBSITE6.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/bxm3c35ez/A-TEMPLATE%20WEBSITE3.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/jjpotpt72/A-TEMPLATE%20WEBSITE9.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/nmobtzh5w/A-TEMPLATE%20WEBSITE4.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/0f8qoue70/A-TEMPLATE%20WEBSITE8.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/s65f163ov/A-TEMPLATE%20WEBSITE2.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/3vbbj6iwn/A-TEMPLATE%20WEBSITE5.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/b4os2v24v/A-TEMPLATE%20WEBSITE7.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001xVao5/lmixnehj4/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk0000031AEvIAM ) [_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] => ) )
"*" indicates required fields