25-3636 – Casa Huerta Cornucopia

1 / 29

2 / 29

3 / 29

4 / 29

5 / 29

6 / 29

7 / 29

8 / 29

9 / 29

10 / 29

11 / 29

12 / 29

13 / 29

14 / 29

15 / 29

16 / 29

17 / 29

18 / 29

19 / 29

20 / 29

21 / 29

22 / 29

23 / 29

24 / 29

25 / 29

26 / 29

27 / 29

28 / 29

29 / 29

+20 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
                )

        )

)