SELECT Homes.*, (SELECT MIN (low) FROM homesNewRates WHERE PID=Homes.ID AND (Low > 0 OR high > 0) ) AS lowRate, (SELECT Max( high ) FROM homesNewRates WHERE PID=Homes.ID AND (Low > 0 OR high > 0) ) AS highRate, CASE WHEN ( SELECT Max( high ) FROM homesNewRates WHERE PID=Homes.ID AND (Low > 0 OR high > 0) ) != 0 THEN ( SELECT Max( high ) FROM homesNewRates WHERE PID=Homes.ID AND (Low > 0 OR high > 0) ) ELSE ( SELECT Min( low ) FROM homesNewRates WHERE PID=Homes.ID AND (Low > 0 OR high > 0) ) END AS SearchRate FROM homesNew Homes WHERE Homes.Active='Yes' And Style = '' ORDER BY Rating DESC, SearchRate DESC, Name ASC
No Properties were found. Please revise your search and try again.
