x
Showing 1 of 0
X
Save

81207 Santa Rosa Court
La Quinta CA 92253 US

$950,000

Active Listing ID 219113524
bed icon
4 bed
bath icon
4.00 Bath (3 Full)
home icon
Single Family Residence

$950,000

Active Listing ID 219113524
Save

81207 Santa Rosa Court 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. A nearby breakfast nook with built-in desk looks out over the lush landscaping, pool and barbecue station and spanish-tiled raised hearth gas fireplace. Doors from the nook lead to an outdoor covered patio, the perfect place to sip that first fresh cup of coffee and feel the light morning breeze. The primary bedroom is a spacious retreat with a large bay window and tray ceiling. The inspired main bath is a sanctuary with his and her vanities and a grand oval soaking tub in the center of the room. The sumptuous large tiled walk-in shower is separated from the main bath and a large walk-in closet with custom built-ins to keep your wardrobe attire neat and organized. Off the great room is a guest bedroom with full bath, and an additional guest bedroom (or office) with nearby linen closet and bath with shower. Of course, family and friends will love the privacy of the detached Casita with private entry, kitchenette, and full bath. An over-sized two-car garage with storage fits two vehicles side-by-side. The lucky golf cart gets its own separate garage. Come discover this beauty for yourself!

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • 3/4 Bathrooms: 1
  • Exterior Finish: Premium Lot, Back Yard, Front Yard, Landscaped, Level, Private, Cul-de-sac, Misting System, Brick - Tile, Concrete Slab, Covered, Misters, Heated, In Ground, Private, Salt Water, Waterfall, Pebble
  • Floor Covering: Tile, Tile - Ceramic
  • Roof Type: Concrete, Tile
  • Heating Fuels: Central Furnace, Fireplace, Forced Air
  • Additional Features
  • Fireplace

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 950000
  • unparsedaddress: 81207 Santa Rosa Court
  • postalcity: La Quinta
  • stateorprovince: CA
  • country: US
  • postalcode: 92253
  • bathroomsfull: 3
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 1
  • lotsizeacres: 0
  • lotsizeunits: Acres
  • livingarea: 2726
  • livingareaunits: Square Feet
  • latitude: 33.605991
  • longitude: -116.248053
  • listagentfullname: Donna Ambrose
  • listagentemail: veronica@equityunion.com
  • listagentkey: 3yd-CDARCA-D81560
  • listagentmlsid: D81560
  • listagentpreferredphone: 8186311660
  • listagentofficephone: 7606210395
  • 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-06-27
  • listagenturl: https://equityunion.com
  • countyorparish: Riverside
  • appliances: Cooktop, Cooktop - Gas, Dishwasher, Dryer, Garbage Disposer, Ice Maker, Microwave, Oven - Convection, Refrigerator, Washer
  • constructionmaterials: Stucco
  • flooring: Tile, Tile - Ceramic
  • heating: Central Furnace, Fireplace, Forced Air
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 3
  • parkingfeatures: Driveway, Garage, Golf Cart, Oversized, Side by Side
  • roof: Concrete, Tile
  • view: Mountain
  • waterfrontyn: False
  • interiorfeatures: All Bedrooms Down, Master Retreat, Master Suite, Walk In Closet, Granite Counters, Built-in Features, Open Floorplan, Recessed Lighting
  • exteriorfeatures: Premium Lot, Back Yard, Front Yard, Landscaped, Level, Private, Cul-de-sac, Misting System, Brick - Tile, Concrete Slab, Covered, Misters, Heated, In Ground, Private, Salt Water, Waterfall, Pebble
  • architecturalstyle: Other
  • rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -116.248055, 33.60599
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Equity Union Real Estate", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":null, "ExpenseValue":552}], "GeocodeOptions":null, "LeadRoutingEmail":"veronica@equityunion.com", "ListBrokerageCity":"Sherman Oaks", "ListBrokerageCountry":"US", "ListBrokerageEmail":"veronica@equityunion.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Equity Union Real Estate", "ListBrokeragePhone":"(818) 631-1660", "ListBrokeragePostalCode":"91423", "ListBrokerageStateOrProvince":"CA", "ListBrokerageUnitNumber":"STE 350", "ListBrokerageUnparsedAddress":"13412 VENTURA BLVD", "ListBrokerageWebsiteUrl":"https://equityunion.com", "ListOfficeAddress1":"44495 Town Center Way Ste. B", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"d84721", "ListOfficeCity":"Palm Desert", "ListOfficeCountry":"US", "ListOfficeEmail":"veronica@equityunion.com", "ListOfficePostalCode":"92260", "ListOfficeStateOrProvince":"CA", "ListPriceCurrencyType":"USD", "ListingTitle":"Single Family Residence - La Quinta, CA", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/81207-Santa-Rosa-Ct_La-Quinta_CA_92253_M20809-58648?f=listhub&s=CDARCA&m=219113524&c=rexren", "MLSModificationTimestamp":"2024-10-28T09:04:56Z", "Neighborhoods":[], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 10/28/2024 4:57:59 PM GMT
Source Updated Date: 11/21/2024 7:02:54 AM GMT

Courtesy of: Donna Ambrose, Equity Union, veronica@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.