Listing
Overview
Price: $949,000
Area: MOKULEIA
Status: Active
Your dream retreat awaits you within this fully functional farm sanctuary sitting on a vast two acre lot that boasts panoramic views of Mt. Ka’ala and vibrant sunset skies. Nestled within 380 acres of ag land, yet minutes to historic Haleiwa town, beautiful beaches + iconic surf spots. Endless possibilities, with multiple structures including a chicken coop, perfectly set up for farming, small businesses + more. All structures have a 3-layer water filtration system, are self sustainable + ready for you to bring your farm-to-table recipes to life. The main structure features 2 bedrooms, on-demand hot water, new toilet, luxurious soaking tub, laundry hookups, propane powered stove, full kitchen, and wired for electricity with solar panels + battery backup. The yurt features modern finishes including a new bathroom, dining area + full kitchen. Two additional tiny homes on the lot feature separate bathroom facilities + cooking areas. One tiny home is fully functional with solar panels + electricity; the yurt + other tiny home are wired for electric and ready for your solar panels to be plugged in. The lot is fully landscaped, fenced in + gated providing the perfect amount of privacy. Listing by: Compass
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202316241"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "0000"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Farrington"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(6) "Lot 23"
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(53) "https://player.vimeo.com/video/843839671?h=ac9147d10a"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "949000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "949000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "MOKULEIA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "Your dream retreat awaits you within this fully functional farm sanctuary sitting on a vast two acre lot that boasts panoramic views of Mt. Ka’ala and vibrant sunset skies. Nestled within 380 acres of ag land, yet minutes to historic Haleiwa town, beautiful beaches + iconic surf spots. Endless possibilities, with multiple structures including a chicken coop, perfectly set up for farming, small businesses + more. All structures have a 3-layer water filtration system, are self sustainable + ready for you to bring your farm-to-table recipes to life. The main structure features 2 bedrooms, on-demand hot water, new toilet, luxurious soaking tub, laundry hookups, propane powered stove, full kitchen, and wired for electricity with solar panels + battery backup. The yurt features modern finishes including a new bathroom, dining area + full kitchen. Two additional tiny homes on the lot feature separate bathroom facilities + cooking areas. One tiny home is fully functional with solar panels + electricity; the yurt + other tiny home are wired for electric and ready for your solar panels to be plugged in. The lot is fully landscaped, fenced in + gated providing the perfect amount of privacy."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "87120.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(0) ""
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(0) ""
}
["ParkingTotal"]=>
array(1) {
[0]=>
NULL
}
["StoriesType"]=>
array(1) {
[0]=>
NULL
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "sean@yanogroup.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Sean S Yano"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-10-30T10:57:54.350"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17435259"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-07-11T07:38:47.827"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25870605"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25870605"
[1]=>
string(8) "25870606"
[2]=>
string(8) "25870607"
[3]=>
string(8) "25870608"
[4]=>
string(8) "25870609"
[5]=>
string(8) "25870610"
[6]=>
string(8) "25870611"
[7]=>
string(8) "25870612"
[8]=>
string(8) "25870613"
[9]=>
string(8) "25870614"
[10]=>
string(8) "25870615"
[11]=>
string(8) "25870616"
[12]=>
string(8) "25870617"
[13]=>
string(8) "25870618"
[14]=>
string(8) "25870619"
[15]=>
string(8) "25870620"
[16]=>
string(8) "25870621"
[17]=>
string(8) "25870622"
[18]=>
string(8) "25870623"
[19]=>
string(8) "25870624"
[20]=>
string(8) "25870625"
[21]=>
string(8) "25870626"
[22]=>
string(8) "25870627"
[23]=>
string(8) "25870628"
[24]=>
string(8) "25870629"
[25]=>
string(8) "25870630"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202316241
)
[StreetNumber] => Array
(
[0] => 0000
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Farrington
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => Lot 23
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/843839671?h=ac9147d10a
)
[ListPrice] => Array
(
[0] => 949000.00
)
[CurrentPrice] => Array
(
[0] => 949000.00
)
[Neighbourhood] => Array
(
[0] => MOKULEIA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Your dream retreat awaits you within this fully functional farm sanctuary sitting on a vast two acre lot that boasts panoramic views of Mt. Ka’ala and vibrant sunset skies. Nestled within 380 acres of ag land, yet minutes to historic Haleiwa town, beautiful beaches + iconic surf spots. Endless possibilities, with multiple structures including a chicken coop, perfectly set up for farming, small businesses + more. All structures have a 3-layer water filtration system, are self sustainable + ready for you to bring your farm-to-table recipes to life. The main structure features 2 bedrooms, on-demand hot water, new toilet, luxurious soaking tub, laundry hookups, propane powered stove, full kitchen, and wired for electricity with solar panels + battery backup. The yurt features modern finishes including a new bathroom, dining area + full kitchen. Two additional tiny homes on the lot feature separate bathroom facilities + cooking areas. One tiny home is fully functional with solar panels + electricity; the yurt + other tiny home are wired for electric and ready for your solar panels to be plugged in. The lot is fully landscaped, fenced in + gated providing the perfect amount of privacy.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 87120.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => sean@yanogroup.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Sean S Yano
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-10-30T10:57:54.350
)
[Matrix_Unique_ID] => Array
(
[0] => 17435259
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-07-11T07:38:47.827
)
[_thumbnail_id] => Array
(
[0] => 25870605
)
[listing_image] => Array
(
[0] => 25870605
[1] => 25870606
[2] => 25870607
[3] => 25870608
[4] => 25870609
[5] => 25870610
[6] => 25870611
[7] => 25870612
[8] => 25870613
[9] => 25870614
[10] => 25870615
[11] => 25870616
[12] => 25870617
[13] => 25870618
[14] => 25870619
[15] => 25870620
[16] => 25870621
[17] => 25870622
[18] => 25870623
[19] => 25870624
[20] => 25870625
[21] => 25870626
[22] => 25870627
[23] => 25870628
[24] => 25870629
[25] => 25870630
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- Land Area (sf): 87,120 sf
- View: Mountain
- Listing Office: Compass
- Land Tenure: FS - Fee Simple
