Needs TLC, large corner lot, cul de sac, across from Momilani Rec. Center with pool, large rear slab the entire length of the house, huge potential for the right buyer.
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Hooui' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)