Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
3 Beds
3 Baths
1,904 sqft

$795,000

54474 Avenida Herrera, La Quinta CA, 92253

Price per sqft$417.54
Built in1967
Property size1,904 sqft
Property typeResidential
test courtesy

Overview

Active

Listed Aug 27, 2025

Updated Apr 10

Location, Location, Vacation! Welcome to Casabella, a SEXY Mid-Century Home w/Modern Flair Perched on a DOUBLE CORNER Lot with a Fully Equipped Detached GUEST HOUSE. Move-in Ready, HIGH in the Cove with Jaw Dropping Views of the Santa Rosa Mountains, the Floor Plan is Everything Today's Buyers Covet: BRIGHT and OPEN w/an Abundance of Natural Light. You'll Appreciate the Functional Floor Plan, the Neutral Color Schematic, a Generous Kitchen with a Quartz Island, a Versatile Room w/Murphy Bed, and Spacious Grounds w/a Private SPOOL. The Attached Guest House has a Bedroom, a Full Bath, Living Room, Functional Kitchen and a Separate Entrance, a Rare Feature for the LQ Cove. Other Notable Features are an Outdoor Shower and Numerous Conversation Areas Throughout, for Outdoor Enjoyment Amongst the Views. TURNKEY FURNISHED and Truly a Triple Option of Opportunity; a Primary Residence, a Vacation Getaway -or- a Fantastic Rental Opportunity that could be Ready for Revenue! BONUS: No HOA's, Close to Hiking/Biking Trails & Minutes from Shopping and Dining in Old Town, Golfing, the Polo/Concert Grounds and all that the Desert has to Offer!

$5,289/mo

Est. mortgage payment based on a $795,000 home price.

All estimates are provided by Luxury Presence for informational purposes only. Actual amounts may vary.

Additional information

MLS® ID
219134521DA

Interior Features

Bedrooms
3
Bathrooms
3

Exterior Features

Lot Size
0.23 Acres

Other Property Details

Pool
Yes
55+/Senior Community
No
MLS provider logo

Broker Reciprocity Courtesy of Cool Digs, T.J. McCaa

Website E2E - Playwright - Full Name

- Phone Number

[email protected] - Email

Jim Halpert - Brokerage Name

76321 - MLS License Number

 

Data last updated 7:19 AM UTC, 4/10/2026

 

Based on information from California Regional Multiple Listing Service, Inc. as of 4/10/2026. This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing.  Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.

 

©2026  CA - California Regional Multiple Listing Service, Inc. (CRMLS). All rights reserved.

Powered by Luxury Presence