Previous Next

67-174 B #1 Farrington Highway Waialua, HI 96791

Listing
Overview

Price: $2,290,000
Area: WAIALUA
Status: Active

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
        )

)

PROPERTY INFO

• Land Area (sf): 906,048 sf

KEY FEATURES

• View: Coastline,Ocean
• Listing Office: List Sotheby's Int'l Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

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.