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] => 298
        )

    [ffd_description_pb] => Array
        (
            [0] => Understated opulence abounds upon arrival within the traditional Mexican hacienda-style courtyard, complete with firepit, at Club Villa 24. This impeccable, three-story custom residence is situated on Hole 16 on the private, award-winning Tom Fazio course. Unlike any other villa within Querencia, the residence features a collection of six bedrooms, 4 full and two half baths, along with a finished basement that includes a family room, library, media room, bar and wine cellar. Inside, the expansive gourmet kitchen and pristine formal dining and living rooms open seamlessly to the terrace, fusing the outdoor and indoor living spaces. Enjoy ample alfresco entertaining space that includes an outdoor kitchen, dining area and firepit.
        )

    [ffd_lastmodifieddate] => Array
        (
            [0] => 2021-11-15T04:41:33.000+0000
        )

    [ffd_listingprice_pb] => Array
        (
            [0] => 2950000
        )

    [ffd_community_lot_number] => Array
        (
            [0] => 24
        )

    [ffd_listing_agent_1] => Array
        (
            [0] => 0053Z00000KX9ZYQA1
        )

    [ffd_id] => Array
        (
            [0] => a093Z00000IkCqOQAV
        )

    [ffd_name] => Array
        (
            [0] => Club Villa #24
        )

    [ffd_yearbuilt_pb] => Array
        (
            [0] => 2010
        )

    [ffd_postalcode_pb] => Array
        (
            [0] => 23400
        )

    [pba__WebsiteId__c] => Array
        (
            [0] => 7901
        )

    [pba__Listing_Website__c] => Array
        (
            [0] => https://qcabo.com/properties/club-villa-24/
        )

    [ffd_media] => Array
        (
            [0] => a:20:{i:0;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/popeusa53/DJI_0036.jpg";i:1;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/uu1pbgdwy/DJI_0318.jpg";i:2;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/5jinhs2po/_DSC8049.jpg";i:3;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/sjn5nbl2d/DJI_0056.jpg";i:4;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/4nja12sy9/_DSC9002.jpg";i:5;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/14kygbdle/_DSC9053.jpg";i:6;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/6odiy8q0z/_DSC8307.jpg";i:7;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/q8waudq3r/_DSC8274.jpg";i:8;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/ih4yeeagd/_DSC8945-Edit.jpg";i:9;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/pe8juiz5v/_DSC9505.jpg";i:10;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/0fncb18qz/_DSC9103.jpg";i:11;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/t9yudw8zz/_DSC9228.jpg";i:12;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/juxru70g7/_DSC8166.jpg";i:13;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/x8cs948pq/_DSC9686.jpg";i:14;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/h7ctajb3w/_DSC8207.jpg";i:15;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/e1r8d8ttn/DJI_0369.jpg";i:16;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/2pb5qv14l/_DSC8432.jpg";i:17;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/i30jdx4et/Laderas_1.mp4.00_00_40_02.Still004.jpg";i:18;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/g48hjynb2/DJI_0363.JPG";i:19;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/p1agthmd6cdjci1q10n3141a14912/VILLA%2024.pdf";}
        )

    [ffd_featured_image] => Array
        (
            [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/popeusa53/DJI_0036.jpg
        )

    [ffd_record_is_deleted] => Array
        (
            [0] => 
        )

    [ffd_website_status_2] => Array
        (
            [0] => Under Contract
        )

    [ffd_sort_by] => Array
        (
            [0] => B
        )

    [_edit_lock] => Array
        (
            [0] => 1635289534:5
        )

    [_wpcf_belongs_neighborhoods_id] => Array
        (
            [0] => 1901
        )

    [_edit_last] => Array
        (
            [0] => 5
        )

    [_ffd_website_status_2] => Array
        (
            [0] => field_608827aae073c
        )

    [featured] => Array
        (
            [0] => 
        )

    [_featured] => Array
        (
            [0] => field_615b2b0a187e6
        )

    [_yoast_wpseo_primary_category] => Array
        (
            [0] => 
        )

    [wpcf-tripple-icon] => Array
        (
            [0] => default
        )

    [wpcf-propertybase-id] => Array
        (
            [0] => a093Z00000IkCqOQAV
        )

    [wpcf-property-type] => Array
        (
            [0] => home
        )

    [wpcf-view] => Array
        (
            [0] => Ocean
        )

    [wpcf-ribbon] => Array
        (
            [0] => Under Contract
        )

    [wpcf-lotsize] => Array
        (
            [0] => 11077.68
        )

    [wpcf-lot-size-sqm] => Array
        (
            [0] => 1029.15
        )

    [wpcf-price] => Array
        (
            [0] => 2950000
        )

    [wpcf-mls] => Array
        (
            [0] => 20-578
        )

    [wpcf-squarefeet] => Array
        (
            [0] => 8831.9
        )

    [wpcf-acarea] => Array
        (
            [0] => 7141
        )

    [wpcf-bedrooms] => Array
        (
            [0] => 6
        )

    [wpcf-bathrooms] => Array
        (
            [0] => 6
        )

    [wpcf-half-bathrooms] => Array
        (
            [0] => 2
        )

    [wpcf-latitude] => Array
        (
            [0] => 23.02599
        )

    [wpcf-longitude] => Array
        (
            [0] => -109.74673
        )

    [wpcf-agent-1] => Array
        (
            [0] => 0053Z00000KX9ZY
        )

    [wpcf-keywords] => Array
        (
            [0] => Ocean Club Villa #24 Single Family Home 20-578ResaleClub VillasUnder Contract
        )

    [wpcf-listing-type] => Array
        (
            [0] => Resale
        )

    [_yoast_wpseo_content_score] => Array
        (
            [0] => 30
        )

    [wpcf-property-features] => Array
        (
            [0] => 
        )

    [ffd_actual_close_date] => Array
        (
            [0] => 
        )

    [ffd_colistingagentmlsid] => Array
        (
            [0] => 
        )

    [ffd_colistingagentname] => Array
        (
            [0] => 
        )

    [ffd_colistingofficemlsid] => Array
        (
            [0] => 
        )

    [wpcf-highlights] => Array
        (
            [0] => 
        )

    [ffd_displayaddress] => Array
        (
            [0] => 
        )

    [ffd_listofficemlsid] => Array
        (
            [0] => 
        )

    [ffd_listofficename] => Array
        (
            [0] => 
        )

    [ffd_listing_agent_email] => Array
        (
            [0] => 
        )

    [ffd_listing_agent_firstname] => Array
        (
            [0] => 
        )

    [ffd_listing_agent_lastname] => Array
        (
            [0] => 
        )

    [ffd_listingagentmlsid] => Array
        (
            [0] => 
        )

    [ffd_listingagentname] => Array
        (
            [0] => 
        )

    [ffd_listing_agent_2] => Array
        (
            [0] => 
        )

    [wpcf-resale] => Array
        (
            [0] => 
        )

    [ffd_solddate] => Array
        (
            [0] => 
        )

    [ffd_soldprice] => Array
        (
            [0] => 
        )

    [ffd_state_pb] => Array
        (
            [0] => 
        )

    [ffd_website_status] => Array
        (
            [0] => Under Contract
        )

)

