Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$1,550,000 Just Listed

  • For Sale
  • Active
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 2,611 Sq. Ft.
  • 2 Car Garage
  • Updated 2 days ago
See This Home
Save This Home
See This Home
Save This Home
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.

Full Property Details for 78625 Avenida Ultimo

General

  • Price: $1,550,000
  • Status: Active
  • Type: Single Family
  • Source: Desert_Area_Palm_Springs
  • MLS ID: 219149858
  • Updated: 7/2/2026
  • Added to Site: 3 day(s) ago

Interior

  • Rooms/Areas: Great Room, Dining Area
  • Interior Features: High Ceilings (9 Ft+)
  • Number of Fireplaces: 1
  • Eating Areas: Dining Area, Living/Dining Combo, Kitchen Island
  • Appliances: Dryer, Convection Oven, Microwave Oven, Water Line to Refrigerator, Washer, Refrigerator, Dishwasher
  • Furnished: Yes
  • Furnishings: Turnkey
  • Flooring: Laminate
  • 220 Volt Locations: In Garage

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1

Bedrooms

  • Total Bedrooms: 4

Other Rooms

  • Kitchen: Gourmet Kitchen, Remodeled, Island
  • Laundry: Individual Room

Additional Information

  • Pool: Yes
  • Pool Description: Salt Water, Private, In Ground, Salt Water, Private, In Ground, Private
  • Spa: Yes
  • Spa Description: In Ground, Heated - Gas, Private
  • Security/Safety: Automatic Gate, Security System Owned, Exterior Security Lights, Closed Circuit Camera(s)

Exterior

  • Deck/Patio: Covered, Wraparound

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Covered Spaces: 2
  • Uncovered Spaces: 2
  • Total Spaces: 6
  • Parking: Direct Entrance, Driveway, Garage Door Opener
  • Garage Description: Attached

Location

  • Area: 313 -La Quinta South of HWY 111
  • County: Riverside
  • Subdivision: Desert Club Estates
  • Cross Streets: Calle Tampico and Calle Quito

Heating & Cooling

  • Cooling Type: Central Air, Zoned
  • Heating Type: Forced Air

Utilities

  • Sewer: In, Connected and Paid

Structural Information

  • Doors: French Doors
  • Sprinklers: Yes
  • Square Feet: 2,611
  • Sq. Ft. Source: Appraiser
  • Year Built: 1991
  • Year Built Source: Assessor
  • Property Condition: Updated/Remodeled
  • Other Struct. Feat.: Custom Built, Premium Lot

Additional Structures

  • Other Structures: Pool House

Lot Features

  • Mountain views: Yes
  • Lot Size (Sq. Ft.): 12,197
  • Lot Size Source: Assessor
  • Irrigation System: Drip System, Sprinkler Timer, Sprinkler System
  • Fencing (Description): Stucco Wall

Financial Considerations

  • Price Per Sq. Ft.: $593
  • Terms: Cash, 1031 Exchange, Cash to New Loan

Disclosures and Reports

  • APN: 770092002

Listed by Equity Union, Raymond J Radas

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 78625 Avenida Ultimo —

  • Raymond J Radas

    Equity Union

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 78625 Avenida Ultimo

School District:Desert Sands Unified School District
NameGradesDistance
Harry S. Truman Elementary School
78-870 Ave. 50, La Quinta, CA 92253
K-50.4 mi
La Quinta Middle School
78-900 Ave. 50, La Quinta, CA 92253
6-80.5 mi
La Quinta High School, La Quinta, CA
79-255 Blackhawk Way, La Quinta, CA 92253
9-122.3 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 78625 Avenida Ultimo Get Price Alerts and Save Property

Date
Details
Price
Change
Source
7/02/2026
Listed
$1,550,000
129.63%
MLS
8/10/2021
Sold
$675,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 78625 Avenida Ultimo

Year
Property Taxes
Change
Tax Assessment
Change
2025
$10,251
10%
$771,394
10%
2024
$9,354
7%
$702,269
2%
2023
$8,780
3%
$688,500
2%
2022
$8,561
17%
$675,000
16%
2021
$7,322
13%
$581,875
12%
2020
$6,497
3%
$519,532
3%
2019
$6,302
4%
$504,400
4%
2018
$6,049
7%
$485,000
7%
2017
$5,666
-3%
$455,000
-4%
2016
$5,840
-4%
$473,000
-2%
2015
$6,058
23%
$482,000
24%
2014
$4,923
10%
$389,000
10%
2013
$4,465
—
$353,000
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 78625 Avenida Ultimo

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Equity Union, Raymond J Radas

