78515 Ave Ultimo, La Quinta, CA 92253 (MLS# 219144008)

78515 Ave Ultimo, La Quinta, CA 92253

$999,900
Property Type: Residential Bedrooms: 3 Baths: 3 Square Footage: 2,246 Status: Active
Current Price: $999,900 List Date: 3/01/2026 Last Modified: 3/18/2026

Overview

Description

Custom designed gated 3 car garage home!!! Gorgeous remodeled kitchen and Primary Bath! Living Room, Formal Dining Room, Foyer, Great Room, , Casual Dining Room, Kitchen, Laundry Room, 3 Bedrooms (2 are matching primary suites) and 3 Full Bathrooms! Dramatic waterfall pool and spa! Living room/Dining Room have 12-foot ceilings, all the other rooms have 9-foot ceilings. Washer, Dryer, Counter-depth Frig, Gas Cook-top (w/ down-draft), Dishwasher, built-in Full-size Double Ovens, Built-in Beverage/Wine Frig and Built-in Microwave Oven. Kitchen remodel (2022). Italian Stainless-steel sink. Chrome Faucet. High-end Decorator solid chrome handles in kitchen, all 3 bathrooms, laundry room and closet. This subdivision is private and quiet, no through streets. No HOA! This home is great for entertaining. Living/dining room opens to the great room which opens to the yard/pool. open concept kitchen, Great Room, casual dining. Outdoor entertaining is ready with built in BBQ, large yard pool and spa ...

Listing Details MLS# 219144008

General Property Information

Total Bedrooms
3
Full Baths
3
Approx SqFt
2246
Total Baths
3
SqFt Source
Assessor
Fireplace
Yes
Total Fireplaces
Yes
Pool
Yes
Garage
Yes
Garage Description
Attached
Sprinklers
Yes
Building # of Stories
Yes
Lot Size Source
Assessor
Year Built
1996
Furnished
Unfurnished
Cross Streets
Calle Rodo

Property Features

Sale Type: Standard Listing Terms: Conventional Possession: Close Of Escrow View Type: Pool Irrigation: Drip System Disclosures: None Building Style: Modern Levels: One Entry Location: Living Room Range Hood: Yes Kitchen Features: Quartz Counters Eating Areas: Kitchen Island Flooring: Ceramic Tile Cooling Type: Air Conditioning; Central Air Pool Location: Private Pool Construction: In Ground; Pebble Pool Description: Gunite Heating: Central Heating Fuel: Natural Gas Fireplace Location: Dining Room Fireplace Features: Gas Rooms: Dining Room; Family Room; Living Room Security Safety: None Sewer: In Street Paid Parking: Garage Door Opener Land Lease Type: Fee Simple

Listing Location and Property Info

APN
770091002
Original List Price
1050000
Property Sub-Type
Single Family Residence
Street #
78515
Street Name
Ave Ultimo
County
Riverside
State
CA
Zip Code
92253
Area
313 -La Quinta South of HWY 111
Country
US

Listing Info

Short Term Rentals
No
Will Consider Lease
Yes

Tax Info

Tax Mello Roos
Unknown

Property Info

Golf Course Within Development
No
Senior Community
No
Gated Community
No
PUD Y/N
No
View
Yes
Total Monthly Association Fees
0

More Information

Status Change Info

Status Change Date
2026-03-01

Parking SpacesInformation

Total Garage Spaces
3
Total Parking Spaces
6

HOA Information

HOA
No

DPR

DPR Eligible
No

Listing, Location and Property Info

Entry Date
2026-03-01
Land Type
Fee

Sale Type

Standard
Yes

Listing Terms

Conventional
Yes

Possession

Close Of Escrow
Yes

Parking Spaces/Information

Total Covered Spaces
0
Total Uncovered/Assigned Spaces
3

View Type

Pool
Yes

Irrigation

Drip System
Yes

Disclosures

None
Yes

Building Style

Modern
Yes

Levels

One
Yes

Entry Location

Living Room
Yes

Range Hood

Yes
Yes

Kitchen Features

Quartz Counters
Yes

Eating Areas

Kitchen Island
Yes

Flooring

Ceramic Tile
Yes

Cooling Type

Air Conditioning
Yes
Central Air
Yes

Pool Location

Private
Yes

Pool Construction

In Ground
Yes
Pebble
Yes

Pool Description

Gunite
Yes

Spa/Hot Tub Construction

In Ground
Yes

Spa/Hot Tub Description

Private
Yes

Heating

Central
Yes

Heating Fuel

Natural Gas
Yes

Fireplace Location

Dining Room
Yes

Fireplace Features

Gas
Yes

Rooms

Dining Room
Yes
Family Room
Yes
Living Room
Yes

Security Safety

None
Yes

Sewer

In Street Paid
Yes

Parking

Garage Door Opener
Yes

Land Lease Type

Fee Simple
Yes
Listing Office: Keller Williams Realty
Listing Agent: Pat Bianchi
Last Updated: March - 18 - 2026
Information deemed reliable but not guaranteed.

Scroll to Top