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 = 'Palm Springs' AND status = 'Active' AND Subdivision = 'Sunmor' AND PropertyType = 'Residential' AND MLNumber != '14792817PS' ORDER BY ListingPrice
MySQL Error:Unknown column 'listingagentfirstname' in 'field list'
Date:Tuesday, July 28, 2015 at 7:34:16 PM
Script:/palm-springs-neighborhood-listings.php?Neighborhood=Sunmor&City=Palm+Springs
Database Error
Message:Result ID: could not be freed.
MySQL Error:Unknown column 'listingagentfirstname' in 'field list'
Date:Tuesday, July 28, 2015 at 7:34:16 PM
Script:/palm-springs-neighborhood-listings.php?Neighborhood=Sunmor&City=Palm+Springs
Homes for sale in the Sunmor Community, Palm Springs CA | Palm Springs Real Estate for Sale

For help with a home sale or purchase call

(800) 590-3110

Property Search Results for Sunmor

About this Property

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