Logo of Coldwell Banker Best Realty
Main Office 714.451.1700 Locations  |  Intranet  |  Log In
An open house is scheduled on Thu, 09/25/2025 11AM ~ 2PM
Property photo 1 of 54175 Avenida Madero, La Quinta
Property photo 2 of 54175 Avenida Madero, La Quinta
Property photo 3 of 54175 Avenida Madero, La Quinta
Property photo 4 of 54175 Avenida Madero, La Quinta
Property photo 5 of 54175 Avenida Madero, La Quinta
Property photo 6 of 54175 Avenida Madero, La Quinta
Property photo 7 of 54175 Avenida Madero, La Quinta
Property photo 8 of 54175 Avenida Madero, La Quinta
Property photo 9 of 54175 Avenida Madero, La Quinta
Property photo 10 of 54175 Avenida Madero, La Quinta
Property photo 11 of 54175 Avenida Madero, La Quinta
Property photo 12 of 54175 Avenida Madero, La Quinta
Property photo 13 of 54175 Avenida Madero, La Quinta
Property photo 14 of 54175 Avenida Madero, La Quinta
Property photo 15 of 54175 Avenida Madero, La Quinta
Property photo 16 of 54175 Avenida Madero, La Quinta
Property photo 17 of 54175 Avenida Madero, La Quinta
Property photo 18 of 54175 Avenida Madero, La Quinta
Property photo 19 of 54175 Avenida Madero, La Quinta
Property photo 20 of 54175 Avenida Madero, La Quinta
Property photo 21 of 54175 Avenida Madero, La Quinta
Property photo 22 of 54175 Avenida Madero, La Quinta
Property photo 23 of 54175 Avenida Madero, La Quinta
Property photo 24 of 54175 Avenida Madero, La Quinta
Property photo 25 of 54175 Avenida Madero, La Quinta
Property photo 26 of 54175 Avenida Madero, La Quinta
Property photo 27 of 54175 Avenida Madero, La Quinta
Property photo 28 of 54175 Avenida Madero, La Quinta
Property photo 29 of 54175 Avenida Madero, La Quinta
Property photo 30 of 54175 Avenida Madero, La Quinta
Property photo 31 of 54175 Avenida Madero, La Quinta
Property photo 32 of 54175 Avenida Madero, La Quinta
Property photo 33 of 54175 Avenida Madero, La Quinta
Property photo 34 of 54175 Avenida Madero, La Quinta
Property photo 35 of 54175 Avenida Madero, La Quinta
Property photo 36 of 54175 Avenida Madero, La Quinta
Property photo 37 of 54175 Avenida Madero, La Quinta
Property photo 38 of 54175 Avenida Madero, La Quinta
Property photo 39 of 54175 Avenida Madero, La Quinta
Click the above photo to start slide show
54175 Avenida Madero
La Quinta, CA 92253
La Quinta South of HWY 111 Area
Price:$725,000
$457.12 / Sq.Ft.
Bedroom:3Bathroom:2
Sq. Ft.:1,586Year Built:1993
Type:Single Family Residence, Detached
MLS #:219134671DAStatus:Active
Listed:8/31/2025Modified:9/22/2025
 Take a Virtual Tour of this property 

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!
Rooms Amenities
  • 3 Bedrooms
  • 0 Full Bath
  • 2 3/4 Baths
  • Bedrooms: Formal Entry, Living Room, Master Suite
  • Dining: Breakfast Nook, Formal Dining Room
  • View: Mountain, Peek-A-Boo
 
  • Parking: Direct Garage Access, Garage Door Opener
  • # of Garages: 2
  • Pool: In Ground, Pebble, Heated with Electricity
  • Spa: Heated, In Ground
  • Appliances: Electric Range, Microwave, Electric Oven, Refrigerator, Propane Water Heater
Interior Exterior/Structural
  • Heating: Forced Air, Electric, Propane
  • Cooling: Central
 
  • Stories: One Level
  • Style: Spanish
  • Roof: Roll, Tile
  • Patio: Concrete, Enclosed
Lot Description Community/Association
  • Lot Sq. Ft.: 4,792
  • Acres: 0.11
 
  • Riverside County
  • Area: La Quinta South of HWY 111
  • School District: Desert Sands Unified
  • HOA:  +
  • Builder Tract: La Quinta Cove
