23-4763 – Casa Dos Cuatro

1 / 25

2 / 25

3 / 25

4 / 25

5 / 25

6 / 25

7 / 25

8 / 25

9 / 25

10 / 25

11 / 25

12 / 25

13 / 25

14 / 25

15 / 25

16 / 25

17 / 25

18 / 25

19 / 25

20 / 25

21 / 25

22 / 25

23 / 25

24 / 25

25 / 25

+16 photos

SJD Corr-Inland

El Parque – Querencia

Casa Dos Cuatro

$ 5,858,000 USD$ 111,302,000 MXN

9,618 sqft

REQUEST A TOUR

CONTACT AGENT

DESCRIPTION

El Parque al Querencia is a refreshing retreat for single level Homes within a lush green Park designed to encourage outdoor living. Located just steps from Querencia´s Clubhouse and all its amenities, Casa Dos Cuatro has Flex rooms to convert to Movie Theater, Office, Gym or extra Guest bedrooms all in a Contemporary design and finishes. El Parque features 29 homesites looking over Mountains, Golf Fairways and the Sea of Cortez to create the ideal family-friendly neighborhood for those looking to experience all Querencia has to offer.

LOCATION

Address: El Parque – Querencia
Area: SJD Corr-Inland
ZIP:
Country: México
State:
City: San Jose Corridor

Open in Google Maps

General

Total sqft: 9,618.04sqft

Standard Fields

On market date: December 8, 2023 10:41 pm
Property Name: Casa Dos Cuatro

Unit Details

Terrace: Yes
Pool: Yes
Patio: Yes
Maids Quarters: Yes

Common Amenities

Beach Club: Yes
Gym: Yes
Gated: Yes
Golf: Yes
Tennis / Basketball Court: Yes

Development Information

Development Name: Section 10- El Parque

Array
(
    [numberposts] => 3
    [post_type] => mexlife-properties
    [type] => Houses
    [meta_query] => Array
        (
            [relation] => AND
            [0] => Array
                (
                    [key] => listing_price
                    [value] => Array
                        (
                            [0] => 4686400
                            [1] => 6736700
                        )

                    [compare] => BETWEEN
                    [type] => NUMERIC
                )

            [1] => Array
                (
                    [key] => beds_total
                    [value] => 5
                    [compare] => >=
                )

        )

    [tax_query] => Array
        (
            [0] => Array
                (
                    [taxonomy] => area
                    [terms] => Array
                        (
                            [0] => 17833
                        )

                    [operator] => IN
                )

        )

)