25-3636 – Casa Huerta Cornucopia

1 / 34

2 / 34

3 / 34

4 / 34

5 / 34

6 / 34

7 / 34

8 / 34

9 / 34

10 / 34

11 / 34

12 / 34

13 / 34

14 / 34

15 / 34

16 / 34

17 / 34

18 / 34

19 / 34

20 / 34

21 / 34

22 / 34

23 / 34

24 / 34

25 / 34

26 / 34

27 / 34

28 / 34

29 / 34

30 / 34

31 / 34

32 / 34

33 / 34

34 / 34

+25 photos

SJD Corr-Inland

Santa Anita, Lomas del Tule

Casa Huerta Cornucopia

$ 890,000 USD$ 16,910,000 MXN

13,243 sqft

REQUEST A TOUR

CONTACT AGENT

DESCRIPTION

Welcome to Casa Huerta Cornucopia, a warm and character-filled Mexican hacienda nestled in the peaceful Lomas del Tule neighborhood. Set on a spacious 1,230.78 m² lot, this 3-bedroom, 3.5-bathroom home offers the charm of traditional architecture, ocean views, and a unique lifestyle surrounded by nature.

LOCATION

Address: Santa Anita, Lomas del Tule
Area: SJD Corr-Inland
ZIP:
Country: México
State:
City: San Jose Corridor

Open in Google Maps

General

Total sqft: 13,243.19sqft

Definiciones Estándar

On market date: July 21, 2025 7:30 pm
Property Name: Casa Huerta Cornucopia

Detalles de la Unidad

Terrace: Sí
Pool: Sí
Patio: Sí
Garden: Sí

Amenidades Generales

Gated: Sí

Información del Desarrollo

Development Name: El Tule-Inland:General

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

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

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

        )

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

                    [operator] => IN
                )

        )

)