Keegan Cin | Realtor® | License # DRE 01971604

Property

La Quinta, CA 92253 54474 Avenida Herrera

54474 Avenida Herrera La Quinta, CA - Image 154474 Avenida Herrera La Quinta, CA - Image 254474 Avenida Herrera La Quinta, CA - Image 3
51 more
54474 Avenida Herrera La Quinta, CA - Image 454474 Avenida Herrera La Quinta, CA - Image 554474 Avenida Herrera La Quinta, CA - Image 654474 Avenida Herrera La Quinta, CA - Image 754474 Avenida Herrera La Quinta, CA - Image 854474 Avenida Herrera La Quinta, CA - Image 954474 Avenida Herrera La Quinta, CA - Image 1054474 Avenida Herrera La Quinta, CA - Image 1154474 Avenida Herrera La Quinta, CA - Image 1254474 Avenida Herrera La Quinta, CA - Image 1354474 Avenida Herrera La Quinta, CA - Image 1454474 Avenida Herrera La Quinta, CA - Image 1554474 Avenida Herrera La Quinta, CA - Image 1654474 Avenida Herrera La Quinta, CA - Image 1754474 Avenida Herrera La Quinta, CA - Image 1854474 Avenida Herrera La Quinta, CA - Image 1954474 Avenida Herrera La Quinta, CA - Image 2054474 Avenida Herrera La Quinta, CA - Image 2154474 Avenida Herrera La Quinta, CA - Image 2254474 Avenida Herrera La Quinta, CA - Image 2354474 Avenida Herrera La Quinta, CA - Image 2454474 Avenida Herrera La Quinta, CA - Image 2554474 Avenida Herrera La Quinta, CA - Image 2654474 Avenida Herrera La Quinta, CA - Image 2754474 Avenida Herrera La Quinta, CA - Image 2854474 Avenida Herrera La Quinta, CA - Image 2954474 Avenida Herrera La Quinta, CA - Image 3054474 Avenida Herrera La Quinta, CA - Image 3154474 Avenida Herrera La Quinta, CA - Image 3254474 Avenida Herrera La Quinta, CA - Image 3354474 Avenida Herrera La Quinta, CA - Image 3454474 Avenida Herrera La Quinta, CA - Image 3554474 Avenida Herrera La Quinta, CA - Image 3654474 Avenida Herrera La Quinta, CA - Image 3754474 Avenida Herrera La Quinta, CA - Image 3854474 Avenida Herrera La Quinta, CA - Image 3954474 Avenida Herrera La Quinta, CA - Image 4054474 Avenida Herrera La Quinta, CA - Image 4154474 Avenida Herrera La Quinta, CA - Image 4254474 Avenida Herrera La Quinta, CA - Image 4354474 Avenida Herrera La Quinta, CA - Image 4454474 Avenida Herrera La Quinta, CA - Image 4554474 Avenida Herrera La Quinta, CA - Image 4654474 Avenida Herrera La Quinta, CA - Image 4754474 Avenida Herrera La Quinta, CA - Image 4854474 Avenida Herrera La Quinta, CA - Image 4954474 Avenida Herrera La Quinta, CA - Image 5054474 Avenida Herrera La Quinta, CA - Image 5154474 Avenida Herrera La Quinta, CA - Image 5254474 Avenida Herrera La Quinta, CA - Image 5354474 Avenida Herrera La Quinta, CA - Image 5454474 Avenida Herrera La Quinta, CA - Image 55
Presented By: T.J. McCaa with Cool Digs;
  • MLS# 219128366DA
  • 04/12/2025
  • Request Tour
  • Request Info
  • Beds • 3
  • Baths • 3
  • SQFT • 1,904
  • Garage • 2
  • Year Built • 1967

Home Details

Location, Location, Vacation! Welcome to Casabella, a SEXY Mid-Century Home w/Modern Flair Perched on a DOUBLE CORNER Lot with a Fully Equipped Guest House. Move-in Ready 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!
Presented By: T.J. McCaa with Cool Digs;

Interior Features for 54474 Avenida Herrera

