LOWEST PRICE home in prestigious Legacy at Mission Hills and...Turnkey furnished! Lovely 3038sf 4 bed, 4.5 bath home with private casita, situated on an elevated lot overlooking the 17th fairway of the Mission Hills North Gary Player Signature course. Adore the cozy entry courtyard with fire table and fountain, providing access to the casita, guest bedroom and main entry. Enjoy the partially covered patio, pool, spa, golf course & mountain views from the living room, family room and primary suite. Love the high ceilings, tall sliding doors and windows offering abundant natural light for seamless indoor/outdoor living. Appreciate features including: 4 ensuite baths plus powder room, inviting fireplace, wet bar, beautifully updated tile floors throughout, Decor and KitchenAid appliances, slab granite countertops, saltwater pool & spa with new salt cell & panel, new 75 gallon hot water heater, newly painted home exterior, newly painted 2 car + cart garage with new polymer coated floor and side yard lemon tree 'orchard'. The Rancho Mirage location offers quick access to casinos, dining, movies, shopping, I-10 and more... this home truly provides delightful year-round living and fantastic entertaining. Legacy homeownership includes Social-Fitness membership at Mission Hills country club with...no Land Lease. Your new desert home awaits!!
Sold for $1,025,000 on 06/30/25
Listing Provided by:
Lynn Jenson DRE #01092376 760-564-3161,
Bennion Deville Homes
Bought with: Equity Union
$1,025,000
247 Loch Lomond Rd, Rancho Mirage, CA 92270
4beds
3,038sqft
Single Family Residence
Built in 2002
0.27 Acres Lot
$1,016,500 Zestimate®
$337/sqft
$7,562 Estimated rent
Home value
$1,016,500
$925,000 - $1.12M
$7,562/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: June 30, 2025 at 01:48pm
Listing Provided by:
Lynn Jenson DRE #01092376 760-564-3161,
Bennion Deville Homes
Bought with:
Kim Kouwabunpat, DRE #02230524
Equity Union
Source: CRMLS,MLS#: 219128833DA
Originating MLS: California Desert AOR & Palm Springs AOR
Originating MLS: California Desert AOR & Palm Springs AORFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 3
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
Primary bedroom
- Features: Primary Suite
Bathroom
- Features: Tile Counters, Vanity
Kitchen
- Features: Granite Counters, Kitchen Island
Other
- Features: Walk-In Closet(s)
Heating
- Central, Fireplace(s)
Cooling
- Central Air
Appliances
- Included: Electric Oven, Gas Cooktop, Microwave, Refrigerator, Range Hood
Features
- Breakfast Bar, Separate/Formal Dining Room, Primary Suite, Walk-In Closet(s)
- Flooring: Stone, Tile
- Doors: Sliding Doors
- Has fireplace: Yes
- Fireplace features: Gas, Living Room
Interior area
- Total interior livable area: 3,038 sqft
Property
Parking
- Total spaces: 6
- Parking features: Garage, Golf Cart Garage, Garage Door Opener
- Attached garage spaces: 3
Features
- Has private pool: Yes
- Pool features: Gunite, Electric Heat, In Ground
- Spa features: Community, In Ground, Private
- Fencing: Stucco Wall,Wrought Iron
- Has view: Yes
- View description: Mountain(s)
Lot
- Size: 0.27 Acres
- Features: Landscaped, On Golf Course, Planned Unit Development, Sprinkler System
Details
- Additional structures: Guest House
- Parcel number: 673520007
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Mediterranean
- Property subtype: Single Family Residence
Materials
- Foundation: Slab
Condition
- Updated/Remodeled
- New construction: No
- Year built: 2002
Community & neighborhood
Security
- Security features: Gated Community
Community
- Community features: Golf, Gated
Location
- Region: Rancho Mirage
- Subdivision: Mission Hills/Legacy-Oakhurst
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $825 monthly
- Amenities included: Clubhouse, Controlled Access
Other
Other facts
- Listing terms: Cash to New Loan
Price history
| Date | Event | Price |
|---|---|---|
| 6/30/2025 | Sold | $1,025,000-6.8%$337/sqft |
Source:  CRMLS #219128833DA | ||
| 6/30/2025 | Pending sale | $1,100,000$362/sqft |
Source:  Greater Palm Springs Realtors #219128833 | ||
| 5/30/2025 | Contingent | $1,100,000$362/sqft |
Source:  CDAR/ Desert Area MLS #219128833 | ||
| 5/23/2025 | Price change | $1,100,000-4.3%$362/sqft |
Source: Greater Palm Springs Realtors #219128833 | ||
| 5/7/2025 | Price change | $1,149,000-3.8%$378/sqft |
Source: Greater Palm Springs Realtors #219128833 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $15,351 -0.9% | $1,175,047 +2% |
| 2024 | $15,489 +0.2% | $1,152,007 +2% |
| 2023 | $15,462 +1.5% | $1,129,420 +2% |
Find assessor info on the county website
Neighborhood: 92270
Nearby schools
GreatSchools rating
- 7/10Sunny Sands Elementary SchoolGrades: K-5Distance: 1.7 mi
- 4/10Nellie N. Coffman Middle SchoolGrades: 6-8Distance: 1.5 mi
- 6/10Rancho Mirage HighGrades: 9-12Distance: 1 mi
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.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$1,016,500
2% more+ $20,330
With Zillow Showcase(estimated)
$1,036,830