This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/39
$525,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/39
Property Description
First showings Saturday from 11 AM to 2 PM. Stunning mountain and sunset views frame this beautifully maintained home in the upper La Quinta Cove, just steps from the Bear Creek Oasis Trail. Freshly painted inside and out, the home offers an open-concept floor plan connecting the kitchen, dining, and living areas--ideal for both everyday living and entertaining.French doors from the kitchen, primary bedroom, and guest bedroom open to a private backyard retreat featuring a sparkling pool that lights up at night, a covered patio, and a spacious yard designed for relaxing, entertaining, or enjoying the desert evenings. The backyard is fully tiled for easy maintenance and includes a convenient AstroTurf dog run along the side yard.Interior highlights include travertine tile flooring in the main living areas and updated tile flooring in the bedrooms, double-pane thermal windows, solar tubes for natural lighting and a fully remodeled primary bathroom with heated bidet. The home also features updated appliances including refrigerator and washer/dryer, plus newer A/C and water heater (approximately two years old).Located in a quiet Upper Cove neighborhood with beautiful surrounding mountains, this home offers the perfect blend of location, comfort, views, and the La Quinta lifestyle.
Full Property Details
Full Property Details for 54140 Avenida Herrera
General
- Price: $525,000
- Status: Active
- Type: Single Family
- Source: Desert_Area_Palm_Springs
- MLS ID: 219145028
- Updated: 3/18/2026
- Added to Site: 8 day(s) ago
Interior
- Rooms/Areas: Family Room, Breakfast
- Fireplace: Yes
- Number of Fireplaces: 1
- Fireplace(s): Living Room, Other
- Furnishings: Unfurnished
- Flooring: Travertine, Tile
Rooms
Bathrooms
- Total Bathrooms: 2
- Full Bathrooms: 2
Bedrooms
- Total Bedrooms: 3
Additional Information
- Pool: Yes
- Pool Description: Private, Private, Private
- Security/Safety: Other
Parking
- Garage: Yes
- Garage Spaces: 2
- Total Spaces: 2
- Parking: On Street, Driveway
- Garage Description: Attached
Location
- Area: 313 -La Quinta South of HWY 111
- County: Riverside
- Subdivision: La Quinta Cove
- Cross Streets: Calle Madrid & Ave Herrera
Heating & Cooling
- Cooling Type: Air Conditioning, Central Air, Ceiling Fan(s)
- Heating Type: Central, Fireplace(s)
Utilities
- Sewer: In, Connected and Paid
Structural Information
- Sprinklers: Yes
- Stories/Levels: 1
- Square Feet: 1,318
- Sq. Ft. Source: Assessor
- Year Built: 1980
- Year Built Source: Assessor
Lot Features
- Mountain views: Yes
- Lot Size (Sq. Ft.): 5,227
- Lot Size Source: Assessor
- Irrigation System: Drip System
Financial Considerations
- Price Per Sq. Ft.: $398
- Terms: Cash to New Loan
Disclosures and Reports
- APN: 774214007
Listed by Equity Union, Justin R Smith
Get Pre-Approved Today
Schools
Schools serving 54140 Avenida Herrera
School District:Desert Sands Unified School District
| Name | Grades | Distance |
|---|---|---|
Harry S. Truman Elementary School 78-870 Ave. 50, La Quinta, CA 92253 | K-5 | 2.5 mi |
La Quinta Middle School 78-900 Ave. 50, La Quinta, CA 92253 | 6-8 | 2.6 mi |
La Quinta High School, La Quinta, CA 79-255 Blackhawk Way, La Quinta, CA 92253 | 9-12 | 4.4 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 54140 Avenida Herrera
Date
Details
Price
Change
Source
3/18/2026
Listed
$525,000
100%
MLS
3/31/2016
Sold
$262,500
—
Public Record
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
Tax History for 54140 Avenida Herrera
Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,610
3%
$310,740
2%
2024
$4,485
3%
$304,648
2%
2023
$4,352
4%
$298,676
2%
2022
$4,200
3%
$292,820
2%
2021
$4,094
2%
$287,079
1%
2020
$4,021
2%
$284,137
2%
2019
$3,942
2%
$278,566
2%
2018
$3,857
1%
$273,105
2%
2017
$3,801
15%
$267,750
18%
2016
$3,303
12%
$226,770
17%
2015
$2,951
2%
$194,000
3%
2014
$2,892
-11%
$189,000
-13%
2013
$3,240
—
$218,002
—
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
Estimate the Cost for 54140 Avenida Herrera
54140 Avenida Herrera, La Quinta, CA 92253 (MLS# 219145028) is a Single Family property with 3 bedrooms and 2 full bathrooms. 54140 Avenida Herrera is currently listed for $525,000 and was received on March 18, 2026. Want to learn more about 54140 Avenida Herrera? 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.

