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
Adult Community
  • MLS#: 219113524DA ( Single Family Residence )
  • Street Address: 81207 Santa Rosa Court
  • Viewed: 1
  • Price: $920,000
  • Price sqft: $337
  • Waterfront: Yes
  • Wateraccess: Yes
  • Year Built: 2005
  • Bldg sqft: 2726
  • Bedrooms: 4
  • Total Baths: 3
  • Full Baths: 3
  • Garage / Parking Spaces: 3
  • Days On Market: 194
  • Additional Information
  • County: RIVERSIDE
  • City: La Quinta
  • Zipcode: 92253
  • Subdivision: Trilogy
  • Provided by: Equity Union
  • Contact: Donna Donna
  • California Regional MLS IDX
  • DMCA Notice
  • Description
    Hollywood glamour comes to Trilogy La Quinta. This rare, outstanding Tamarisk model home spans 2,726 square feet with four bedrooms (or three bedrooms plus office), private courtyard with a separate Casita, dramatic cascading waterfalls over a raised spa to a salt water pool below, and a grand bronze colored entry gate befitting a Hollywood estate. Located on a cul de sac, the home sits on a sprawling one third plus acre with tall palms, lush gardens, and towering southwest mountain views from the back and side yards. Step into the main home foyer and you're immediately captivated by the elegance of the bright and open floor plan as it flows effortlessly from one room to the next. Throughout the main living area the ten foot ceilings and over sized windows offer awe inspiring views from every room. The great room features a media niche and sliding door to a private covered patio with an automated sunscreen. Mountain vistas, green gardens, and waterfalls take center stage when seated in the formal dining room and when preparing culinary delights in the spacious gourmet kitchen. Professional grade stainless appliances with double oven, abundant cabinets with pull outs, walk in pantry, and expansive counter space with lovely slab granite extends, to a huge center island with built in wine frig, and plenty of seating for casual entertaining.
Request More Information
  • All fields are required.
Features
Appliances
  1. Gas Cooktop
  2. Microwave
  3. Convection Oven
  4. Self Cleaning Oven
  5. Electric Oven
  6. Vented Exhaust Fan
  7. Water Line to Refrigerator
  8. Refrigerator
  9. Ice Maker
  10. Disposal
  11. Dishwasher
  12. Water Heater Central
  13. Water Heater
Association Amenities
  1. Barbecue
  2. Tennis Court(s)
  3. Pet Rules
  4. Management
  5. Meeting Room
  6. Maintenance Grounds
  7. Golf Course
  8. Fire Pit
  9. Gym/Ex Room
  10. Card Room
  11. Clubhouse
  12. Billiard Room
  13. Banquet Facilities
  14. Bocce Ball Court
  15. Clubhouse Paid
  16. Trash
  17. Sewer
  18. Security
  19. Cable TV
  20. Concierge
Association Fee
  1. 552.00
Association Fee Frequency
  1. Monthly
Builder Name
  1. Shea Homes
Carport Spaces
  1. 0.00
Construction Materials
  1. Stucco
Cooling
  1. Central Air
Country
  1. US
Door Features
  1. Sliding Doors
Eating Area
  1. Breakfast Counter / Bar
  2. Dining Room
  3. Breakfast Nook
Fencing
  1. Block
Fireplace Features
  1. Raised Hearth
  2. Masonry
  3. Outside
  4. Patio
Flooring
  1. Tile
Garage Spaces
  1. 3.00
Heating
  1. Central
  2. Forced Air
  3. Natural Gas
Interior Features
  1. Built-in Features
  2. Recessed Lighting
  3. Open Floorplan
  4. High Ceilings
  5. Partially Furnished
Laundry Features
  1. Individual Room
Levels
  1. One
Living Area Source
  1. Assessor
Lockboxtype
  1. None
Lot Features
  1. Back Yard
  2. Yard
  3. Paved
  4. Level
  5. Landscaped
  6. Lawn
  7. Front Yard
  8. Cul-De-Sac
  9. Sprinklers Drip System
  10. Sprinklers Timer
  11. Sprinkler System
  12. Planned Unit Development
Other Structures
  1. Guest House
Parcel Number
  1. 764440009
Parking Features
  1. Golf Cart Garage
  2. Driveway
  3. Garage Door Opener
  4. Side by Side
  5. Oversized
Patio And Porch Features
  1. Brick
  2. Concrete
  3. Covered
Pool Features
  1. Waterfall
  2. Pebble
  3. Electric Heat
  4. Salt Water
  5. Private
  6. In Ground
Postalcodeplus4
  1. 9338
Property Type
  1. Single Family Residence
Roof
  1. Concrete
  2. Tile
Security Features
  1. Gated Community
  2. Resident Manager
Spa Features
  1. Heated
  2. Private
Subdivision Name Other
  1. Trilogy
Uncovered Spaces
  1. 0.00
Utilities
  1. Cable Available
View
  1. Mountain(s)
Window Features
  1. Screens
  2. Double Pane Windows
Year Built
  1. 2005
Year Built Source
  1. Assessor