Discover Our Properties
SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt1 ON ( wp_tota44soje_posts.ID = mt1.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt2 ON ( wp_tota44soje_posts.ID = mt2.post_id ) WHERE 1=1 AND ( wp_tota44soje_postmeta.meta_key = 'wpcf-price' AND ( ( mt1.meta_key = 'wpcf-ribbon' AND mt1.meta_value IN ('Active','Under Contract','Sold') ) AND ( mt2.meta_key = '_wpcf_belongs_neighborhoods_id' AND mt2.meta_value = '1899' ) )) 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
24
Array ( [ffd_listing_title] => Array ( [0] => Verandas PH-C ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-296 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWl0JQAT ) [ffd_totalarea_pb] => Array ( [0] => 5623.86 ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-01-15T18:58:17.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1052 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia penthosue residences with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez and San Jose del Cabo, Veranda PH-C is a spacious 4 bedroom, 4.5 bath with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The residence is located just steps away from the community’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 more.Verandas PH-C Verandas Condominium 5,400,000 USD | 91,800,000 MXN | 5,624 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. Photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-29T01:48:35.000+0000 ) [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_community_lot_number] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWl0JQAT ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_name] => Array ( [0] => Verandas PH-C ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9261 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-ph-c/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/b9376n4v7/5.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/sxfmq8ilq/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/yq7o2851o/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/96zq5yhif/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/pn8rrz8u7/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/n0yfdhzmx/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/u7ejpvg08/6.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/ccp9lhahe/7.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/o4nvds1zz/8.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/oiffj9iyi/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/b9376n4v7/5.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1642799546:10 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [_edit_last] => Array ( [0] => 10 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_wpcf-ribbon] => Array ( [0] => field_61a62a2ab65ac ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWl0JQAT ) [wpcf-property-type] => Array ( [0] => condo ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Active ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-price] => Array ( [0] => 5400000 ) [wpcf-mls] => Array ( [0] => 22-296 ) [wpcf-squarefeet] => Array ( [0] => 7412.81 ) [wpcf-acarea] => Array ( [0] => 5624 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.03112 ) [wpcf-longitude] => Array ( [0] => -109.75026 ) [wpcf-keywords] => Array ( [0] => Ocean Verandas PH-C Condominium 22-296DeveloperVerandasActive ) [wpcf-listing-type] => Array ( [0] => Developer ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_listing_price_pesos] => Array ( [0] => 91800000 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1733174705 ) )
Array ( [ffd_listing_title] => Array ( [0] => Verandas C-201 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-462 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWl0EQAT ) [ffd_totalarea_pb] => Array ( [0] => 3868.54 ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-01-15T18:56:51.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1052 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez and San Jose del Cabo, Veranda C-201 is a spacious 4 bedroom, 4.5 bath with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The residence is located just steps away from the community’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 more.Verandas C-201 Verandas Condominium 4,250,000 USD | 72,250,000 MXN | 3,869 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.
Photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-28T22:31:44.000+0000 ) [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_community_lot_number] => Array ( [0] => 201 ) [ffd_website_status_2] => Array ( [0] => ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWl0EQAT ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_name] => Array ( [0] => Verandas C-201 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9257 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-c-201/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/uydn6yfz3/7.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/34cgo1mbz/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/vsq3m3kyy/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/2aze57j6j/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/4hwg9xpcm/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/sn4w6ze49/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/zohjejsgr/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/hzc8hql7e/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/8tx88msli/8.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/gay72oun9/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/uydn6yfz3/7.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1682443926:19 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [_edit_last] => Array ( [0] => 10 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_wpcf-ribbon] => Array ( [0] => field_61a62a2ab65ac ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWl0EQAT ) [wpcf-property-type] => Array ( [0] => condo ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Active ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-price] => Array ( [0] => 4250000 ) [wpcf-mls] => Array ( [0] => 23-462 ) [wpcf-squarefeet] => Array ( [0] => 5491.26 ) [wpcf-acarea] => Array ( [0] => 3869 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.03112 ) [wpcf-longitude] => Array ( [0] => -109.75026 ) [wpcf-keywords] => Array ( [0] => Ocean Verandas C-201 Condominium 23-462DeveloperVerandasActive ) [wpcf-listing-type] => Array ( [0] => Developer ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_listing_price_pesos] => Array ( [0] => 72250000 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1733174705 ) )
Array ( [ffd_listing_title] => Array ( [0] => Verandas E-202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-2472 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKD3uQAH ) [ffd_totalarea_pb] => Array ( [0] => 3868.54 ) [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] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [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_createddate] => Array ( [0] => 2022-04-26T20:58:58.000+0000 ) [ffd_days_on_market] => Array ( [0] => 951 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia private residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez, and San Jose del Cabo, Veranda E-202 is a spacious 4 bedroom, 4.5 bath residence with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The Verandas community features a community pool and social area and is just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, dog park, pickleball courts, hiking and biking trails and other Club amenities, including restaurants, pools, fitness center, Men's and Women's Spas, Kids & Teens Clubs and more.Verandas E-202 Verandas Condominium 4,250,000 USD | 72,250,000 MXN | 3,869 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.
The photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-28T22:39:16.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0636 ) [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 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-2472 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3869 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKD3uQAH ) [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 E-202 ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 4250000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas E-202 Condominium 22-2472DeveloperVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9448 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-e-202/ ) [ffd_media] => Array ( [0] => a:14:{i:0;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/4vcknu41h/9%20%281%29.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/knslfz8s9/2.jpg";i:2;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/b7ku78vl2/1%20copia.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/e6fq4fdd2/10.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/dbh9ddt3r/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/o8d58hsdh/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/t03tuib1z/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/umhjvtnfy/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/9t31dll1k/7.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/x9mzcssgd/Clubhouse-3.jpg";i:10;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/9cl55nrtz/golf-2.jpg";i:11;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/e5c9vjoj0/Golf-4.jpg";i:12;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/0v2vuts6h/Pickleball.jpg";i:13;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/b17ruuf7f/trails-2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/4vcknu41h/9%20%281%29.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKD3uQAH ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [ffd_listing_price_pesos] => Array ( [0] => 72250000 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1733174711 ) )
Array ( [ffd_listing_title] => Array ( [0] => Verandas C-202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-461 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWl0AQAT ) [ffd_totalarea_pb] => Array ( [0] => 3868.54 ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-01-15T18:57:37.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1052 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez and San Jose del Cabo, Veranda C-202 is a spacious 4 bedroom, 4.5 bath with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The residence is located just steps away from the community’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 more.Verandas C-202 Verandas Condominium 4,250,000 USD | 72,250,000 MXN | 3,869 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.
Photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-28T22:32:57.000+0000 ) [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_community_lot_number] => Array ( [0] => 202 ) [ffd_website_status_2] => Array ( [0] => ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWl0AQAT ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_name] => Array ( [0] => Verandas C-202 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9259 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-c-202/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/9ibo2yvtp/3.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/yw8qirjsn/9.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/pful4qagx/2.jpg";i:3;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/jmnuy4coe/1%20copia.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/tmi5cmj4a/10.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/of9db6mww/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/jj53vq2qv/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/0dwryo0nh/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/xywa8kmlk/7.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/52eulsyiw/8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/9ibo2yvtp/3.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1648488732:10 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [_edit_last] => Array ( [0] => 10 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_wpcf-ribbon] => Array ( [0] => field_61a62a2ab65ac ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWl0AQAT ) [wpcf-property-type] => Array ( [0] => condo ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Active ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-price] => Array ( [0] => 4250000 ) [wpcf-mls] => Array ( [0] => 23-461 ) [wpcf-squarefeet] => Array ( [0] => 5511.06 ) [wpcf-acarea] => Array ( [0] => 3869 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.03112 ) [wpcf-longitude] => Array ( [0] => -109.75026 ) [wpcf-keywords] => Array ( [0] => Ocean Verandas C-202 Condominium 23-461DeveloperVerandasActive ) [wpcf-listing-type] => Array ( [0] => Developer ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_listing_price_pesos] => Array ( [0] => 72250000 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1733174706 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1735408626 ) [ffd_listing_title] => Array ( [0] => Verandas B-302 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-2622 ) [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] => 207 ) [ffd_description_pb] => Array ( [0] => Discover luxury living with this exquisite collection of multi-family condominium homes, situated just steps away from Querencia’s world-class Clubhouse Village. Perfectly blending sophistication, comfort, and convenience, Las Verandas offers an unparalleled lifestyle experience.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 exquisite 4-bedroom condominium is fully furnished with a $400,000 luxury package, featuring custom-designed furniture and thoughtfully curated art pieces that enhance the elegance of every room. The residence offers breathtaking panoramic views of the ocean, golf course, and desert landscape, creating a dynamic and ever-changing tapestry of natural beauty.
The expansive open floor plan is thoughtfully designed to maximize both space and light, seamlessly transitioning into generous outdoor living areas with breathtaking vistas.
At the heart of the home lies a gourmet kitchen, outfitted with top-of-the-line appliances, premium finishes, and custom cabinetry—truly a chef’s dream. The primary suite offers a serene retreat, featuring a spa-like ensuite bathroom and ample closet space, all complemented by elegant design elements that reflect the property’s premium furnishings.
In addition, residents enjoy exclusive access to exceptional amenities, including a resort-style pool, fitness center, private dining options, and concierge services, ensuring every need is met with ease. Located in one of Querencia’s most sought-after communities, this property offers the perfect balance of privacy, elegance, and connection to the surrounding natural beauty.
Experience a lifestyle like no other at Las Verandas—where luxury living and effortless sophistication meet.
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-12-28T17:39:21.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] => 24-2622 ) [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 24-2622ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 11602 ) [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 ( [ffd_listing_title] => Array ( [0] => Verandas D-101 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-297 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWl0OQAT ) [ffd_totalarea_pb] => Array ( [0] => 2634.79 ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-01-15T18:59:39.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1052 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez and San Jose del Cabo, Veranda D-101 is a spacious 3 bedroom, 3.5 bath with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The residence is located just steps away from the community’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 more.Verandas D-101 Verandas Condominium 3,250,000 USD | 55,250,000 MXN | 2,635 A/C SQ FT 3 Beds 3 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.)
Photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-28T22:35:46.000+0000 ) [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] => 3250000 ) [ffd_community_lot_number] => Array ( [0] => 101 ) [ffd_website_status_2] => Array ( [0] => ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWl0OQAT ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_name] => Array ( [0] => Verandas D-101 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9267 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-d-101/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/a3pfue0h9/7.jpg";i:1;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/rft40j0s3/10.jpg";i:2;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/f1si549np/1%20copia.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/0knpulosz/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/pvxzf0f5w/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/aag3a8lnx/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/po6ryutgn/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/yj5okexc6/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/u5a4v57ex/8.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/m7dl2ykqk/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueT/a3pfue0h9/7.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1642793514:10 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [_edit_last] => Array ( [0] => 10 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_wpcf-ribbon] => Array ( [0] => field_61a62a2ab65ac ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWl0OQAT ) [wpcf-property-type] => Array ( [0] => condo ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Active ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-price] => Array ( [0] => 3250000 ) [wpcf-mls] => Array ( [0] => 22-297 ) [wpcf-squarefeet] => Array ( [0] => 3975.13 ) [wpcf-acarea] => Array ( [0] => 2635 ) [wpcf-bedrooms] => Array ( [0] => 3 ) [wpcf-bathrooms] => Array ( [0] => 3 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.03112 ) [wpcf-longitude] => Array ( [0] => -109.75026 ) [wpcf-keywords] => Array ( [0] => Ocean Verandas D-101 Condominium 22-297DeveloperVerandasActive ) [wpcf-listing-type] => Array ( [0] => Developer ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_listing_price_pesos] => Array ( [0] => 55250000 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1733174707 ) )
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1734641838 ) [ffd_listing_title] => Array ( [0] => Verandas A301 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 24-5576 ) [ffd_salesforce_id] => Array ( [0] => a09Pk00000ALIXGIA5 ) [ffd_totalarea_pb] => Array ( [0] => 4130.98 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 3 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San José del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_createddate] => Array ( [0] => 2024-12-04T20:46:27.000+0000 ) [ffd_days_on_market] => Array ( [0] => 16 ) [ffd_description_pb] => Array ( [0] => This partially-furnished Verandas Penthouse maintains its Latin roots with a fun, colorful, cozy transitional style that is synonymous with Mexico! The living room features lofty 13' coffered ceilings, a charming kitchen and living area that expands seamlessly onto a shaded terrace, capturing the azure waters of the Sea of Cortez. Veranda A-301 has custom finishes and features throughout, located steps away from Querencia´s world-class Clubhouse Village, making the amenities truly an extension of your home. This unit will be looking over holes #1 and #18 of the new golf course at Querencia, also designed by Tom Fazio.Verandas A301 Verandas Condominium 3,150,000 USD | 62,922,374 MXN | 4,131 A/C SQ FT 4 Beds 3 Full Baths 2 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] => 2 ) [ffd_lastmodifieddate] => Array ( [0] => 2024-12-19T20:00:30.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03094 ) [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] => 3150000 ) [ffd_listing_price_pesos] => Array ( [0] => 62922374 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.75024 ) [ffd_community_lot_number] => Array ( [0] => 301.3 ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 24-5576 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a09Pk00000ALIXGIA5 ) [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 A301 ) [wpcf-squarefeet] => Array ( [0] => 4306.47 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 3150000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas A301 Condominium 24-5576ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 11458 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-a301/ ) [ffd_media] => Array ( [0] => a:12:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/vyn772jjy/A-TEMPLATE%20WEBSITE4.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/w201sesbs/A-TEMPLATE%20WEBSITE3.jpg";i:2;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/y39dsu61h/A-TEMPLATE%20WEBSITE12.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/4qz4j182e/A-TEMPLATE%20WEBSITE9.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/ocj6ohyu9/A-TEMPLATE%20WEBSITE10.jpg";i:5;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/3popwywdv/A-TEMPLATE%20WEBSITE11.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/6pgxvradi/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/ifltwxqmr/A-TEMPLATE%20WEBSITE5.jpg";i:8;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/0ejm6ju1s/A-TEMPLATE%20WEBSITE.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/al8uf9ml3/A-TEMPLATE%20WEBSITE2.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/b49257qu7/A-TEMPLATE%20WEBSITE6.jpg";i:11;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/6fbzzn4p5/A-TEMPLATE%20WEBSITE8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00003lFDNJ/vyn772jjy/A-TEMPLATE%20WEBSITE4.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk00000ALIXGIA5 ) [_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 ( [ffd_listing_title] => Array ( [0] => Verandas E-201 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-2470 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKD3kQAH ) [ffd_totalarea_pb] => Array ( [0] => 3868.54 ) [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] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [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_createddate] => Array ( [0] => 2022-04-26T20:54:17.000+0000 ) [ffd_days_on_market] => Array ( [0] => 993 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia private residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez, and San Jose del Cabo, Veranda E-201 is a spacious 4 bedroom, 4.5 bath residence with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The Verandas community features a community pool and social area and is just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, dog park, pickleball courts, hiking and biking trails and other Club amenities, including restaurants, pools, fitness center, Men's and Women's Spas, Kids & Teens Clubs and more.Verandas E-201 Verandas Condominium 4,250,000 USD | 72,250,000 MXN | 3,869 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.
The photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2025-01-14T00:04:16.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0636 ) [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 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-2470 ) [ffd_website_status_2] => Array ( [0] => Under Contract ) [wpcf-acarea] => Array ( [0] => 3869 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKD3kQAH ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Under Contract ) [ffd_name] => Array ( [0] => Verandas E-201 ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 4250000 ) [ffd_sort_by] => Array ( [0] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => Verandas E-201 Condominium 22-2470DeveloperVerandasUnder Contract ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9452 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-e-201/ ) [ffd_media] => Array ( [0] => a:15:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/oii8z85oy/6.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/rjkbgqfdz/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/fzq9wrect/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/3y9qs569r/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/0trohfv61/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/mmfommcqh/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/z3kev3x19/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/pux8j5k7n/7.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/odiltz2oy/8.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/e16ty0x1x/9%20%281%29.jpg";i:10;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/3aiq1qfwl/Clubhouse-3.jpg";i:11;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/ua47ldbs0/golf-2.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/3tommlt4c/Golf-4.jpg";i:13;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/7jjwxk1w0/Pickleball.jpg";i:14;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/nj0979ufb/trails-2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/oii8z85oy/6.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKD3kQAH ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [ffd_listing_price_pesos] => Array ( [0] => 72250000 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1736816385 ) )
Under ContractUnder Contract
Array ( [ffd_listing_title] => Array ( [0] => Verandas PH-E ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-2469 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKD3zQAH ) [ffd_totalarea_pb] => Array ( [0] => 5623.86 ) [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] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [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_createddate] => Array ( [0] => 2022-04-26T21:06:07.000+0000 ) [ffd_days_on_market] => Array ( [0] => 951 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia private residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez, and San Jose del Cabo, Veranda PH-E is a spacious 4 bedroom, 4.5 bath residence with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The Verandas community features a community pool and social area and is just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, dog park, pickleball courts, hiking and biking trails and other Club amenities, including restaurants, pools, fitness center, Men's and Women's Spas, Kids & Teens Clubs and more.Verandas PH-E Verandas Condominium | 91,800,000 MXN | 5,624 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
The photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2024-05-07T22:29:46.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0636 ) [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 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-2469 ) [ffd_website_status_2] => Array ( [0] => Sold ) [wpcf-acarea] => Array ( [0] => 5624 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKD3zQAH ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Sold ) [ffd_name] => Array ( [0] => Verandas PH-E ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 5400000 ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [wpcf-keywords] => Array ( [0] => Verandas PH-E Condominium 22-2469DeveloperVerandasSold ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9449 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-ph-e/ ) [ffd_media] => Array ( [0] => a:15:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/tmxa89ioy/8.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/5i6eqea5x/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/egi41rib4/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/rg9d446h4/3.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/3q0nlpjqt/4.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/9slmj1o46/5.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/aa16i6ssf/6.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/zascxuc76/7.jpg";i:8;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/ngv7oene5/9%20%281%29.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/pmw3b4q55/Clubhouse-3.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/dexmyag23/2.jpg";i:11;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/6uc391ml4/golf-2.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/dbxzilpoh/Golf-4.jpg";i:13;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/4f8ruxs7c/Pickleball.jpg";i:14;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/e09h4esi3/trails-2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/tmxa89ioy/8.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKD3zQAH ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1655392280:11 ) [ffd_community] => Array ( [0] => Verandas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [ffd_listing_price_pesos] => Array ( [0] => 91800000 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1733174711 ) )
SoldSold
SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) WHERE 1=1 AND ( ( wp_tota44soje_postmeta.meta_key = 'featured' AND wp_tota44soje_postmeta.meta_value = 'yes' )) AND wp_tota44soje_posts.post_type = 'properties' AND ((wp_tota44soje_posts.post_status = 'publish')) GROUP BY wp_tota44soje_posts.ID ORDER BY wp_tota44soje_posts.post_date DESC LIMIT 0, 3
Featured properties
10
Array ( [_yoast_indexnow_last_ping] => Array ( [0] => 1733174752 ) [ffd_listing_title] => Array ( [0] => Ocean Residence B 202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a09Pk000002GVRiIAO ) [ffd_totalarea_pb] => Array ( [0] => 2679 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Querencia, San Jose del Cabo, Baja California Sur, Mexico, Los Cabos. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San José del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Ocean Residences ) [ffd_createddate] => Array ( [0] => 2024-04-09T22:57:14.000+0000 ) [ffd_days_on_market] => Array ( [0] => 236 ) [ffd_description_pb] => Array ( [0] =>Ocean Residence B 202 Ocean Residences Condominium 6,500,000 USD | 130,671,652 MXN | 2,679 A/C SQ FT 4 Beds 4 Full BathsSleek, spacious and just steps from the sun-drenched shores of the Sea of Cortez, Ocean Residence B-202 is the epitome of modern luxury meets coastal contemporary.
Inside, find inspired living within the neutral, yet refined space. This turnkey, brand new 4-bedroom, 4 full-bath residence – one of just a few in the 30-unit complex—is flooded with natural light framing panoramic views of the swimmable beach, one of the best surf breaks in San Jose. Designed with impeccable attention to detail and with top-of-the-line appliances and finishes throughout, Residence B-202 is centrally located within the center of the three Ocean Residence towers.
Rest and luxuriate with views of the ocean from the primary bedroom complete with an oversized spa-like bath with dual-showers and ample closet space. Two additional bedrooms features ensuite baths, while the fourth bedroom has direct access to a full bath.
Designed to maximize storage opportunities, the open concept floorplan features 2,600 sq. ft. of interior space which seamlessly flows through minimalistic floor-to-ceiling, double paned glass doors onto an additional 500 square feet of outdoor living lounge space with outdoor fireplace and heated plunge pool.
Owners of B-202 gain access to convenient underground parking, including two desirable side-by-side parking spaces, additional lock-off storage space and full-time security and access to beachfront living at its finest at the Querencia Beach Club, home to two family pools, four dining experiences, a satellite Querencia Spa, Sports Lounge and oceanfront Fitness Center.
Other Features Include:
Elevator access | SubZero and Wolf appliances | Rosa Morada wood throughout | Fully-furnished, including TVs and hidden mounted soffit speakers | Convenient, electric roll-down, hurricane shutters throughout | External hurricane shutters on terrace
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family.
) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2024-11-19T20:56:12.000+0000 ) [wpcf-latitude] => Array ( [0] => 22.90981 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 6500000 ) [ffd_listing_price_pesos] => Array ( [0] => 130671652.15 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.9278 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a09Pk000002GVRiIAO ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Ocean Residence B 202 ) [wpcf-squarefeet] => Array ( [0] => 3237 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 6500000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Residence B 202 Condominium DeveloperOcean ResidencesActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 10382 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/ocean-residence-b-202/ ) [ffd_media] => Array ( [0] => a:40:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/rz7zvb253/A-TEMPLATE%20WEBSITE.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/40ty3hcgr/A-TEMPLATE%20WEBSITE10.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/1zoepwm5u/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/unijgvx3x/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/idt463vt6/A-TEMPLATE%20WEBSITE17.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h8hbbgt2y/A-TEMPLATE%20WEBSITE4.jpg";i:6;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/0rvlsktzd/A-TEMPLATE%20WEBSITE16.jpg";i:7;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7rrnt7d1z/A-TEMPLATE%20WEBSITE15.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9wf8a3zhq/A-TEMPLATE%20WEBSITE18.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/sk61xp1f2/A-TEMPLATE%20WEBSITE19.jpg";i:10;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/lanc9lix2/A-TEMPLATE%20WEBSITE20.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/a0yrnk6cr/A-TEMPLATE%20WEBSITE11.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/7jv1c1yf2/A-TEMPLATE%20WEBSITE12.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/k7uktv0fn/A-TEMPLATE%20WEBSITE13.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/g9e0xk2oc/A-TEMPLATE%20WEBSITE14.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/l08lgfln0/A-TEMPLATE%20WEBSITE5.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/fu01nec1w/A-TEMPLATE%20WEBSITE8.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/zolndnp7l/A-TEMPLATE%20WEBSITE7.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/403ih1ghs/A-TEMPLATE%20WEBSITE9.jpg";i:19;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/q5lcscn1s/A-TEMPLATE%20WEBSITE22.jpg";i:20;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mshycubwg/A-TEMPLATE%20WEBSITE21.jpg";i:21;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/015pr15cw/A-TEMPLATE%20WEBSITE24.jpg";i:22;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/h06pixcdw/A-TEMPLATE%20WEBSITE25.jpg";i:23;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/9ov4diznp/A-TEMPLATE%20WEBSITE26.jpg";i:24;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/le7q8myhm/A-TEMPLATE%20WEBSITE6.jpg";i:25;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/ns7gahnbq/A-TEMPLATE%20WEBSITE27.jpg";i:26;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/d481dk7lb/A-TEMPLATE%20WEBSITE28.jpg";i:27;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/j136isshw/A-TEMPLATE%20WEBSITE29.jpg";i:28;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/nif80q33n/A-TEMPLATE%20WEBSITE30.jpg";i:29;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tqoi2fzra/A-TEMPLATE%20WEBSITE31.jpg";i:30;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/495zsyqlq/A-TEMPLATE%20WEBSITE32.jpg";i:31;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/5bplookua/A-TEMPLATE%20WEBSITE-beachclub4.jpg";i:32;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/tgn5n0p5r/A-TEMPLATE%20WEBSITE-beachclub3.jpg";i:33;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/edv316i9i/A-TEMPLATE%20WEBSITE-beach6.jpg";i:34;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/mubnz02c2/A-TEMPLATE%20WEBSITE-beachclub.jpg";i:35;s:126:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/3akjmljnc/A-TEMPLATE%20WEBSITE-beachclub2.jpg";i:36;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/qlzqkchb1/A-TEMPLATE%20WEBSITE-beach5.jpg";i:37;s:121:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/b854v7fei/A-TEMPLATE%20WEBSITE-beach.jpg";i:38;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/xclj8i22z/A-TEMPLATE%20WEBSITE-beach3.jpg";i:39;s:122:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/8a5llup8p/A-TEMPLATE%20WEBSITE-beach4.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0CPk00001dh81m/rz7zvb253/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a09Pk000002GVRiIAO ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8670 ) [_edit_lock] => Array ( [0] => 1726065644:21 ) [_edit_last] => Array ( [0] => 21 ) [_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] => 30 ) [_yoast_wpseo_focuskeywords] => Array ( [0] => [] ) [_yoast_wpseo_keywordsynonyms] => Array ( [0] => [""] ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => 2 ) [_yoast_wpseo_wordproof_timestamp] => Array ( [0] => ) )
Array ( [ffd_listing_title] => Array ( [0] => El Valle 1 Upper ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JYGq7QAH ) [ffd_totalarea_pb] => Array ( [0] => 3050 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 3 ) [wpcf-bedrooms] => Array ( [0] => 3 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => El Valle ) [ffd_createddate] => Array ( [0] => 2023-03-30T18:47:15.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => El Valle is the latest neighborhood designed within the masterplanned Querencia community. A smaller, more intimate enclave set against the backdrop of the vibrant desert mountains, the 12 condominium residences offer a mix of views of the turquoise San Jose bay, Querencia lake and the award-winning Tom Fazio golf course.El Valle 1 Upper El Valle Condominium 3,465,000 USD | 58,905,000 MXN | 3,050 A/C SQ FT 3 Beds 3 Full Baths 1 Half Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-28T22:02:01.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.05381 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3465000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 35 ) [wpcf-lotsize] => Array ( [0] => 22948.66 ) [wpcf-lot-size-sqm] => Array ( [0] => 2132 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3050 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_id] => Array ( [0] => a093Z00000JYGq7QAH ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => El Valle 1 Upper ) [wpcf-squarefeet] => Array ( [0] => 3588 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 3465000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => El Valle 1 Upper Condominium DeveloperEl ValleActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9604 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-valle-1-upper/ ) [ffd_media] => Array ( [0] => a:29:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/tq1hxt5r6/A-TEMPLATE%20WEBSITE2.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/uifiwgcnt/A-TEMPLATE%20WEBSITE3.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hojxk6ut1/A-TEMPLATE%20WEBSITE4.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/zgnw06tqo/A-TEMPLATE%20WEBSITE5.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5d98tiql5/A-TEMPLATE%20WEBSITE6.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/je4iqh7s6/A-TEMPLATE%20WEBSITE7.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gotztox5o/A-TEMPLATE%20WEBSITE8.jpg";i:8;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/7j9e91qrc/Clubhouse-2.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/upeuzy8r2/Clubhouse-3.jpg";i:10;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/n4qrwk05e/Clubhouse-4.jpg";i:11;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/0cxtdew1t/Clubhouse.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4hwfbxexi/dinner.jpg";i:13;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4jg6szv38/golf-2.jpg";i:14;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/o1d1bhfrr/Yoga%20Querencia.jpg";i:15;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p41u05p61/trampoline.jpg";i:16;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/xvak4upbw/trails.jpg";i:17;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/vp3pbyasj/trails-2.jpg";i:18;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/efb60lvs3/surf.jpg";i:19;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/ol4v781k1/surf-3.jpg";i:20;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/31zt4rvy4/surf-2.jpg";i:21;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p8nazbkgc/slide.jpg";i:22;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gcekb0ldt/Querencia%20Golf.jpg";i:23;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5xp1u8wn8/Querencia%20Beach%20Club.jpg";i:24;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8hsjs0szf/Pickleball.jpg";i:25;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/acd2s0967/Pickleball-2.jpg";i:26;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/49vq4ijob/Mountain%20Bike.jpg";i:27;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/bepc4cg6o/golf.jpg";i:28;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/8wwe0k7wm/Golf-4.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JYGq7QAH ) [wpcf-agent-1] => Array ( [0] => 0053Z00000Kt8H2 ) [wpcf-agent-2] => Array ( [0] => 0053Z00000KX9ZY ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 58905000 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 9608 ) [_edit_lock] => Array ( [0] => 1701276370:21 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1733174717 ) )
Array ( [ffd_listing_title] => Array ( [0] => El Valle 6 Lower ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JYL7NQAX ) [ffd_totalarea_pb] => Array ( [0] => 3050 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 3 ) [wpcf-bedrooms] => Array ( [0] => 3 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => El Valle ) [ffd_createddate] => Array ( [0] => 2023-04-17T22:39:57.000+0000 ) [ffd_days_on_market] => Array ( [0] => 595 ) [ffd_description_pb] => Array ( [0] => El Valle is the latest neighborhood designed within the masterplanned Querencia community. A smaller, more intimate enclave set against the backdrop of the vibrant desert mountains, the 12 condominium residences offer a mix of views of the turquoise San Jose bay, Querencia lake and the award-winning Tom Fazio golf course.El Valle 6 Lower El Valle Condominium 2,970,000 USD | 50,490,000 MXN | 3,050 A/C SQ FT 3 Beds 3 Full Baths 1 Half Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-07-29T19:31:33.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.05381 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 2970000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 35 ) [wpcf-lotsize] => Array ( [0] => 22948.66 ) [wpcf-lot-size-sqm] => Array ( [0] => 2132 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3050 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JYL7NQAX ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => El Valle 6 Lower ) [wpcf-squarefeet] => Array ( [0] => 3588 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 2970000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => El Valle 6 Lower Condominium DeveloperEl ValleActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9602 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-valle-6-lower/ ) [ffd_media] => Array ( [0] => a:20:{i:0;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/59da53bl9/A-TEMPLATE%20WEBSITE8.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zb2ykxl8/A-TEMPLATE%20WEBSITE.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/qv0b0b5ir/A-TEMPLATE%20WEBSITE2.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/l5ajufh3m/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nrkbi41ve/A-TEMPLATE%20WEBSITE4.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/nhvo5ykxt/A-TEMPLATE%20WEBSITE5.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/kxit5zdgo/A-TEMPLATE%20WEBSITE6.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/41ulfgs6j/A-TEMPLATE%20WEBSITE7.jpg";i:8;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/xl6wa0998/Clubhouse.jpg";i:9;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/7rkc1miym/dinner.jpg";i:10;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8bbmuy30i/Golf-4.jpg";i:11;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/o18l17egf/golf.jpg";i:12;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/8u4cjjqhj/Mountain%20Bike.jpg";i:13;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/vke6ofpck/Pickleball-2.jpg";i:14;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/3zg8fsi4o/slide.jpg";i:15;s:99:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/jiy6m42k9/surf.jpg";i:16;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/6y2arpc7c/trails-2.jpg";i:17;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/ij9e65fmd/trails.jpg";i:18;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5iozycjr3/trampoline.jpg";i:19;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/5xcehypmk/Yoga%20Querencia.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCVAs/59da53bl9/A-TEMPLATE%20WEBSITE8.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JYL7NQAX ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 50490000 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 9608 ) [_edit_lock] => Array ( [0] => 1690823630:10 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1733174721 ) )