$1,200,000
$50K PRICE DROP

78515 Avenida Ultimo La Quinta, CA 92253

Estimated payment $6,785/month

Total Views 4,424
3 Beds
3 Baths
2,246 Sq Ft
$534 Price per Sq Ft

Highlights

  • Home Theater
  • Contemporary Architecture
  • Pool View
  • In Ground Pool
  • Living Room with Fireplace
  • Quartz Countertops

About This Home

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.

Listing Agent

Pat Bianchi

Keller Williams Realty License #01893682 Listed on: 05/30/2025

Keller Williams Realty

Co-Listing Agent

Arleen Cohen-Bianchi

Keller Williams Realty License #01815894

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,698

Year Built

  • Built in 1996

Lot Details

  • 0.3 Acre Lot
  • Block Wall Fence
  • Drip System Landscaping

Home Design

  • Contemporary Architecture
  • Modern Architecture
  • Slab Foundation
  • Foam Roof
  • Stucco Exterior

Interior Spaces

  • 2,246 Sq Ft Home
  • 2-Story Property
  • Partially Furnished
  • Ceiling Fan
  • Gas Fireplace
  • Living Room with Fireplace
  • 2 Fireplaces
  • Home Theater
  • Ceramic Tile Flooring
  • Pool Views

Kitchen

  • Gas Cooktop
  • Range Hood
  • Recirculated Exhaust Fan
  • Microwave
  • Kitchen Island
  • Quartz Countertops

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Remodeled Bathroom
  • 3 Full Bathrooms

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Automatic Gate
  • On-Street Parking

Pool

  • In Ground Pool
  • Heated Spa
  • In Ground Spa
  • Outdoor Pool
  • Waterfall Pool Feature

Outdoor Features

  • Outdoor Fireplace

Utilities

  • Central Heating and Cooling System
  • Heating System Uses Natural Gas
  • Sewer in Street

Community Details

  • Desert Club Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 770091002

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,698

Year Built

Built in 1996

Lot Details

0

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Property Attached/Detached: No
  • Levels: One
  • Building Number Of Stories: 2
  • Building Style: Contemporary, Modern
  • List Price per Sq Ft: 534.28
  • View Type: Pool
  • Year Built: 1996
  • Co Listing Member Address: 70005 Mirage Cove Dr, Rancho Mirage, CA 92270
  • Co Listing Member Fax: (310) 775-9760
  • Co Listing Office Address: 70005 Mirage Cove Dr, Rancho Mirage, CA 92270
  • Co Listing Office Fax: (760) 770-9510
  • Listing I D: 219130788
  • Listing Member Address: 70005 Mirage Cove Dr, Rancho Mirage, CA 92270
  • Listing Office Address: 70005 Mirage Cove Dr, Rancho Mirage, CA 92270
  • Listing Office Fax: (760) 770-9510
  • Land Type: Fee
  • New Construction: No
  • Subdivision: Desert Club Estates
  • Special Features: None

Interior Features

  • Appliances: Refrigerator, Gas Cooktop, Microwave Oven, Exhaust Fan
  • Fireplace: Yes
  • Fireplace Location: Exterior, Living Room
  • Range Hood: Yes
  • Fireplace Features: Gas
  • Flooring: Ceramic Tile
  • Bedroom Features: 2 Primary Bedrooms
  • Total Bedrooms: 3
  • Bathroom Features: Remodeled
  • Total Bathrooms: 3.00
  • Full Bathrooms: 3
  • Eating Areas: Kitchen Island
  • Kitchen Features: Quartz Counters
  • Estimated Sq Ft: 2246.00

Exterior Features

  • Construction: Stucco
  • Roofing: Foam
  • Fencing: Block
  • Foundation: Slab
  • Pool: Yes
  • Pool Accessories: Waterfall
  • Pool Construction: In Ground
  • Pool Description: In Ground
  • Pool Location: Private
  • Planned Unit Development: No
  • Spa Hot Tub: Yes
  • Spa Hot Tub Construction: In Ground
  • Spa Hot Tub Description: Heated - Gas, Private
  • View: Yes

