• explore homes
  • find an advisor
  • listing image 10995451966167021323 blurlisting image 10995451966167021323
  • listing image 10997428648119840175 blurlisting image 10997428648119840175
  • listing image 10997853314107082267 blurlisting image 10997853314107082267
  • listing image 10993689736872475059 blurlisting image 10993689736872475059
  • listing image 10991359954363119310 blurlisting image 10991359954363119310
  • listing image 10991516310761201911 blurlisting image 10991516310761201911
  • listing image 10993263840947817451 blurlisting image 10993263840947817451
  • listing image 10997173849982879692 blurlisting image 10997173849982879692
  • listing image 10997860322715799586 blurlisting image 10997860322715799586
  • listing image 10995023867117544825 blurlisting image 10995023867117544825
  • listing image 10998571513138507855 blurlisting image 10998571513138507855
  • listing image 10996474265049873228 blurlisting image 10996474265049873228
  • listing image 10998288432868981166 blurlisting image 10998288432868981166
  • listing image 10990456156806491123 blurlisting image 10990456156806491123
  • listing image 10995048709245207376 blurlisting image 10995048709245207376
  • listing image 10993119878055808703 blurlisting image 10993119878055808703
  • listing image 10990728669295718006 blurlisting image 10990728669295718006
  • listing image 10998989414403243346 blurlisting image 10998989414403243346
  • listing image 10998072654440648425 blurlisting image 10998072654440648425
  • listing image 10997828520303141693 blurlisting image 10997828520303141693
  • listing image 10991112944641533253 blurlisting image 10991112944641533253
  • listing image 10997700731863449380 blurlisting image 10997700731863449380
  • listing image 10991025419244953377 blurlisting image 10991025419244953377
  • listing image 10998727685098344803 blurlisting image 10998727685098344803
  • listing image 10999926535674400386 blurlisting image 10999926535674400386
  • listing image 10999909834573339195 blurlisting image 10999909834573339195
  • 1 / 26
Listed by: Jose Espinoza | OZA Realty
Sold Aug 03, 2015
$300,000

51675 Avenida Herrera, La Quinta CA

4beds
2baths
1,667sq ft
$179/sq ft
36 days on rennie- cumulative days on market
215014702MLS ®

PRIVATE Retreat/Compound in the Cove. Newly modernized from head-to-toe! This gorgeous hacienda has 3bdr/2bth PLUS a OFFICE/DEN or BDR and is nestled in the downtown area of La Quinta Cove. Standard Sale and move-in ready. You can now own this impressive La Quinta retreat complete with privacy walls. Situated on a Large Double Lot with majestic mountain views, these well-maintained grounds will impress any guest. Includes a bonus office/den or game-room with new laminate wood floors. An immaculate sparkling pool for those hot summer days! The modern open plan concept creates intimacy but yet is spacious. Brand new appliances and fixtures throughout, updated custom kitchen cabinets with new quartz counter tops, custom tiled floors, new paint, new carpet and recessed lighting & a fireplace to 'die-for'. Large lot allows parking for RV/Boat & toys. This breathtaking home/retreat is walking distance to Old Town' shopping/restaurants and has to be seen to be believed. Preview Toda

property details


HouseProperty type
10,018.8 ft²Lot area SF
$0Taxes
OneFloor levels
Mountain(s)Views
Back Yard, Landscaped, LevelFeatures included
Open Floorplan, Recessed LightingAmenities
SubareaLa Quinta Cove
Listed byOZA Realty
rennie last checkedApril 17, 2025 at 02:41pm
Last updatedOctober 04, 2024 at 09:20pm
Closed DateAugust 03, 2015
SourceDesertArea

Additional Details


Parking / Storage
ParkingBoat, Driveway
Parking places - total2
Additional building details
Complex / sub divisionLa Quinta Cove
Year Built1987
ConstructionStucco
FoundationSlab
RoofTile
Floor finishCarpet, Tile
FencingBlock
Sewer typeSeptic Tank
Fuel / heatingCentral, Natural Gas
Fireplaces1
Fireplace fueled byGas Log
interested in this home?
Our advisor team can provide guidance.

rennie group
copyright © 2025 rennie all rights reserved

By using this website, you agree to our Privacy Policy and Terms of Use.

do not share or sell my personal information

California DRE #02248150