54474 Avenida Herrera, La Quinta, CA 92253
  • MLS#: 219128366DA ( Single Family Residence )
  • Street Address: 54474 Avenida Herrera
  • Viewed: 2
  • Price: $949,000
  • Price sqft: $498
  • Waterfront: No
  • Year Built: 1967
  • Bldg sqft: 1904
  • Bedrooms: 3
  • Total Baths: 3
  • Full Baths: 3
  • Garage / Parking Spaces: 4
  • Days On Market: 14
  • 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
Request More Information
  • All fields are required.
Contact Patrick Adams
Contacting Patrick Adams
  • All fields are required.
Schedule A Showing
Schedule a Showing.
  • All fields are required.
Check this box to Register with us:
Features
Appliances
  1. Electric Cooktop
  2. Microwave
  3. Electric Oven
  4. Vented Exhaust Fan
  5. Refrigerator
  6. Disposal
  7. Electric Cooking
  8. Dishwasher
  9. 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