Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
Price: $1,750,000 Area: WAIPIO ACRES/WAIKALANI WOODLANDS Status: Active
Step into a world of opportunity with this expansive property, offering a flexible 2-story living space designed for multi-generational families, home-based businesses—all while enjoying the comfort of living onsite. 1st floor: 1) Private-entry studio with bar sink, full bath, and closet—ideal for guests, rental income, or a personal retreat 2) Private-entry spacious 1-bedroom/1-bath suite with bar sink, family room, closet, and patio—perfect for extended family or a home office. Oversized garage with abundant shelving for storage and hobbies. 2nd floor sanctuary: 3-bdrms, 2-bths, primary suite, open living room, and a modern kitchen—tailored for comfort and connection. Outdoor Oasis: 1) Entertain effortlessly in a beautifully landscaped yard with programmable sprinklers and drip irrigation. 2) Enjoy tranquil moments by the waterfall and fishpond, surrounded by lush potted plants. 3) Ample driveway with 7-car stalls and multiple storage spaces for all your tools and treasures. Gardener’s Paradise: 3-level terraced lot with thriving red and brown lychee trees, papaya varieties, and a flourishing vegetable garden—all on efficient drip irrigation. Listing by: OahuRE.com (808) 425-7887
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202527889"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "95-152"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Waimakua"
}
["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(92) "https://oahurealestatevirtualtours.net/SellYourHome.php?MLSNumber=202527889&PropertyType=RES"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1750000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1174) "Step into a world of opportunity with this expansive property, offering a flexible 2-story living space designed for multi-generational families, home-based businesses—all while enjoying the comfort of living onsite. 1st floor: 1) Private-entry studio with bar sink, full bath, and closet—ideal for guests, rental income, or a personal retreat 2) Private-entry spacious 1-bedroom/1-bath suite with bar sink, family room, closet, and patio—perfect for extended family or a home office. Oversized garage with abundant shelving for storage and hobbies. 2nd floor sanctuary: 3-bdrms, 2-bths, primary suite, open living room, and a modern kitchen—tailored for comfort and connection. Outdoor Oasis: 1) Entertain effortlessly in a beautifully landscaped yard with programmable sprinklers and drip irrigation. 2) Enjoy tranquil moments by the waterfall and fishpond, surrounded by lush potted plants. 3) Ample driveway with 7-car stalls and multiple storage spaces for all your tools and treasures. Gardener’s Paradise: 3-level terraced lot with thriving red and brown lychee trees, papaya varieties, and a flourishing vegetable garden—all on efficient drip irrigation."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "OahuRE.com"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10012.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2669"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2012"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "GIVE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(15) "bryn@oahure.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 425-7887"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Bryn W Kaufman"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19170199"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-19T11:14:07.190"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-12-19"
}
["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) "11:14:07.190"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27250133"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27250133"
[1]=>
string(8) "27250134"
[2]=>
string(8) "27250135"
[3]=>
string(8) "27250136"
[4]=>
string(8) "27250137"
[5]=>
string(8) "27250138"
[6]=>
string(8) "27250139"
[7]=>
string(8) "27250140"
[8]=>
string(8) "27250141"
[9]=>
string(8) "27250142"
[10]=>
string(8) "27250143"
[11]=>
string(8) "27250144"
[12]=>
string(8) "27250145"
[13]=>
string(8) "27250146"
[14]=>
string(8) "27250147"
[15]=>
string(8) "27250148"
[16]=>
string(8) "27250149"
[17]=>
string(8) "27250150"
[18]=>
string(8) "27250151"
[19]=>
string(8) "27250152"
[20]=>
string(8) "27250153"
[21]=>
string(8) "27250154"
[22]=>
string(8) "27250155"
[23]=>
string(8) "27250156"
[24]=>
string(8) "27250157"
[25]=>
string(8) "27250158"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202527889
)
[StreetNumber] => Array
(
[0] => 95-152
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waimakua
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://oahurealestatevirtualtours.net/SellYourHome.php?MLSNumber=202527889&PropertyType=RES
)
[ListPrice] => Array
(
[0] => 1750000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Step into a world of opportunity with this expansive property, offering a flexible 2-story living space designed for multi-generational families, home-based businesses—all while enjoying the comfort of living onsite. 1st floor: 1) Private-entry studio with bar sink, full bath, and closet—ideal for guests, rental income, or a personal retreat 2) Private-entry spacious 1-bedroom/1-bath suite with bar sink, family room, closet, and patio—perfect for extended family or a home office. Oversized garage with abundant shelving for storage and hobbies. 2nd floor sanctuary: 3-bdrms, 2-bths, primary suite, open living room, and a modern kitchen—tailored for comfort and connection. Outdoor Oasis: 1) Entertain effortlessly in a beautifully landscaped yard with programmable sprinklers and drip irrigation. 2) Enjoy tranquil moments by the waterfall and fishpond, surrounded by lush potted plants. 3) Ample driveway with 7-car stalls and multiple storage spaces for all your tools and treasures. Gardener’s Paradise: 3-level terraced lot with thriving red and brown lychee trees, papaya varieties, and a flourishing vegetable garden—all on efficient drip irrigation.
)
[ListOfficeName] => Array
(
[0] => OahuRE.com
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 5
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 10012.00
)
[SqftTotal] => Array
(
[0] => 2669
)
[YearBuilt] => Array
(
[0] => 2012
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kipapa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Mililani
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => GIVE
)
[ListAgentEmail] => Array
(
[0] => bryn@oahure.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 425-7887
)
[ListAgentFullName] => Array
(
[0] => Bryn W Kaufman
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19170199
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-19T11:14:07.190
)
[ListingContractDate] => Array
(
[0] => 2025-12-19
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:14:07.190
)
[_thumbnail_id] => Array
(
[0] => 27250133
)
[listing_image] => Array
(
[0] => 27250133
[1] => 27250134
[2] => 27250135
[3] => 27250136
[4] => 27250137
[5] => 27250138
[6] => 27250139
[7] => 27250140
[8] => 27250141
[9] => 27250142
[10] => 27250143
[11] => 27250144
[12] => 27250145
[13] => 27250146
[14] => 27250147
[15] => 27250148
[16] => 27250149
[17] => 27250150
[18] => 27250151
[19] => 27250152
[20] => 27250153
[21] => 27250154
[22] => 27250155
[23] => 27250156
[24] => 27250157
[25] => 27250158
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 19, 2025 - 11:14 AM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
