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
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.