Custom designed gated 3 car garage home!!!Gorgeous remodeled kitchen and Primary Bath! Living Room, Formal Dining Room, Foyer, Great Room, Family 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, family room, casual dining. Outdoor entertaining is ready with built in BBQ, large yard pool and spa, Fireplace (gas) and patio off of primary suite. Great family home or vacation home. Owned and Leased Solar.
For sale
Listing Provided by:
Pat Bianchi DRE #01893682 760-969-1000,
Keller Williams Realty,
Arleen Cohen-Bianchi DRE #01815894 310-435-2944,
Keller Williams Realty
Price cut: $50K (6/19)
$1,200,000
78515 Avenida Ultimo, La Quinta, CA 92253
3beds
2,246sqft
Est.:
Single Family Residence
Built in 1996
0.3 Acres Lot
$1,168,200 Zestimate®
$534/sqft
$-- HOA
What's special
- 89 days
- on Zillow |
- 518 |
- 26 |
Zillow last checked: 7 hours ago
Listing updated: July 21, 2025 at 12:31pm
Listing Provided by:
Pat Bianchi DRE #01893682 760-969-1000,
Keller Williams Realty,
Arleen Cohen-Bianchi DRE #01815894 310-435-2944,
Keller Williams Realty
Source: CRMLS,MLS#: 219130788PS
Originating MLS: California Desert AOR & Palm Springs AOR

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
Rooms
- Room types: Primary Bedroom, Media Room
Primary bedroom
- Features: Multiple Primary Suites
Bathroom
- Features: Remodeled
Kitchen
- Features: Quartz Counters
Heating
- Central, Natural Gas
Cooling
- Central Air
Appliances
- Included: Gas Cooktop, Microwave, Refrigerator, Range Hood, Vented Exhaust Fan
Features
- Breakfast Bar, Partially Furnished, Multiple Primary Suites
- Flooring: Tile
- Has fireplace: Yes
- Fireplace features: Gas, Living Room, Outside
Interior area
- Total interior livable area: 2,246 sqft
Property
Parking
- Total spaces: 4
- Parking features: Garage, Garage Door Opener, On Street
- Attached garage spaces: 2
- Uncovered spaces: 2
Features
- Levels: One
- Stories: 1
- Has private pool: Yes
- Pool features: In Ground, Waterfall
- Spa features: Heated, In Ground, Private
- Fencing: Block
- Has view: Yes
- View description: Pool
Lot
- Size: 0.3 Acres
- Features: Drip Irrigation/Bubblers
Details
- Parcel number: 770091002
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary,Modern
- Property subtype: Single Family Residence
Materials
- Stucco
- Foundation: Slab
- Roof: Foam
Condition
- New construction: No
- Year built: 1996
Community & HOA
Community
- Security: Security Gate
- Subdivision: Desert Club Estates
Location
- Region: La Quinta
Financial & listing details
- Price per square foot: $534/sqft
- Tax assessed value: $329,012
- Annual tax amount: $4,698
- Date on market: 5/30/2025
- Listing terms: Cash,Cash to New Loan,Conventional
- Loading
- Loading