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;

32-640 Piha Kahuku Rd
Ninole, HI 96773
Ernestina Cassell with Equity Hawaii Real Estate LLC, original listing - (808) 934-7300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 2
Baths: Full: 3
Status: Active
SqFt: 1032 Square Feet
Agency: Equity Hawaii Real Estate LLC
Agency Phone: (180) 831-9991 x3

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: MUST SEE! Seller financing available. Two primary bedrooms 3 full bathrooms a loft and den and 2 full car garage on 18.7 acre property next to forest reserve. Hunting allowed. Architect designed by Bambooliving.com. Sustainably built.<br /> Concrete slab, timber/bamboo with exposed Bamboo ceiling.<br /> Metal roof with insulation.<br /> (garage has full water and gas service, so it can be converted to a living space). Garage door with remote entry.<br /> Post-and-beam home (above ground). Lots of storage space under structure.<br /> Stream next to house. Additional streams and springs on property. Ocean view.<br /> End of the road home. No other man-made structures are visible from the house. Incredibly peaceful and impossibly private. <br /> 1850 feet elevation. Ideal temperature range.<br /> Espresso shaker kitchen cabinets.<br /> LED lighting throughout.<br /> Dexton Laurent stone kitchen island (extra-large sink, oven, stove, dishwasher, etc.).<br /> Twin undercounter drawer refrigerators (freezer/fridge are configurable).<br /> Ceiling fans throughout.<br /> Main-floor convenience laundry closet (Additional large unit hookups in the garage).<br /> Full off-grid home:<br /> - Two ground based solar arrays. 21 solar panels total (8kW output).<br /> - 16 kWh Blue Planet Ion 16 kWh battery (Ferrous Phosphate).<br /> - 12 kHh Sol-ark inverter (oversized to allow for future expansion).<br /> - Remote power system monitoring.<br /> - Backup diesel generator (30 gallon tank). <br /> - Redundant water tanks (10000 and 5000 gallons each) for uninterrupted water <br /> availability during maintenance.<br /> - Full house water filtration and UV filter system.<br /> - Insulated walls.<br /> - Full house surge protector.<br /> Scratch and humidity resistant flooring.<br /> Built in 2022/23<br /> Gas appliances, including full house on-demand heater.<br /> Subsistence farming allowed and permitted.<br /> All organic material from the land clearing is buried on site for veg garden.
MlsNumber: --
ListingId: 715830


Listing Provided By: Equity Hawaii Real Estate LLC, original listing
Phone: (808) 729-8515
Office Phone: (808) 934-7300
Agent Name: Ernestina Cassell
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 Joreen Knox, Lic#21618
Joreen Knox, Lic#21618
ASCIIAloha Kona Realty Inc
Call Today!: (808) 989-5077

Local Mortgage Pro

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;
Ryan Herbert, NMLS#630033
ASCIIApex Home Mortgage
Call Today!: (808) 747-6152

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App