Skip main navigation
For sale
  • Listing Provided by: 

    Garrett Dylan DRE #01821629 818-398-6406,

    David Spiegel & Assoc.

    Price cut: $20K (7/18)
    $809,950

    54060 Avenida Madero, La Quinta, CA 92253

    4beds
    1,870sqft
    : 
    Single Family Residence
    Built in 2018
    5,227 Square Feet Lot
    $-- Zestimate®
    $433/sqft
    $-- HOA

    What's special

    Heated pool and spaPrivate courtyardWest-facing mountain viewsQuartz countertopsStainless steel appliances
    Upper La Quinta Cove Gem! This beautiful mid-century modern home features 4 bedrooms and 3.5 baths, including a primary suite and a rare junior suite. Enjoy a like-new feel with a spacious great room, an oversized dining room, and a gourmet kitchen boasting quartz countertops and stainless steel appliances. Soak in breathtaking west-facing mountain views from your private courtyard, complete with a Pebble Tec pool and spa. The heated pool and spa ensure year-round enjoyment. For outdoor enthusiasts, this home is a hiker's dream, located just steps from the Santa Rosa Mountain trails. Furnishings are negotiable
    110 days
    on Zillow
    |
    268
    |
    16
    |

    Zillow last checked: 7 hours ago

    Listing updated: July 17, 2025 at 09:56pm

    Listing Provided by:

    Garrett Dylan DRE #01821629 818-398-6406,

    David Spiegel & Assoc.

    Source: CRMLS,MLS#: SR25103024MLS LogoOriginating MLS: California Regional MLS
    Travel times

    Tour with a buyer's agent

    We'll find a local expert to take you on a private tour of 54060 Avenida Madero.

    Next available tour time:Tomorrow at 9am

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    • Main level bathrooms: 4
    • Main level bedrooms: 4
    Rooms
    • Room types: Bedroom
    Bedroom
    • Features: All Bedrooms Down
    Heating
    • Central
    Cooling
    • Central Air
    Appliances
    • Included: Built-In Range, Convection Oven, Electric Oven
    • Laundry: Laundry Closet
    Features
    • Ceiling Fan(s), All Bedrooms Down
    • Has fireplace: No
    • Fireplace features: None
    • Common walls with other units/homes: No Common Walls
    Interior area
    • Total interior livable area: 1,870 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Attached
    • Attached garage spaces: 2
    Features
    • Levels: One
    • Stories: 1
    • Entry location: first
    • Has private pool: Yes
    • Pool features: Private
    • Has spa: Yes
    • Spa features: Private
    • Has view: Yes
    • View description: Mountain(s), Neighborhood
    Lot
    • Size: 5,227 Square Feet
    • Features: 0-1 Unit/Acre
    Details
    • Parcel number: 774193003
    • Zoning: R1
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Condition
    • New construction: No
    • Year built: 2018

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public

    Community & HOA

    Community
    • Features: Foothills, Hiking, Mountainous
    • Subdivision: La Quinta Cove*
    Location
    • Region: La Quinta

    Financial & listing details

    • Price per square foot: $433/sqft
    • Tax assessed value: $351,493
    • Annual tax amount: $5,990
    • Date on market: 5/8/2025
    • Cumulative days on market: 111 days
    • Listing terms: Cash,Conventional
    • Loading
    • Loading