Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$649,000

  • For Sale
  • Under Contract
  • Single Family
  • 3 Beds
  • 2 Partial Baths
  • 1,586 Sq. Ft.
  • 2 Car Garage
  • Updated 2 days ago
See This Home
Save This Home
See This Home
Save This Home
Welcome to your private desert retreat in sought-after La Quinta Cove! This Santa Fe-style home blends charm, character, and modern updates with breathtaking views of the Santa Rosa & San Jacinto Mountains. A gated front courtyard welcomes you with an outdoor kitchen/BBQ, firepit & a covered seating area - perfect for relaxing or entertaining while enjoying colorful sunrises in total privacy. Inside, the open living area features polished concrete floors, transom windows, custom built-ins, and a striking custom fireplace. The fully renovated kitchen offers quartz countertops, stainless steel appliances & a breakfast bar opening to the dining space. The backyard is a true resort escape with a covered sitting area & a sparkling pool/spa, framed by dramatic mountain vistas. Perfect as a primary home, vacation retreat, or investment, this property is located near hiking and biking trails, the shops & restaurants of Old Town La Quinta, the Empire Polo Club (Coachella & Stagecoach) & the Indian Wells Tennis Garden (BNP Paribas Open). A rare opportunity to own a stylish Santa Fe home in one of La Quinta's most desirable locations!

Full Property Details for 54175 Avenida Madero

General

  • Price: $649,000
  • Status: Under Contract
  • Type: Single Family
  • Source: Desert_Area_Palm_Springs
  • MLS ID: 219134671
  • Updated: 1/15/2026
  • Added to Site: 139 day(s) ago

Interior

  • Rooms/Areas: Formal Entry, Dining Area, Living Room
  • Interior Features: High Ceilings (9 Ft+)
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Living Room, Wood
  • Eating Areas: Breakfast Nook, Dining Area
  • Appliances: Dryer, Electric Range, Microwave Oven, Electric Oven, Washer, Refrigerator
  • Furnished: Yes
  • Furnishings: Turnkey
  • Flooring: Concrete, Tile
  • Windows/Treatment: Custom Window Covering
  • 220 Volt Locations: In Garage

Rooms

Bathrooms

  • Total Bathrooms: 2
  • 3/4 Bathrooms: 2
  • Bathroom Features: Double Vanity(s), Tile Shower, Remodeled

Bedrooms

  • Total Bedrooms: 3
  • Bedroom Features: Primary Suite

Other Rooms

  • Kitchen: Greenhouse Window, Quartz Counters, Remodeled
  • Laundry: In Garage

Additional Information

  • Pool: Yes
  • Pool Description: Heated, In Ground, Heated, In Ground, Private
  • Spa: Yes
  • Spa Description: In Ground, Pebble, Heated, Heated - Propane
  • Security/Safety: Other

Exterior

  • Deck/Patio: Concrete Slab, Enclosed

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Total Spaces: 2
  • Parking: Direct Entrance, Garage Door Opener
  • Garage Description: Attached

Location

  • Area: 313 -La Quinta South of HWY 111
  • County: Riverside
  • Subdivision: La Quinta Cove
  • Cross Streets: Eisenhower to Chillion; right to Avenida Madero
  • Direction Faces: Leisure Faces West

School Information

  • School District: Desert Sands Unified

Heating & Cooling

  • Cooling Type: Air Conditioning, Other, Central Air, Ceiling Fan(s)
  • Heating Type: Forced Air, Other
  • Heating Fuel: Electricity, Propane Gas
  • Water Heater: Propane

Utilities

  • Sewer: In, Connected and Paid
  • Water District: CVWD
  • Water: Water District

Structural Information

  • Architectural Style: Spanish
  • Exterior Const.: Stucco
  • Foundation: Slab
  • Roof: Rolled/Hot Mop, Tile
  • Doors: Sliding Doors
  • Sprinklers: Yes
  • Entry Floor Number: 1
  • Entry Location: Ground Level - No Steps
  • Stories/Levels: 1
  • Square Feet: 1,586
  • Sq. Ft. Source: Assessor
  • Year Built: 1993
  • Year Built Source: Assessor
  • Property Condition: Updated/Remodeled

Lot Features

  • Mountain views: Yes
  • Lot Size (Sq. Ft.): 4,792
  • Lot Size Source: Assessor
  • Irrigation System: Sprinkler System
  • Lot Description: Landscaped
  • Fencing (Description): Stucco Wall

Financial Considerations

  • Price Per Sq. Ft.: $409
  • Terms: Cash, Cash to New Loan

Disclosures and Reports

  • APN: 774192019
Buyer's Brokerage Compensation: Contact Listing Agent
Not binding unless confirmed by separate agreement among applicable parties.

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Meet the listing agent

Meet the listing agent
— 54175 Avenida Madero —

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 54175 Avenida Madero

School District:Desert Sands Unified School District
NameGradesDistance
Harry S. Truman Elementary School
78-870 Ave. 50, La Quinta, CA 92253
K-52.8 mi
La Quinta Middle School
78-900 Ave. 50, La Quinta, CA 92253
6-82.9 mi
La Quinta High School, La Quinta, CA
79-255 Blackhawk Way, La Quinta, CA 92253
9-124.6 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 54175 Avenida Madero Get Price Alerts and Save Property

