Database Error
Message:MySQL Query fail: SELECT mlnumber, bedrooms, bathrooms, CONCAT(streetnumber, ' ', streetname, ' ', streetsuffix) AS address, city, zipcode, ListingPrice, listingprice, originalprice, squarefootage, LotSquareFootage, CONCAT(listingagentfirstname, ' ', listingagentlastname) AS listingagent, CONCAT(ListingAgentFirstName, '-', ListingAgentLastName,'.jpg') AS listingAgentPic, listingofficename, marketingremarks, propertysubtype1 as proptype, subdivision, latitude AS lat, longitude AS lng, picturecount, cdom, dom, PricePerSqFt, detailBlob FROM AllMLSListings WHERE DOM > 0 AND Status='Active' AND city = 'Rancho Mirage' AND status = 'Active' AND Subdivision = 'Mission Hills Country Club' AND PropertyType = 'Residential' AND MLNumber != '14792817PS' ORDER BY ListingPrice
MySQL Error:Unknown column 'listingagentfirstname' in 'field list'
Date:Monday, August 3, 2015 at 8:03:11 AM
Script:/palm-springs-neighborhood-listings.php?Neighborhood=Mission+Hills+Country+Club&City=Rancho+Mirage
Database Error
Message:Result ID: could not be freed.
MySQL Error:Unknown column 'listingagentfirstname' in 'field list'
Date:Monday, August 3, 2015 at 8:03:11 AM
Script:/palm-springs-neighborhood-listings.php?Neighborhood=Mission+Hills+Country+Club&City=Rancho+Mirage
Homes for sale in the Mission Hills Country Club Community, Rancho Mirage CA | Rancho Mirage Real Estate for Sale

For help with a home sale or purchase call

(800) 590-3110

Property Search Results for Mission Hills Country Club

About this Property

Hover over a blue icon on the map to see info about each home.