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','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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-2649 Government Beach Rd
Pahoa, HI 96778

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $985,000
Beds: 2
Baths: 1
Status: Active
SqFt: 1008
Agency: Hilo Brokers, Ltd.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 1981
Notes: <br /> * Have you or someone you know been searching for that true oceanfront property with direct shoreline access from your own backyard? Well, have a look at this 5.27 ACRES of OCEANFRONT privacy with miles of coastline views, countless palms, wooded acreage, lawn areas and a gated, winding tree-lined driveway on the Big Island of Hawaii.<br /> <br /> * A bonus here is the included unfinished house with large ocean view windows, a covered deck and partially finished bathroom that includes stone floors and a stone-lined shower. All of the improvements presently do not include finaled permits, water, power or a waste treatment system for occupancy.<br /> <br /> * Electric service is available along Beach Road fronting the lot which can be brought in or use locally available solar services for power. No repairs, modifications or renovations shall be performed by seller. Buyer and buyer's agent are responsible for performing due diligence on property permits, permit status, and all other pertinent matters. Property will be sold AS-IS.<br /> <br /> * Offers must include an AS-IS Addendum.<br /> <br /> * This lot lies within the Special Management Area (SMA), conservation (resource zone) district, tsunami zone and lava zone 2.<br /> <br /> * Site location is convenient with easy access from a county-maintained road.<br /> <br /> * For day-to-day grocery needs, banking, medical care, hardware supplies, post offices restaurants, fast food drive-throughs, auto repair, veterinary services, etc., this property is about 15 minutes from the growing town of Pahoa, 20 minutes from the town of Keaau or 40 minutes from Hilo and the airport.<br /> <br /> * PLEASE NOTE: Prior to showing, seller requires that buyer is confirmed as financially qualified to close at the full asking price. Buyer's broker or agent must accompany all prospects with each showing.<br /> <br /> * To watch a 3-min. video of this property with audio, copy & paste this link into your browser and open to full view: https://bit.ly/47LIfLk
MlsNumber: 705897


Listing Provided By: Hilo Brokers, Ltd., original listing
Name: Hilo Brokers, Ltd.
Phone: (808) 969-9400
Office Name: Hilo Brokers Ltd
Office Phone: (808) 969-9400
Agent Name: Marcel Pichon
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','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Real Estate Expert Photo for Sarah Smith
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