Listing
Overview
Price: $460,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Pending
Cool. Calm. Convenient... and perfect for you! This incredible 2 bedroom, 1 full bathroom condo, is nestled in beautiful Northbrook Melemanu Woodlands. Meticulously improved, this magnificent condo has removed all jalousie windows and has been intentionally upgraded to double-paned windows, newly installed fans with remote control lights, and a window AC in every room. Being pet friendly, you and your furry family members can enjoy the cool vinyl flooring, the bathroom’s delightful ceramic tile, and the views of your backyard oasis. The outstanding, open layout from the kitchen, dining, and living room will be the living space you’ve been searching for. Not to mention, the proximity to all of your activity needs and wants, have endless potential and will blow your mind with this marvelous Mililani home. Listing by: Keller Williams Honolulu (808) 596-2888
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202414011"
}
["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) "B102"
}
["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(51) "https://my.matterport.com/show/?m=SjQxkbdwr5d&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "460000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "460000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(818) "Cool. Calm. Convenient... and perfect for you! This incredible 2 bedroom, 1 full bathroom condo, is nestled in beautiful Northbrook Melemanu Woodlands. Meticulously improved, this magnificent condo has removed all jalousie windows and has been intentionally upgraded to double-paned windows, newly installed fans with remote control lights, and a window AC in every room. Being pet friendly, you and your furry family members can enjoy the cool vinyl flooring, the bathroom’s delightful ceramic tile, and the views of your backyard oasis. The outstanding, open layout from the kitchen, dining, and living room will be the living space you’ve been searching for. Not to mention, the proximity to all of your activity needs and wants, have endless potential and will blow your mind with this marvelous Mililani home."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["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(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["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) "KWPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "joe@oteamhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Joe Extra Ordinario"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-24T12:22:49.457"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18064799"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-20T09:42:01.383"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26627713"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26627713"
[1]=>
string(8) "26627714"
[2]=>
string(8) "26627715"
[3]=>
string(8) "26627716"
[4]=>
string(8) "26627717"
[5]=>
string(8) "26627718"
[6]=>
string(8) "26627719"
[7]=>
string(8) "26627720"
[8]=>
string(8) "26627721"
[9]=>
string(8) "26627722"
[10]=>
string(8) "26627723"
[11]=>
string(8) "26627724"
[12]=>
string(8) "26627725"
[13]=>
string(8) "26627726"
[14]=>
string(8) "26627727"
[15]=>
string(8) "26627728"
[16]=>
string(8) "26627729"
[17]=>
string(8) "26627730"
[18]=>
string(8) "26627731"
[19]=>
string(8) "26627732"
[20]=>
string(8) "26627733"
[21]=>
string(8) "26627734"
[22]=>
string(8) "26627735"
[23]=>
string(8) "26627736"
[24]=>
string(8) "26627737"
[25]=>
string(8) "26627738"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202414011
)
[StreetNumber] => Array
(
[0] => 95-2035
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => B102
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=SjQxkbdwr5d&mls=1
)
[ListPrice] => Array
(
[0] => 460000.00
)
[CurrentPrice] => Array
(
[0] => 460000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Cool. Calm. Convenient... and perfect for you! This incredible 2 bedroom, 1 full bathroom condo, is nestled in beautiful Northbrook Melemanu Woodlands. Meticulously improved, this magnificent condo has removed all jalousie windows and has been intentionally upgraded to double-paned windows, newly installed fans with remote control lights, and a window AC in every room. Being pet friendly, you and your furry family members can enjoy the cool vinyl flooring, the bathroom’s delightful ceramic tile, and the views of your backyard oasis. The outstanding, open layout from the kitchen, dining, and living room will be the living space you’ve been searching for. Not to mention, the proximity to all of your activity needs and wants, have endless potential and will blow your mind with this marvelous Mililani home.
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[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,Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[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] => KWPP
)
[ListAgentEmail] => Array
(
[0] => joe@oteamhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 596-2888
)
[ListAgentFullName] => Array
(
[0] => Joe Extra Ordinario
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-24T12:22:49.457
)
[Matrix_Unique_ID] => Array
(
[0] => 18064799
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-20T09:42:01.383
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26627713
)
[listing_image] => Array
(
[0] => 26627713
[1] => 26627714
[2] => 26627715
[3] => 26627716
[4] => 26627717
[5] => 26627718
[6] => 26627719
[7] => 26627720
[8] => 26627721
[9] => 26627722
[10] => 26627723
[11] => 26627724
[12] => 26627725
[13] => 26627726
[14] => 26627727
[15] => 26627728
[16] => 26627729
[17] => 26627730
[18] => 26627731
[19] => 26627732
[20] => 26627733
[21] => 26627734
[22] => 26627735
[23] => 26627736
[24] => 26627737
[25] => 26627738
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 170,145
- Living (sf): 896
- Year Built: 1973
- Building Name: Northbrook-Melemanu
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 1
- View: Garden
- Listing Office: Keller Williams Honolulu
- Maintenance Fees: $782
- Land Tenure: FS - Fee Simple
