LOCATION! LOCATION! LOCATION! 4 bedrooms 3 full bath single family home on 5,000 sq ft leveled lot. Home needs TLC and is sold in “As Is” condition. Lots of potential as layout set up as 3/1 and studio, and full bath in the back. Property has a nice size yard which allows for possible expansion. Minutes away from Diamond Head and Waikiki. Do Not walk the property or bother tenants without an appointment.
(Status = 'Active' OR Status = 'In Escrow Showing' OR Status = 'In Escrow Not Showing' OR Status = 'Sold') AND StreetName = 'Campbell' AND PropertyType = 'Single Family' AND ListingContractDate >= DATE_SUB(CURDATE(),INTERVAL 2 YEAR)