Date
Details
Price
Change
Source
1/07/2026
Price Reduced
$649,000
-3.85%
MLS
11/09/2025
Price Reduced
$675,000
-2.88%
MLS
9/26/2025
Price Reduced
$695,000
-4.14%
MLS
8/31/2025
Listed
$725,000
52.63%
MLS
6/03/2019
Sold
$475,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 54175 Avenida Madero

Year
Property Taxes
Change
Tax Assessment
Change
2025
$7,293
2%
$529,865
2%
2024
$7,116
3%
$519,477
2%
2023
$6,931
3%
$509,293
2%
2022
$6,728
2%
$499,308
2%
2021
$6,573
2%
$489,519
1%
2020
$6,453
20%
$484,500
22%
2019
$5,387
28%
$397,697
32%
2018
$4,195
2%
$300,968
2%
2017
$4,133
6%
$295,068
7%
2016
$3,909
-1%
$277,000
1%
2015
$3,947
8%
$275,000
10%
2014
$3,656
22%
$251,000
26%
2013
$3,006
—
$199,000
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 54175 Avenida Madero

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Similar Properties near 54175 Avenida Madero

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

54725 Avenida Rubio, La Quinta, CA 92253 - Photo 1
$649,000

54725 Avenida Rubio  La Quinta, CA 92253

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
  • 1,529
    Sq. Ft.
53545 Avenida Ramirez, La Quinta, CA 92253 - Photo 1
$649,000
Open House

53545 Avenida Ramirez  La Quinta, CA 92253

  • Single Family
  • Active
  • Updated 12 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,479
    Sq. Ft.
54925 Avenida Alvarado, La Quinta, CA 92253 - Photo 1
$644,900
Open House

54925 Avenida Alvarado  La Quinta, CA 92253

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
  • 1,654
    Sq. Ft.
78310 Crest View Terrace, La Quinta, CA 92253 - Photo 1
$655,000

78310 Crest View Terrace  La Quinta, CA 92253

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
  • 1,550
    Sq. Ft.

Just Listed near 54175 Avenida Madero

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

78155 Cabrillo Ln, Indian Wells, CA 92210 - Photo 1 Just Listed
$360,000

78155 Cabrillo Ln  #38  Indian Wells, CA 92210

  • Condo
  • Active
  • Updated 1 day ago
  • 1
    Bed
  • 1
    Total Bath
  • 576
    Sq. Ft.
45595 Apache Rd, Indian Wells, CA 92210 - Photo 1 Just Listed
$2,195,000

45595 Apache Rd  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 6
    Total Baths
  • 3,897
    Sq. Ft.
75224 Citadel Pl, Indian Wells, CA 92210 - Photo 1 Just Listed
$2,050,000

75224 Citadel Pl  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 3,159
    Sq. Ft.
75160 Citadel Pl, Indian Wells, CA 92210 - Photo 1 Just Listed
$2,190,000
Open House

75160 Citadel Pl  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 3,159
    Sq. Ft.

Price Reduced near 54175 Avenida Madero

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

44190 Tahoe Cir, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$19,000 (-2.57%)
$720,000

44190 Tahoe Cir  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,432
    Sq. Ft.
75465 Montecito Dr, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$25,000 (-1.57%)
$1,570,000

75465 Montecito Dr  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,924
    Sq. Ft.
75180 Chippewa Dr, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$9,000 (-1.18%)
$755,000
Open House

75180 Chippewa Dr  Indian Wells, CA 92210

  • Condo
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,489
    Sq. Ft.
76101 Zuni Rd, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$5,000 (-0.31%)
$1,594,000

76101 Zuni Rd  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,941
    Sq. Ft.

Recent Sales near 54175 Avenida Madero

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

53745 Avenida Madero, La Quinta, CA 92253 - Photo 1 Sold
$620,000

53745 Avenida Madero  La Quinta, CA 92253

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,400
    Sq. Ft.
54330 Avenida Diaz, La Quinta, CA 92253 - Photo 1 Sold
$635,000

54330 Avenida Diaz  La Quinta, CA 92253

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,360
    Sq. Ft.
54465 Avenida Rubio, La Quinta, CA 92253 - Photo 1 Sold
$570,000

54465 Avenida Rubio  La Quinta, CA 92253

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,704
    Sq. Ft.
54100 Avenida Obregon, La Quinta, CA 92253 - Photo 1 Sold
$675,000

54100 Avenida Obregon  La Quinta, CA 92253

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,616
    Sq. Ft.

54175 Avenida Madero, La Quinta, CA 92253 (MLS# 219134671) is a Single Family property with 3 bedrooms, 0 full bathrooms and 2 partial bathrooms. 54175 Avenida Madero is currently listed for $649,000 and was received on August 31, 2025. This property is listed by The Briggs Group from our Indian Wells/La Quinta Office.Want to learn more about 54175 Avenida Madero? Do you have questions about finding other Single Family real estate for sale in La Quinta? You can browse all La Quinta real estate or contact a Coldwell Banker agent to request more information.

Tour this property