54474 Avenida Herrera, La Quinta

$729,000

Previous Next

3

Beds

3

Baths

1,904

Square feet

0.23

Acres

About 54474 Avenida Herrera

Location, Location, Vacation! Price Improvement on 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!

Do you plan to sell your home to buy this one?

Get your home evaluation

Features of 54474 Avenida Herrera

MLS® # 219134521DA
Price $729,000
Bedrooms 3
Bathrooms 3.00
Full Baths 3
Square Footage 1,904
Acres 0.23
Year Built 1967
Type Residential
Sub-Type Single Family Residence
Status Active

Community Information

Address 54474 Avenida Herrera
Area 313 - La Quinta South of HWY 111
Subdivision La Quinta Cove
City La Quinta
County Riverside
Zip Code 92253

Amenities

Utilities Cable Available
Parking Spaces 4
Parking Driveway, Garage, Garage Door Opener, Side By Side
# of Garages 2
Garages Driveway, Garage, Garage Door Opener, Side By Side
View Mountain(s), Panoramic
Is Waterfront No
Has Pool Yes
Pool Gunite, In Ground, Private, Tile, Electric Heat, Waterfall

Interior

Interior Tile
Interior Features Breakfast Bar, Separate/Formal Dining Room, Bedroom on Main Level, Main Level Primary, Primary Suite, Walk-In Closet(s), Furnished
Appliances Dishwasher, Electric Cooktop, Electric Oven, Disposal, Gas Water Heater, Microwave, Refrigerator, Vented Exhaust Fan
Heating Central, Forced Air, Natural Gas, Propane
Cooling Central Air
Has Basement No
Fireplace No
# of Stories 1
Stories One

Exterior

Exterior Stucco
Lot Description Back Yard, Drip Irrigation/Bubblers, Landscaped, Rectangular Lot, Sprinklers Timer, Sprinkler System, Corner Lot, TwoToFiveUnitsAcre
Windows Blinds, Drapes
Roof Foam
Construction Stucco
Foundation Slab

School Information

Elementary Truman
Middle La Quinta
High La Quinta

Additional Information

Date Listed April 12th, 2025
Days on Market 53
Foreclosure No
Short Sale No
RE / Bank Owned No

Listing Details

AgentT.j. Mccaa
OfficeCool Digs

Listing Map

Request a Showing

Provide a valid email address.
When would you like to view this property?

Work With Us

With over $750 Million in real estate sales, The Aaronson Group offers an unparalleled level of service to our highly respected clients. Whether you are looking to buy or sell your home, we guarantee that our expertise, professionalism & dedication will navigate you towards meeting your unique real estate needs.

Let’s Connect
Luxury Real Estate