25-3636 – Casa Huerta Cornucopia

1 / 24

2 / 24

3 / 24

4 / 24

5 / 24

6 / 24

7 / 24

8 / 24

9 / 24

10 / 24

11 / 24

12 / 24

13 / 24

14 / 24

15 / 24

16 / 24

17 / 24

18 / 24

19 / 24

20 / 24

21 / 24

22 / 24

23 / 24

24 / 24

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

        )

)