2651 Waiomao Road Unit A Honolulu, HI 96816

Listing
Overview

Price: $2,988,888
Area: PALOLO
Status: Active

Don’t miss out on this once in a lifetime opportunity to call this tropical paradise home. Located on 4+ acres and with rental potential in the downstairs in-law suite and approved permits to build an ADU on top of the free-standing garage, this home has endless potential. Backed up to preservation land and surrounded by immaculate landscaping and tropical flora with fruit trees to include banana, papaya, lychee, and mango. With peak-a-boo Waikiki views, you won’t believe you’re just a short 15 minute drive to Waikiki and the beach. Remodeled in 2012 and built with the highest attention to materials and craftsmanship, this home is graced with expansive ceilings and doorways, custom built-in open shelves for storage, spacious rooms & baths, walk-in Master closet and shower, hard-wood flooring, custom built kitchen, wet bar & cabinets, a wrap-around covered lanai, and a beautiful koi pond at the home's main entrance. Additional features include solar and a Tesla EV charger in the garage. Attached Ohana that is a successful rental to use for additional family or for some extra income. Call now to see this secluded and peaceful estate nestled in the heart of Palolo Valley. Listing by: KBM Hawaii

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202310779"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "2651"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Waiomao"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "A"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96816"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2988888.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "2988888.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "PALOLO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1193) "Don’t miss out on this once in a lifetime opportunity to call this tropical paradise home. Located on 4+ acres and with rental potential in the downstairs in-law suite and approved permits to build an ADU on top of the free-standing garage, this home has endless potential. Backed up to preservation land and surrounded by immaculate landscaping and tropical flora with fruit trees to include banana, papaya, lychee, and mango. With peak-a-boo Waikiki views, you won’t believe you’re just a short 15 minute drive to Waikiki and the beach. Remodeled in 2012 and built with the highest attention to materials and craftsmanship, this home is graced with expansive ceilings and doorways, custom built-in open shelves for storage, spacious rooms & baths, walk-in Master closet and shower, hard-wood flooring, custom built kitchen, wet bar & cabinets, a wrap-around covered lanai, and a beautiful koi pond at the home's main entrance. Additional features include solar and a Tesla EV charger in the garage. Attached Ohana that is a successful rental to use for additional family or for some extra income. Call now to see this secluded and peaceful estate nestled in the heart of Palolo Valley."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "KBM Hawaii"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "175466.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3334"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2004"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(6) "Three+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(12) "Garden,Other"
  }
  ["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) "KMAA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "jon@kbmresorts.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Jonathan B Brunold"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-09-30T13:00:01.370"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17319036"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-05-14T09:32:46.800"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25849158"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25849158"
    [1]=>
    string(8) "25849159"
    [2]=>
    string(8) "25849160"
    [3]=>
    string(8) "25849161"
    [4]=>
    string(8) "25849162"
    [5]=>
    string(8) "25849163"
    [6]=>
    string(8) "25849164"
    [7]=>
    string(8) "25849165"
    [8]=>
    string(8) "25849166"
    [9]=>
    string(8) "25849167"
    [10]=>
    string(8) "25849168"
    [11]=>
    string(8) "25849169"
    [12]=>
    string(8) "25849170"
    [13]=>
    string(8) "25849171"
    [14]=>
    string(8) "25849172"
    [15]=>
    string(8) "25849173"
    [16]=>
    string(8) "25849174"
    [17]=>
    string(8) "25849175"
    [18]=>
    string(8) "25849176"
    [19]=>
    string(8) "25849177"
    [20]=>
    string(8) "25849178"
    [21]=>
    string(8) "25849179"
    [22]=>
    string(8) "25849180"
    [23]=>
    string(8) "25849181"
    [24]=>
    string(8) "25849182"
    [25]=>
    string(8) "25849183"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(12) "Preservation"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202310779
        )

    [StreetNumber] => Array
        (
            [0] => 2651
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Waiomao
        )

    [StreetSuffix] => Array
        (
            [0] => Road
        )

    [UnitNumber] => Array
        (
            [0] => A
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96816
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 2988888.00
        )

    [CurrentPrice] => Array
        (
            [0] => 2988888.00
        )

    [Neighbourhood] => Array
        (
            [0] => PALOLO
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Don’t miss out on this once in a lifetime opportunity to call this tropical paradise home. Located on 4+ acres and with rental potential in the downstairs in-law suite and approved permits to build an ADU on top of the free-standing garage, this home has endless potential. Backed up to preservation land and surrounded by immaculate landscaping and tropical flora with fruit trees to include banana, papaya, lychee, and mango. With peak-a-boo Waikiki views, you won’t believe you’re just a short 15 minute drive to Waikiki and the beach. Remodeled in 2012 and built with the highest attention to materials and craftsmanship, this home is graced with expansive ceilings and doorways, custom built-in open shelves for storage, spacious rooms & baths, walk-in Master closet and shower, hard-wood flooring, custom built kitchen, wet bar & cabinets, a wrap-around covered lanai, and a beautiful koi pond at the home's main entrance. Additional features include solar and a Tesla EV charger in the garage. Attached Ohana that is a successful rental to use for additional family or for some extra income. Call now to see this secluded and peaceful estate nestled in the heart of Palolo Valley.
        )

    [ListOfficeName] => Array
        (
            [0] => KBM Hawaii
        )

    [BedsTotal] => Array
        (
            [0] => 4
        )

    [BathsFull] => Array
        (
            [0] => 4
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 175466.00
        )

    [SqftTotal] => Array
        (
            [0] => 3334
        )

    [YearBuilt] => Array
        (
            [0] => 2004
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

    [ParkingTotal] => Array
        (
            [0] => 6
        )

    [StoriesType] => Array
        (
            [0] => Three+
        )

    [View] => Array
        (
            [0] => Garden,Other
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => KMAA
        )

    [ListAgentEmail] => Array
        (
            [0] => jon@kbmresorts.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => 
        )

    [ListAgentFullName] => Array
        (
            [0] => Jonathan B Brunold
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-09-30T13:00:01.370
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 17319036
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-05-14T09:32:46.800
        )

    [_thumbnail_id] => Array
        (
            [0] => 25849158
        )

    [listing_image] => Array
        (
            [0] => 25849158
            [1] => 25849159
            [2] => 25849160
            [3] => 25849161
            [4] => 25849162
            [5] => 25849163
            [6] => 25849164
            [7] => 25849165
            [8] => 25849166
            [9] => 25849167
            [10] => 25849168
            [11] => 25849169
            [12] => 25849170
            [13] => 25849171
            [14] => 25849172
            [15] => 25849173
            [16] => 25849174
            [17] => 25849175
            [18] => 25849176
            [19] => 25849177
            [20] => 25849178
            [21] => 25849179
            [22] => 25849180
            [23] => 25849181
            [24] => 25849182
            [25] => 25849183
        )

    [MLSAreaMajor] => Array
        (
            [0] => DiamondHd
        )

    [PropertyFrontage] => Array
        (
            [0] => Preservation
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

)

  • BedsTotal: 4
  • Full Baths: 4
  • Land Area (sf): 175,466
  • Living (sf): 3,334
  • Year Built: 2004

  • Property Condition: Above Average
  • Number of Parking Spaces: 6
  • View: Garden,Other
  • Listing Office: KBM Hawaii

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446