Bedrooms

Total Bedrooms3

Bathrooms

Half Baths0
Total Baths3
1/4 Baths
3/4 Baths

Other Interior Features

Air Conditioning Y/NYes
Basement (Y/N)No
Fireplace Y/NNo
FlooringTile
Heating Y/NYes
Laundry FeaturesInGarage
LivingAreaSourceAssessor
Total Stories1
Window FeaturesBlinds, Drapes

General for 54474 Avenida Herrera

Additional Parcels Y/NNo
AppliancesDishwasher, ElectricCooktop, ElectricCooking, ElectricOven, Disposal, GasWaterHeater, Microwave, Refrigerator, VentedExhaustFan
Attached Garage Yes
Carport Spaces0.0
Carport Y/NNo
CityLa Quinta
Construction MaterialsStucco
CoolingCentralAir
CountyRiverside
DirectionsTake Eisenhower to Call Temecula and turn Left. Home is on the corner of Calle Temecula and Avenida Herrera Cross Street: Calle Temecula.
DisclosuresHomeWarranty
ElectricVolts220InGarage
Electric On Property Y/NNo
Elementary SchoolTruman
Full Baths3
Garage Spaces2.0
Garage Y/NYes
HOANo
HeatingCentral, ForcedAir, Propane, NaturalGas
High SchoolLa Quinta
High School DistrictDesert Sands Unified
Home Warranty Y/NNo
Interior FeaturesBreakfastBar, SeparateFormalDiningRoom, Furnished, BedroomOnMainLevel, MainLevelPrimary, PrimarySuite, WalkInClosets
Land Lease Y/NNo
Lease Considered Y/NNo
Lease Renewal Y/NNo
LevelsOne
Listing TermsCash, CashToNewLoan, Conventional
Lot Size Square Feet10019.0
Lot Size UnitsSquareFeet
MLS Area313 - La Quinta South of HWY 111
Middle/Junior High SchoolLa Quinta
MobileHomeRemainsYNNo
New ConstructionNo
Occupancy TypeVacant
Open Parking Spaces2.0
Other StructuresGuestHouse
Patio/Porch FeaturesCovered
Pool FeaturesGunite, ElectricHeat, InGround, Private, Tile, Waterfall
PossessionCloseOfEscrow
Property Attached Y/NNo
Property ConditionUpdatedRemodeled
Property Sub Type AdditionalSingleFamilyResidence
Property SubtypeSingleFamilyResidence
Property TypeResidential
Rent Control Y/NNo
RoofFoam
Security FeaturesSecurityGate
Senior Community Y/NNo
Special Listing ConditionsStandard
Standard StatusActive
StatusActive
Stories1
Subdivision NameLa Quinta Cove
UtilitiesCableAvailable
ViewMountains, Panoramic
Walk Score0
Waterfront Y/NNo
Year Built1967
Year Built SourceAssessor
ZoningR-1

Exterior for 54474 Avenida Herrera

Crops Included Y/NNo
Door FeaturesFrenchDoors, SlidingDoors
FencingStuccoWall
Foundation DetailsSlab
Horse Y/NNo
InclusionsTurnkey minus personal clothing and two pieces of art in the living room
Irrigation Water Rights Y/NNo
Lot FeaturesTwoToFiveUnitsAcre, BackYard, CornerLot, DripIrrigationBubblers, Landscaped, RectangularLot, SprinklersTimer, SprinklerSystem
Lot Size Acres0.23
Lot Size Area10019.0
Lot Size SourceAssessor
Open Parking Y/NNo
Parking FeaturesDriveway, Garage, GarageDoorOpener, SideBySide
Private PoolYes
SpaNo
Total Parking4.0

Additional Details

Price History

Schools

High School La Quinta High School
Middle School La Quinta Middle School
Elementary School Truman Elementary School

Alexandra Eston

Sales Associate
Price $949,000
MLS#219128366DA
List Date 04/12/2025
Property Type Single Family
Request Tour
Request Info
Visit My Website

Similar Properties to 54474 Avenida Herrera

Skip to content