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 = '1901' ) )) 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
6
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #17 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-4578 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKj7lQAD ) [ffd_totalarea_pb] => Array ( [0] => 4124.4 ) [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] => 5 ) [wpcf-bedrooms] => Array ( [0] => 5 ) [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] => Club Villas ) [ffd_createddate] => Array ( [0] => 2022-12-07T21:30:13.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => Villa 17 is a one-story home nestled above the 16th fairway of the famed Querencia Golf Course designed by Tom Fazio and features beautiful panoramic vistas of the Sea of Cortez. The luxurious finishes and furnishings drew inspiration from the homes rich surroundings, from the earthy tones of the desert, to the azure blues of the ocean. Indoor living spaces transition seamlessly to the outside terrazas, pool, private lawn and summer kitchen. When the sliding doors are open, it's as if there's nothing to separate you from the beauty outside. A golf membership is included in the purchase of the home, buyer to pay the transfer fee. Conveniently located near the Querencia Club Village, one can easily enjoy the world-class amenities including access to the Querencia Beach Club with a swimmable cove, miles of hiking & mountain biking trails, state-of-the art fitness and wellness center, Kids * Teen Clubs, restaurants, pools, Spa & more! ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-04-18T21:52:41.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.06359 ) [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 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70247 ) [ffd_community_lot_number] => Array ( [0] => 17 ) [wpcf-lotsize] => Array ( [0] => 11077.68 ) [wpcf-lot-size-sqm] => Array ( [0] => 1029.15 ) [wpcf-mls] => Array ( [0] => 22-4578 ) [ffd_website_status_2] => Array ( [0] => Sold ) [wpcf-acarea] => Array ( [0] => 4124 ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKj7lQAD ) [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] => Club Villa #17 ) [wpcf-squarefeet] => Array ( [0] => 5926.16 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3950000 ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #17 Homesite 22-4578ResaleClub VillasSold ) [ffd_yearbuilt_pb] => Array ( [0] => 2015 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9555 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-17/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:146:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/v3h2uoi4q/Villa-17-Querencia-RomanaLilic-LA76-Photography-199.JPG";i:1;s:152:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/tc4j51p37/6.-%20Villa-17-Querencia-RomanaLilic-LA76-Photography-012.JPG";i:2;s:146:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/00a0obrob/Villa-17-Querencia-RomanaLilic-LA76-Photography-203.JPG";i:3;s:146:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/yqs0cv8qa/Villa-17-Querencia-RomanaLilic-LA76-Photography-194.JPG";i:4;s:150:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/rl5qzesds/18.-Villa-17-Querencia-RomanaLilic-LA76-Photography-095.JPG";i:5;s:153:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/t5fxvhl7g/12.-%20Villa-17-Querencia-RomanaLilic-LA76-Photography-120.JPG";i:6;s:153:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/4s0pt20uy/10.-%20Villa-17-Querencia-RomanaLilic-LA76-Photography-115.JPG";i:7;s:152:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/7i74bgfn5/2.-%20Villa-17-Querencia-RomanaLilic-LA76-Photography-155.JPG";i:8;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/26tcpszvv/CLUB%20VILLA%2017_FLOOR%20PLAN.pdf";i:9;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/p1agthdpj02ul17311pgs1ng6r5j2/VILLA%2017.pdf";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/v3h2uoi4q/Villa-17-Querencia-RomanaLilic-LA76-Photography-199.JPG ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKj7lQAD ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1710420829 ) )Club Villa #17 Club Villas Homesite | 4,124 A/C SQ FT 5 Beds 5 Full Baths 1 Half Baths Lot Size 11077.68 sq ft 1029.15 sq m
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #03 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKin6QAD ) [ffd_totalarea_pb] => Array ( [0] => 4249.58 ) [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] => Club Villas ) [ffd_createddate] => Array ( [0] => 2022-12-06T20:45:02.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => Inside the luxurious, gated, and highly amenitized community of Querencia. This impeccable, two-story custom residence is situated on the private, award-winning Tom Fazio course overlooking the 18th fairway. This residence features a collection of four bedrooms and an office. Inside, the expansive gourmet kitchen and pristine formal dining and living rooms open seamlessly to the terrace, fusing the outdoor and indoor living spaces. Enjoy ample alfresco entertaining space that includes an outdoor kitchen, dining area and firepit. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-09-06T16:24:13.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.02987 ) [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] => 3400000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.74735 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => 8342.66 ) [wpcf-lot-size-sqm] => Array ( [0] => 775.06 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => Sold ) [wpcf-acarea] => Array ( [0] => 4250 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKin6QAD ) [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] => Club Villa #03 ) [wpcf-squarefeet] => Array ( [0] => 6249.52 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3400000 ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #03 Single Family Home ResaleClub VillasSold ) [ffd_yearbuilt_pb] => Array ( [0] => 2007 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9552 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-03/ ) [ffd_media] => Array ( [0] => a:5:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/h3d57r9e4/1.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/jk624pqvz/2.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/yt1beifzb/3.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/affdtcwvd/6.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/x5nggmn6e/8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/h3d57r9e4/1.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKin6QAD ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_listing_price_pesos] => Array ( [0] => 61404000 ) [_yoast_indexnow_last_ping] => Array ( [0] => 1710420821 ) )Club Villa #03 Club Villas Single Family Home | 61,404,000 MXN | 4,250 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #30 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-1277 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWwUrQAL ) [ffd_totalarea_pb] => Array ( [0] => 3527.98 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Querencia ) [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_createddate] => Array ( [0] => 2022-02-25T18:53:57.000+0000 ) [ffd_days_on_market] => Array ( [0] => 748 ) [ffd_description_pb] => Array ( [0] => Upon entering the serene courtyard of Querencia's Club Villa 30, you'll immediately sense the connection of home to lifestyle. A thoughtful floor plan, seamlessly integrating the indoors with outdoor living, combined with tasteful décor, provide all that is needed to live life to the fullest. Family and friends will enjoy top-of-the line furnishings and finishes, which highlight every room and allow one to relax and enjoy all that Querencia has to offer. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2022-07-13T15:21:51.000+0000 ) [wpcf-latitude] => Array ( [0] => -34.73853 ) [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] => 3000000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -56.4424 ) [ffd_community_lot_number] => Array ( [0] => 30 ) [wpcf-lotsize] => Array ( [0] => 12223.5 ) [wpcf-lot-size-sqm] => Array ( [0] => 1135.6 ) [wpcf-mls] => Array ( [0] => 22-1277 ) [ffd_website_status_2] => Array ( [0] => Sold ) [wpcf-acarea] => Array ( [0] => 3528 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWwUrQAL ) [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] => Club Villa #30 ) [wpcf-squarefeet] => Array ( [0] => 4349.16 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3000000 ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #30 Single Family Home 22-1277ResaleClub VillasSold ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9321 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-30/ ) [ffd_media] => Array ( [0] => a:12:{i:0;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c18be2nv1pj71ib91p9qhqd2qk3/Querencia-Club-Villa-30-LA76-Photography-40.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c1lbqo8q10ntmojurcqss1f5la/2.JPG";i:2;s:157:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33tql0o8181fihulv9c711t22/Querencia-Club-Villa-30-LA76-Photography-02.jpg";i:3;s:157:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33ts36h1u41p6015ec5p8qig4/Querencia-Club-Villa-30-LA76-Photography-06.jpg";i:4;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33tt9mu1v59l3m17vofpg15tc6/Querencia-Club-Villa-30-LA76-Photography-10.jpg";i:5;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33tuc6s15rieu5i8d1v3h12108/Querencia-Club-Villa-30-LA76-Photography-16.jpg";i:6;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33tvegn1bfql7k5qs12651sr5a/Querencia-Club-Villa-30-LA76-Photography-17.jpg";i:7;s:159:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33u0nfe1g4e1v06132m9vj1eijc/Querencia-Club-Villa-30-LA76-Photography-18.jpg";i:8;s:156:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33u27vapn91k5lsnjt5um0se/Querencia-Club-Villa-30-LA76-Photography-44.jpg";i:9;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33u810b1ci71pvskj711jk29tg/Querencia-Club-Villa-30-LA76-Photography-11.jpg";i:10;s:156:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33ubbukkj9lmk1l71bpmtnqi/Querencia-Club-Villa-30-LA76-Photography-08.jpg";i:11;s:156:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33ug80jko217l38rgcjkq24k/Querencia-Club-Villa-30-LA76-Photography-45.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c18be2nv1pj71ib91p9qhqd2qk3/Querencia-Club-Villa-30-LA76-Photography-40.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWwUrQAL ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Club Villas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [ffd_listing_price_pesos] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1710420830 ) )Club Villa #30 Club Villas Single Family Home | 3,528 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #24 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 20-578 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000IkCqOQAV ) [ffd_totalarea_pb] => Array ( [0] => 7140.98 ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_createddate] => Array ( [0] => 2020-02-07T17:41:35.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1081 ) [ffd_description_pb] => Array ( [0] => Understated opulence abounds upon arrival within the traditional Mexican hacienda-style courtyard, complete with firepit, at Club Villa 24. This impeccable, three-story custom residence is situated on Hole 16 on the private, award-winning Tom Fazio course. Unlike any other villa within Querencia, the residence features a collection of six bedrooms, 4 full and two half baths, along with a finished basement that includes a family room, library, media room, bar and wine cellar. Inside, the expansive gourmet kitchen and pristine formal dining and living rooms open seamlessly to the terrace, fusing the outdoor and indoor living spaces. Enjoy ample alfresco entertaining space that includes an outdoor kitchen, dining area and firepit. ) [ffd_lastmodifieddate] => Array ( [0] => 2022-06-15T17:50:22.000+0000 ) [ffd_listingprice_pb] => Array ( [0] => 2950000 ) [ffd_community_lot_number] => Array ( [0] => 24 ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_id] => Array ( [0] => a093Z00000IkCqOQAV ) [ffd_name] => Array ( [0] => Club Villa #24 ) [ffd_yearbuilt_pb] => Array ( [0] => 2010 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 7901 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-24/ ) [ffd_media] => Array ( [0] => a:20:{i:0;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/popeusa53/DJI_0036.jpg";i:1;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/uu1pbgdwy/DJI_0318.jpg";i:2;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/5jinhs2po/_DSC8049.jpg";i:3;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/sjn5nbl2d/DJI_0056.jpg";i:4;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/4nja12sy9/_DSC9002.jpg";i:5;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/14kygbdle/_DSC9053.jpg";i:6;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/6odiy8q0z/_DSC8307.jpg";i:7;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/q8waudq3r/_DSC8274.jpg";i:8;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/ih4yeeagd/_DSC8945-Edit.jpg";i:9;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/pe8juiz5v/_DSC9505.jpg";i:10;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/0fncb18qz/_DSC9103.jpg";i:11;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/t9yudw8zz/_DSC9228.jpg";i:12;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/juxru70g7/_DSC8166.jpg";i:13;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/x8cs948pq/_DSC9686.jpg";i:14;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/h7ctajb3w/_DSC8207.jpg";i:15;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/e1r8d8ttn/DJI_0369.jpg";i:16;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/2pb5qv14l/_DSC8432.jpg";i:17;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/i30jdx4et/Laderas_1.mp4.00_00_40_02.Still004.jpg";i:18;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/g48hjynb2/DJI_0363.JPG";i:19;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/p1agthmd6cdjci1q10n3141a14912/VILLA%2024.pdf";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/popeusa53/DJI_0036.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => Sold ) [ffd_sort_by] => Array ( [0] => C ) [_edit_lock] => Array ( [0] => 1635289534:5 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [_edit_last] => Array ( [0] => 5 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [featured] => Array ( [0] => ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_yoast_wpseo_primary_category] => Array ( [0] => ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000IkCqOQAV ) [wpcf-property-type] => Array ( [0] => home ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Sold ) [wpcf-lotsize] => Array ( [0] => 11077.68 ) [wpcf-lot-size-sqm] => Array ( [0] => 1029.15 ) [wpcf-price] => Array ( [0] => 2950000 ) [wpcf-mls] => Array ( [0] => 20-578 ) [wpcf-squarefeet] => Array ( [0] => 8831.9 ) [wpcf-acarea] => Array ( [0] => 7141 ) [wpcf-bedrooms] => Array ( [0] => 6 ) [wpcf-bathrooms] => Array ( [0] => 6 ) [wpcf-half-bathrooms] => Array ( [0] => 2 ) [wpcf-latitude] => Array ( [0] => 23.02599 ) [wpcf-longitude] => Array ( [0] => -109.74673 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #24 Single Family Home 20-578ResaleClub VillasSold ) [wpcf-listing-type] => Array ( [0] => Resale ) [_yoast_wpseo_content_score] => Array ( [0] => 30 ) [wpcf-property-features] => Array ( [0] => ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_website_status] => Array ( [0] => Sold ) [ffd_community] => Array ( [0] => Club Villas ) [ffd_listing_price_pesos] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1710420822 ) )Club Villa #24 Club Villas Single Family Home | 7,141 A/C SQ FT 6 Beds 6 Full Baths 2 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #22 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-151 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWjnqQAD ) [ffd_totalarea_pb] => Array ( [0] => 3502.95 ) [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 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-12T16:43:55.000+0000 ) [ffd_days_on_market] => Array ( [0] => 793 ) [ffd_description_pb] => Array ( [0] => Through the gates of the private 2,000-acre Querencia community find Club Villa 22. Overlooking the 16th fairway of the award-winning Tom Fazio Championship course, the residence offers panoramic views that capture the natural beauty of the Baja landscape and the crystalline waters of the Sea of Cortez. Upon entering the open-air courtyard experience the soothing sound of a cascading fountain and the lush, manicured garden. Villa 22 offers four bedrooms and 3.5 baths and a seamless indoor/outdoor living space ideal for entertaining. Outside, the expansive terrace features a pool and jacuzzi, along with a fire pit and outdoor kitchen. At Villa 22, experience exceptional design detail throughout, including updated smooth-textured walls, energy-efficient A/C system, and overall efficiency in terms of annual costs. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2022-06-22T22:15:25.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.06359 ) [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] => 2295000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70247 ) [ffd_community_lot_number] => Array ( [0] => 22 ) [wpcf-lotsize] => Array ( [0] => 11077.68 ) [wpcf-lot-size-sqm] => Array ( [0] => 1029.15 ) [wpcf-mls] => Array ( [0] => 22-151 ) [ffd_website_status_2] => Array ( [0] => Sold ) [wpcf-acarea] => Array ( [0] => 3503 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 005f100000I1eqJAAR ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWjnqQAD ) [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] => Club Villa #22 ) [wpcf-squarefeet] => Array ( [0] => 4517 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 2295000 ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #22 Single Family Home 22-151ResaleClub VillasSold ) [ffd_yearbuilt_pb] => Array ( [0] => 2008 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9251 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-22/ ) [ffd_media] => Array ( [0] => a:18:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/nun4qx2fh/4.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/ip8zztk9a/1%20copia.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/l0lwrvn9b/3.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/m17dy0g9v/10.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/sm2rdpfi1/11.jpg";i:5;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/b77nemizl/12.jpg";i:6;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/1d72meknf/13.jpg";i:7;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/f9l8s921x/14.jpg";i:8;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/lxlhkphpk/15.jpg";i:9;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/di4eaoq1p/16.jpg";i:10;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/ntnj4d33i/17.jpg";i:11;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/4la9zgq86/18.jpg";i:12;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/0xns8r95f/2.jpg";i:13;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/yjrrev1g9/5.jpg";i:14;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/wosda9rrt/6.jpg";i:15;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/gjrabg1dq/7.jpg";i:16;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/re0252ma8/8.jpg";i:17;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/5h4j9av1l/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/nun4qx2fh/4.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWjnqQAD ) [wpcf-agent-1] => Array ( [0] => 005f100000I1eqJ ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Club Villas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [ffd_listing_price_pesos] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1710420822 ) )Club Villa #22 Club Villas Single Family Home | 3,503 A/C SQ FT 4 Beds 3 Full Baths 1 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #11 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 20-1182 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000IkO60QAF ) [ffd_totalarea_pb] => Array ( [0] => 4048 ) [ffd_address_pb] => Array ( [0] => Villa 11 Querencia ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_createddate] => Array ( [0] => 2020-02-20T19:14:26.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1435 ) [ffd_description_pb] => Array ( [0] => Club Villa 11 is a private respite. Upon entering the lush and meticulously landscaped courtyard you are enveloped in relaxed opulence. Inside, the expansive living space is designed in an open concept; ideal for entertaining friends and family. The custom finishes and interior design are thoughtfully inspired to highlight the stunning view of the Sea of Cortez on display throughout the two-story home. Outside, the extensive natural stone terrace features an infinity-edge pool with jacuzzi and outdoor dining with BBQ. Just steps from the Querencia Clubhouse and Tom Fazio golf, Club Villa 11 is your entre into a community overflowing with activities, camaraderie and amenities. Welcome home. ) [ffd_lastmodifieddate] => Array ( [0] => 2022-06-14T16:10:06.000+0000 ) [ffd_listingprice_pb] => Array ( [0] => 2200000 ) [ffd_community_lot_number] => Array ( [0] => 11 ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_id] => Array ( [0] => a093Z00000IkO60QAF ) [ffd_name] => Array ( [0] => Club Villa #11 ) [ffd_yearbuilt_pb] => Array ( [0] => 2007 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 7895 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-11/ ) [ffd_media] => Array ( [0] => a:18:{i:0;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/19lxj0leh/Club%20Villa%2011%20Querencia%20107.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/wxb321s1z/Club%20Villa%20487-187.jpg";i:2;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/f3gxik8o8/Club%20Villa%2011%20Querencia%20223.jpg";i:3;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/5ekiv5zwo/Club%20Villa%2011%20Querencia%20217.jpg";i:4;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/ct991ewl6/Club%20Villa%2011%20Querencia%20116.jpg";i:5;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/k89ut4cp5/Club%20Villa%2011%20Querencia%2051.jpg";i:6;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/k18fttq1k/Club%20Villa%2011%20Querencia%2088.jpg";i:7;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/0kzhuy3z1/Club%20Villa%2011%20Querencia%20228.jpg";i:8;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/1q3hga2bf/Club%20Villa%2011%20Querencia%2032.jpg";i:9;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/noxqrvlgm/club%20villa%2011squid-78.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/jd78f091k/Club%20Villa%20185%20.jpg";i:11;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/9h68jskl1/Club%20Villa%2011%20Querencia%20100.jpg";i:12;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/r7saew8gg/Club%20Villa%20204.jpg";i:13;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/hno51rvco/Club%20Villa%2011%20Querencia%2070.jpg";i:14;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/5rhiysjbi/Club%20Villa%2011%20Querencia%2097.jpg";i:15;s:134:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/7a2yvtzu1/Club%20Villa%2011%20Querencia%20122%202.jpg";i:16;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/wtp85a5oq/Club%20Villa%2011%20Querencia%2042.jpg";i:17;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/vxzekgcii/Club%20Villa%2011%20Querencia%2016.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/19lxj0leh/Club%20Villa%2011%20Querencia%20107.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_sort_by] => Array ( [0] => C ) [_edit_lock] => Array ( [0] => 1635289820:5 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [_edit_last] => Array ( [0] => 5 ) [ffd_website_status_2] => Array ( [0] => Sold ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [featured] => Array ( [0] => ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_yoast_wpseo_primary_category] => Array ( [0] => ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000IkO60QAF ) [wpcf-property-type] => Array ( [0] => home ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Sold ) [wpcf-lotsize] => Array ( [0] => 8230.41 ) [wpcf-lot-size-sqm] => Array ( [0] => 764.63 ) [wpcf-price] => Array ( [0] => 2200000 ) [wpcf-mls] => Array ( [0] => 20-1182 ) [wpcf-squarefeet] => Array ( [0] => 6209.59 ) [wpcf-acarea] => Array ( [0] => 4048 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.02788 ) [wpcf-longitude] => Array ( [0] => -109.74612 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #11 Single Family Home 20-1182ResaleClub VillasSold ) [wpcf-listing-type] => Array ( [0] => Resale ) [_yoast_wpseo_content_score] => Array ( [0] => 30 ) [wpcf-property-features] => Array ( [0] => ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_website_status] => Array ( [0] => Sold ) [ffd_community] => Array ( [0] => Club Villas ) [ffd_listing_price_pesos] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1710420821 ) )Club Villa #11 Club Villas Single Family Home | 4,048 A/C SQ FT 4 Beds 4 Full Baths 1 Half Baths
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
11
Array ( [ffd_listing_title] => Array ( [0] => La Montaña #09 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWADxQAP ) [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] => 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] => La Montaña ) [ffd_createddate] => Array ( [0] => 2021-09-08T16:01:21.000+0000 ) [ffd_days_on_market] => Array ( [0] => 890 ) [ffd_description_pb] => Array ( [0] => La Montaña is a collection of 29 distinctive homesites in the heart of Querencia. The tiered elevation configuration allows for sweeping views from each homesite – from mountain and arroyo views to the crystalline vistas of the Sea of Cortez. Surrounded by a lush landscape and with privacy in mind, the padded and walled sites allow for the building of single-level homes from approximately 4,500 - 6,000 A/C sq. ft.La Montaña #09 La Montaña Single Family Home 5,925,000 USD | 42,500,000 MXN 4 Beds 4 Full Baths 1 Half Baths
Property owners within Querencia have the opportunity to purchase Golf or Social memberships, unlocking access to a host of amenities for the entire family. (All memberships are subject to approval.) ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-09-06T21:41:13.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] => 5925000 ) [ffd_listing_price_pesos] => Array ( [0] => 42500000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 9 ) [wpcf-lotsize] => Array ( [0] => 19343 ) [wpcf-lot-size-sqm] => Array ( [0] => 1797.02 ) [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] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWADxQAP ) [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 #09 ) [wpcf-squarefeet] => Array ( [0] => 19343 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 5925000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => La Montaña #09 Single Family Home DeveloperLa MontañaActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9716 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/la-montana-09/ ) [ffd_media] => Array ( [0] => a:23:{i:0;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/lb6r0zcju/A-TEMPLATE%20WEBSITE.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/a9ogq32m3/A-TEMPLATE%20WEBSITE7.jpg";i:2;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/50jysme6a/1%20copia.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/rq3s4vh3l/A-TEMPLATE%20WEBSITE3.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/48z3h9upy/2.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/wgvz1aapm/A-TEMPLATE%20WEBSITE8.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/l40yyzndk/A-TEMPLATE%20WEBSITE5.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/fpuo53yzz/A-TEMPLATE%20WEBSITE4.jpg";i:8;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/o4v59pp71/A-TEMPLATE%20WEBSITE2.jpg";i:9;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/63k13h0k7/A-TEMPLATE%20WEBSITE6.jpg";i:10;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/zzdbltae2/Clubhouse-4.jpg";i:11;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/9jo18wu2l/Clubhouse-3.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/27dt6e9c1/golf-2.jpg";i:13;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/p556iyehy/Golf-5.jpg";i:14;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/2w30vidvv/Mountain%20Bike.jpg";i:15;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/94uya7yhd/Pickleball.jpg";i:16;s:119:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/0l7hgnz64/Querencia%20Beach%20Club.jpg";i:17;s:100:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/mgb6pa0pi/slide.jpg";i:18;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/y8owcs7tz/surf-3.jpg";i:19;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/317fjha6p/surf-2.jpg";i:20;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/f1y9wba1p/trails-2.jpg";i:21;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/csnki59o0/trampoline.jpg";i:22;s:111:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/pqmj6ie4n/Yoga%20Querencia.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IyciN/lb6r0zcju/A-TEMPLATE%20WEBSITE.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWADxQAP ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8744 ) [ffd_record_is_deleted] => Array ( [0] => ) [_yoast_indexnow_last_ping] => Array ( [0] => 1710420774 ) )
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] => 1710420795 ) )
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] => 332 ) [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] => 1710420796 ) )