87-250 Kulaaupuni Street Waianae, HI 96792
Listing
Overview
Price: $2,000,000
Area: MAILI
Status: Active
3 acres of flat and clear land in Waianae! Zoned AG2 and ready to be made your own. This property features a large house with two bedrooms, two bathrooms, and two additional office rooms. The living room features an indoor koi pond! The lot features a grove of about 30 Kou trees and 20 Milo trees. There are three naval orange, three tangerine, three varieties of mango, lemon, calamansi, pomegranate, and tamarind trees on the property too. Listing by: Newtown Realty, Inc. (808) 597-7086
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202411927"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "87-250"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kulaaupuni"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2000000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2000000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(5) "MAILI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(442) "3 acres of flat and clear land in Waianae! Zoned AG2 and ready to be made your own. This property features a large house with two bedrooms, two bathrooms, and two additional office rooms. The living room features an indoor koi pond! The lot features a grove of about 30 Kou trees and 20 Milo trees. There are three naval orange, three tangerine, three varieties of mango, lemon, calamansi, pomegranate, and tamarind trees on the property too."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(20) "Newtown Realty, Inc."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "132422.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(5) "Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(5) "Maili"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "NEWT"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "amtsuchitori@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 597-7086"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Aaron M Tsuchitori"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-05-24T13:43:44.810"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18024427"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-24T13:43:44.810"
}
["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) "26426176"
}
["listing_image"]=>
array(10) {
[0]=>
string(8) "26426176"
[1]=>
string(8) "26426177"
[2]=>
string(8) "26426178"
[3]=>
string(8) "26426179"
[4]=>
string(8) "26426180"
[5]=>
string(8) "26426181"
[6]=>
string(8) "26426182"
[7]=>
string(8) "26426183"
[8]=>
string(8) "26426184"
[9]=>
string(8) "26426185"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202411927
)
[StreetNumber] => Array
(
[0] => 87-250
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kulaaupuni
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waianae
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96792
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 2000000.00
)
[CurrentPrice] => Array
(
[0] => 2000000.00
)
[Neighbourhood] => Array
(
[0] => MAILI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => 3 acres of flat and clear land in Waianae! Zoned AG2 and ready to be made your own. This property features a large house with two bedrooms, two bathrooms, and two additional office rooms. The living room features an indoor koi pond! The lot features a grove of about 30 Kou trees and 20 Milo trees. There are three naval orange, three tangerine, three varieties of mango, lemon, calamansi, pomegranate, and tamarind trees on the property too.
)
[ListOfficeName] => Array
(
[0] => Newtown Realty, Inc.
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 132422.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Maili
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waianae
)
[HighSchool] => Array
(
[0] => Waianae
)
[ListOfficeMLSID] => Array
(
[0] => NEWT
)
[ListAgentEmail] => Array
(
[0] => amtsuchitori@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 597-7086
)
[ListAgentFullName] => Array
(
[0] => Aaron M Tsuchitori
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-05-24T13:43:44.810
)
[Matrix_Unique_ID] => Array
(
[0] => 18024427
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-24T13:43:44.810
)
[MLSAreaMajor] => Array
(
[0] => Leeward
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26426176
)
[listing_image] => Array
(
[0] => 26426176
[1] => 26426177
[2] => 26426178
[3] => 26426179
[4] => 26426180
[5] => 26426181
[6] => 26426182
[7] => 26426183
[8] => 26426184
[9] => 26426185
)
)
- View: Other
- Listing Office: Newtown Realty, Inc.
- Land Tenure: FS - Fee Simple
- Elementary School: Maili
- Middle School: Waianae
- High School: Waianae
