95-2035 Waikalani Place Unit B306 Mililani, HI 96789

Listing
Overview

Price: $449,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active

Nestled in the heart of Waipio Acres, your new home awaits in the tranquil hideaway, Northbrook Melemanu Woodlands! This 2 bedroom, 1 bathroom was carefully upgraded in 2024 and features luxury vinyl plank flooring, stainless steel kitchen appliances, and a full-size, in-unit washer and dryer! Relax on your sofa with unobstructed views of the nearby garden, or take your 'Me Time' outside to your covered lanai, basking in the warm Oahu sunshine. Both bedrooms feature ample storage space, and the extra counter space in the bathroom is perfect for making cohabitating a breeze. Located just a few minutes away from Mililani Golf Club, Mililani Shopping Center, Melemanu Neighborhood Park, and Wheeler Army Airfield, this is truly a hidden gem! Must see to fully appreciate all this unit has to offer. Listing by: Vesta Hawaii Real Estate (808) 561-8200

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202423838"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "95-2035"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Waikalani"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "B306"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96789"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "449000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "449000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(803) "Nestled in the heart of Waipio Acres, your new home awaits in the tranquil hideaway, Northbrook Melemanu Woodlands! This 2 bedroom, 1 bathroom was carefully upgraded in 2024 and features luxury vinyl plank flooring, stainless steel kitchen appliances, and a full-size, in-unit washer and dryer! Relax on your sofa with unobstructed views of the nearby garden, or take your 'Me Time' outside to your covered lanai, basking in the warm Oahu sunshine. Both bedrooms feature ample storage space, and the extra counter space in the bathroom is perfect for making cohabitating a breeze. Located just a few minutes away from Mililani Golf Club, Mililani Shopping Center, Melemanu Neighborhood Park, and Wheeler Army Airfield, this is truly a hidden gem! Must see to fully appreciate all this unit has to offer."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "Vesta Hawaii Real Estate"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "170145.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "896"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(19) "Northbrook-Melemanu"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(9) "15-20,21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "782.00"
  }
  ["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) "VEST"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "courtney@vestahawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 561-8200"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Courtney J Takai"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-24T07:27:40.877"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18322306"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-14T12:28:13.027"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Central"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26730423"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "26730423"
    [1]=>
    string(8) "26730424"
    [2]=>
    string(8) "26730425"
    [3]=>
    string(8) "26730426"
    [4]=>
    string(8) "26730427"
    [5]=>
    string(8) "26730428"
    [6]=>
    string(8) "26730429"
    [7]=>
    string(8) "26730430"
    [8]=>
    string(8) "26730431"
    [9]=>
    string(8) "26730432"
    [10]=>
    string(8) "26730433"
    [11]=>
    string(8) "26730434"
    [12]=>
    string(8) "26730435"
    [13]=>
    string(8) "26730436"
    [14]=>
    string(8) "26730437"
    [15]=>
    string(8) "26730438"
    [16]=>
    string(8) "26730439"
    [17]=>
    string(8) "26730440"
    [18]=>
    string(8) "26730441"
    [19]=>
    string(8) "26730442"
    [20]=>
    string(8) "26730443"
    [21]=>
    string(8) "26730444"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202423838
        )

    [StreetNumber] => Array
        (
            [0] => 95-2035
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => WAIPIO ACRES/WAIKALANI WOODLANDS
        )

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

    [PublicRemarks] => Array
        (
            [0] => Nestled in the heart of Waipio Acres, your new home awaits in the tranquil hideaway, Northbrook Melemanu Woodlands! This 2 bedroom, 1 bathroom was carefully upgraded in 2024 and features luxury vinyl plank flooring, stainless steel kitchen appliances, and a full-size, in-unit washer and dryer! Relax on your sofa with unobstructed views of the nearby garden, or take your 'Me Time' outside to your covered lanai, basking in the warm Oahu sunshine. Both bedrooms feature ample storage space, and the extra counter space in the bathroom is perfect for making cohabitating a breeze. Located just a few minutes away from Mililani Golf Club, Mililani Shopping Center, Melemanu Neighborhood Park, and Wheeler Army Airfield, this is truly a hidden gem! Must see to fully appreciate all this unit has to offer.
        )

    [ListOfficeName] => Array
        (
            [0] => Vesta Hawaii Real Estate
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Northbrook-Melemanu
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

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

    [StoriesType] => Array
        (
            [0] => 15-20,21+
        )

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => courtney@vestahawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 561-8200
        )

    [ListAgentFullName] => Array
        (
            [0] => Courtney J Takai
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-24T07:27:40.877
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-10-14T12:28:13.027
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26730423
            [1] => 26730424
            [2] => 26730425
            [3] => 26730426
            [4] => 26730427
            [5] => 26730428
            [6] => 26730429
            [7] => 26730430
            [8] => 26730431
            [9] => 26730432
            [10] => 26730433
            [11] => 26730434
            [12] => 26730435
            [13] => 26730436
            [14] => 26730437
            [15] => 26730438
            [16] => 26730439
            [17] => 26730440
            [18] => 26730441
            [19] => 26730442
            [20] => 26730443
            [21] => 26730444
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Land Area (sf): 170,145
  • Living (sf): 896
  • Year Built: 1973
  • Building Name: Northbrook-Melemanu

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: Garden
  • Listing Office: Vesta Hawaii Real Estate

  • Maintenance Fees: $782
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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