Residential Gallery

SELECT id,address,city,price,sold,reduced,reduced_price_date,newlisting,open_house,open_house2,bedrooms,baths,garages,abovegrade_sqft,lotsize,taxes FROM Residential WHERE (true) AND (reduced=0 OR (reduced=1 AND reduced_price_date<'2018-02-23')) UNION SELECT id,address,city,reduced_price as price,sold,reduced,reduced_price_date,newlisting,open_house,open_house2,bedrooms,baths,garages,abovegrade_sqft,lotsize,taxes FROM Residential WHERE (true) AND reduced=1 AND reduced_price_date>='2018-02-23' ORDER BY price DESC, id
page 1 of 2 1 2   (20 listings found)