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
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
Est.:
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
- 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#: SR25103024
Originating MLS: California Regional MLS

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
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
Video & virtual tour
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