54140 Avenida Herrera, La Quinta, CA 92253
$515,000
Property Type:
Residential
Bedrooms:
3
Baths:
2
Square Footage:
1,318
Status:
Active Under Contract
Current Price:
$515,000
List Date:
3/18/2026
Last Modified:
5/17/2026
Description
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.
More Information MLS# 219145028
Listing, Location and Property Info
Entry Date: 2026-03-18
Land Type: Fee
General Property Information
Fireplace: Yes
Building # of Stories: 1
Total Fireplaces: 1
Pool: Yes
Garage: Yes
Garage Description: Attached
Sprinklers: Yes
Furnished: Unfurnished
Total Bedrooms: 3
Full Baths: 2
Approx SqFt: 1318
Total Baths: 2
SqFt Source: Assessor
Lot Size: 5227
Lot Size Source: Assessor
Year Built: 1980
Cross Streets: Calle Madrid & Ave Herrera
Listing Info
Short Term Rentals: No
Will Consider Lease: No
Tax Info
Tax Mello Roos: No
Property Info
View: Yes
Golf Course Within Development: No
Senior Community: No
Gated Community: No
PUD Y/N: No
Total Monthly Association Fees: 0
Sale Type
Standard: 1
Listing Terms
Cash to New Loan: 1
Parking Spaces/Information
Total Covered Spaces: 0
Total Uncovered/Assigned Spaces: 0
View Type
Mountain(s): 1
Irrigation
Drip System: 1
Disclosures
Property As Is: 1
Levels
Ground: 1
Flooring
Tile: 1
Travertine: 1
Cooling Type
Air Conditioning: 1
Ceiling Fan(s): 1
Central Air: 1
Pool Location
Private: 1
Pool Construction
In Ground: 1
Pool Description
Private: 1
Heating
Central: 1
Fireplace(s): 1
Fireplace Location
Living Room: 1
Fireplace Features
Other: 1
Rooms
Breakfast: 1
Family Room: 1
Security Safety
Other: 1
Sewer
In, Connected and Paid: 1
Parking
Driveway: 1
On Street: 1
HOA Information
HOA: No
Contingent Upon
Appraisal: 1
Inspection: 1
Land Lease Type
Fee Simple: 1
DPR
DPR Eligible: Yes
Listing Location and Property Info
APN: 774214007
Status: Active Under Contract
Listing Date: 2026-03-18
Original List Price: 525000
List Price: $515,000
Current Price: $515,000
Property Sub-Type: Single Family Residence
Street #: 54140
Street Name: Avenida Herrera
County: Riverside
State: CA
Zip Code: 92253
Area: 313 -La Quinta South of HWY 111
Country: US
Status Change Info
Status Change Date: 2026-05-07
Contingent: Active Under Contract
Parking SpacesInformation
Total Garage Spaces: 2
Total Parking Spaces: 2
Property Features
Sale Type: Standard
Listing Terms: Cash to New Loan
View Type: Mountain(s)
Irrigation: Drip System
Disclosures: Property As Is
Levels: Ground
Flooring: Tile; Travertine
Cooling Type: Air Conditioning; Ceiling Fan(s); Central Air
Pool Location: Private
Pool Construction: In Ground
Pool Description: Private
Heating: Central; Fireplace(s)
Fireplace Location: Living Room
Fireplace Features: Other
Rooms: Breakfast; Family Room
Security Safety: Other
Sewer: In, Connected and Paid
Parking: Driveway; On Street
Contingent Upon: Appraisal; Inspection
Land Lease Type: Fee Simple
Listing Office:
Equity Union
Listing Agent:
Justin R Smith
Last Updated: May - 17 - 2026
Information deemed reliable but not guaranteed.