Our office will be closed on Monday, November 11th, 2024.
68-670 Farrington Highway Unit 38 Waialua, HI 96791
Listing Overview
Price: $730,000 Area: MOKULEIA Status: Active Under Contract
This could be the best unit in the gated Kawaihapai Farms development! Nestle between two access roads at the very top of the development, this unit offers privacy and higher elevation for tranquil blue ocean views. With over 2 acres, this unit is more than ready for your AG plans. The water for this development comes right from wells within the development. Many other units in the development are currently growing a wide variety fruits and vegetables. 31 miles from HNL, 15 miles to Wahiawa, 14 miles to Schofield Barracks, 9 miles from Hale'iwa town, 7 miles from the Waialua Sugar Mill and post office, 1.5 miles from Camp Erdman.
Bring your AG vision and energy and let it grow!
Farm dwelling not allowed. Farm structures under 1000 square feet without electrical nor plumbing are allowed with an approved exemption form. Farm structures larger than 1000 square feet or with plumbing or electrical require DPP permitting.
Feel free to call for more information. Listing by: Hawaii Life (800) 370-3848
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421465"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-670"
}
["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(2) "38"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "730000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "730000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "MOKULEIA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(989) "This could be the best unit in the gated Kawaihapai Farms development! Nestle between two access roads at the very top of the development, this unit offers privacy and higher elevation for tranquil blue ocean views. With over 2 acres, this unit is more than ready for your AG plans. The water for this development comes right from wells within the development. Many other units in the development are currently growing a wide variety fruits and vegetables. 31 miles from HNL, 15 miles to Wahiawa, 14 miles to Schofield Barracks, 9 miles from Hale'iwa town, 7 miles from the Waialua Sugar Mill and post office, 1.5 miles from Camp Erdman.
Bring your AG vision and energy and let it grow!
Farm dwelling not allowed. Farm structures under 1000 square feet without electrical nor plumbing are allowed with an approved exemption form. Farm structures larger than 1000 square feet or with plumbing or electrical require DPP permitting.
Feel free to call for more information."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(11) "Hawaii Life"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "89080.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(14) "Mountain,Ocean"
}
["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) "HLRE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(28) "kylebernhardt@hawaiilife.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(800) 370-3848"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Kyle Bernhardt"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-27T17:41:27.633"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18273005"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-20T14:55:10.190"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26702940"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26702940"
[1]=>
string(8) "26702941"
[2]=>
string(8) "26702942"
[3]=>
string(8) "26702943"
[4]=>
string(8) "26702944"
[5]=>
string(8) "26702945"
[6]=>
string(8) "26702946"
[7]=>
string(8) "26702947"
[8]=>
string(8) "26702948"
[9]=>
string(8) "26702949"
[10]=>
string(8) "26702950"
[11]=>
string(8) "26702951"
[12]=>
string(8) "26702952"
[13]=>
string(8) "26702953"
[14]=>
string(8) "26702954"
[15]=>
string(8) "26702955"
[16]=>
string(8) "26702956"
[17]=>
string(8) "26702957"
[18]=>
string(8) "26702958"
[19]=>
string(8) "26702959"
[20]=>
string(8) "26702960"
[21]=>
string(8) "26702961"
[22]=>
string(8) "26702962"
[23]=>
string(8) "26702963"
[24]=>
string(8) "26702964"
[25]=>
string(8) "26702965"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421465
)
[StreetNumber] => Array
(
[0] => 68-670
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Farrington
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 38
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 730000.00
)
[CurrentPrice] => Array
(
[0] => 730000.00
)
[Neighbourhood] => Array
(
[0] => MOKULEIA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => This could be the best unit in the gated Kawaihapai Farms development! Nestle between two access roads at the very top of the development, this unit offers privacy and higher elevation for tranquil blue ocean views. With over 2 acres, this unit is more than ready for your AG plans. The water for this development comes right from wells within the development. Many other units in the development are currently growing a wide variety fruits and vegetables. 31 miles from HNL, 15 miles to Wahiawa, 14 miles to Schofield Barracks, 9 miles from Hale'iwa town, 7 miles from the Waialua Sugar Mill and post office, 1.5 miles from Camp Erdman.
Bring your AG vision and energy and let it grow!
Farm dwelling not allowed. Farm structures under 1000 square feet without electrical nor plumbing are allowed with an approved exemption form. Farm structures larger than 1000 square feet or with plumbing or electrical require DPP permitting.
Feel free to call for more information.
)
[ListOfficeName] => Array
(
[0] => Hawaii Life
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 89080.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HLRE
)
[ListAgentEmail] => Array
(
[0] => kylebernhardt@hawaiilife.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (800) 370-3848
)
[ListAgentFullName] => Array
(
[0] => Kyle Bernhardt
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-27T17:41:27.633
)
[Matrix_Unique_ID] => Array
(
[0] => 18273005
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-20T14:55:10.190
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26702940
)
[listing_image] => Array
(
[0] => 26702940
[1] => 26702941
[2] => 26702942
[3] => 26702943
[4] => 26702944
[5] => 26702945
[6] => 26702946
[7] => 26702947
[8] => 26702948
[9] => 26702949
[10] => 26702950
[11] => 26702951
[12] => 26702952
[13] => 26702953
[14] => 26702954
[15] => 26702955
[16] => 26702956
[17] => 26702957
[18] => 26702958
[19] => 26702959
[20] => 26702960
[21] => 26702961
[22] => 26702962
[23] => 26702963
[24] => 26702964
[25] => 26702965
)
)
