Previous Next

65-277 Poamoho Place Waialua, HI 96791

Listing
Overview

Price: $15,000,000
Area: WAIALUA
Status: Active

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
        )

)

PROPERTY INFO

• BedsTotal: 5
• Full Baths: 5
• Half Baths: 1
• Land Area (sf): 218,192 sf
• Living (sf): 5,500
• Year Built: 2013

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 8
• View: Coastline,Mountain,Ocean,Sunrise,Sunset
• Listing Office: Nathalie Mullinix R. U., Inc.

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

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 September 18, 2024 - 8:20 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.