SELECT id,address,city,price,sold,reduced,reduced_price_date,newlisting,open_house,bedrooms,baths,garages,abovegrade_sqft,lotsize,taxes FROM Residential WHERE (price>120000) AND (reduced=0 OR (reduced=1 AND reduced_price_date<'2024-05-03'))
UNION
SELECT id,address,city,reduced_price as price,sold,reduced,reduced_price_date,newlisting,open_house,bedrooms,baths,garages,abovegrade_sqft,lotsize,taxes FROM Residential WHERE (reduced_price>120000) AND reduced=1 AND reduced_price_date>='2024-05-03' ORDER BY price DESC, id
page 2 of 2
1
2
 (8 listings found)
NEW LISTING
Offered at: $185,000
NEW LISTING
Offered at: $149,000
|