54140 Avenida Herrera, La Quinta, CA 92253 (MLS# 219145028)

54140 Avenida Herrera, La Quinta, CA 92253

$525,000
Property Type: Residential Bedrooms: 3 Baths: 2 Square Footage: 1,318 Status: Active
Current Price: $525,000 List Date: 3/18/2026 Last Modified: 3/29/2026

Overview

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 refrig ...

Listing Details MLS# 219145028

General Property Information

Total Bedrooms
3
Full Baths
2
Approx SqFt
1318
Total Baths
2
SqFt Source
Assessor
Fireplace
Yes
Total Fireplaces
Yes
Pool
Yes
Garage
Yes
Garage Description
Attached
Sprinklers
Yes
Building # of Stories
Yes
Lot Size Source
Assessor
Year Built
1980
Furnished
Unfurnished
Cross Streets
Calle Madrid & Ave Herrera

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 Land Lease Type: Fee Simple

Listing Location and Property Info

APN
774214007
Original List Price
525000
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

Listing Info

Short Term Rentals
No
Will Consider Lease
No

Tax Info

Tax Mello Roos
No

Property Info

Golf Course Within Development
No
Senior Community
No
Gated Community
No
PUD Y/N
No
View
Yes
Total Monthly Association Fees
0

More Information

Status Change Info

Status Change Date
2026-03-18

Parking SpacesInformation

Total Garage Spaces
2
Total Parking Spaces
2

HOA Information

HOA
No

DPR

DPR Eligible
Yes

Listing, Location and Property Info

Entry Date
2026-03-18
Land Type
Fee

Sale Type

Standard
Yes

Listing Terms

Cash to New Loan
Yes

Parking Spaces/Information

Total Covered Spaces
0
Total Uncovered/Assigned Spaces
0

View Type

Mountain(s)
Yes

Irrigation

Drip System
Yes

Disclosures

Property As Is
Yes

Levels

Ground
Yes

Flooring

Tile
Yes
Travertine
Yes

Cooling Type

Air Conditioning
Yes
Ceiling Fan(s)
Yes
Central Air
Yes

Pool Location

Private
Yes

Pool Construction

In Ground
Yes

Pool Description

Private
Yes

Heating

Central
Yes
Fireplace(s)
Yes

Fireplace Location

Living Room
Yes

Fireplace Features

Other
Yes

Rooms

Breakfast
Yes
Family Room
Yes

Security Safety

Other
Yes

Sewer

In, Connected and Paid
Yes

Parking

Driveway
Yes
On Street
Yes

Land Lease Type

Fee Simple
Yes
Listing Office: Equity Union
Listing Agent: Justin R Smith
Last Updated: March - 29 - 2026
Information deemed reliable but not guaranteed.
Search powered by FBS Products
Scroll to Top

Terms and Conditions