Skip main navigation
Off market
  • Tax assessed value
    $410,126

    51207 Avenida Herrera, La Quinta, CA 92253

    4beds
    1,960sqft
    Single Family Residence
    Built in ----
    -- sqft lot
    $-- Zestimate®
    $209/sqft
    $3,770 Estimated rent

    Home value

    Not available

    Estimated sales range

    Not available

    $3,770/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,770/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

    $3,770/mo

    Rent Zestimate®

    Refinance and save

    $2,592/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

    $2,592/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

    VARYING RATES PER MONTH! NEWLY REMODELED. MOVE-IN READY Welcome to this stunning masterpiece in the heart of La Quinta. This modern cubic-style home seamlessly blends various architectural influences, combining mid-century modern aesthetics with the sleek lines of desert contemporary designs. Located in a neighborhood known for its artistic vibe and proximity to nature, this vacant property offers a unique blend of luxury and tranquility. As you step inside, you'll be greeted by an open layout that effortlessly connects the kitchen to the potential living area, creating a spacious and well-lit ambiance. The elegant lighting throughout the house complements the design, casting a warm glow that enhances the overall atmosphere. Sliding doors seamlessly connect adjacent rooms, promoting a fluid and interconnected living experience. The kitchen features a stylish island, perfect for culinary enthusiasts and social gatherings. With new construction and upscale finishes, this property exudes modern elegance and sophistication. The large windows and sliding doors not only provide abundant natural light but also offer captivating views of the surrounding Santa Rosa Mountains. Retreat to one of four generously sized bedrooms, including two luxurious master suites. Each thoughtfully designed space promises restful slumber. Three full bathrooms provide ample convenience for family or guests. One of the standout features of this home is its commitment to sustainability, boasting solar panels that contribute to eco-friendly living. Imagine the joy of living in a space that combines luxurious comfort with environmental responsibility. This thoughtfully designed residence includes four bedrooms and two and a half baths, ensuring ample space for your family or guests. La Quinta Cove's unique charm, with its beautiful scenery and artistic community, serves as the backdrop to this architectural gem. Embrace a lifestyle that encourages outdoor exploration with hiking trails offering breathtaking views, especially during the mesmerizing sunsets. Engage in community events like the La Quinta Art Walks and Night Sky Star Observations, fostering a strong sense of belonging and connection. Don't miss the opportunity to make this retreat in La Quinta Cove your own. Experience luxury, serenity, and a unique blend of architectural styles in this exquisite property. Available for a long term rental. Owner is open to month to month of an annual lease.

    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: 4
    • Bathrooms: 3
    • Full bathrooms: 3
    Rooms
    • Room types: []
    Heating
    • Forced Air
    Cooling
    • Central Air
    Appliances
    • Laundry: Hookups
    Features
    • WD Hookup
    Interior area
    • Total interior livable area: 1,960 sqft

    Property

    Parking
    • Parking features: Attached
    • Has attached garage: Yes
    • Details: Contact manager
    Features
    • Exterior features: Heating system: Forced Air
    Details
    • Parcel number: 773063020

    Construction

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

    Community & HOA

    Community
    • Deposit fee: $2,500
    Location
    • Region: La Quinta

    Financial & listing details

    • Price per square foot: $209/sqft
    • Tax assessed value: $410,126
    • Annual tax amount: $5,827
    • Date on market: 1/6/2024
    • Lease term: 1 Year

    Price history

    DateEventPrice
    8/23/2025Listing removed$795,000$406/sqft
    Source: SDMLS #CV24228271 Report a problem
    7/31/2025Listed for rent$3,000-15.5%$2/sqft
    Source: CRMLS #CV25171782 Report a problem
    6/28/2025Listed for sale$795,000+1035.7%$406/sqft
    Source: SDMLS #CV24228271 Report a problem
    11/23/2024Listing removed$3,549$2/sqft
    Source: CRMLS #SR24003415 Report a problem
    11/20/2024Listed for rent$3,549-1.4%$2/sqft
    Source: CRMLS #SR24003415 Report a problem
    11/13/2024Listing removed$3,598$2/sqft
    Source: Zillow Rentals Report a problem
    9/19/2024Price change$3,5980%$2/sqft
    Source: Zillow Rentals Report a problem
    8/29/2024Price change$3,599-8.9%$2/sqft
    Source: Zillow Rentals Report a problem
    8/15/2024Price change$3,950-1.3%$2/sqft
    Source: Zillow Rentals Report a problem
    8/1/2024Price change$4,000-0.6%$2/sqft
    Source: Zillow Rentals Report a problem
    6/30/2024Price change$4,025-1.2%$2/sqft
    Source: Zillow Rentals Report a problem
    4/10/2024Price change$4,075-1.2%$2/sqft
    Source: Zillow Rentals Report a problem
    3/6/2024Price change$4,125-3.9%$2/sqft
    Source: Zillow Rentals Report a problem
    3/4/2024Price change$4,2940%$2/sqft
    Source: Zillow Rentals Report a problem
    1/31/2024Price change$4,295-8.5%$2/sqft
    Source: Zillow Rentals Report a problem
    1/26/2024Price change$4,695-6%$2/sqft
    Source: Zillow Rentals Report a problem
    1/16/2024Price change$4,995-8.3%$3/sqft
    Source: Zillow Rentals Report a problem
    1/11/2024Price change$5,445-0.9%$3/sqft
    Source: Zillow Rentals Report a problem
    1/7/2024Listed for rent$5,495$3/sqft
    Source: Zillow Rentals Report a problem
    12/6/2017Sold$70,000+4.5%$36/sqft
    Source: Public Record Report a problem
    8/18/2017Sold$67,000$34/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$5,827 +2.8%$410,126 +2%
    2024$5,668 +490%$402,085 +425.2%
    2023$961 +1.9%$76,554 +2%
    2022$943 +1.9%$75,053 +2%
    2021$925 +1.9%$73,582 +1%
    2020$907 $72,828 +2%
    2019-- $71,400 +2%
    2018$873 +303.4%$70,000 +338.9%
    2017$216 $15,948 +2%
    2016$216 +2.1%$15,636 +1.5%
    2015$212 +1.6%$15,402 +2%
    2014$209 $15,101 +0.4%
    2013-- $15,034 +2%
    2012-- $14,740 +2%
    2011-- $14,451 +0.7%
    2010-- $14,344 -0.2%
    2009-- $14,379 +2%
    2008-- $14,098 +2%
    2007-- $13,822 +2%
    2006-- $13,551 +2%
    2005-- $13,286 +3.9%
    2003-- $12,788 +2%
    2002-- $12,538 +2%
    2001$347 -30%$12,293 +2%
    2000$496 $12,052
    Find assessor info on the county website

    Neighborhood: 92253

    Nearby schools

    GreatSchools rating
    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.