Listing
Overview
Price: $2,995,000
Area: LUALUALEI
Status: Active
Rarely Available was previously operated as a Wholesale Orchid Business **orchid business serving the mainland had a license. This property was also previously used for wholes/retail and garden supplies, wholesale construction materials, plumbing and heating equipment, and agricultural raw materials and live animals. Highlights include: Multiple buildings on property, 2 Single family house on site, a warehouse , Fully installed plumbing, water lines, electrical systems and structures to cultivate farm type operation. Has 2 water meters. Listing by: List Sotheby's Int'l Realty (808) 397-4480
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202515618"
}
["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(93) "https://players.brightcove.net/5782054075001/default_default/index.html?videoId=6356517721112"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2995000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "LUALUALEI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(542) "Rarely Available was previously operated as a Wholesale Orchid Business **orchid business serving the mainland had a license. This property was also previously used for wholes/retail and garden supplies, wholesale construction materials, plumbing and heating equipment, and agricultural raw materials and live animals. Highlights include: Multiple buildings on property, 2 Single family house on site, a warehouse , Fully installed plumbing, water lines, electrical systems and structures to cultivate farm type operation. Has 2 water meters."
}
["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(4) "None"
}
["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) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18852387"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-07-09T00:58:09.440"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-07-07"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Leeward"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "00:58:09.440"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27060496"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "27060496"
[1]=>
string(8) "27060497"
[2]=>
string(8) "27060498"
[3]=>
string(8) "27060499"
[4]=>
string(8) "27060500"
[5]=>
string(8) "27060501"
[6]=>
string(8) "27060502"
[7]=>
string(8) "27060503"
[8]=>
string(8) "27060504"
[9]=>
string(8) "27060505"
[10]=>
string(8) "27060506"
[11]=>
string(8) "27060507"
[12]=>
string(8) "27060508"
[13]=>
string(8) "27060509"
[14]=>
string(8) "27060510"
[15]=>
string(8) "27060511"
[16]=>
string(8) "27060512"
[17]=>
string(8) "27060513"
[18]=>
string(8) "27060514"
[19]=>
string(8) "27060515"
[20]=>
string(8) "27060516"
[21]=>
string(8) "27060517"
[22]=>
string(8) "27060518"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202515618
)
[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://players.brightcove.net/5782054075001/default_default/index.html?videoId=6356517721112
)
[ListPrice] => Array
(
[0] => 2995000.00
)
[Neighbourhood] => Array
(
[0] => LUALUALEI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Rarely Available was previously operated as a Wholesale Orchid Business **orchid business serving the mainland had a license. This property was also previously used for wholes/retail and garden supplies, wholesale construction materials, plumbing and heating equipment, and agricultural raw materials and live animals. Highlights include: Multiple buildings on property, 2 Single family house on site, a warehouse , Fully installed plumbing, water lines, electrical systems and structures to cultivate farm type operation. Has 2 water meters.
)
[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] => None
)
[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] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18852387
)
[MatrixModifiedDT] => Array
(
[0] => 2025-07-09T00:58:09.440
)
[ListingContractDate] => Array
(
[0] => 2025-07-07
)
[MLSAreaMajor] => Array
(
[0] => Leeward
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 00:58:09.440
)
[_thumbnail_id] => Array
(
[0] => 27060496
)
[listing_image] => Array
(
[0] => 27060496
[1] => 27060497
[2] => 27060498
[3] => 27060499
[4] => 27060500
[5] => 27060501
[6] => 27060502
[7] => 27060503
[8] => 27060504
[9] => 27060505
[10] => 27060506
[11] => 27060507
[12] => 27060508
[13] => 27060509
[14] => 27060510
[15] => 27060511
[16] => 27060512
[17] => 27060513
[18] => 27060514
[19] => 27060515
[20] => 27060516
[21] => 27060517
[22] => 27060518
)
)
- Land Area (sf): 198,711 sf
- View: None
- 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 July 9, 2025 - 12:58 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.