Garage/Parking

  • Garage: Yes
  • Garage Description: Attached
  • Parking: On Street, Garage Door Opener
  • Total Garage Spaces: 2.00
  • Total Parking Spaces: 4.00
  • Total Uncovered Assigned Spaces: 2.00

Utilities

  • Cooling Type: Air Conditioning, Central Air, Ceiling Fan(s)
  • Heating: Central
  • Heating Fuel: Natural Gas
  • Security: Automatic Gate
  • Sewer: In Street Paid

Lot Info

  • Sprinklers: Yes
  • Assessor Parcel Number: 770091002
  • Irrigation: Drip System
  • Lot Description: Automatic Gate, Street Public
  • Lot Size: 13068.00

Rental Info

  • Furnished: Partially
  • Land Lease Type: Fee Simple
  • Rental Restrictions: Yes

Tax Info

  • Mello Roos: Unknown

Multi Family

  • Total Fireplaces: 2

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $4,698 $1,025,000 $256,251 $768,749
2023 $4,698 $322,562 $62,024 $260,538
2022 $4,401 $316,238 $60,808 $255,430
2021 $4,289 $310,038 $59,616 $250,422
2020 $4,212 $306,860 $59,005 $247,855
2019 $4,127 $300,845 $57,849 $242,996
2018 $4,037 $294,947 $56,716 $238,231
2017 $3,976 $289,164 $55,604 $233,560
2016 $3,903 $283,495 $54,514 $228,981
2015 $3,913 $279,240 $53,697 $225,543
2014 $3,851 $273,773 $52,647 $221,126
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/19/2025 06/19/25 Price Changed $1,200,000 -4.0% $534 / Sq Ft
05/30/2025 05/30/25 For Sale $1,250,000 +22.0% $557 / Sq Ft
12/03/2024 12/03/24 Sold $1,025,000 -3.2% $400 / Sq Ft
10/22/2024 10/22/24 Pending -- -- --
10/04/2024 10/04/24 Price Changed $1,059,000 0.0% $414 / Sq Ft
10/04/2024 10/04/24 For Sale $1,059,000 +3.3% $414 / Sq Ft
09/30/2024 09/30/24 Off Market $1,025,000 -- --
06/15/2024 06/15/24 Price Changed $1,149,000 -11.3% $449 / Sq Ft
04/25/2024 04/25/24 For Sale $1,295,000 -- $506 / Sq Ft
Source: Greater Palm Springs Multiple Listing Service

Purchase History

Date Type Sale Price Title Company
Grant Deed $1,025,000 Equity Title
Deed -- Knasiak Leo Leonard
Grant Deed $260,000 Chicago Title Company
Grant Deed -- Chicago Title Company
Trustee Deed $338,852 Accommodation
Interfamily Deed Transfer -- New Century Title Company
Interfamily Deed Transfer -- Orange Coast Title
Interfamily Deed Transfer -- Orange Coast Title
Interfamily Deed Transfer -- Orange Coast Title
Grant Deed $225,000 Orange Coast Title
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- First American Title Co
Grant Deed $25,000 --
Interfamily Deed Transfer -- --
Grant Deed -- --
Grant Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $820,000 New Conventional
Previous Owner $134,025 New Conventional
Previous Owner $208,000 New Conventional
Previous Owner $607,200 Stand Alone Refi Refinance Of Original Loan
Previous Owner $74,000 Credit Line Revolving
Previous Owner $572,000 Fannie Mae Freddie Mac
Previous Owner $63,000 Stand Alone Second
Previous Owner $328,000 Unknown
Previous Owner $73,000 Stand Alone Second
Previous Owner $237,500 Purchase Money Mortgage
Previous Owner $20,087 Unknown
Previous Owner $192,000 Purchase Money Mortgage
Source: Public Records

Source: Greater Palm Springs Multiple Listing Service

MLS Number: 219130788

Greater Palm Springs Multiple Listing Service

APN: 770-091-002