Private La Quinta Retreat with Pool, Mountain Views & Owned Solar.Welcome to a private desert retreat in desirable Desert Club Estates, where generous living spaces, mature landscaping and resort-style outdoor amenities come together in a setting designed for the La Quinta lifestyle.This spacious 3-bedroom, 3-bath residence offers approximately 2,560 square feet of living space on an approximately 13,068-square-foot lot with a 3-car garage. Inside, an open and versatile floor plan features multiple living and dining areas, high ceilings and abundant natural light. The kitchen offers granite countertops, stainless-steel appliances, double ovens, a gas cooktop and plenty of cabinetry, opening comfortably to the surrounding living spaces.Step outside and discover a backyard made for enjoying the desert. A private pool and spa, covered patio areas, outdoor fireplace, built-in BBQ/outdoor kitchen and mature landscaping create multiple spaces for entertaining or simply relaxing at home. Palm trees and surrounding greenery enhance the sense of privacy, while desert and mountain views provide a beautiful backdrop.The home also provides a 32-panel owned solar energy system, offering the benefit of solar-generated electricity.Additional highlights include a 3-car garage, two fireplaces (1 indoor, 1 outdoor), indoor laundry, multiple French doors providing access to the backyard, and an oversized lot that gives the property a wonderful sense of space and privacy.A distinctive La Quinta property offering space, privacy, solar, mountain views and true indoor-outdoor desert living.
For sale
Listed by: Equity Union • Richard MacMillan • 760-574-2299
$965,000
78515 Avenida Ultimo, La Quinta, CA 92253
3beds
2,246sqft
Single Family Residence
Built in 1996
0.3 Acres Lot
$935,600 Zestimate®
$430/sqft
$-- HOA
What's special
Private pool and spaOutdoor fireplaceMature landscapingAbundant natural lightOversized lotResort-style outdoor amenitiesHigh ceilings
- 38 days
- 1,235
- 85
Zillow last checked:
Listing updated:
Listed by:
Richard MacMillan DRE #01183445 760-574-2299,
Equity Union,
Paige Maccio-Smith DRE #01956853 760-851-8514,
Equity Union
Source: CRMLS,MLS#: 219152370DA
Originating MLS: California Desert AOR & Palm Springs AOR
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
Rooms
- Room types: Family Room, Great Room
Heating
- Central
Cooling
- Central Air
Features
- Partially Furnished
- Flooring: Carpet, Tile
- Has fireplace: Yes
- Fireplace features: Family Room, Gas, Outside
Interior area
- Total interior livable area: 2,246 sqft
Property
Parking
- Total spaces: 6
- Parking features: Driveway
- Attached garage spaces: 3
- Uncovered spaces: 3
Features
- Levels: One
- Stories: 1
- Has private pool: Yes
- Pool features: In Ground
- Spa features: In Ground, Private
Lot
- Size: 0.3 Acres
- Features: Sprinklers Timer
Details
- Parcel number: 770091002
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Condition
- New construction: No
- Year built: 1996
Community & HOA
Community
- Subdivision: Desert Club Estates
Location
- Region: La Quinta
Financial & listing details
- Price per square foot: $430/sqft
- Tax assessed value: $1,045,499
- Date on market: 9/5/2026
- Listing terms: Cash,Cash to New Loan,FHA,VA Loan
Estimated market value
$935,600
$889,000 - $982,000
$5,003/mo
Price history
| Date | Event | Price |
|---|---|---|
| 9/6/2026 | Listed for sale | $965,000-14.2%$430/sqft |
Source: | ||
| 12/16/2025 | Listing removed | $1,125,000$501/sqft |
Source: | ||
| 10/8/2025 | Listed for sale | $1,125,000-6.3%$501/sqft |
Source: | ||
| 10/7/2025 | Listing removed | $1,200,000$534/sqft |
Source: | ||
| 6/19/2025 | Price change | $1,200,000-4%$534/sqft |
Source: | ||
| 5/30/2025 | Listed for sale | $1,250,000+22%$557/sqft |
Source: | ||
| 12/3/2024 | Sold | $1,025,000-3.2%$456/sqft |
Source: | ||
| 11/29/2024 | Pending sale | $1,059,000$472/sqft |
Source: | ||
| 10/24/2024 | Contingent | $1,059,000$472/sqft |
Source: | ||
| 10/4/2024 | Price change | $1,059,000-7.8%$472/sqft |
Source: | ||
| 10/2/2024 | Listed for sale | $1,149,000-8.1%$512/sqft |
Source: | ||
| 11/14/2022 | Listing removed | -- |
Source: | ||
| 11/13/2022 | Listed for sale | $1,249,999+380.8%$557/sqft |
Source: | ||
| 10/15/2009 | Sold | $260,000+4%$116/sqft |
Source: Public Record Report a problem | ||
| 9/12/2009 | Price change | $249,900-9.1%$111/sqft |
Source: foreclosure.com Report a problem | ||
| 8/7/2009 | Price change | $274,900-9.2%$122/sqft |
Source: foreclosure.com Report a problem | ||
| 7/2/2009 | Listed for sale | $302,900-10.6%$135/sqft |
Source: foreclosure.com Report a problem | ||
| 2/25/2009 | Sold | $338,852+50.6%$151/sqft |
Source: Public Record Report a problem | ||
| 10/6/2000 | Sold | $225,000+800%$100/sqft |
Source: Public Record Report a problem | ||
| 12/4/1995 | Sold | $25,000$11/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $1,045,499 +2% |
| 2025 | $13,356 +184.3% | $1,025,000 +211.5% |
| 2024 | $4,698 +3.1% | $329,012 +2% |
| 2023 | $4,558 +3.6% | $322,562 +2% |
| 2022 | $4,401 +2.6% | $316,238 +2% |
| 2021 | $4,289 +1.8% | $310,038 +1% |
| 2020 | $4,212 +2.1% | $306,860 +2% |
| 2019 | $4,127 +2.2% | $300,845 +2% |
| 2018 | $4,037 +1.5% | $294,947 +2% |
| 2017 | $3,976 | $289,164 +2% |
| 2016 | $3,976 +1.6% | $283,495 +1.5% |
| 2015 | $3,913 +1.6% | $279,240 +2% |
| 2014 | $3,851 | $273,773 +0.5% |
| 2013 | -- | $272,538 +2% |
| 2012 | -- | $267,195 +2% |
| 2011 | -- | $261,957 +0.8% |
| 2010 | -- | $260,000 -1.2% |
| 2009 | -- | $263,272 +2% |
| 2008 | -- | $258,111 +2% |
| 2007 | -- | $253,051 +2% |
| 2006 | -- | $248,090 +2% |
| 2005 | -- | $243,226 +3.9% |
| 2003 | -- | $234,090 +2% |
| 2002 | -- | $229,500 +2% |
| 2001 | $3,359 +12.2% | $225,000 +21% |
| 2000 | $2,994 | $185,971 |
Find assessor info on the county website
Monthly payment
Est. payment





