GREAT LOCATION! A large and multi family 14 bedroom with 6 full baths. Property is located close to major freeway on ramp and Kamehameha Shopping Center close by. TMK does not match public record data. Buyers to do their own due diligence to verify. To be sold in its existing "AS IS" and "where is" condition. No Text please.
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Hauiki' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)