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#: 219142631DA ( Single Family Residence )
  • Street Address: 81207 Santa Rosa Court
  • Viewed: 3
  • Price: $1,195,000
  • Price sqft: $438
  • Waterfront: Yes
  • Wateraccess: Yes
  • Year Built: 2005
  • Bldg sqft: 2726
  • Bedrooms: 4
  • Total Baths: 4
  • Full Baths: 3
  • Garage / Parking Spaces: 3
  • Days On Market: 37
  • Additional Information
  • County: RIVERSIDE
  • City: La Quinta
  • Zipcode: 92253
  • Subdivision: Trilogy
  • Provided by: Bennion Deville Homes
  • Contact: John John
  • California Regional MLS IDX
  • DMCA Notice
  • Description
    Experience the pinnacle of desert living in this rare Tamarisk model with detached casita, ideally situated on a private cul de sac within Trilogy La Quinta. Set on an expansive .35 acre homesite, this exceptional residence offers a beautifully landscaped front lawn, an inviting courtyard with ornate entry gate, three covered patios, an outdoor fireplace, and a resort style pool and spa highlighted by a dramatic stone waterfall. Encompassing approximately 2,726 sq. ft. of refined single level living, the home showcases 4 bedrooms, 4 bathrooms, a formal dining room with bay window, and a spacious great room with custom media niche. Recent upgrades include fresh interior and exterior paint (including the casita), new porcelain tile flooring with 7 inch baseboards, shutters, shades, and a custom designed TV and electric fireplace wall. The gourmet kitchen is a true showpiece, boasting all new cabinetry, quartz Gucci stone island, stainless steel sink, Monogram cooktop, built in double ovens, designer accent walls and wall sconces, and a charming breakfast nook with custom bench seating and dry bar. The primary suite impresses with a tray ceiling, bay window sitting area, walk in closet, updated shutters, and a luxurious bathroom with separate shower. Additional enhancements include new toilets and faucets throughout, upgraded ceiling fans, custom built ins, and a split 3 car garage. A rare offering of style, space, and upgrades, this home is not to be missed.
Request More Information
  • All fields are required.
Features
Appliances
  1. Disposal
  2. Gas Cooktop
  3. Microwave
  4. Gas Oven
  5. Vented Exhaust Fan
  6. Water Line to Refrigerator
  7. Gas Water Heater
Association Amenities
  1. Barbecue
  2. Tennis Court(s)
  3. Sport Court
  4. Management
  5. Meeting Room
  6. Lake or Pond
  7. Golf Course
  8. Gym/Ex Room
  9. Card Room
  10. Clubhouse
  11. Billiard Room
  12. Banquet Facilities
  13. Bocce Ball Court
  14. Security
  15. Cable TV
  16. Concierge
  17. Clubhouse Paid
Association Fee
  1. 595.00
Association Fee Frequency
  1. Monthly
Builder Model
  1. Tamarisk/Casita
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 Nook
  2. Breakfast Counter / Bar
  3. Dining Room
Electric
  1. 220 Volts in Laundry
Fencing
  1. Block
Fireplace Features
  1. Decorative
  2. Gas
  3. Outside
  4. Great Room
Flooring
  1. Tile
Foundation Details
  1. Slab
Garage Spaces
  1. 3.00
Heating
  1. Central
  2. Natural Gas
Interior Features
  1. Built-in Features
  2. Dry Bar
  3. Tray Ceiling(s)
  4. Recessed Lighting
  5. Open Floorplan
  6. High Ceilings
Laundry Features
  1. Individual Room
Levels
  1. One
Living Area Source
  1. Assessor
Lockboxtype
  1. Supra
Lot Features
  1. Front Yard
  2. Landscaped
  3. Lawn
  4. Cul-De-Sac
  5. Sprinkler System
  6. Planned Unit Development
Other Structures
  1. Guest House
Parcel Number
  1. 764440009
Parking Features
  1. Side by Side
  2. Garage Door Opener
  3. Direct Garage Access
Patio And Porch Features
  1. Covered
  2. Concrete
Pool Features
  1. Waterfall
  2. In Ground
Postalcodeplus4
  1. 9338
Property Type
  1. Single Family Residence
Roof
  1. Tile
Security Features
  1. 24 Hour Security
  2. Gated Community
Spa Features
  1. Heated
  2. In Ground
Subdivision Name Other
  1. Trilogy
Uncovered Spaces
  1. 0.00
Utilities
  1. Cable Available
View
  1. Mountain(s)
  2. Pool
Window Features
  1. Bay Window(s)
  2. Shutters
  3. Drapes
Year Built
  1. 2005
Year Built Source
  1. Assessor