65-277 Poamoho Place Waialua, HI 96791
Listing
Overview
Price: $15,000,000
Area: WAIALUA
Status: Active
Unique super luxury escape and retreat with a farm in North Shore. Two dwellings, two pools, roofed sheep pan, stand-alone sauna, stand-alone 25kW solar panel and battery system, large stand-alone furnished gazebo, stand-alone jacuzzi, storage structure, fish pond. Land has 100+ mango trees, infrastructure includes propane storage, 25+ water spigots and electric outlets, area ready for a tennis court. Two vehicle entrances, two electrified parking areas. Tractor and zero-turn lawnmower. Dwellings are completely remodeled with use of glassboard instead of plywood. Each room has own bathroom and separate entrance. Main house has large outdoor grill bar, gas stove, huge bar island with induction cooktop, two propane on-demand water heaters, built-in vacuum, four air conditioners. Rooms include separate office and exercise facilities. Balcony. Virtual tour & some pictures are taken before the renovation. “All comments, data is provided by seller or seller's representatives. Buyer to confirm all & hold all parties harmless from any discrepancy data in the mls & advertising. Limited Service–Data Entry Addendum signed by seller/s must be sign by buyer/s with Purchase Contract." Listing by: Nathalie Mullinix R. U., Inc. (808) 261-0350
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202401614"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "65-277"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Poamoho"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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(11) "15000000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(11) "15000000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1193) "Unique super luxury escape and retreat with a farm in North Shore. Two dwellings, two pools, roofed sheep pan, stand-alone sauna, stand-alone 25kW solar panel and battery system, large stand-alone furnished gazebo, stand-alone jacuzzi, storage structure, fish pond. Land has 100+ mango trees, infrastructure includes propane storage, 25+ water spigots and electric outlets, area ready for a tennis court. Two vehicle entrances, two electrified parking areas. Tractor and zero-turn lawnmower. Dwellings are completely remodeled with use of glassboard instead of plywood. Each room has own bathroom and separate entrance. Main house has large outdoor grill bar, gas stove, huge bar island with induction cooktop, two propane on-demand water heaters, built-in vacuum, four air conditioners. Rooms include separate office and exercise facilities. Balcony. Virtual tour & some pictures are taken before the renovation. “All comments, data is provided by seller or seller's representatives. Buyer to confirm all & hold all parties harmless from any discrepancy data in the mls & advertising. Limited Service–Data Entry Addendum signed by seller/s must be sign by buyer/s with Purchase Contract.""
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(29) "Nathalie Mullinix R. U., Inc."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "218192.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "5500"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2013"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "8"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(39) "Coastline,Mountain,Ocean,Sunrise,Sunset"
}
["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) "NATH"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "sales@realtyuniversal.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 261-0350"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Nathalie C Mullinix"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-18T08:20:43.140"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17793870"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-01-31T10:55:50.303"
}
["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) "26080896"
}
["listing_image"]=>
array(17) {
[0]=>
string(8) "26080896"
[1]=>
string(8) "26080897"
[2]=>
string(8) "26080898"
[3]=>
string(8) "26080899"
[4]=>
string(8) "26080900"
[5]=>
string(8) "26080901"
[6]=>
string(8) "26080902"
[7]=>
string(8) "26080903"
[8]=>
string(8) "26080904"
[9]=>
string(8) "26080905"
[10]=>
string(8) "26080906"
[11]=>
string(8) "26080907"
[12]=>
string(8) "26080908"
[13]=>
string(8) "26080909"
[14]=>
string(8) "26080910"
[15]=>
string(8) "26080911"
[16]=>
string(8) "26080912"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:20:43.140"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202401614
)
[StreetNumber] => Array
(
[0] => 65-277
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Poamoho
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 15000000.00
)
[CurrentPrice] => Array
(
[0] => 15000000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Unique super luxury escape and retreat with a farm in North Shore. Two dwellings, two pools, roofed sheep pan, stand-alone sauna, stand-alone 25kW solar panel and battery system, large stand-alone furnished gazebo, stand-alone jacuzzi, storage structure, fish pond. Land has 100+ mango trees, infrastructure includes propane storage, 25+ water spigots and electric outlets, area ready for a tennis court. Two vehicle entrances, two electrified parking areas. Tractor and zero-turn lawnmower. Dwellings are completely remodeled with use of glassboard instead of plywood. Each room has own bathroom and separate entrance. Main house has large outdoor grill bar, gas stove, huge bar island with induction cooktop, two propane on-demand water heaters, built-in vacuum, four air conditioners. Rooms include separate office and exercise facilities. Balcony. Virtual tour & some pictures are taken before the renovation. “All comments, data is provided by seller or seller's representatives. Buyer to confirm all & hold all parties harmless from any discrepancy data in the mls & advertising. Limited Service–Data Entry Addendum signed by seller/s must be sign by buyer/s with Purchase Contract."
)
[ListOfficeName] => Array
(
[0] => Nathalie Mullinix R. U., Inc.
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 5
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 218192.00
)
[SqftTotal] => Array
(
[0] => 5500
)
[YearBuilt] => Array
(
[0] => 2013
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 8
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => NATH
)
[ListAgentEmail] => Array
(
[0] => sales@realtyuniversal.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 261-0350
)
[ListAgentFullName] => Array
(
[0] => Nathalie C Mullinix
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-18T08:20:43.140
)
[Matrix_Unique_ID] => Array
(
[0] => 17793870
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-01-31T10:55:50.303
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26080896
)
[listing_image] => Array
(
[0] => 26080896
[1] => 26080897
[2] => 26080898
[3] => 26080899
[4] => 26080900
[5] => 26080901
[6] => 26080902
[7] => 26080903
[8] => 26080904
[9] => 26080905
[10] => 26080906
[11] => 26080907
[12] => 26080908
[13] => 26080909
[14] => 26080910
[15] => 26080911
[16] => 26080912
)
[MatrixModifiedTime] => Array
(
[0] => 08:20:43.140
)
)
- BedsTotal: 5
- Full Baths: 5
- Half Baths: 1
- Land Area (sf): 218,192 sf
- Living (sf): 5,500
- Year Built: 2013
- Property Condition: Excellent
- Number of Parking Spaces: 8
- View: Coastline,Mountain,Ocean,Sunrise,Sunset
- Listing Office: Nathalie Mullinix R. U., Inc.
- Land Tenure: FS - Fee Simple
