Skip main navigation
Off market
  • Zillow Home logoZestimate®
    $1,414,900

    78625 Avenida Ultimo, La Quinta, CA 92253

    4beds
    2,370sqft
    Single Family Residence
    Built in ----
    -- sqft lot
    $1,414,900 Zestimate®
    $597/sqft
    $6,350 Estimated rent

    Home value

    $1,414,900

    $1.34M - $1.49M

    $6,350/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $6,350/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $6,350/mo

    Rent Zestimate®

    Refinance and save

    $9,611/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $9,611/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    2026 Availability (Stays not to exceed 2 months) * Jun 15 - Oct 5 $6,996 per mo. * Nov 19 - Dec 20 $10,075 per mo. 2027 Availability (Stays not to exceed 2 months) * Apr 1 - Apr 30 $19,950 per mo. * May 1 - Oct 31 $6.996 per mo. * Nov 1 - Dec 31 $10,075 per mo. * Pool/ Spa Heating $35.00 per day (when applicable) * Dog Friendly $500 Flat rate per stay. (2) dog limit. Small to mid-sized. *Cleaning $750 **City of La Quinta requires 30+ night stays. This property is not permitted for short-term rentals. Located in La Quinta's beautiful Desert Estates (just down the street from Old Town), Casa Ultimo features 4 bedrooms, 3.5 baths, gourmet kitchen and spectacular great room. Resort style outdoor space features well-appointed patio's with BBQ, fire pit, heated pool & 2 spa's. AC, high-end furnishings, appliances, and home entertainment. Professionally remodeled and decorated 2,400 sqft single level home sleeps 8 with garage and driveway parking for 4 vehicles. EV charger. 2 Electric bikes. Dog-friendly. 2-minute drive to Old Town. Launched December 2021. Property Overview Casa Ultimo embodies the desert resort lifestyle. A Splendid Rentals Premier property, the spacious single level floor plan features vaulted ceilings, laminate floors, ample windows with spectacular views of outdoor living space and the majestic Santa Rosa mountains. Living Area The home hosts a large gourmet kitchen featuring custom cabinetry, granite tops, and high-end appliances. It overlooks the tastefully furnished dining and great room, spa, and mountains. Bedrooms Hosts four bedrooms- 2 ensuites and 2 secondary. All feature premium flooring, fine furnishings, quality linens, closets, ceiling fans, and HI-Def TV's. Memory foam king mattresses sit atop custom bed frames. Finished with wireless phone chargers and Amazon Echo Dots. Bathrooms Hosts 3.5 bathrooms. The primary master, a dual vanity, walk-in shower, and Roman tub. The 2nd master, a single vanity and walk-in shower. The 3rd, a single vanity and walk-in shower. The 4th, a stunning powder room. All well stocked with plush towels, spa-quality toiletries, hair dryers and curling irons. Service Areas Separate laundry room boasts high efficiency, front-loading washer and dryer. Premium washing supplies. Home Entertainment Casa Ultimo is home entertainment rich. Featuring Wi-Fi, cable, (4) Hi-Def TV's, (4) Fire TV's, (1) Sonos Sound Bar, (1) Xbox One, (1) iPad, and (1) Amazon Echo. Subscription services include Amazon Music Unlimited, Prime Video, and Netflix. For guests desiring classic family entertainment, there are pool and ping pong tables, corn hole, ample board games, books and magazines. Also, 2 RAD electric bikes with helmets. Workspace For those working or schooling remotely, a monochrome laser printer, paper, and USB cable is provided. High speed Nest WiFi throughout home. Outdoor Living Space Placing an equal emphasis on outdoor living, the home features spacious front and backyards with fully appointed patios. Amenities include covered dining area with ceiling fan, oversized stainless BBQ, fire pit, and numerous seating and lounging areas. The enclosed front yard features a pool and spa. The back has an oversized spa and yard area. Heating is provided free of charge. Small Details The property has everything expected from a luxury vacation home. The kitchen is complete with high-quality cookware, utensils, and gadgets. As well as a large selection of coffee capsules for the Keurig & Nespresso brewers. There is a tasteful selection of desert-themed table settings. Designer candles throughout property. The laundry stocks quality supplies, iron, and board. Fred Wolff Bear Creek Nature Preserve For guests desiring immediate access to fresh air activities, the Santa Rosa Mountains are literally in the backyard. Fred Wolff Bear Creek Nature Preserve showcases local wildlife and native flora with trails for jogging, hiking, bicycling, and dog walking. Children and adults alike enjoy exploring the natural beauty of the area. About La Quinta La Quinta is a luxury destination, home to world class golf, tennis, equestrian, and concert events. Including shopping, dining and entertainment. Old Town, a quick 2-minute drive, features a number of boutique shops, restaurants and an exceptional coffeehouse. World famous La Quinta Resort and Club, 5-minutes. Desiring even more quality desert life experiences? El Paseo in Palm Desert, renowned for best of class retail shopping, is 20-minutes. Safety Features Smoke detectors/ Carbon monoxide detectors/ Multiple fire extinguishers/ First Aid kit/ Flashlights. * 30+ Day stay minimum * Renters insurance is required * Cleaning fee is $750 * Dog friendly (Limit 2. $500 Flat rate pet rent) * Utilities (gas, electric, cable, WIFI, sewage, water & trash) are not included from May thru Sep. Approximately $750 per month. * Gardening services are included * No events or parties without permission * No smoking (e-cigarette/ vaping/ hookah included) in property * This is a Smart Home with multiple WIFI enabled devices. Do not tamper with internet hardware. Critical guest health & safety components like Smoke/ C02 warnings are connected. * Gentle reminder that this is our home and to treat it, and surrounding neighbors, with consideration

    This property is not currently displayed as for sale or rent on Zillow. This may be different from what's on other websites or public sources.

    Zillow last checked:

    Listing updated:

    Source: Zillow Rentals

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Heating
    • Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Dryer, Oven, Refrigerator, Washer
    • Laundry: In Unit
    Features
    • Flooring: Hardwood
    • Furnished: Yes
    Interior area
    • Total interior livable area: 2,370 sqft

    Property

    Parking
    • Parking features: Attached
    • Has attached garage: Yes
    • Details: Contact manager
    Features
    • Exterior features: Bicycle storage, Electric Vehicle Charging Station, Heating system: Forced Air, Pet Park
    • Has private pool: Yes
    • Pool features: Pool
    Details
    • Parcel number: 770092002

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence

    Community & HOA

    Community
    • Deposit fee: $5,000
    HOA
    • Amenities included: Pool
    Location
    • Region: La Quinta

    Financial & listing details

    • Price per square foot: $597/sqft
    • Tax assessed value: $786,821
    • Date on market: 11/29/2024
    • Lease term: 1 Month

    Price history

    DateEventPrice
    10/9/2026Listing removed$1,499,000$632/sqft
    Source: CDAR/ Desert Area MLS #219149858 Report a problem
    8/12/2026Price change$1,499,000-3.3%$632/sqft
    Source: Greater Palm Springs Realtors #219149858 Report a problem
    7/2/2026Listed for sale$1,550,000+20.6%$654/sqft
    Source: CDAR/ Desert Area MLS #219149858 Report a problem
    6/6/2026Listing removed$6,996$3/sqft
    Source: Zillow Rentals Report a problem
    2/28/2025Price change$6,996-28.2%$3/sqft
    Source: Zillow Rentals Report a problem
    11/30/2024Listed for rent$9,750-1.2%$4/sqft
    Source: Zillow Rentals Report a problem
    7/25/2024Listing removed--
    Source: Zillow Rentals Report a problem
    5/6/2024Listed for rent$9,870+182%$4/sqft
    Source: Zillow Rentals Report a problem
    8/22/2023Listing removed--
    Source: HomeSmart Report a problem
    4/28/2023Price change$1,285,000-1.2%$542/sqft
    Source: Greater Palm Springs Realtors #219094216 Report a problem
    11/11/2022Listed for sale$1,300,000+92.6%$549/sqft
    Source: CDAR/ Desert Area MLS #219087104 Report a problem
    8/24/2021Sold$675,000-9.9%$285/sqft
    Source: CDAR/ Desert Area MLS #219062756 Report a problem
    8/9/2021Contingent$749,000$316/sqft
    Source: Greater Palm Springs Realtors #219062756 Report a problem
    5/28/2021Listed for sale$749,000+26650%$316/sqft
    Source: Greater Palm Springs Realtors #219062756 Report a problem
    8/16/2019Sold$2,800-99.4%$1/sqft
    Source: Greater Palm Springs Realtors #19474382PS Report a problem
    6/25/2019Listing removed$3,500$1/sqft
    Source: Hayes Real Estate #19474382PS Report a problem
    6/8/2019Price change$475,000-5%$200/sqft
    Source: Hayes Real Estate #19474366PS Report a problem
    6/5/2019Listed for rent$3,500$1/sqft
    Source: Hayes Real Estate #19474382PS Report a problem
    2/20/2019Price change$499,900-5.5%$211/sqft
    Source: HK Lane Real Estate #218033026 Report a problem
    11/23/2018Price change$529,000-3.6%$223/sqft
    Source: HK Lane Real Estate #218033026 Report a problem
    8/13/2018Listed for sale$549,000+23.4%$232/sqft
    Source: Bennion Deville Homes #218022472 Report a problem
    10/5/2004Sold$445,000$188/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2026-- $786,821 +2%
    2025$10,251 +2.3%$771,394 +9.8%
    2024$10,015 +14.1%$702,269 +2%
    2023$8,780 +2.5%$688,500 +2%
    2022$8,561 +16.9%$675,000 +16%
    2021$7,322 +12.7%$581,875 +12%
    2020$6,497 +3.1%$519,532 +3%
    2019$6,302 +4.2%$504,400 +4%
    2018$6,049 +6.8%$485,000 +6.6%
    2017$5,666 $455,000 -3.8%
    2016$5,666 -6.5%$473,000 -1.9%
    2015$6,058 +23.1%$482,000 +23.9%
    2014$4,923 $389,000 +10.2%
    2013-- $353,000 +20.1%
    2012-- $294,000 -8.1%
    2011-- $320,000 +0.6%
    2010-- $318,000 -16.1%
    2009-- $379,000 -23.2%
    2008-- $493,459 +2%
    2007-- $483,785 +2%
    2006-- $474,300 +6.6%
    2005-- $445,000 +62%
    2003-- $274,708 +2%
    2002-- $269,323 +2%
    2001$3,532 +1.7%$264,044 +2%
    2000$3,473 $258,868
    Find assessor info on the county website

    Neighborhood: 92253

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,414,900
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,414,900