Cheyenne Celestine
BEDS3
BATHS2 full 1 partial
SQUARE FEET1,995
MLS#IG26056806
STATUSActive
PROPERTY TYPEResidential - Single Family
SUBDIVISIONLa Quinta Cove*
SCHOOLDesert Sands Unified
Listing Courtesy of:
Century 21 Masters
Agency Phone: 951-734-6210
Associate Name: Shellye Milazzo Wilson
Listing Shown by:
Farrell Smyth, Inc.
Associate Name: Cheyenne Celestine
Property Description
Stunning fully remodeled desert retreat located moments from La Quinta Resort. This beautifully updated property features a 1500 square foot main residence offering 3 spacious bedrooms and two stylishly remodeled bathrooms. The home showcases a large open floor plan designed for comfortable living and effortless entertaining. The updated kitchen features elegant quartz countertops, stainless appliances, and modern cabinetry that floes seamlessly into the main living areas. Both bathrooms have been updated with quartz counters, primary bath with a tastefully done shower, home enhanced with new light fixtures that add a fresh look. Detached 495 square foot casita with it's own half bath provides the perfect space for guests, a private office, or additional living quarters. Step outside to your own private desert oasis with a sparkling pool and relaxing spa, ideal for relaxing or entertaining. A gated front courtyard offers added privacy and a welcoming outdoor space.
Property Features
Property Type: Residential - Single Family
Cooling: Central Air
Garage: 2 car attached
Heating: Central
Lot Size: 0.23 Acres
Roof Type: Tile
Stories: 1.0
Year Built: 1995
Amenities
Breakfast Bar
Block Walls
Ceiling Fan(s)
Separate/Formal Dining Room
High Ceilings
Laminate Counters
Open Floorplan
Recessed Lighting
All Bedrooms Down
Dressing Area
Walk-In Closet(s)
Feature Descriptions
Appliances: Dishwasher, Disposal, Gas Oven, Gas Range, Refrigerator, Water Heater
Community Features: Street Lights, Sidewalks
Days on Site: 33
Fencing: Block
Fireplace: Living Room
Flooring: Tile
Laundry: Gas Dryer Hookup
Lot: 2-5 Units/Acre
Parcel#: 773135013
Parking: Direct Access, Driveway, Garage
Parking Notes: Direct Access, Driveway, Garage
Patio/Porch: Concrete
Pool: Private
Security: Security System, Carbon Monoxide Detector(s), Smoke Detector(s), Security Lights
Sewer: Public Sewer
Spa: Private
Spa: Yes
Special View Info: Mountain(s), Neighborhood
Swimming Pool: Yes
Units: 2
Utilities: Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected
Water: Public
Local Schools
School District: Desert Sands Unified
Listed By / Shown By
Listed By
Agency Name: Century 21 Masters
Agency Phone: 951-734-6210
Agent Name: Shellye Milazzo Wilson
Shown By
Agent Name: Cheyenne Celestine
Agent Phone: (805) 543-2636 ext. 16
Agency Title: Farrell Smyth, Inc.
Estimate Your Payment
Estimated Payment
$ 1,950.86 per month $1,724.81 Principal & Interest $0.00 Property Tax (data not provided by mls) $226.04 Homeowner's InsuranceChange Payment Information
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
51540 Eisenhower Street | MLS# IG26056806
This single family home located at 51540 Eisenhower Street, La Quinta, CA 92253 is currently listed for sale with an asking price of $775,000. This property was built in 1995 and has 3 bedrooms and 2 full and 1 partial baths with 1995 sq. ft. Eisenhower Street is located in the La Quinta Cove* subdivision within the Desert Sands Unified school district. Search La Quinta Cove* real estate on ccelestine.farrellsmyth.com today.