Skip to main content

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.

Hand Wave

Contact Darlene

Hi, I'm Darlene Harwick and I provide real estate service to buyers and sellers in the Palm Springs area.

Darlene Harwick
Contact Agent