Great opportunity to purchase a Hawaiian Home Land property at an exceptional value. Needs major repairs. Renovate and create your dream home. Excellent location with a ranch and mountains in the back yard. New owner must be at least 50% Hawaiian to purchase. Leasehold property. Seller financing available!
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Puawiliwili' AND MLSAreaMajor = 'Leeward' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)