Welcome to this beautifully updated single-story home that blends comfort and space. This is a beautiful stunning modern home with surrounding views of the Santa Rosa Mountains. This home is conveniently located in La Quinta Cove just one block from mountain hiking/biking trails, the historic Old Town La Quinta, the famous La Quinta Resort & Spa, tennis, golf, restaurants, This stylish single family home offers 1,361 sq.ft. of family living, 5227 sq. ft. lot, there are three bedroom and two remodeled bathrooms, newly installed porcelain floors, newer windows, ceiling fans, recessed lighting, tile work, newer backyard turf and a covered side patio. The fully equipped kitchen with quartz countertops and stainless-steel appliances are perfect for family time and entertaining. There is a large family room with a fireplace with lots of natural lighting plus a two-car garage with direct access to the house. This bright and charming home offers everything you need, This is a must see!!
For sale
Listed by: Jesus Martinez, Broker • Jesus Martinez • 760-899-4055
$459,000
54200 Avenida Juarez, La Quinta, CA 92253
3beds
1,361sqft
Single Family Residence
Built in 1978
5,227 Square Feet Lot
$452,500 Zestimate®
$337/sqft
$-- HOA
What's special
Beautifully updated single-story homeBright and charming homeNewer backyard turfNewly installed porcelain floorsTile workStainless-steel appliancesTwo remodeled bathrooms
- 22 hours
- 250
- 16
Zillow last checked:
Listing updated:
Listed by:
Jesus Martinez DRE #01234250 760-899-4055,
Jesus Martinez, Broker
Source: CRMLS,MLS#: 219151947DA
Originating MLS: California Desert AOR & Palm Springs AOR
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Rooms
- Room types: Family Room, Dining Room
Kitchen
- Features: Quartz Counters
Heating
- Central
Cooling
- Central Air
Appliances
- Included: Dishwasher, Electric Water Heater, Gas Range, Microwave
- Laundry: In Garage
Features
- Separate/Formal Dining Room, Recessed Lighting
- Flooring: Tile
- Doors: Sliding Doors
- Has fireplace: No
Interior area
- Total interior livable area: 1,361 sqft
Property
Parking
- Total spaces: 4
- Parking features: Driveway
- Attached garage spaces: 2
- Uncovered spaces: 2
Features
- Patio & porch: Covered
- Fencing: Wood
- Has view: Yes
- View description: Mountain(s)
Lot
- Size: 5,227 Square Feet
- Features: Sprinkler System
Details
- Parcel number: 774194010
- Zoning: R-1
- Special conditions: Short Sale
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Stucco
- Foundation: Permanent
- Roof: Composition
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1978
Utilities & green energy
- Sewer: Unknown
Community & HOA
Community
- Subdivision: La Quinta Cove
Location
- Region: La Quinta
Financial & listing details
- Price per square foot: $337/sqft
- Tax assessed value: $498,767
- Date on market: 8/28/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
Estimated market value
$452,500
$430,000 - $475,000
$3,068/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/28/2026 | Listed for sale | $459,000-3.2%$337/sqft |
Source: | ||
| 3/12/2026 | Listing removed | $474,000$348/sqft |
Source: | ||
| 1/22/2026 | Listed for sale | $474,000-10.5%$348/sqft |
Source: | ||
| 10/14/2025 | Listing removed | $529,500$389/sqft |
Source: | ||
| 8/26/2025 | Listed for sale | $529,500+12.7%$389/sqft |
Source: | ||
| 8/10/2022 | Sold | $470,000+1.1%$345/sqft |
Source: Public Record Report a problem | ||
| 8/8/2022 | Pending sale | $465,000$342/sqft |
Source: | ||
| 7/29/2022 | Contingent | $465,000$342/sqft |
Source: | ||
| 7/18/2022 | Price change | $465,000-2.1%$342/sqft |
Source: | ||
| 7/8/2022 | Price change | $475,000-4%$349/sqft |
Source: | ||
| 7/1/2022 | Listed for sale | $494,900+41.4%$364/sqft |
Source: | ||
| 1/14/2022 | Sold | $350,000$257/sqft |
Source: | ||
| 1/8/2022 | Pending sale | $350,000$257/sqft |
Source: | ||
| 12/4/2021 | Contingent | $350,000$257/sqft |
Source: | ||
| 10/27/2021 | Listed for sale | $350,000$257/sqft |
Source: | ||
| 10/5/2021 | Contingent | $350,000$257/sqft |
Source: | ||
| 9/13/2021 | Listed for sale | $350,000+62.8%$257/sqft |
Source: | ||
| 8/26/2015 | Sold | $215,000-2.2%$158/sqft |
Source: | ||
| 8/14/2015 | Pending sale | $219,900$162/sqft |
Source: Homepath #215018244 Report a problem | ||
| 8/6/2015 | Listed for sale | $219,900$162/sqft |
Source: Homepath #215018244 Report a problem | ||
| 7/26/2015 | Pending sale | $219,900$162/sqft |
Source: Capitis Real Estate #215018244 Report a problem | ||
| 7/23/2015 | Listed for sale | $219,900$162/sqft |
Source: Homepath #215018244 Report a problem | ||
| 6/26/2015 | Pending sale | $219,900$162/sqft |
Source: Capitis Real Estate #215018244 Report a problem | ||
| 6/14/2015 | Listed for sale | $219,900-8.8%$162/sqft |
Source: Homepath #215018244 Report a problem | ||
| 4/2/2015 | Sold | $241,039+30.3%$177/sqft |
Source: Public Record Report a problem | ||
| 1/10/2015 | Listed for sale | $185,000-28%$136/sqft |
Source: Dream Big Real Estate #IV13234398 Report a problem | ||
| 3/29/2007 | Sold | $257,000$189/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $498,767 +2% |
| 2025 | $6,793 +2.5% | $488,988 +2% |
| 2024 | $6,625 +1.6% | $479,400 +2% |
| 2023 | $6,523 +83.7% | $470,000 +96% |
| 2022 | $3,551 +2.7% | $239,831 +2% |
| 2021 | $3,458 +1.8% | $235,129 +1% |
| 2020 | $3,397 +2% | $232,719 +2% |
| 2019 | $3,330 +2.2% | $228,157 +2% |
| 2018 | $3,257 +1.3% | $223,685 +2% |
| 2017 | $3,214 | $219,300 +2% |
| 2016 | $3,214 +4.6% | $215,000 +11.4% |
| 2015 | $3,073 +9.9% | $193,000 +7.2% |
| 2014 | $2,796 | $180,000 +20.8% |
| 2013 | -- | $149,000 +20.2% |
| 2012 | -- | $124,000 -8.8% |
| 2011 | -- | $136,000 +5.4% |
| 2010 | -- | $129,000 -24.6% |
| 2009 | -- | $171,000 -22.3% |
| 2008 | -- | $220,000 +186.2% |
| 2007 | -- | $76,857 +2% |
| 2006 | -- | $75,351 +2% |
| 2005 | -- | $73,874 +3.9% |
| 2003 | -- | $71,100 +2% |
| 2002 | -- | $69,707 +2% |
| 2001 | $1,156 +2.1% | $68,341 +2% |
| 2000 | $1,132 | $67,002 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 92253
Local buyer's agents are ready to help





