Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
95-156 Waikalani Drive Mililani, HI 96789
Listing
Price: $900,000Area: WAIPIO ACRES/WAIKALANI WOODLANDSStatus: 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: 3Full Baths: 2Half Baths: 1Land Area (sf): 44,213 sfLiving (sf): 2,061Year Built: 1969
Property Condition: FairNumber of Parking Spaces: 4View: NoneListing Office: Soldier To Soldier HI Realty
Land Tenure: FS - Fee Simple