Similar Properties near 78625 Avenida Ultimo

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

77869 Desert Dr, La Quinta, CA 92253 - Photo 1
$1,575,000

77869 Desert Dr  La Quinta, CA 92253

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 3,031
    Sq. Ft.
Listed by Marie Sontz (CalRE#: 02113787) (760) 409-4434
49374 Gila River St, Indio, CA 92201 - Photo 1
$1,495,000

49374 Gila River St  Indio, CA 92201

  • Single Family
  • Active
  • Updated 10 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 3,150
    Sq. Ft.
73198 Loma Vista Ln, Palm Desert, CA 92260 - Photo 1
$1,599,000
Open House

73198 Loma Vista Ln  Palm Desert, CA 92260

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 3,054
    Sq. Ft.
74090 Setting Sun Trail, Palm Desert, CA 92260 - Photo 1
$1,495,000

74090 Setting Sun Trail  Palm Desert, CA 92260

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 2,893
    Sq. Ft.

Just Listed near 78625 Avenida Ultimo

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

77431 Huntley Dr, Indian Wells, CA 92210 - Photo 1 Just Listed
$1,195,000
Open House

77431 Huntley Dr  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,031
    Sq. Ft.
75180 Hancock Pl, Indian Wells, CA 92210 - Photo 1 Just Listed
$2,400,000

75180 Hancock Pl  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 5
    Total Baths
  • 3,020
    Sq. Ft.
74984 S Chateau Circle, Indian Wells, CA 92210 - Photo 1 Just Listed
$519,000

74984 S Chateau Circle  Indian Wells, CA 92210

  • Condo
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,947
    Sq. Ft.
38406 Brandywine Ave, Palm Desert, CA 92211 - Photo 1 Just Listed
$374,900

38406 Brandywine Ave  Palm Desert, CA 92211

  • Single Family
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,157
    Sq. Ft.
Listed by Team Francis (760) 776-9898

Price Reduced near 78625 Avenida Ultimo

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

75313 14th Green Dr, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$49,000 (-2.45%)
$1,950,000

75313 14th Green Dr  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 2,855
    Sq. Ft.
Listed by Susan Winters-McIntosh (CalRE#: 00982931) (760) 989-0244
44848 Oro Grande Cir, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$75,000 (-7.52%)
$923,000

44848 Oro Grande Cir  Indian Wells, CA 92210

  • Condo
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,813
    Sq. Ft.
78130 Cortez Ln, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$25,100 (-7.72%)
$299,900

78130 Cortez Ln  #56  Indian Wells, CA 92210

  • Condo
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,152
    Sq. Ft.
109 Verde Way, Palm Desert, CA 92260 - Photo 1 Price Reduced
-$50,000 (-9.09%)
$500,000

109 Verde Way  Palm Desert, CA 92260

  • Condo
  • Active
  • Updated 2 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,421
    Sq. Ft.
Listed by The Hamilton Real Estate Group (760) 625-7229

Recent Sales near 78625 Avenida Ultimo

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

50245 Mountain Shadows Rd, La Quinta, CA 92253 - Photo 1 Sold
$1,555,000

50245 Mountain Shadows Rd  La Quinta, CA 92253

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 3,100
    Sq. Ft.
79140 Jack Rabbit Trail, La Quinta, CA 92253 - Photo 1 Sold
$1,610,000

79140 Jack Rabbit Trail  La Quinta, CA 92253

  • Single Family
  • Closed
  • Updated 4 days ago
  • 4
    Beds
  • 5
    Total Baths
  • 3,840
    Sq. Ft.
78700 Cabrillo Way, La Quinta, CA 92253 - Photo 1 Sold
$1,671,500

78700 Cabrillo Way  La Quinta, CA 92253

  • Single Family
  • Closed
  • 3
    Beds
  • 4
    Total Baths
  • 3,135
    Sq. Ft.
79200 Jack Rabbit Trail, La Quinta, CA 92253 - Photo 1 Sold
$1,650,000

79200 Jack Rabbit Trail  La Quinta, CA 92253

  • Single Family
  • Closed
  • 4
    Beds
  • 5
    Total Baths
  • 3,723
    Sq. Ft.

78625 Avenida Ultimo, La Quinta, CA 92253 (MLS# 219149858) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 78625 Avenida Ultimo is currently listed for $1,550,000 and was received on July 02, 2026. Want to learn more about 78625 Avenida Ultimo? Do you have questions about finding other Single Family real estate for sale in La Quinta? You can browse all La Quinta real estate or contact a Coldwell Banker agent to request more information.

Tour this property