Skip main navigation
Sold for $825,000
  • Listing Provided by: Equity Union
    Bought with: Equity Union
    $825,000

    81207 Santa Rosa Ct, La Quinta, CA 92253

    4beds
    2,726sqft
    Single Family Residence
    Built in 2005
    0.35 Acres Lot
    $1,150,700 Zestimate®
    $303/sqft
    $6,160 Estimated rent

    Home value

    $1,150,700

    $1.09M - $1.21M

    $6,160/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $6,160/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $6,160/mo

    Rent Zestimate®

    Refinance and save

    $5,712/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $5,712/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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.

    Zillow last checked:

    Listing updated:

    Listing Provided by:

    Donna Ambrose DRE #02038351 206-755-9823,

    Equity Union

    Bought with:

    DW & Associates, DRE #01991637

    Equity Union

    Source: CRMLS,MLS#: 219113524DAMLS LogoOriginating MLS: California Desert AOR & Palm Springs AOR

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 3
    • 3/4 bathrooms: 1
    Primary bedroom
    • Features: Primary Suite
    Bedroom
    • Features: All Bedrooms Down
    Bathroom
    • Features: Bathtub, Linen Closet, Separate Shower, Tub Shower, Vanity
    Kitchen
    • Features: Granite Counters, Kitchen Island
    Other
    • Features: Walk-In Closet(s)
    Pantry
    • Features: Walk-In Pantry
    Heating
    • Central, Forced Air, Natural Gas
    Cooling
    • Central Air
    Appliances
    • Included: Convection Oven, Dishwasher, Electric Oven, Gas Cooktop, Disposal, Ice Maker, Microwave, Refrigerator, Self Cleaning Oven, Vented Exhaust Fan, Water To Refrigerator, Water Heater
    • Laundry: Laundry Room
    Features
    • Breakfast Bar, Built-in Features, Breakfast Area, Separate/Formal Dining Room, High Ceilings, Open Floorplan, Partially Furnished, Recessed Lighting, All Bedrooms Down, Primary Suite, Walk-In Pantry, Walk-In Closet(s)
    • Flooring: Tile
    • Doors: Sliding Doors
    • Windows: Double Pane Windows, Screens
    • Has fireplace: Yes
    • Fireplace features: Masonry, Outside, Raised Hearth
    Interior area
    • Total interior livable area: 2,726 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Driveway, Garage, Golf Cart Garage, Garage Door Opener, Oversized, Side By Side
    • Attached garage spaces: 3
    Features
    • Levels: One
    • Stories: 1
    • Patio & porch: Brick, Concrete, Covered
    • Has private pool: Yes
    • Pool features: Electric Heat, In Ground, Pebble, Private, Salt Water, Waterfall
    • Spa features: Heated, Private
    • Fencing: Block
    • Has view: Yes
    • View description: Mountain(s)
    Lot
    • Size: 0.35 Acres
    • Features: Back Yard, Cul-De-Sac, Drip Irrigation/Bubblers, Front Yard, Lawn, Landscaped, Level, Planned Unit Development, Sprinklers Timer, Sprinkler System, Yard
    Details
    • Additional structures: Guest House
    • Parcel number: 764440009
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    • Attached to another structure: Yes
    Materials
    • Stucco
    • Roof: Concrete,Tile
    Condition
    • New construction: No
    • Year built: 2005
    Details
    • Builder name: Shea Homes

    Utilities & green energy

    • Utilities for property: Cable Available

    Community & neighborhood

    Security
    • Security features: Gated Community, Resident Manager
    Community
    • Community features: Golf, Gated
    Senior living
    • Senior community: Yes
    Location
    • Region: La Quinta
    • Subdivision: Trilogy

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $552 monthly
    • Amenities included: Bocce Court, Billiard Room, Clubhouse, Fitness Center, Fire Pit, Golf Course, Maintenance Grounds, Game Room, Meeting Room, Management, Meeting/Banquet/Party Room, Barbecue, Pet Restrictions, Security, Tennis Court(s), Trash, Cable TV
    • Services included: Sewer
    • Association name: Trilogy at La Quinta Maintenance Assn
    • Association phone: 760-777-6059

    Other

    Other facts
    • Listing terms: Cash,Conventional

    Price history

    DateEventPrice
    4/4/2026Listing removed$1,195,000$438/sqft
    Source: CDAR/ Desert Area MLS #219142631 Report a problem
    2/4/2026Listed for sale$1,195,000$438/sqft
    Source: Greater Palm Springs Realtors #219142631 Report a problem
    2/3/2026Listing removed$1,195,000$438/sqft
    Source: Greater Palm Springs Realtors #219136521 Report a problem
    10/7/2025Listed for sale$1,195,000+44.8%$438/sqft
    Source: Greater Palm Springs Realtors #219136521 Report a problem
    2/21/2025Sold$825,000-7.3%$303/sqft
    Source: CRMLS #219113524DA Report a problem
    2/12/2025Pending sale$890,000$326/sqft
    Source: Greater Palm Springs Realtors #219113524 Report a problem
    1/17/2025Contingent$890,000$326/sqft
    Source: CDAR/ Desert Area MLS #219113524 Report a problem
    1/8/2025Price change$890,000-3.3%$326/sqft
    Source: CDAR/ Desert Area MLS #219113524 Report a problem
    12/5/2024Price change$920,000-3.2%$337/sqft
    Source: CDAR/ Desert Area MLS #219113524 Report a problem
    9/28/2024Price change$950,000-4.5%$348/sqft
    Source: Greater Palm Springs Realtors #219113524 Report a problem
    6/28/2024Listed for sale$995,000$365/sqft
    Source: CDAR/ Desert Area MLS #219113524 Report a problem
    5/30/2024Listing removed$995,000$365/sqft
    Source: BHHS broker feed #219107101 Report a problem
    4/10/2024Price change$995,000-9.5%$365/sqft
    Source: Greater Palm Springs Realtors #219107101 Report a problem
    2/18/2024Listed for sale$1,100,000+25.7%$404/sqft
    Source: CDAR/ Desert Area MLS #219107101 Report a problem
    10/17/2023Listing removed--
    Source: Greater Palm Springs Realtors #219099793 Report a problem
    9/18/2023Listed for sale$875,000+16.4%$321/sqft
    Source: CDAR/ Desert Area MLS #219099793 Report a problem
    6/14/2021Sold$752,000+7.6%$276/sqft
    Source: CDAR/ Desert Area MLS #219061359 Report a problem
    5/19/2021Pending sale$699,000$256/sqft
    Source: CDAR/ Desert Area MLS #219061359 Report a problem
    5/5/2021Contingent$699,000$256/sqft
    Source: CDAR/ Desert Area MLS #219061359 Report a problem
    5/1/2021Listed for sale$699,000+10.3%$256/sqft
    Source: CDAR/ Desert Area MLS #219061359 Report a problem
    7/14/2017Listing removed$634,000$233/sqft
    Source: HomeSmart Professionals #217009060 Report a problem
    6/27/2017Price change$634,000-2.3%$233/sqft
    Source: HomeSmart Professionals #217009060 Report a problem
    3/27/2017Listed for sale$649,000+2.2%$238/sqft
    Source: HomeSmart Professionals #217009060 Report a problem
    5/4/2016Listing removed$635,000$233/sqft
    Source: HK Lane | Christie's Int'l #216004456 Report a problem
    4/4/2016Listed for sale$635,000-2.5%$233/sqft
    Source: HK Lane | Christie's Int'l #216004456 Report a problem
    12/14/2005Sold$651,000$239/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$11,485 +5.7%$841,500 +5.4%
    2024$10,862 +1.5%$798,027 +2%
    2023$10,698 +2.2%$782,380 +2%
    2022$10,464 +8%$767,040 +9.3%
    2021$9,691 +11.3%$701,851 +12%
    2020$8,708 +2.7%$626,652 +3%
    2019$8,480 +3.9%$608,400 +4%
    2018$8,162 -7.8%$585,000 -6.4%
    2017$8,856 $625,000 +10.6%
    2016$8,856 +16.7%$565,000 +1.8%
    2015$7,589 -9.2%$555,000 -9.6%
    2014$8,355 $614,000 -19.6%
    2013-- $763,660 +19.1%
    2012-- $641,000 +2.6%
    2011-- $625,000 -5.4%
    2010-- $661,000 -9.5%
    2009-- $730,259 +3.7%
    2008-- $704,000 +0.7%
    2007-- $699,020 +7.4%
    2006-- $651,000 +12143.7%
    2005-- $5,317

    Find assessor info on the county website

    Neighborhood: 92253

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,150,700
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,150,700