3 bedrooms, 3 bath two-story single family house with 2 car garage in Ewa Gentry Alii Court house, inviting all contractors or investors to remodel the house. Close to school, shopping center and Community Associatin Pool.
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Niuhiwa' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)