95-156 Waikalani Drive Mililani, HI 96789
Listing
Overview
Price: $900,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active Under Contract
Discover the hidden gem awaiting your personal touch at this spacious fixer-upper nestled within the coveted gated community of Melemanu in Mililani. Boasting over 2000 square feet of living space on a sprawling 1-acre lot, this property offers boundless potential for customization and transformation. With two generous living rooms, a separate office, and a picturesque backdrop of lush trees providing ample backyard privacy, envision the opportunity to craft your dream retreat. Conveniently situated near premier shopping, golf courses, and entertainment options, seize the chance to unlock the possibilities of this highly desired locale Listing by: Soldier To Soldier HI Realty (808) 312-7884
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202411106"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "95-156"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Waikalani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "900000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "900000.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(643) "Discover the hidden gem awaiting your personal touch at this spacious fixer-upper nestled within the coveted gated community of Melemanu in Mililani. Boasting over 2000 square feet of living space on a sprawling 1-acre lot, this property offers boundless potential for customization and transformation. With two generous living rooms, a separate office, and a picturesque backdrop of lush trees providing ample backyard privacy, envision the opportunity to craft your dream retreat. Conveniently situated near premier shopping, golf courses, and entertainment options, seize the chance to unlock the possibilities of this highly desired locale"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(28) "Soldier To Soldier HI Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "44213.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2061"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1969"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(4) "Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["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) "STSH"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "celester.thomas@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 312-7884"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Celester Thomas"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-14T11:57:04.993"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18001499"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-12T09:53:45.163"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(10) "Short Sale"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26200136"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26200136"
[1]=>
string(8) "26200137"
[2]=>
string(8) "26200138"
[3]=>
string(8) "26200139"
[4]=>
string(8) "26200140"
[5]=>
string(8) "26200141"
[6]=>
string(8) "26200142"
[7]=>
string(8) "26200143"
[8]=>
string(8) "26200144"
[9]=>
string(8) "26200145"
[10]=>
string(8) "26200146"
[11]=>
string(8) "26200147"
[12]=>
string(8) "26200148"
[13]=>
string(8) "26200149"
[14]=>
string(8) "26200150"
[15]=>
string(8) "26200151"
[16]=>
string(8) "26200152"
[17]=>
string(8) "26200153"
[18]=>
string(8) "26200154"
[19]=>
string(8) "26200155"
[20]=>
string(8) "26200156"
[21]=>
string(8) "26200157"
[22]=>
string(8) "26200158"
[23]=>
string(8) "26200159"
[24]=>
string(8) "26200160"
[25]=>
string(8) "26200161"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202411106
)
[StreetNumber] => Array
(
[0] => 95-156
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 900000.00
)
[CurrentPrice] => Array
(
[0] => 900000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Discover the hidden gem awaiting your personal touch at this spacious fixer-upper nestled within the coveted gated community of Melemanu in Mililani. Boasting over 2000 square feet of living space on a sprawling 1-acre lot, this property offers boundless potential for customization and transformation. With two generous living rooms, a separate office, and a picturesque backdrop of lush trees providing ample backyard privacy, envision the opportunity to craft your dream retreat. Conveniently situated near premier shopping, golf courses, and entertainment options, seize the chance to unlock the possibilities of this highly desired locale
)
[ListOfficeName] => Array
(
[0] => Soldier To Soldier HI Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 44213.00
)
[SqftTotal] => Array
(
[0] => 2061
)
[YearBuilt] => Array
(
[0] => 1969
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Fair
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => STSH
)
[ListAgentEmail] => Array
(
[0] => celester.thomas@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 312-7884
)
[ListAgentFullName] => Array
(
[0] => Celester Thomas
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-14T11:57:04.993
)
[Matrix_Unique_ID] => Array
(
[0] => 18001499
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-12T09:53:45.163
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => Short Sale
)
[_thumbnail_id] => Array
(
[0] => 26200136
)
[listing_image] => Array
(
[0] => 26200136
[1] => 26200137
[2] => 26200138
[3] => 26200139
[4] => 26200140
[5] => 26200141
[6] => 26200142
[7] => 26200143
[8] => 26200144
[9] => 26200145
[10] => 26200146
[11] => 26200147
[12] => 26200148
[13] => 26200149
[14] => 26200150
[15] => 26200151
[16] => 26200152
[17] => 26200153
[18] => 26200154
[19] => 26200155
[20] => 26200156
[21] => 26200157
[22] => 26200158
[23] => 26200159
[24] => 26200160
[25] => 26200161
)
)
- BedsTotal: 3
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 44,213
- Living (sf): 2,061
- Year Built: 1969
- Property Condition: Fair
- Number of Parking Spaces: 4
- View: None
- Listing Office: Soldier To Soldier HI Realty
- Land Tenure: FS - Fee Simple
