Array
(
    [ffd_listing_title] => Array
        (
            [0] => Las Colinas #37 (Casa Amanecer)
        )

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

    [ffd_mls_id] => Array
        (
            [0] => 21-4315
        )

    [ffd_salesforce_id] => Array
        (
            [0] => a093Z00000JWg6YQAT
        )

    [ffd_totalarea_pb] => Array
        (
            [0] => 5465.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] => 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] => 2021-12-21T20:58:36.000+0000
        )

    [ffd_days_on_market] => Array
        (
            [0] => 139
        )

    [ffd_description_pb] => Array
        (
            [0] => An amazing opportunity to own a panoramic ocean view and energy-efficient residence within the masterplanned community of Querencia. The main and lower levels have a frameless glass railing, serving up vistas of endless ocean views from all the bedrooms and even the kitchen, living room and dining room. This elegant, turn-key 4-bedroom, 4.5-bathroom home offers tremendous value. It was built with myriad of elegant details, an open-concept floorplan integrating a large living room, spacious dining room and a chef's kitchen with pristine granite countertops. The upper-level patio offers relaxing and lounging areas with a swimming pool and hot tub and the lower-level terrace has an entertaining area with pool table, TV and a comfortable seating area.

The house also includes a state-of-the-art media room with a large screen TV. The garage is conveniently located on the main level with convenient access to the house.
        )

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

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

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

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

    [ffd_lastmodifieddate] => Array
        (
            [0] => 2022-05-09T06:09:48.000+0000
        )

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

    [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] => 3285000
        )

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

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

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

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

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

    [wpcf-mls] => Array
        (
            [0] => 21-4315
        )

    [ffd_website_status_2] => Array
        (
            [0] => Sold
        )

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

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

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

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

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

    [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] => Las Colinas #37 (Casa Amanecer)
        )

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

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

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

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

    [ffd_website_status] => Array
        (
            [0] => Sold
        )

    [wpcf-keywords] => Array
        (
            [0] => Ocean Las Colinas #37 (Casa Amanecer) Single Family Home 21-4315ResaleLas ColinasSold
        )

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

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

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

    [pba__Listing_Website__c] => Array
        (
            [0] => https://qcabo.com/properties/las-colinas-37-casa-amanecer/
        )

    [ffd_media] => Array
        (
            [0] => a:10:{i:0;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/w7yuwg63y/10.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/4i1k5n5uc/1%20copia.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/ray2bup6k/2.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/gg2a5j7ut/3.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/yk8o70aj3/4.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/ymvq3f795/5.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/dbyemyl4i/6.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/8kwonmjqh/7.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/494fitigu/8.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/ay6e9mh83/9.jpg";}
        )

    [ffd_featured_image] => Array
        (
            [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/w7yuwg63y/10.jpg
        )

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

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

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

)

Las Colinas #37 (Casa Amanecer)

4 | 4 | 1
5,466 A/C sqftSingle Family HomeSold

Property Summary

An amazing opportunity to own a panoramic ocean view and energy-efficient residence within the masterplanned community of Querencia. The main and lower levels have a frameless glass railing, serving up vistas of endless ocean views from all the bedrooms and even the kitchen, living room and dining room. This elegant, turn-key 4-bedroom, 4.5-bathroom home offers tremendous value. It was built with myriad of elegant details, an open-concept floorplan integrating a large living room, spacious dining room and a chef's kitchen with pristine granite countertops. The upper-level patio offers relaxing and lounging areas with a swimming pool and hot tub and the lower-level terrace has an entertaining area with pool table, TV and a comfortable seating area.The house also includes a state-of-the-art media room with a large screen TV. The garage is conveniently located on the main level with convenient access to the house.Connect with Sales

Property Inquiry

USA: 833.507.2226MEX: 011.52.624.145.6615

    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