TURN-KEY, FULLY RENOVATED 3-Bedroom, 2-Bath in Ewa Beach (Soda Creek) waiting for a new owner!! BRAND NEW: ROOF, KITCHEN, flooring, paint, stainless steel APPLIANCES, window ACs, fans, vanities, shower, bathtub, blinds. NO Maintenance fee! Come and seeā¦.this one will go FAST! Listor is owner.
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Waimapuna' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)