Sold for $787,000

Listed by: David Spiegel & Assoc. • Garrett Dylan • Contact: 818-995-3700

Bought with: Coldwell Banker Realty

$787,000

54060 Avenida Madero, La Quinta, CA 92253

4beds

1,870sqft

Single Family Residence

Built in 2018

5,227 Square Feet Lot

$790,600 Zestimate^®

$421/sqft

$5,390 Estimated rent

Home value

$790,600

$719,000 - $870,000

$5,390/mo

Zestimate^® history

Owner options

List your home for rent

$5,390/mo

Rent Zestimate^®

Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

Learn more

$5,390/mo

Rent Zestimate^®

Refinance and save

$5,081/mo

Est. payment

Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

See today's rates

$5,081/mo

Est. payment

Explore your selling options

Work with a Zillow partner agent

Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

Get started

List with your own agent

Get your home in front of millions of buyers by listing it on Zillow.

Learn how to do it

Sell it yourself

Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

List your home

What's special

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

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: $421/sqft
Tax assessed value: $358,522
Annual tax amount: $5,949
Date on market: 5/8/2025
Cumulative days on market: 259 days
Listing terms: Cash,Conventional

Price history

Date	Event	Price
4/30/2026	Sold	$787,000-0.4%$421/sqft
Source: CRMLS #SR25103024 Report a problem
2/4/2026	Pending sale	$789,950$422/sqft
Source: CRMLS #SR25103024 Report a problem
12/29/2025	Listed for sale	$789,950$422/sqft
Source: CRMLS #SR25103024 Report a problem
12/22/2025	Pending sale	$789,950$422/sqft
Source: CRMLS #SR25103024 Report a problem
10/9/2025	Listed for sale	$789,950-1.9%$422/sqft
Source: CRMLS #SR25103024 Report a problem
10/9/2025	Listing removed	$804,950-3%$430/sqft
Source: SDMLS #SR25103024 Report a problem
6/24/2025	Listed for sale	$829,950+1120.5%$444/sqft
Source: SDMLS #SR25103024 Report a problem
7/2/2019	Listing removed	$7,500$4/sqft
Source: Hacienda Group, Inc #219007629 Report a problem
3/11/2019	Listed for rent	$7,500$4/sqft
Source: Hacienda Group, Inc #219007629 Report a problem
9/19/2017	Sold	$68,000$36/sqft
Source: Public Record Report a problem

Public tax history

Year	Property taxes	Tax assessment
2025	$5,949 -0.7%	$358,522 +2%
2024	$5,990 +3.2%	$351,493 +2%
2023	$5,807 +7%	$344,602 +2%
2022	$5,426 +6.6%	$337,846 +2%
2021	$5,088 -19.7%	$331,223 -26.1%
2020	$6,339 +43.9%	$448,000 +39.4%
2019	$4,406 +288.4%	$321,400 +372.6%
2018	$1,134 +157.2%	$68,000 +97.3%
2017	$441	$34,472 +2%
2016	$441 +2.1%	$33,797 +1.5%
2015	$432 +1.6%	$33,291 +2%
2014	$425	$32,640 +0.4%
2013	--	$32,494 +2%
2012	--	$31,857 +2%
2011	--	$31,233 -55.4%
2010	--	$70,000
2009	--	$70,000 -22.2%
2008	--	$90,000 +557.6%
2007	--	$13,687 +2%
2006	--	$13,419 +2%
2005	--	$13,156 +3.9%
2003	--	$12,663 +2%
2002	--	$12,415 +2%
2001	$158 +1.7%	$12,172 +2%
2000	$155	$11,934