Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 553 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 553 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 553 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

15-2819 Popaa St
Pahoa, HI 96778

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $575,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1476
Agency: RELIFE REALTY, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: Looking to buy a newer furnished 2022 modern style single story home near the ocean? Here’s a great find with the ocean front approximately one block away from your front door!<br /> <br /> The home fronts two quiet dead-end streets which backup to 334 acres.<br /> <br /> Take a tour inside this lovely property in East Hawaii and find out if this is the one that checks all your boxes!<br /> <br /> Features include:<br /> ~1,476 Square Feet of Living Space<br /> ~492 Square Foot Covered Lanai <br /> ~10-Foot Ceilings<br /> ~Keyless Entry Keypads on all Exterior Doors/Smartphone Compatible<br /> ~Wi-Fi Garage Door Opener/Smartphone Compatible<br /> ~Oversized Detached 2-Car 672 Square Foot Garage<br /> ~Garage Pre-Wired with 220V for EV Fast Charger (Charger not included)<br /> ~ 7850-Watt Backup Generator with Whole House Transfer Switch<br /> ~Solar 90 Gallon Hot Water Heater<br /> ~Insulated Ceiling and Walls/Keeps House Cool!<br /> ~SPC (Stone Plastic Composite) Durable Waterproof Flooring<br /> ~GE Slate Smudge Proof Kitchen Appliances<br /> ~Beautiful Quartzite Countertops<br /> ~Custom Window and Lanai Door Treatments<br /> ~Soft Close Drawers and Cabinets<br /> ~Ceiling Fans and Custom Drop Lights<br /> ~Electrical Outlet in Primary Bath Drawer to Hide Cords<br /> ~Indoor Laundry Whirlpool Washer and Dryer<br /> ~Extra Storage Space above Laundry Closet<br /> ~Exterior Recessed Lights and Ceiling Fans on Lanai with extra electrical outlets<br /> ~Ring Camera Security System<br /> ~Spectrum Cable High-Speed Internet<br /> ~Available Extra Graded, Grass Seeded, Fenced Lot on North Side for Extra Yard Space Offered at $55,000.<br /> <br /> Your home ownership entitles you to all the amenities of exclusive Hawaiian Shores Recreational Estates, including private water supply, (no catchment water), privately maintained streets, U.S. mail and UPS/FedEx delivery service, active Homeowners Association, and three separate parks: Papio Ocean Park, Maikoiko Park, and Honu Park, with its members-only swimming pool, tennis courts, playground, and BBQ pavilions.
MlsNumber: 707051


Listing Provided By: RELIFE REALTY, LLC, original listing
Name: RELIFE REALTY, LLC
Phone: (808) 756-2079
Office Name: ReLife Realty, LLC
Office Phone: (808) 756-2079
Agent Name: Christi Mallicoat
Disclaimer: Copyright © 2024 Hawaii Information Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 553 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App