Club Villa #24

6 | 6 | 2
7,141 A/C sqftSingle Family Home
$2,950,000Under Contract

Property Summary

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.Connect with Sales

Property Inquiry

USA: 833.507.2226MEX: 011.52.624.145.6615

    More About Club Villas

    Step into a private home of luxury that you have come to expect in today’s modern home craftsmanship. These marvelous Club Villas are move-in ready, nestled perfectly in the picturesque landscape of Los Cabos. Choose from a large 3,200 to 5,000 A/C sq. ft. floor plan in either a three or four bedroom layout.

    Just footsteps away from a state-of-the art Club Village, these homes offer everything you need right on site. Fitness center, beautiful landscaping, wrought iron gates and open courtyards let you enjoy the scenery of sunny Baja while being part of a warm community.

    Inside you will live in spacious elegance, with handsome fireplaces and lovely interior décor that is all part of the Club Villa lifestyle. If that’s not enough to leave you breathless with anticipation, just come take a private tour and discover all of the add-ons the Club Villa builders have done to make your new home a one-of-a kind living experience.

    • Private Courtyard
    • Infinity Edge Pool & spa
    • Varied & Colorful Landscape
    • Two Car Garage
    • Spacious Gourmet Kitchen Layout
    • Luxurious Master Suites with Outdoor Showers
    • Nestled between a Golf Course and a Desert Park
    • Expansive Ocean Views
    • Located within a Short Walk from The Club Village
    • Two Floor Plans are Available Offering Three & Four Bedroom Layouts
    • 18-Hole Championship Golf Course by Tom Fazio
    • Custom Finished & Upgrade Options Exclusively at our Architectural Design Center

    Explore the Property

    The Ocean Residences are the first oceanfront ownership opportunity in our community, bringing Querencia closer than ever to the Sea of Cortez. With spacious terraces, open floorplans and floor-to-ceiling glass doors, each airy residence is artfully planned to invite the seascape in. Let our team bring your vision to life with custom features or select an Ocean Residences signature design.

    View Map