x
Showing 1 of 0
X
Save

51905 Avenida Herrera
La Quinta CA 92253 US

$515,000

Active Listing ID 219107921
bed icon
3 bed
bath icon
2.00 Bath (2 Full Bath)
home icon
Single Family Residence

$515,000

Active Listing ID 219107921
Save

51905 Avenida Herrera Nestled in the serene La Quinta Cove, this charming home offers 3 bedrooms, 2 bathrooms, and a bonus family room. With fresh paint, new carpeting, and updated lighting fixtures, it exudes a refreshing ambiance. Vaulted ceilings and an open floor plan create an inviting atmosphere, perfect for both relaxation and entertainment. The primary bedroom features a dual sink vanity and glass sliders leading to the pristine, low-maintenance backyard bordered by block walls for privacy. A bonus family room provides versatility as an entertainment space, den, or home office. Both guest bedrooms are spacious and separated from the primary bedroom for privacy. Situated near picturesque hiking trails and just a stone's throw from the vibrant shopping and dining scene of Old Town La Quinta, this home offers both tranquility and convenience.

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 2
  • Exterior Finish: Back Yard, Front Yard, Covered
  • Floor Covering: Carpet, Tile, Tile - Ceramic
  • Roof Type: Tile
  • Heating Fuels: Central Furnace, Fireplace
  • Additional Features
  • Fireplace

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 515000
  • unparsedaddress: 51905 Avenida Herrera
  • postalcity: La Quinta
  • stateorprovince: CA
  • country: US
  • postalcode: 92253
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0
  • lotsizeunits: Acres
  • livingarea: 1778
  • livingareaunits: Square Feet
  • latitude: 33.671396
  • longitude: -116.310059
  • listagentfullname: Felipe Hernandez
  • listagentemail: felipe.hernandez@equityunion.com
  • listagentkey: 3yd-CDARCA-D82305
  • listagentmlsid: D82305
  • listagentpreferredphone: 7602182583
  • listagentofficephone: 8189892000
  • listofficekey: 3yd-CDARCA-d24281
  • listofficemlsid: d24281
  • disclaimer: Copyright © 2024 California Desert Association of REALTORS®, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: CDARCA
  • yearbuilt: 2005
  • listingcontractdate: 2024-03-04
  • listagenturl: https://equityunion.com
  • countyorparish: Riverside
  • appliances: Cooktop, Cooktop - Gas, Dishwasher, Dryer, Oven - Gas, Washer
  • constructionmaterials: Stucco
  • flooring: Carpet, Tile, Tile - Ceramic
  • heating: Central Furnace, Fireplace
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 6
  • parkingfeatures: Driveway, Garage
  • roof: Tile
  • view: Mountain
  • waterfrontyn: False
  • interiorfeatures: Vaulted Ceiling(s)
  • exteriorfeatures: Back Yard, Front Yard, Covered
  • architecturalstyle: Other
  • rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -116.310059, 33.671396
  • customfields: {"AlternatePrices":[], "Expenses":[], "Neighborhoods":[], "Taxes":[], "ListPriceCurrencyType":"USD", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/51905-Avenida-Herrera_La-Quinta_CA_92253_M23186-97325?f=listhub&s=CDARCA&m=219107921&c=rexren", "LeadRoutingEmail":"felipe.hernandez@equityunion.com", "BrokerName":"Equity Union Real Estate", "ListingTitle":"Single Family Residence - La Quinta, CA", "ListOfficeBrokerMlsId":"d84721", "ListOfficeEmail":"veronica@equityunion.com", "ListOfficeAddress1":"44495 Town Center Way Ste. B", "ListOfficeAddress2":null, "ListOfficeCity":"Palm Desert", "ListOfficePostalCode":"92260", "ListOfficeStateOrProvince":"CA", "ListOfficeCountry":"US", "BuilderPhone":null, "BuilderFax":null, "BuilderEmail":null, "UnparsedAddress":null, "UnitNumber":null, "City":null, "StateOrProvince":null, "PostalCode":null, "Country":null, "ListBrokerageName":"Equity Union Real Estate", "ListBrokeragePhone":"(818) 631-1660", "ListBrokerageEmail":"veronica@equityunion.com", "ListBrokerageWebsiteUrl":"https://equityunion.com", "ListBrokerageLogoUrl":null, "ListBrokerageUnparsedAddress":"13412 VENTURA BLVD", "ListBrokerageUnitNumber":"STE 350", "ListBrokerageCity":"Sherman Oaks", "ListBrokerageStateOrProvince":"CA", "ListBrokeragePostalCode":"91423", "ListBrokerageCountry":"US", "RoomCount":null, "GeocodeOptions":null, "MLSModificationTimestamp":"2024-03-22T22:07:06Z"}
Listing Changed: 3/26/2024 3:12:37 PM GMT
Source Updated Date: 4/27/2024 6:43:39 AM GMT

Courtesy of: Felipe Hernandez, Equity Union, felipe.hernandez@equityunion.com

Copyright © 2024 California Desert Association of REALTORS®, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

}