Skip main navigation
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
    : 
    Single Family Residence
    Built in 1996
    0.3 Acres Lot
    $1,168,200 Zestimate®
    $534/sqft
    $-- HOA

    What's special

    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.
    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#: 219130788PSMLS LogoOriginating MLS: California Desert AOR & Palm Springs AOR
    Travel times

    Tour with a buyer's agent

    We'll find a local expert to take you on a private tour of 78515 Avenida Ultimo.

    Next available tour time:Today at 11am

    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