Skip to Main Content
Contact Kim Barron
Contacting Kim Barron
  • All fields are required.
Schedule A Showing
Schedule a Showing.
  • All fields are required.
Check this box to Register with us:
Request more information
  1. Home
  2. Property Search
  3. Search results
  4. 54474 Avenida Herrera, La Quinta, CA 92253
Property Photos
54474 Avenida Herrera
  1. Image 0 of 56 For 54474 Avenida Herrera
  2. Image 1 of 56 For 54474 Avenida Herrera
  3. Image 2 of 56 For 54474 Avenida Herrera
  4. Image 3 of 56 For 54474 Avenida Herrera
  5. Image 4 of 56 For 54474 Avenida Herrera
  6. Image 5 of 56 For 54474 Avenida Herrera
  7. Image 6 of 56 For 54474 Avenida Herrera
  8. Image 7 of 56 For 54474 Avenida Herrera
  9. Image 8 of 56 For 54474 Avenida Herrera
  10. Image 9 of 56 For 54474 Avenida Herrera
  11. Image 10 of 56 For 54474 Avenida Herrera
  12. Image 11 of 56 For 54474 Avenida Herrera
  13. Image 12 of 56 For 54474 Avenida Herrera
  14. Image 13 of 56 For 54474 Avenida Herrera
  15. Image 14 of 56 For 54474 Avenida Herrera
  16. Image 15 of 56 For 54474 Avenida Herrera
  17. Image 16 of 56 For 54474 Avenida Herrera
  18. Image 17 of 56 For 54474 Avenida Herrera
  19. Image 18 of 56 For 54474 Avenida Herrera
  20. Image 19 of 56 For 54474 Avenida Herrera
  21. Image 20 of 56 For 54474 Avenida Herrera
  22. Image 21 of 56 For 54474 Avenida Herrera
  23. Image 22 of 56 For 54474 Avenida Herrera
  24. Image 23 of 56 For 54474 Avenida Herrera
  25. Image 24 of 56 For 54474 Avenida Herrera
  26. Image 25 of 56 For 54474 Avenida Herrera
  27. Image 26 of 56 For 54474 Avenida Herrera
  28. Image 27 of 56 For 54474 Avenida Herrera
  29. Image 28 of 56 For 54474 Avenida Herrera
  30. Image 29 of 56 For 54474 Avenida Herrera
  31. Image 30 of 56 For 54474 Avenida Herrera
  32. Image 31 of 56 For 54474 Avenida Herrera
  33. Image 32 of 56 For 54474 Avenida Herrera
  34. Image 33 of 56 For 54474 Avenida Herrera
  35. Image 34 of 56 For 54474 Avenida Herrera
  36. Image 35 of 56 For 54474 Avenida Herrera
  37. Image 36 of 56 For 54474 Avenida Herrera
  38. Image 37 of 56 For 54474 Avenida Herrera
  39. Image 38 of 56 For 54474 Avenida Herrera
  40. Image 39 of 56 For 54474 Avenida Herrera
  41. Image 40 of 56 For 54474 Avenida Herrera
  42. Image 41 of 56 For 54474 Avenida Herrera
  43. Image 42 of 56 For 54474 Avenida Herrera
  44. Image 43 of 56 For 54474 Avenida Herrera
  45. Image 44 of 56 For 54474 Avenida Herrera
  46. Image 45 of 56 For 54474 Avenida Herrera
  47. Image 46 of 56 For 54474 Avenida Herrera
  48. Image 47 of 56 For 54474 Avenida Herrera
  49. Image 48 of 56 For 54474 Avenida Herrera
  50. Image 49 of 56 For 54474 Avenida Herrera
  51. Image 50 of 56 For 54474 Avenida Herrera
  52. Image 51 of 56 For 54474 Avenida Herrera
  53. Image 52 of 56 For 54474 Avenida Herrera
  54. Image 53 of 56 For 54474 Avenida Herrera
  55. Image 54 of 56 For 54474 Avenida Herrera
  56. Image 55 of 56 For 54474 Avenida Herrera
