This is a Leasehold Property- Hawaiian Home Lands in Kapolei /Maluoha'i Lovely single level home priced to sell. Close to schools, bus line, restaurants and eating places, hotels and Kamakana Ali'i shopping mall.
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Ualakupu' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)