86-347 Halona Road Waianae, HI 96792

Take a Virtual Tour

Listing
Overview

Price: $2,995,000
Area: LUALUALEI
Status: Active

A rare find in Waiand 4.562 acres this Former Orchid farm has so much potential. This unique property, previously operated as a successful orchid business with a recently expired international shipping license, offers endless possibilities. It has been used for wholesale and retail operations, including garden supplies, construction materials, plumbing and heating equipment, and agricultural raw materials. The property features multiple buildings, a single-family home, warehouse, irrigation system with fully installed plumbing, water lines, and electrical systems, along with existing structures designed for agriculture cultivation. There are 2 tenants on the property both on month to month and goats. Additionally, it is well-suited for farming use. According to the owner, the lot may be subdivided or CPR’d, but buyers are advised to conduct their own due diligence. With its versatile potential, this is a rare opportunity you won’t want to miss! Listing by: List Sotheby's Int'l Realty (808) 397-4480

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202412073"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "86-347"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Halona"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waianae"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96792"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(27) "https://bcove.video/3Lhe5Gd"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2995000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "3290000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(9) "LUALUALEI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(965) "A rare find in Waiand 4.562 acres this Former Orchid farm has so much potential.  This unique property, previously operated as a successful orchid business with a recently expired international shipping license, offers endless possibilities. It has been used for wholesale and retail operations, including garden supplies, construction materials, plumbing and heating equipment, and agricultural raw materials. The property features multiple buildings, a single-family home, warehouse, irrigation system with fully installed plumbing, water lines, and electrical systems, along  with existing structures designed for agriculture cultivation. There are 2 tenants on the property both on month to month and goats.  Additionally, it is well-suited for farming use. According to the owner, the lot may be subdivided or CPR’d, but buyers are advised to conduct their own due diligence. With its versatile potential, this is a rare opportunity you won’t want to miss!"
  }
  ["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) "198711.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) "LIST"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "amallin@listsir.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 397-4480"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Akimi Sue Mallin"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-03-11T09:37:19.687"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18028793"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-05-28T15:10:24.997"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Leeward"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26498407"
  }
  ["listing_image"]=>
  array(23) {
    [0]=>
    string(8) "26498407"
    [1]=>
    string(8) "26498408"
    [2]=>
    string(8) "26498409"
    [3]=>
    string(8) "26498410"
    [4]=>
    string(8) "26498411"
    [5]=>
    string(8) "26498412"
    [6]=>
    string(8) "26498413"
    [7]=>
    string(8) "26498414"
    [8]=>
    string(8) "26609152"
    [9]=>
    string(8) "26609153"
    [10]=>
    string(8) "26609154"
    [11]=>
    string(8) "26609155"
    [12]=>
    string(8) "26609156"
    [13]=>
    string(8) "26609157"
    [14]=>
    string(8) "26609158"
    [15]=>
    string(8) "26609159"
    [16]=>
    string(8) "26609160"
    [17]=>
    string(8) "26609161"
    [18]=>
    string(8) "26609162"
    [19]=>
    string(8) "26609163"
    [20]=>
    string(8) "26609164"
    [21]=>
    string(8) "26609165"
    [22]=>
    string(8) "26609166"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-05-28"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:37:19.687"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202412073
        )

    [StreetNumber] => Array
        (
            [0] => 86-347
        )

    [PropertyType] => Array
        (
            [0] => Lots/Acres/Farms
        )

    [StreetName] => Array
        (
            [0] => Halona
        )

    [StreetSuffix] => Array
        (
            [0] => Road
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Waianae
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96792
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://bcove.video/3Lhe5Gd
        )

    [ListPrice] => Array
        (
            [0] => 2995000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 3290000.00
        )

    [Neighbourhood] => Array
        (
            [0] => LUALUALEI
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => A rare find in Waiand 4.562 acres this Former Orchid farm has so much potential.  This unique property, previously operated as a successful orchid business with a recently expired international shipping license, offers endless possibilities. It has been used for wholesale and retail operations, including garden supplies, construction materials, plumbing and heating equipment, and agricultural raw materials. The property features multiple buildings, a single-family home, warehouse, irrigation system with fully installed plumbing, water lines, and electrical systems, along  with existing structures designed for agriculture cultivation. There are 2 tenants on the property both on month to month and goats.  Additionally, it is well-suited for farming use. According to the owner, the lot may be subdivided or CPR’d, but buyers are advised to conduct their own due diligence. With its versatile potential, this is a rare opportunity you won’t want to miss!
        )

    [ListOfficeName] => Array
        (
            [0] => List Sotheby's Int'l Realty
        )

    [BedsTotal] => Array
        (
            [0] => 
        )

    [BathsFull] => Array
        (
            [0] => 
        )

    [BathsHalf] => Array
        (
            [0] => 
        )

    [LotSizeArea] => Array
        (
            [0] => 198711.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] => LIST
        )

    [ListAgentEmail] => Array
        (
            [0] => amallin@listsir.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 397-4480
        )

    [ListAgentFullName] => Array
        (
            [0] => Akimi Sue Mallin
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-03-11T09:37:19.687
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18028793
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-05-28T15:10:24.997
        )

    [MLSAreaMajor] => Array
        (
            [0] => Leeward
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26498407
        )

    [listing_image] => Array
        (
            [0] => 26498407
            [1] => 26498408
            [2] => 26498409
            [3] => 26498410
            [4] => 26498411
            [5] => 26498412
            [6] => 26498413
            [7] => 26498414
            [8] => 26609152
            [9] => 26609153
            [10] => 26609154
            [11] => 26609155
            [12] => 26609156
            [13] => 26609157
            [14] => 26609158
            [15] => 26609159
            [16] => 26609160
            [17] => 26609161
            [18] => 26609162
            [19] => 26609163
            [20] => 26609164
            [21] => 26609165
            [22] => 26609166
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-05-28
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 09:37:19.687
        )

)

  • Land Area (sf): 198,711 sf

  • View: Mountain
  • Listing Office: List Sotheby's Int'l Realty

  • Land Tenure: FS - Fee Simple

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 March 11, 2025 - 9:37 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.