Skip main navigation
Off market
  • $628,800

    77509 Avenida Madrugada, La Quinta, CA 92253

    2beds
    1,389sqft
    Single Family Residence
    Built in ----
    -- sqft lot
    $628,800 Zestimate®
    $453/sqft
    $4,260 Estimated rent

    Home value

    $628,800

    $572,000 - $692,000

    $4,260/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,260/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

    $4,260/mo

    Rent Zestimate®

    Refinance and save

    $4,057/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

    $4,057/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

    Gas fireplaceLarge smart tvRemodeled kitchen

    This Santa Rosa Cove hacienda has unparalleled Spanish charm with custom tiling and accents throughout. The private courtyard is surrounded by mature vines and greenery, creating a tranquil and beautiful outdoor entertainment space. The open floorplan has elevated ceilings with multiple dining and entertainment spaces. The remodeled kitchen is completely stocked with all cookware and essentials required for an extended stay. The living room is outfitted with a plentiful lounge seating, a large smart TV, and gas fireplace. Just off of the living area, open the sliding glass doors to a private patio overlooking the gorgeous greenbelt with breathtaking mountain views. Enjoy the abundance of sunshine on the back patio, outfitted with plenty of lounge seating as well as a gas BBQ. The main bedroom has a King size bed, smart TV, access to the private patio, and an ensuite bathroom, outfitted with a double vanity and tub/shower The second bedroom has a queen size bed, smart TV, and a remodeled walk in shower. This home also comes with exclusive access of 1 car garage. Guests will have full access to Santa Rosa Cove community amenities, including 10 swimming pools and spas and 3 Tennis Courts, as well as 24/7 Front gate security. You will not have resort privileges with this rental, but you are welcome to dine at the Resort restaurants, walk the Resort grounds, Golf at the Resort Courses and utilize the World-Renowned Spa for a fee. This is a fully furnished, 30 day or more rental. Please inquire about discounts for long term stays! Available January 1, 2026 2026 January - Reserved February - Reserved March - Reserved April - Reserved May - Reserved June - Reserved July - Reserved Aug - Reserved Sept - Reserved Oct - Reserved Nov - Reserved Dec - Reserved 2027 January - Reserved February - Reserved March - Reserved April - Reserved May - Reserved Owner Utility Credit of $350/mo. The Renter is responsible for all utilities (Gas, Electric, Water) above the $350 monthly utility credit thereafter. Please contact Desert Sol Real Estate with any questions or inquiries. DRE#01984950

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Zillow last checked:

    Listing updated:

    Source: Zillow Rentals

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 2
    • Full bathrooms: 2
    Heating
    • Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Dryer, Freezer, Microwave, Oven, Refrigerator, Washer
    • Laundry: In Unit
    Features
    • Flooring: Tile
    • Furnished: Yes
    Interior area
    • Total interior livable area: 1,389 sqft

    Property

    Parking
    • Parking features: Attached, Off Street
    • Has attached garage: Yes
    • Details: Contact manager
    Features
    • Exterior features: Bicycle storage, Electricity not included in rent, Gas not included in rent, Heating system: Forced Air, No Utilities included in rent, Utilities fee required, Water not included in rent
    • Has private pool: Yes
    • Pool features: Pool
    Details
    • Parcel number: 773340040

    Construction

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

    Community & HOA

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

    Financial & listing details

    • Price per square foot: $453/sqft
    • Tax assessed value: $451,221
    • Annual tax amount: $6,324
    • Date on market: 2/8/2026
    • Lease term: 1 Month

    Price history

    DateEventPrice
    2/9/2026Listing removed$12,500$9/sqft
    Source: Zillow Rentals Report a problem
    12/27/2025Listed for rent$12,500$9/sqft
    Source: Zillow Rentals Report a problem
    11/26/2025Listing removed$12,500$9/sqft
    Source: Zillow Rentals Report a problem
    10/2/2025Listed for rent$12,500$9/sqft
    Source: Zillow Rentals Report a problem
    9/15/2025Listing removed$12,500$9/sqft
    Source: Zillow Rentals Report a problem
    9/2/2025Listed for rent$12,500$9/sqft
    Source: Zillow Rentals Report a problem
    6/3/2025Listing removed$12,500$9/sqft
    Source: Zillow Rentals Report a problem
    12/5/2024Listed for rent$12,500$9/sqft
    Source: Zillow Rentals Report a problem
    11/23/2024Listing removed$12,500$9/sqft
    Source: Zillow Rentals Report a problem
    11/2/2024Listed for rent$12,500+48.8%$9/sqft
    Source: Zillow Rentals Report a problem
    4/16/2021Listing removed--
    Source: CDAR/ Desert Area MLS Report a problem
    4/2/2021Listed for rent$8,400$6/sqft
    Source: CDAR/ Desert Area MLS #219034684 Report a problem
    1/12/2021Listing removed--
    Source: CDAR/ Desert Area MLS Report a problem
    11/29/2019Listed for rent$8,400$6/sqft
    Source: La Quinta Resort Leasing #219034684 Report a problem
    3/30/2019Sold$454,500-7.1%$327/sqft
    Source: CDAR/ Desert Area MLS #219003899 Report a problem
    2/3/2019Listed for sale$489,000+4.3%$352/sqft
    Source: California Lifestyle Realty #219003899 Report a problem
    3/1/2017Listing removed$469,000$338/sqft
    Source: California Lifestyle Realty #217002936 Report a problem
    2/5/2017Price change$469,000-5.3%$338/sqft
    Source: California Lifestyle Realty #217002936 Report a problem
    1/28/2017Listed for sale$495,000+10%$356/sqft
    Source: California Lifestyle Realty #217002936 Report a problem
    12/20/2011Listing removed$449,900$324/sqft
    Source: California Lifestyle Realty #21392071 Report a problem
    3/26/2011Price change$449,900+100100.4%$324/sqft
    Source: California Lifestyle Realty #21392071 Report a problem
    2/25/2011Price change$449-99.9%
    Source: California Lifestyle Realty #21392071 Report a problem
    9/2/2010Price change$395,000-7.1%$284/sqft
    Source: California Lifestyle Realty #21392071 Report a problem
    3/30/2010Price change$425,000-5.5%$306/sqft
    Source: California Lifestyle Realty #21392071 Report a problem
    3/6/2010Listed for sale$449,900-21.8%$324/sqft
    Source: California Lifestyle Realty #21392071 Report a problem
    2/28/2006Sold$575,000+98.3%$414/sqft
    Source: Public Record Report a problem
    6/30/2003Sold$290,000+48.7%$209/sqft
    Source: Public Record Report a problem
    4/12/2000Sold$195,000+40.8%$140/sqft
    Source: Public Record Report a problem
    1/9/1997Sold$138,500+123.4%$100/sqft
    Source: Public Record Report a problem
    6/11/1996Sold$62,000$45/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$6,324 +2.6%$451,221 +2%
    2024$6,165 +2.8%$442,375 +2%
    2023$5,999 +3.2%$433,702 +2%
    2022$5,815 +2.4%$425,199 +2%
    2021$5,676 +1.8%$416,863 +1%
    2020$5,574 $412,590 +6.4%
    2019-- $387,920 +4%
    2018$5,064 +6.2%$373,000 +7.2%
    2017$4,770 $348,000
    2016$4,770 +5.8%$348,000 +8.4%
    2015$4,510 +7.2%$321,000 +8.4%
    2014$4,209 $296,000 +12.5%
    2013-- $263,000 -1.5%
    2012-- $267,000 -6.6%
    2011-- $286,000 -12.3%
    2010-- $326,000 -25.9%
    2009-- $440,000 -26.4%
    2008-- $598,229 +2%
    2007-- $586,500 +90.8%
    2006-- $307,346 +2%
    2005-- $301,321 +45.6%
    2003-- $206,934 +2%
    2002-- $202,877 +2%
    2001$2,666 +29.1%$198,900 +35.5%
    2000$2,065 $146,763
    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
    $628,800
    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
    $628,800