Search -

47870 Rosemary Street, La Quinta, CA 92253

$549,000

Property Type: Residential Bedrooms: 3 Baths: 3 Square Footage: 1,920 Status: Active Under Contract

Current Price: $549,000 List Date: 2/11/2026 Last Modified: 4/24/2026

Overview

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/S ... (Read more)

Listing Details MLS# 219143054

General Property Information

Total Bedrooms: 3
Full Baths: Yes
3/4 Baths: Yes
Half Baths: Yes
Approx SqFt: 1920
Total Baths: 3
SqFt Source: Assessor
Fireplace: Yes
Total Fireplaces: Yes
Pool: Yes
Garage: Yes
Garage Description: Attached
Sprinklers: Yes
Building # of Stories: Yes
Lot Size Source: Assessor
Zoning: R-1
Zoning Source: Assessor
Year Built: 2001
Furnished: Unfurnished
Cross Streets: Cassia Street

Property Features

Sale Type: Standard Listing Terms: Cash; Cash to New Loan; Conventional; FHA Possession: Close Of Escrow Lot Description: Level; Yard Lot Location: Park Nearby; Private Road Property Orientation Faces: Front Door Faces South Irrigation: Drip System; Sprinkler System; Sprinkler Timer Fencing: Stucco Wall; Wood Disclosures: CC & R; Home Warranty Plan; Homeowners Association; Planned Development Community Features: Community Mailbox; Sidewalks Building Style: Spanish Levels: One Entry Location: Ground Level - No Steps Appliances: Convection Oven; Dishwasher; Disposal; Dryer; Electric Oven; Exhaust Fan; Gas Cooktop; Microwave Oven; Refrigerator; Washer; Water Line to Refrigerator Kitchen Features: Granite Counters Eating Areas: Breakfast Counter/Bar; Formal Dining Room Bedroom Features: Main Floor Primary Bedroom; Walk In Closet Bathroom Features: Double Vanity(s); Shower Over Tub; Shower Stall Doors: Sliding Doors Exterior Construction: Stucco Foundation: Slab Flooring: Carpet; Ceramic Tile; Laminate Cooling Type: Air Conditioning; Ceiling Fan(s); Central Air Pool Location: Community Pool Construction: In Ground Pool Description: Community; Heated; In Ground Heating: Central; Fireplace(s); Forced Air Heating Fuel: Natural Gas Fireplace Location: Family Room Fireplace Features: Gas; Gas Log; Glass Doors; Tile Rooms: Den - Study; Dining Area; Family Room Interior Features: High Ceilings (9 Ft+); Open Floorplan Laundry: Individual Room Security Safety: Automatic Gate; Community; Gated Community Window Treatments: Drapes; Shutters Roofing: Clay Tile Patio Features: Concrete Slab Utilities: Electricity Connected; Natural Gas Connected; Sewer Connected; Water Connected Sewer: In, Connected and Paid Water: Water District Water Heater Feature: Gas Parking: Direct Entrance; Driveway; Garage Door Opener; On Street; Side By Side Association 1 Frequency: Monthly Association Amenities: Greenbelt/Park; Pet Rules Association Pet Rules: Assoc Pet Rules Contingent Upon: Appraisal; Inspection; Loan Approval Land Lease Type: Fee Simple

Listing Location and Property Info

APN: 600320017
Original List Price: 555000
Property Sub-Type: Single Family Residence
Street #: 47870
Street Name: Rosemary
Street Suffix: Street
County: Riverside
State: CA
Zip Code: 92253
Area: 313 -La Quinta South of HWY 111
Country: US

Listing Info

Short Term Rentals: No
Rental Restrictions: Yes
Will Consider Lease: No
School District: Desert Sands Unified
Elementary School: Truman
Junior Middle School: La Quinta
High School: La Quinta

Tax Info

Tax Mello Roos: No

Property Info

View: No
Golf Course Within Development: No
Additional Parcel: No
Senior Community: No
Gated Community: Yes
PUD Y/N: Yes
Total Monthly Association Fees: 324

More Information

Status Change Info

Status Change Date: 2026-04-24
Contingent: Active Under Contract

Water

