95-024 Waihau Streets Unit 4/B Mililani, HI 96789
Listing
Overview
Price: $349,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
This original owner two bedroom, 1 bath, one assigned parking unit features newly painted interior, ceiling and kitchen cabinets as well as new refrigerator, oven stove, microwave and ceiling fan. The windows have also been professionally cleaned to allow all the natural lighting to make this spacious unit move-in ready. Located in the Mililani school district and conveniently close to Schofield Barracks, Wheeler Army Air Field and a short drive to the scenic North Shore. Building is equipped with PV Solar and electricity is sub-metered to occupant. Open House Sunday 3/2 from 2-5pm. Come on BUY! Listing by: List Sotheby's Int'l Realty (808) 735-2411
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202503399"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "95-024"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Waihau"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Streets"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "4/B"
}
["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) "349000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(604) "This original owner two bedroom, 1 bath, one assigned parking unit features newly painted interior, ceiling and kitchen cabinets as well as new refrigerator, oven stove, microwave and ceiling fan. The windows have also been professionally cleaned to allow all the natural lighting to make this spacious unit move-in ready. Located in the Mililani school district and conveniently close to Schofield Barracks, Wheeler Army Air Field and a short drive to the scenic North Shore. Building is equipped with PV Solar and electricity is sub-metered to occupant. Open House Sunday 3/2 from 2-5pm. Come on BUY!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "List Sotheby's Int'l Realty"
}
["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(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "682"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1965"
}
["BuildingName"]=>
array(1) {
[0]=>
string(14) "Waipio Gardens"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "769.42"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Kipapa"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "LIST"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "hirealestate@hawaii.rr.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 735-2411"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(26) "Yuki Schenkenberg Takenaka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18529905"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-27T06:45:01.127"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-02-05"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "06:45:01.127"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26872711"
}
["listing_image"]=>
array(19) {
[0]=>
string(8) "26872711"
[1]=>
string(8) "26872712"
[2]=>
string(8) "26872713"
[3]=>
string(8) "26872714"
[4]=>
string(8) "26872715"
[5]=>
string(8) "26872716"
[6]=>
string(8) "26872717"
[7]=>
string(8) "26872718"
[8]=>
string(8) "26872719"
[9]=>
string(8) "26872720"
[10]=>
string(8) "26872721"
[11]=>
string(8) "26872722"
[12]=>
string(8) "26872723"
[13]=>
string(8) "26872724"
[14]=>
string(8) "26872725"
[15]=>
string(8) "26872726"
[16]=>
string(8) "26872727"
[17]=>
string(8) "26872728"
[18]=>
string(8) "26878374"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202503399
)
[StreetNumber] => Array
(
[0] => 95-024
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waihau
)
[StreetSuffix] => Array
(
[0] => Streets
)
[UnitNumber] => Array
(
[0] => 4/B
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 349000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This original owner two bedroom, 1 bath, one assigned parking unit features newly painted interior, ceiling and kitchen cabinets as well as new refrigerator, oven stove, microwave and ceiling fan. The windows have also been professionally cleaned to allow all the natural lighting to make this spacious unit move-in ready. Located in the Mililani school district and conveniently close to Schofield Barracks, Wheeler Army Air Field and a short drive to the scenic North Shore. Building is equipped with PV Solar and electricity is sub-metered to occupant. Open House Sunday 3/2 from 2-5pm. Come on BUY!
)
[ListOfficeName] => Array
(
[0] => List Sotheby's Int'l Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 682
)
[YearBuilt] => Array
(
[0] => 1965
)
[BuildingName] => Array
(
[0] => Waipio Gardens
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 769.42
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kipapa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Mililani
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => LIST
)
[ListAgentEmail] => Array
(
[0] => hirealestate@hawaii.rr.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 735-2411
)
[ListAgentFullName] => Array
(
[0] => Yuki Schenkenberg Takenaka
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18529905
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-27T06:45:01.127
)
[ListingContractDate] => Array
(
[0] => 2025-02-05
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 06:45:01.127
)
[_thumbnail_id] => Array
(
[0] => 26872711
)
[listing_image] => Array
(
[0] => 26872711
[1] => 26872712
[2] => 26872713
[3] => 26872714
[4] => 26872715
[5] => 26872716
[6] => 26872717
[7] => 26872718
[8] => 26872719
[9] => 26872720
[10] => 26872721
[11] => 26872722
[12] => 26872723
[13] => 26872724
[14] => 26872725
[15] => 26872726
[16] => 26872727
[17] => 26872728
[18] => 26878374
)
)
- BedsTotal: 2
- Full Baths: 1
- Living (sf): 682
- Year Built: 1965
- Building Name: Waipio Gardens
- Property Condition: Above Average
- Number of Parking Spaces: 1
- View: Mountain
- Listing Office: List Sotheby's Int'l Realty
- Maintenance Fees: $769
- Land Tenure: FS - Fee Simple
- Elementary School: Kipapa
- Middle School: Mililani
- High School: Mililani
