95-257 Waikalani Drive Unit B703 Mililani, HI 96789

Listing
Overview

Price: $440,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active Under Contract

Welcome to Waikalani Woodlands, a peaceful and tranquil location for your new home. Newly painted 2 bedroom 1 bath corner unit located on the 7th floor. Your property comes complete with upgraded stainless steel appliances and vinyl plank flooring. Upgraded cabinetry in the kitchen. Along with upgraded vanity and cabinetry in the bathroom. It comes with a lanai that oversees the beautfiul launani valley stream and mililani mountain side. Unit Is also located immediately adjacent to 2 covered parking stalls (45,46) and with walking distance of a community rec center. The rec center comes with a very open BBQ area/park for the kids and a community pool great for entertaining. Also your Woodlands complex is located in close proximity to multiple schools including, Wheeler Elementary and Middle. Leileihua and Mililani High school. It's located right next to a freeway on ramp which makes for easy commuting, not to mention within a short distance to the gorgeous North Shore. Welcome Home!!!! Listing by: Mello Properties of Oahu LLC (808) 479-0482

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202421666"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "95-257"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Waikalani"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Drive"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "B703"
  }
  ["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) "440000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "440000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1000) "Welcome to Waikalani Woodlands, a peaceful and tranquil location for your new home. Newly painted 2 bedroom 1 bath corner unit located on the 7th floor. Your property comes complete with upgraded stainless steel appliances and vinyl plank flooring. Upgraded cabinetry in the kitchen. Along with upgraded vanity and cabinetry in the bathroom. It comes with a lanai that oversees the beautfiul launani valley stream and mililani mountain side. Unit Is also located immediately adjacent to 2 covered parking stalls (45,46) and with walking distance of a community rec center. The rec center comes with a very open BBQ area/park for the kids and a community pool great for entertaining. Also your Woodlands complex is located in close proximity to multiple schools including, Wheeler Elementary and Middle. Leileihua and Mililani High school. It's located right next to a freeway on ramp which makes for easy commuting, not to mention within a short distance to the gorgeous North Shore. Welcome Home!!!!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(28) "Mello Properties of Oahu LLC"
  }
  ["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(10) "1135914.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "890"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1976"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(19) "Waikalani Woodlands"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(4) "8-14"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "696.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) "MELL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(38) "gavin.mendez@mellopropertiesofoahu.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 479-0482"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Gavin Mendez"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-04T14:21:48.060"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18279036"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-24T08:56:47.223"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Central"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(12) "Stream/Canal"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26705916"
  }
  ["listing_image"]=>
  array(13) {
    [0]=>
    string(8) "26705916"
    [1]=>
    string(8) "26705917"
    [2]=>
    string(8) "26705918"
    [3]=>
    string(8) "26705919"
    [4]=>
    string(8) "26705920"
    [5]=>
    string(8) "26705921"
    [6]=>
    string(8) "26705922"
    [7]=>
    string(8) "26705923"
    [8]=>
    string(8) "26705924"
    [9]=>
    string(8) "26705925"
    [10]=>
    string(8) "26705926"
    [11]=>
    string(8) "26705927"
    [12]=>
    string(8) "26705928"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202421666
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to Waikalani Woodlands, a peaceful and tranquil location for your new home. Newly painted 2 bedroom 1 bath corner unit located on the 7th floor. Your property comes complete with upgraded stainless steel appliances and vinyl plank flooring. Upgraded cabinetry in the kitchen. Along with upgraded vanity and cabinetry in the bathroom. It comes with a lanai that oversees the beautfiul launani valley stream and mililani mountain side. Unit Is also located immediately adjacent to 2 covered parking stalls (45,46) and with walking distance of a community rec center. The rec center comes with a very open BBQ area/park for the kids and a community pool great for entertaining. Also your Woodlands complex is located in close proximity to multiple schools including, Wheeler Elementary and Middle. Leileihua and Mililani High school. It's located right next to a freeway on ramp which makes for easy commuting, not to mention within a short distance to the gorgeous North Shore. Welcome Home!!!!
        )

    [ListOfficeName] => Array
        (
            [0] => Mello Properties of Oahu LLC
        )

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

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

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

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

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

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

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

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

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

    [StoriesType] => Array
        (
            [0] => 8-14
        )

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => gavin.mendez@mellopropertiesofoahu.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 479-0482
        )

    [ListAgentFullName] => Array
        (
            [0] => Gavin Mendez
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-04T14:21:48.060
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-09-24T08:56:47.223
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Stream/Canal
        )

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

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

    [listing_image] => Array
        (
            [0] => 26705916
            [1] => 26705917
            [2] => 26705918
            [3] => 26705919
            [4] => 26705920
            [5] => 26705921
            [6] => 26705922
            [7] => 26705923
            [8] => 26705924
            [9] => 26705925
            [10] => 26705926
            [11] => 26705927
            [12] => 26705928
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Land Area (sf): 1,135,914
  • Living (sf): 890
  • Year Built: 1976
  • Building Name: Waikalani Woodlands

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: Mountain
  • Listing Office: Mello Properties of Oahu LLC

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

CONTACT US

Marcus Realty

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