The office will be closed on Friday, July 4th, in observance of Independence Day and will re-open on Monday.
67-174 B #1 Farrington Highway Waialua, HI 96791
Listing Overview
Price: $2,290,000
Area: WAIALUA
Status: Active
This private location is for those that want to escape to a rural setting with stunning views. This lot has been graded and there is a private water well with both residential and AG water approved, electric is ready for connection. One could use existing plans or start anew and create a beautiful country agricultural estate. Private, restricted access. Listing by: List Sotheby's Int'l Realty (808) 478-2568
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415433"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(11) "67-174 B #1"
}
["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(0) ""
}
["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(10) "2290000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2290000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(355) "This private location is for those that want to escape to a rural setting with stunning views. This lot has been graded and there is a private water well with both residential and AG water approved, electric is ready for connection. One could use existing plans or start anew and create a beautiful country agricultural estate. Private, restricted access."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "List Sotheby's Int'l Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "906048.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(15) "Coastline,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) "LIST"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "jeffhughes96743@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 478-2568"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Jeffrey A Hughes"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-01T11:12:01.910"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18109537"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-01T11:12:01.910"
}
["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) "26644354"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "26644354"
[1]=>
string(8) "26644355"
[2]=>
string(8) "26644356"
[3]=>
string(8) "26644357"
[4]=>
string(8) "26644358"
[5]=>
string(8) "26644359"
[6]=>
string(8) "26644360"
[7]=>
string(8) "26644361"
[8]=>
string(8) "26644362"
[9]=>
string(8) "26644363"
[10]=>
string(8) "26644364"
[11]=>
string(8) "26644365"
[12]=>
string(8) "26644366"
[13]=>
string(8) "26644367"
[14]=>
string(8) "26644368"
[15]=>
string(8) "26644369"
[16]=>
string(8) "26644370"
[17]=>
string(8) "26644371"
[18]=>
string(8) "26644372"
[19]=>
string(8) "26644373"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415433
)
[StreetNumber] => Array
(
[0] => 67-174 B #1
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Farrington
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 2290000.00
)
[CurrentPrice] => Array
(
[0] => 2290000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This private location is for those that want to escape to a rural setting with stunning views. This lot has been graded and there is a private water well with both residential and AG water approved, electric is ready for connection. One could use existing plans or start anew and create a beautiful country agricultural estate. Private, restricted access.
)
[ListOfficeName] => Array
(
[0] => List Sotheby's Int'l Realty
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 906048.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Coastline,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => LIST
)
[ListAgentEmail] => Array
(
[0] => jeffhughes96743@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 478-2568
)
[ListAgentFullName] => Array
(
[0] => Jeffrey A Hughes
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-01T11:12:01.910
)
[Matrix_Unique_ID] => Array
(
[0] => 18109537
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-01T11:12:01.910
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26644354
)
[listing_image] => Array
(
[0] => 26644354
[1] => 26644355
[2] => 26644356
[3] => 26644357
[4] => 26644358
[5] => 26644359
[6] => 26644360
[7] => 26644361
[8] => 26644362
[9] => 26644363
[10] => 26644364
[11] => 26644365
[12] => 26644366
[13] => 26644367
[14] => 26644368
[15] => 26644369
[16] => 26644370
[17] => 26644371
[18] => 26644372
[19] => 26644373
)
)
Land Area (sf): 906,048 sf
View: Coastline,Ocean
Listing Office: List Sotheby's Int'l Realty
Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 1, 2024 - 11:12 AM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
© Marcus Realty. All Rights Reserved.