Water District Name: CVWD
Water District: Yes

Parking SpacesInformation

Total Garage Spaces: 2
Total Parking Spaces: 4

HOA Information

HOA: Yes
HOA Fee 1: 324

DPR

DPR Eligible: Yes

Listing, Location and Property Info

New Construction: No
Entry Date: 2026-02-11
Land Type: Fee

Community Features

Community Mailbox: Yes
Sidewalks: Yes

Fencing

Stucco Wall: Yes
Wood: Yes

Utilities

Electricity Connected: Yes
Natural Gas Connected: Yes
Sewer Connected: Yes
Water Connected: Yes

Sale Type

Standard: Yes

Listing Terms

Cash: Yes
Cash to New Loan: Yes
Conventional: Yes
FHA: Yes

Possession

Close Of Escrow: Yes

Parking Spaces/Information

Total Covered Spaces: 2
Total Uncovered/Assigned Spaces: 0

Lot Description

Level: Yes
Yard: Yes

Lot Location

Park Nearby: Yes
Private Road: Yes

Property Orientation Faces

Front Door Faces South: Yes

Irrigation

Drip System: Yes
Sprinkler System: Yes
Sprinkler Timer: Yes

Disclosures

CC & R: Yes
Home Warranty Plan: Yes
Homeowners Association: Yes
Planned Development: Yes

Building Style

Spanish: Yes

Levels

One: Yes

Entry Location

Ground Level - No Steps: Yes

Appliances

Convection Oven: Yes
Dishwasher: Yes
Disposal: Yes
Dryer: Yes
Electric Oven: Yes
Exhaust Fan: Yes
Gas Cooktop: Yes
Microwave Oven: Yes
Refrigerator: Yes
Washer: Yes
Water Line to Refrigerator: Yes

Kitchen Features

Granite Counters: Yes

Eating Areas

Breakfast Counter/Bar: Yes
Formal Dining Room: Yes

Bedroom Features

Main Floor Primary Bedroom: Yes
Walk In Closet: Yes

Bathroom Features

Double Vanity(s): Yes
Shower Over Tub: Yes
Shower Stall: Yes

Doors

Sliding Doors: Yes

Exterior Construction

Stucco: Yes

Foundation

Slab: Yes

Flooring

Carpet: Yes
Ceramic Tile: Yes
Laminate: Yes

Cooling Type

Air Conditioning: Yes
Ceiling Fan(s): Yes
Central Air: Yes

Pool Location

Community: Yes

Pool Construction

In Ground: Yes

Pool Description

Community: Yes
Heated: Yes
In Ground: Yes

Spa/Hot Tub Construction

In Ground: Yes

Spa/Hot Tub Description

Community: Yes

Heating

Central: Yes
Fireplace(s): Yes
Forced Air: Yes

Heating Fuel

Natural Gas: Yes

Fireplace Location

Family Room: Yes

Fireplace Features

Gas: Yes
Gas Log: Yes
Glass Doors: Yes
Tile: Yes

Rooms

Den - Study: Yes
Dining Area: Yes
Family Room: Yes

Interior Features

High Ceilings (9 Ft+): Yes
Open Floorplan: Yes

Laundry

Individual Room: Yes

Security Safety

Automatic Gate: Yes
Community: Yes
Gated Community: Yes

Window Treatments

Drapes: Yes
Shutters: Yes

Roofing

Clay Tile: Yes

Patio Features

Concrete Slab: Yes

Sewer

In, Connected and Paid: Yes

Water Heater Feature

Gas: Yes

Parking

Direct Entrance: Yes
Driveway: Yes
Garage Door Opener: Yes
On Street: Yes
Side By Side: Yes

Association Amenities

Greenbelt/Park: Yes
Pet Rules: Yes

Association 1 Frequency

Monthly: Yes

Association Pet Rules

Assoc Pet Rules: Yes

Contingent Upon

Appraisal: Yes
Inspection: Yes
Loan Approval: Yes

Land Lease Type

Fee Simple: Yes

Listing Office: Cool Digs

Listing Agent: T.J. McCaa

Last Updated: April - 24 - 2026

Information deemed reliable but not guaranteed.

760.799.7770