$549,000

47870 Rosemary Street, La Quinta, CA 92253

3 beds |
3 baths |
1,920 sqft

Single-Family Home
Built in 2001
5,663sqft lot
2 car garage
$286/sqft
Listed 1 month ago

Property Description

Price Improvement on this AFFORDABLE LQ Home that Exudes Pride of Ownership in this Centrally Located Community of Mira Flores! User-Friendly Open-Concept Floor Plan Delivers a Functional Flow that is both AIRY and OPEN. You'll Appreciate the Generous Kitchen w/Granite Counters and Backsplash, Stainless Appliances, Rich Cabinetry which Opens to the Family Room w/a Cozy Fireplace and Wrap-Around Sliding Glass Doors Framing the Patio. Bedrooms are Appropriately Spaced for Privacy and a Versatile Bonus Room has Potential for a Home Office, Hobby Room or a Potential Fourth Bedroom. The Primary Suite is a Tranquil Retreat with a Walk-in Closet, Ensuite Bathroom w/Dual Sinks and Walk-in shower. Outdoor Living is Easy w/a Generous Patio, Peek a Boo Mountain Views and Low Maintenance Landscaping. Truly a Triple Option of Opportunity; a Primary Residence, a Vacation Getaway -or- a Rental Opportunity that could be Ready for Revenue! HOA covers Front Yard Maintenance, Front Gate, Community Pool/Spa and a Pet Friendly Greenbelt. Bonus: Low HOA Dues, Desirable Schools, Close to Restaurants, Costco, Shopping, Music Festivals, Theatres, Hwy 111 and All La Quinta has to Offer!

Listing Status:: Active
Date Added:: February 11, 2026
Data Last Updated:: April 4, 2026 at 7:16AM
Listing Office:: Cool Digs : (760) 262-7472
Listing Agent:: T.J. McCaa : (760) 880-4261
MLS ID:: 219143054DA

General: Breakfast BarSeparate/Formal Dining RoomHigh CeilingsOpen FloorplanMain Level PrimaryWalk-In Closet(s)
Appliances: Convection OvenDishwasherElectric OvenGas CooktopDisposalGas Water HeaterMicrowaveRefrigeratorVented Exhaust FanWater To Refrigerator
Laundry: Laundry Room
Flooring: CarpetLaminateTile
A/C: Central Air
Heating: CentralForced AirFireplace(s)Natural Gas
Fireplace: Family RoomGasMasonrySee ThroughFireplace

General: CommunityIn Ground
Style: Spanish
Other Structures: Concrete
Pool: CommunityElectric HeatIn Ground
Parking: Direct AccessDrivewayGarageGarage Door OpenerOn StreetSide By SideParking spaces: 4

Roofing: Clay
Windows: DrapesShutters
General: Stucco1Slab

HOA Amenities: Pet Restrictions324.0Monthly
Originating MLS: CRMLS_CDAR
School District: Desert Sands Unified
County: Riverside

Zoning: R-1600320017
Fencing: Stucco WallWood

Source: CRMLS_CDAR

This listing courtesy of T.J. McCaa , Cool Digs

Monthly Payment

$Est. Payment

Principal & Interest $
Property Taxes $
Home Insurance $
VA Funding Fee $

Ready to Start a VA Loan?

Get Started

NMLS #1907 ^†

Get Prequalified »

Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Schools Nearby

Harry S. Truman Elementary School

78870 Avenue 50, La Quinta, CA, 92253

Grades KG-5

1.33 miles away

La Quinta Middle STEM Academy

78900 Avenue 50, La Quinta, CA, 92253

Grades 6-8

1.23 miles away

La Quinta High School

79255 Blackhawk Way, La Quinta, CA, 92253

Grades 9-12

1.10 miles away

Disclaimer: School and School District information courtesy of the National Center for Education Statistics (NCES). School boundaries may change. Proximity to listed schools does not guarantee enrollment eligibility. Contact the school district for more information and exact boundaries.