24-2737 – Casa Huerta Cornucopia

1 / 58

2 / 58

3 / 58

4 / 58

5 / 58

6 / 58

7 / 58

8 / 58

9 / 58

10 / 58

11 / 58

12 / 58

13 / 58

14 / 58

15 / 58

16 / 58

17 / 58

18 / 58

19 / 58

20 / 58

21 / 58

22 / 58

23 / 58

24 / 58

25 / 58

26 / 58

27 / 58

28 / 58

29 / 58

30 / 58

31 / 58

32 / 58

33 / 58

34 / 58

35 / 58

36 / 58

37 / 58

38 / 58

39 / 58

40 / 58

41 / 58

42 / 58

43 / 58

44 / 58

45 / 58

46 / 58

47 / 58

48 / 58

49 / 58

50 / 58

51 / 58

52 / 58

53 / 58

54 / 58

55 / 58

56 / 58

57 / 58

58 / 58

+49 photos

SJD Corr-Inland

Lomas del Tule, C. Santa Anita

Casa Huerta Cornucopia

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

13,243 sqft

REQUEST A TOUR

CONTACT AGENT

DESCRIPTION

Discover the elegance and serenity of ”Casa Huerta Cornucopia,” a beautiful Mexican hacienda-style property located in the exclusive Lomas del Tule neighborhood. With spectacular ocean views, this furnished & equipped 3-bedroom, 3.5-bathroom home sits on a spacious 1,230.78 M2 lot, offering a tranquil and comfortable retreat. The living room, breakfast area, and terrace offer direct views of the Sea of Cortez, creating the perfect setting to enjoy a fresh breakfast with an impressive view. The spacious central patio and family pool are ideal for entertaining friends and family in a relaxed and private environment.

LOCATION

Address: Lomas del Tule, C. Santa Anita
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: November 6, 2024 5:16 pm
Property Name: Casa Huerta Cornucopia

Detalles de la Unidad

Terrace: Sí
Pool: Sí
Patio: Sí
Maids Quarters: Sí
Garden: Sí

Información del Desarrollo

Development Name: ResidenciasLomasTule

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
                )

        )

)