Price Information Listing Information
  • Current Price: $725,000
  • Original Price: $725,000
  • Price/Sq. Ft.: $457.12
 
  • List Type: Standard
  • Listed Date: 8/31/2025
  • Modified Date: 9/22/2025
Listing Agent Listing Office
 Coldwell Banker Realty
Laurie Briggs Coldwell Banker Realty
  Mortgage Calculator
 Price For Sale:
 Down Payment Rate:
 Mortgage Amount:
 Mortgage Term:
 Interest Rate: %
 Monthly Payment:
  Need Help?
Michelle Kwon
Michelle Kwon
DRE# 01361657
Call 714-335-0500
to refer to MLS # 219134671DA
  Get a new challenge
Contact Agent button


Aerial View  
Nearby Similar Home Sales[Map all] 
1
Property photo of 54510 Avenida Madero0.19 miles
54510 Avenida Madero
$759,000
4 brs/2 bas/1,470 sf
2
Property photo of 54445 Avenida Alvarado0.23 miles
54445 Avenida Alvarado
$545,000
3 brs/2 bas/1,430 sf
3
Property photo of 54660 Avenida Madero0.25 miles
54660 Avenida Madero
$749,000
3 brs/2 bas/1,739 sf
4
Property photo of 54677 Avenida Diaz0.28 miles
54677 Avenida Diaz
$650,000
2 brs/2 bas/1,465 sf
5
Property photo of 77305 Calle Colima0.34 miles
77305 Calle Colima
$489,900
3 brs/2 bas/1,439 sf
6
Property photo of 77445 Calle Potrero0.37 miles
77445 Calle Potrero
$610,000
3 brs/2 bas/1,524 sf
7
Property photo of 53545 Avenida Ramirez0.44 miles
53545 Avenida Ramirez
$674,000
3 brs/2 bas/1,479 sf
8
Property photo of 53265 Avenida Obregon0.5 miles
53265 Avenida Obregon
$495,000
3 brs/2 bas/1,537 sf
9
Property photo of 53045 Avenida Obregon0.6 miles
53045 Avenida Obregon
$575,000
4 brs/2 bas/1,441 sf
10
Property photo of 52851 Avenida Herrera0.78 miles
52851 Avenida Herrera
$535,000
3 brs/2 bas/1,491 sf
11
Property photo of 52300 Avenida Velasco1.05 miles
52300 Avenida Velasco
$769,000
3 brs/3 bas/1,609 sf
12
Property photo of 52200 Avenida Velasco1.09 miles
52200 Avenida Velasco
$675,000
3 brs/2 bas/1,405 sf
13
Property photo of 51800 Avenida Ramirez1.23 miles
51800 Avenida Ramirez
$579,000
3 brs/2 bas/1,539 sf
14
Property photo of 51910 Eisenhower DR1.24 miles
51910 Eisenhower DR
$471,000
3 brs/3 bas/1,635 sf
15
Property photo of 51605 Avenida Carranza1.3 miles
51605 Avenida Carranza
$729,000
3 brs/2 bas/1,534 sf
16
Property photo of 51885 Avenida Bermudas1.36 miles
51885 Avenida Bermudas
$620,000
3 brs/2 bas/1,600 sf
17
Property photo of 77181 Calle Mazatlan2.17 miles
77181 Calle Mazatlan
$875,000
3 brs/2 bas/1,591 sf
18
Property photo of 77129 Calle Mazatlan2.2 miles
77129 Calle Mazatlan
$718,000
2 brs/2 bas/1,389 sf
19
Property photo of 54970 Firestone2.44 miles
54970 Firestone
$579,999
2 brs/3 bas/1,410 sf
20
Property photo of 55730 Riviera2.45 miles
55730 Riviera
$745,000
3 brs/2 bas/1,627 sf

The information above, though secured from sources believed to be reliable, cannot be guaranteed. The buyer should independently verify this information to his/her satisfaction. Coldwell Banker Best Realty may or may not be the listing broker of this property. In either case, where allowed by law, Coldwell Banker Best Realty can represent you in the purchase of this property.

Based on information from California Regional Multiple Listing Service, Inc. as of 9/22/2025. This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.

Zillow.com, Zillow, Zestimate, and Zindex are registered trademarks or trademarks of Zillow, Inc. ®Zillow, Inc. and suppliers. Any use of Zillow tools is subject to our general Terms of Use.