No HOA! Located in desirable Desert Club Estates near Old Town La Quinta, this custom-built 4-bedroom, 4-bath home sits on a large lot surrounded by other custom residences. Completely remodeled from top to bottom, the property features a brand-new pool, beautifully landscaped grounds, expansive patio space, and grassy areas ideal for entertaining. The open floor plan includes a spacious great room, chef's kitchen with large island and premium appliances, generous dining area, and covered patio for outdoor dining. The primary suite offers French doors to the garden and a spa-inspired bath. Three additional guest rooms continue the elevated design, each with French doors opening to the pool and garden. The garage is equipped with an electric vehicle charging station. Offered turnkey furnished with designer furnishings and everything needed to enjoy the La Quinta desert lifestyle.
For sale
Listed by: Equity Union • Raymond Radas • Contact: 760-485-4586
$1,550,000
78625 Avenida Ultimo, La Quinta, CA 92253
4beds
2,611sqft
Single Family Residence
Built in 1991
0.28 Acres Lot
$1,459,600 Zestimate®
$594/sqft
$-- HOA
What's special
Large lotBrand-new poolExpansive patio spaceBeautifully landscaped groundsOpen floor planGenerous dining areaSpacious great room
- 10 days |
- 921 |
- 65 |
Zillow last checked:
Listing updated:
Listed by:
Raymond Radas DRE #01091175 760-485-4586,
Equity Union
Source: CRMLS,MLS#: 219149858DA
Originating MLS: California Desert AOR & Palm Springs AOR
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Rooms
- Room types: Great Room, Dining Room
Kitchen
- Features: Kitchen Island, Remodeled, Updated Kitchen
Heating
- Forced Air
Cooling
- Central Air, Zoned
Appliances
- Included: Convection Oven, Dishwasher, Microwave, Refrigerator, Water To Refrigerator
- Laundry: Laundry Room
Features
- Breakfast Bar, Separate/Formal Dining Room, Furnished, High Ceilings
- Flooring: Laminate
- Doors: French Doors
- Has fireplace: No
- Furnished: Yes
Interior area
- Total interior livable area: 2,611 sqft
Video & virtual tour
Property
Parking
- Total spaces: 6
- Parking features: Direct Access, Driveway, Garage, Garage Door Opener
- Attached garage spaces: 2
- Uncovered spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Wrap Around
- Has private pool: Yes
- Pool features: In Ground, Private, Salt Water
- Spa features: Heated, In Ground, Private
- Fencing: Stucco Wall
- Has view: Yes
- View description: Mountain(s)
Lot
- Size: 0.28 Acres
- Features: Drip Irrigation/Bubblers, Sprinklers Timer, Sprinkler System
Details
- Parcel number: 770092002
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1991
Utilities & green energy
- Electric: 220 Volts in Garage
Community & HOA
Community
- Security: Closed Circuit Camera(s), Security Gate, Security Lights
- Subdivision: Desert Club Estates
Location
- Region: La Quinta
Financial & listing details
- Price per square foot: $594/sqft
- Tax assessed value: $771,394
- Annual tax amount: $10,251
- Date on market: 7/2/2026
- Listing terms: Cash,Cash to New Loan,1031 Exchange
- Inclusions: Turnkey furnished.
Estimated market value
Zestimate®
$1,459,600
Estimated sales range
$1.39M - $1.53M
Rent Zestimate®
$5,336/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/2/2026 | Listed for sale | $1,550,000+20.6%$594/sqft |
Source: | ||
| 6/6/2026 | Listing removed | $6,996$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 2/28/2025 | Price change | $6,996-28.2%$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/30/2024 | Listed for rent | $9,750-1.2%$4/sqft |
Source: Zillow Rentals Report a problem | ||
| 7/25/2024 | Listing removed | -- |
Source: Zillow Rentals Report a problem | ||
| 5/6/2024 | Listed for rent | $9,870+182%$4/sqft |
Source: Zillow Rentals Report a problem | ||
| 8/22/2023 | Listing removed | -- |
Source: | ||
| 4/28/2023 | Price change | $1,285,000-1.2%$492/sqft |
Source: | ||
| 11/11/2022 | Listed for sale | $1,300,000+92.6%$498/sqft |
Source: | ||
| 8/24/2021 | Sold | $675,000-9.9%$259/sqft |
Source: | ||
| 8/9/2021 | Contingent | $749,000$287/sqft |
Source: | ||
| 5/28/2021 | Listed for sale | $749,000+26650%$287/sqft |
Source: | ||
| 8/16/2019 | Sold | $2,800-99.4%$1/sqft |
Source: | ||
| 6/25/2019 | Listing removed | $3,500$1/sqft |
Source: Hayes Real Estate #19474382PS Report a problem | ||
| 6/8/2019 | Price change | $475,000-5%$182/sqft |
Source: Hayes Real Estate #19474366PS Report a problem | ||
| 6/5/2019 | Listed for rent | $3,500$1/sqft |
Source: Hayes Real Estate #19474382PS Report a problem | ||
| 2/20/2019 | Price change | $499,900-5.5%$191/sqft |
Source: HK Lane Real Estate #218033026 Report a problem | ||
| 11/23/2018 | Price change | $529,000-3.6%$203/sqft |
Source: HK Lane Real Estate #218033026 Report a problem | ||
| 8/13/2018 | Listed for sale | $549,000+23.4%$210/sqft |
Source: Bennion Deville Homes #218022472 Report a problem | ||
| 10/5/2004 | Sold | $445,000$170/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $10,251 +2.3% | $771,394 +9.8% |
| 2024 | $10,015 +14.1% | $702,269 +2% |
| 2023 | $8,780 +2.5% | $688,500 +2% |
| 2022 | $8,561 +16.9% | $675,000 +16% |
| 2021 | $7,322 +12.7% | $581,875 +12% |
| 2020 | $6,497 +3.1% | $519,532 +3% |
| 2019 | $6,302 +4.2% | $504,400 +4% |
| 2018 | $6,049 +6.8% | $485,000 +6.6% |
| 2017 | $5,666 | $455,000 -3.8% |
| 2016 | $5,666 -6.5% | $473,000 -1.9% |
| 2015 | $6,058 +23.1% | $482,000 +23.9% |
| 2014 | $4,923 | $389,000 +10.2% |
| 2013 | -- | $353,000 +20.1% |
| 2012 | -- | $294,000 -8.1% |
| 2011 | -- | $320,000 +0.6% |
| 2010 | -- | $318,000 -16.1% |
| 2009 | -- | $379,000 -23.2% |
| 2008 | -- | $493,459 +2% |
| 2007 | -- | $483,785 +2% |
| 2006 | -- | $474,300 +6.6% |
| 2005 | -- | $445,000 +62% |
| 2003 | -- | $274,708 +2% |
| 2002 | -- | $269,323 +2% |
| 2001 | $3,532 +1.7% | $264,044 +2% |
| 2000 | $3,473 | $258,868 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Principal & interest
$1,547Mortgage insurance
$0Property taxes
$170Home insurance
$105HOA fees
$0Utilities
Not includedAll calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 92253
Nearby schools
GreatSchools rating
- 5/10Harry S. Truman Elementary SchoolGrades: K-5Distance: 0.4 mi
- 4/10La Quinta Middle SchoolGrades: 6-8Distance: 0.5 mi
- 7/10La Quinta High SchoolGrades: 9-12Distance: 2.3 mi
- $882,8003 bd3 ba2.4k sqft78655 Avenida Ultimo, La Quinta, CA 92253Off Market
Save - $456,7003 bd2 ba1.1k sqft78630 Avenida Tujunga, La Quinta, CA 92253Off Market
Save - $572,0003 bd2 ba1.3k sqft50550 Calle Quito, La Quinta, CA 92253Sold
Save 
- $720,4002 bd2 ba1.9k sqft78628 Avenida Tujunga, La Quinta, CA 92253Off Market
Save 
- $550,0004 bd2 ba1.4k sqft78650 Avenida Tujunga, La Quinta, CA 92253Sold
Save - $550,0004 bd2 ba1.4k sqft78650 Avenue Tujunga, La Quinta, CA 92253Sold
Save - $968,3004 bd5 ba2.6k sqft78685 Avenida Ultimo, La Quinta, CA 92253Off Market
Save - $1,017,3004 bd4 ba2.8k sqft78680 Avenida Tujunga, La Quinta, CA 92253Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $1,699,5005 bd4 ba3.2k sqft50700 Calle Paloma, La Quinta, CA 92253For Sale
Save
MLS ID #219148891DA, Raymond Radas, Equity Union. CRMLS - $1,725,0005 bd4 ba3k sqft78930 Via Florence, La Quinta, CA 92253For Sale
Save
MLS ID #219150011DA, Damin Halum, Compass. CRMLS - $1,950,0003 bd4 ba3.4k sqft78745 Avenue Lf, La Quinta, CA 92253For Sale
Save
MLS ID #219148971DA, Serena Lamble, Compass. CRMLS - $1,099,0004 bd4 ba2.7k sqft81822 Alegre, La Quinta, CA 92253For Sale
Save
MLS ID #219150116DA, Brandi Pratt, Seven Gables Real Estate. CRMLS - $1,280,0003 bd4 ba3.4k sqft80030 Via Valerosa, La Quinta, CA 92253For Sale
Save MLS ID #219147878DA, Kelly Ramsay, Equity Union. CRMLS - $1,495,0004 bd4 ba3.1k sqft49374 Gila River St, Indio, CA 92201For Sale
Save MLS ID #219145589DA, Camille Pfeifer, Bennion Deville Homes. CRMLS - $1,695,0004 bd4 ba3.1k sqft80440 Old Ranch Trl S, La Quinta, CA 92253For Sale
Save MLS ID #219147485DA, Tyson Hawley, Desert Sotheby's Int'l Realty. CRMLS - $1,299,0004 bd4 ba2.9k sqft52900 Jalisco St, La Quinta, CA 92253For Sale
Save MLS ID #219148305DA, Ryan Pylypow, Rennie Group. CRMLS - $1,147,0004 bd3 ba3k sqft58229 Coral View Way, La Quinta, CA 92253For Sale
Save MLS ID #219150078DA, Craig Conley, Bennion Deville Homes. CRMLS - $1,468,0003 bd3 ba3k sqft58228 Aragon Way, La Quinta, CA 92253For Sale
Save MLS ID #219145019DA, Declan Marmion, Equity Union. CRMLS - $1,725,0003 bd4 ba2.9k sqft81660 Chant Ct, La Quinta, CA 92253For Sale
Save MLS ID #219146210DA, Kevin Prosser, Compass. CRMLS - $875,0003 bd3 ba2.3k sqft51833 Via Santero, La Quinta, CA 92253For Sale
Save MLS ID #219149981DA, Charles Scicli, Desert Elite Properties, Inc.. CRMLS - $1,149,0003 bd3 ba3k sqft51933 Marquis Ln, La Quinta, CA 92253For Sale
Save MLS ID #219149759DA, Christina Arthur, Keller Williams Luxury Homes. CRMLS - $1,600,0003 bd4 ba3.1k sqft80404 Old Ranch Trl S, La Quinta, CA 92253For Sale
Save MLS ID #219148249DA, Nicole Dibble, Keller Williams Luxury Homes. CRMLS - $1,295,0004 bd4 ba3.1k sqft81307 Jasmine Ct, La Quinta, CA 92253For Sale
Save MLS ID #219145763DA, Rachel Wills, Vista Sotheby's International. CRMLS - $1,395,0003 bd4 ba3k sqft54857 Inverness Way, La Quinta, CA 92253For Sale
Save MLS ID #219143345DA, Rick Parnell, Windermere Real Estate. CRMLS - $1,398,0003 bd4 ba3.2k sqft78420 Heritage Way, La Quinta, CA 92253For Sale
Save MLS ID #219146608DA, Jon Caruana, Compass. CRMLS - $1,250,0003 bd4 ba2.6k sqft81196 Victoria Ln, La Quinta, CA 92253For Sale
Save MLS ID #219148337DA, Sandi Phillips and Asso..., Compass. CRMLS - $2,200,0003 bd5 ba3.2k sqft47320 Via Koron, La Quinta, CA 92253For Sale
Save MLS ID #219141503DA, Dana Tarnow, Desert Sands Realty. CRMLS - $1,495,0004 bd4 ba2.8k sqft74090 Setting Sun Trl, Palm Desert, CA 92260For Sale
Save MLS ID #219144188DA, Nicole Dunn, KW Coachella Valley. CRMLS
- Request a tour
as early as today at 4:00 pm
Contact agent Local buyer's agents are ready to help
- California
- Riverside County
- La Quinta
- 92253
- 78625 Avenida Ultimo