View all images
  1. Image 0 of 56 For 54474 Avenida Herrera
  2. Image 1 of 56 For 54474 Avenida Herrera
  3. Image 2 of 56 For 54474 Avenida Herrera
  4. Image 3 of 56 For 54474 Avenida Herrera
  5. Image 4 of 56 For 54474 Avenida Herrera
  6. Image 5 of 56 For 54474 Avenida Herrera
  7. Image 6 of 56 For 54474 Avenida Herrera
  8. Image 7 of 56 For 54474 Avenida Herrera
  9. Image 8 of 56 For 54474 Avenida Herrera
  10. Image 9 of 56 For 54474 Avenida Herrera
  11. Image 10 of 56 For 54474 Avenida Herrera
  12. Image 11 of 56 For 54474 Avenida Herrera
  13. Image 12 of 56 For 54474 Avenida Herrera
  14. Image 13 of 56 For 54474 Avenida Herrera
  15. Image 14 of 56 For 54474 Avenida Herrera
  16. Image 15 of 56 For 54474 Avenida Herrera
  17. Image 16 of 56 For 54474 Avenida Herrera
  18. Image 17 of 56 For 54474 Avenida Herrera
  19. Image 18 of 56 For 54474 Avenida Herrera
  20. Image 19 of 56 For 54474 Avenida Herrera
  21. Image 20 of 56 For 54474 Avenida Herrera
  22. Image 21 of 56 For 54474 Avenida Herrera
  23. Image 22 of 56 For 54474 Avenida Herrera
  24. Image 23 of 56 For 54474 Avenida Herrera
  25. Image 24 of 56 For 54474 Avenida Herrera
  26. Image 25 of 56 For 54474 Avenida Herrera
  27. Image 26 of 56 For 54474 Avenida Herrera
  28. Image 27 of 56 For 54474 Avenida Herrera
  29. Image 28 of 56 For 54474 Avenida Herrera
  30. Image 29 of 56 For 54474 Avenida Herrera
  31. Image 30 of 56 For 54474 Avenida Herrera
  32. Image 31 of 56 For 54474 Avenida Herrera
  33. Image 32 of 56 For 54474 Avenida Herrera
  34. Image 33 of 56 For 54474 Avenida Herrera
  35. Image 34 of 56 For 54474 Avenida Herrera
  36. Image 35 of 56 For 54474 Avenida Herrera
  37. Image 36 of 56 For 54474 Avenida Herrera
  38. Image 37 of 56 For 54474 Avenida Herrera
  39. Image 38 of 56 For 54474 Avenida Herrera
  40. Image 39 of 56 For 54474 Avenida Herrera
  41. Image 40 of 56 For 54474 Avenida Herrera
  42. Image 41 of 56 For 54474 Avenida Herrera
  43. Image 42 of 56 For 54474 Avenida Herrera
  44. Image 43 of 56 For 54474 Avenida Herrera
  45. Image 44 of 56 For 54474 Avenida Herrera
  46. Image 45 of 56 For 54474 Avenida Herrera
  47. Image 46 of 56 For 54474 Avenida Herrera
  48. Image 47 of 56 For 54474 Avenida Herrera
  49. Image 48 of 56 For 54474 Avenida Herrera
  50. Image 49 of 56 For 54474 Avenida Herrera
  51. Image 50 of 56 For 54474 Avenida Herrera
  52. Image 51 of 56 For 54474 Avenida Herrera
  53. Image 52 of 56 For 54474 Avenida Herrera
  54. Image 53 of 56 For 54474 Avenida Herrera
  55. Image 54 of 56 For 54474 Avenida Herrera
  56. Image 55 of 56 For 54474 Avenida Herrera
More Like This
  • MLS#: 219128366DA ( Single Family Residence )
  • Street Address: 54474 Avenida Herrera
  • Viewed: 6
  • Price: $850,000
  • Price sqft: $446
  • Waterfront: No
  • Year Built: 1967
  • Bldg sqft: 1904
  • Bedrooms: 3
  • Total Baths: 3
  • Full Baths: 3
  • Garage / Parking Spaces: 4
  • Days On Market: 75
  • Additional Information
  • County: RIVERSIDE
  • City: La Quinta
  • Zipcode: 92253
  • Subdivision: La Quinta Cove
  • District: Desert Sands Unified
  • Elementary School: TRUMAN
  • Middle School: LAQUI
  • High School: LAQUI
  • Provided by: Cool Digs
  • Contact: T.J. T.J.
  • California Regional MLS IDX
  • DMCA Notice
  • Description
    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!
Property Location and Similar Properties
All
Similar
Request More Information
  • All fields are required.
Features
Appliances
  1. Electric Cooktop
  2. Microwave
  3. Electric Oven
  4. Vented Exhaust Fan
  5. Refrigerator
  6. Disposal
  7. Dishwasher
  8. Gas Water Heater
Carport Spaces
  1. 0.00
Construction Materials
  1. Stucco
Cooling
  1. Central Air
Country
  1. US
Door Features
  1. French Doors
  2. Sliding Doors
Eating Area
  1. Breakfast Counter / Bar
  2. Dining Room
Electric
  1. 220 Volts in Garage
Elementary School
  1. TRUMAN
Elementaryschool
  1. Truman
Fencing
  1. Stucco Wall
Flooring
  1. Tile
Foundation Details
  1. Slab
Garage Spaces
  1. 2.00
Heating
  1. Central
  2. Forced Air
  3. Natural Gas
  4. Propane
High School
  1. LAQUI
Highschool
  1. La Quinta
Inclusions
  1. Turnkey minus personal clothing and two pieces of art in the living room
Interior Features
  1. Furnished
Laundry Features
  1. In Garage
Levels
  1. One
Living Area Source
  1. Assessor
Lockboxtype
  1. None
Lot Features
  1. 2-5 Units/Acre
  2. Rectangular Lot
  3. Landscaped
  4. Back Yard
  5. Corner Lot
  6. Sprinklers Drip System
  7. Sprinklers Timer
  8. Sprinkler System
Middle School
  1. LAQUI
Middleorjuniorschool
  1. La Quinta
Other Structures
  1. Guest House
Parcel Number
  1. 774251023
Parking Features
  1. Side by Side
  2. Driveway
  3. Garage Door Opener
Patio And Porch Features
  1. Covered
Pool Features
  1. Waterfall
  2. Gunite
  3. In Ground
  4. Electric Heat
  5. Tile
  6. Private
Postalcodeplus4
  1. 3697
Property Type
  1. Single Family Residence
Property Condition
  1. Updated/Remodeled
Roof
  1. Foam
School District
  1. Desert Sands Unified
Security Features
  1. Automatic Gate
Subdivision Name Other
  1. La Quinta Cove
Uncovered Spaces
  1. 2.00
Utilities
  1. Cable Available
View
  1. Mountain(s)
  2. Panoramic
Window Features
  1. Drapes
  2. Blinds
Year Built
  1. 1967
Year Built Source
  1. Assessor
Zoning
  1. R-1
Equal Housing Opportunity

Based on information from California Regional Multiple Listing Service, Inc. as of Jun 26, 2025. 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. 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.
Display of MLS data is usually deemed reliable but is NOT guaranteed accurate.
Datafeed Last updated on June 26, 2025 @ 12:00 am
©2006-2025 brokerIDXsites.com - https://brokerIDXsites.com
We believe in accessibility for all
Your Privacy Is Important
XML Sitemap
Manage Your Account