Price: $285,000 Area: WAIPIO ACRES/WAIKALANI WOODLANDS Status: Active
Seller now offering a 2:1 rate Buydown at no cost to the Buyer!! This desirable corner unit, G207, offers added privacy and natural light with a comfortable, functional layout. The bright living area flows seamlessly to a private lanai—perfect for relaxing or entertaining while enjoying cool island breezes. The kitchen is efficiently designed with ample storage, and the bedroom provides a peaceful retreat with great light and closet space.
Ideally situated within the community, this unit is just moments from the park and community pool, making it easy to enjoy outdoor recreation and leisure. Enjoy the convenience of covered parking located close to the unit for easy access. Conveniently located near Mililani Town, you’ll have quick access to shopping, dining, and everyday essentials, along with close proximity to Schofield Barracks and Wheeler Army Airfield. Enjoy weekend getaways with approximately a 15-minute drive to Haleiwa and the world-famous North Shore Oahu.
A fantastic opportunity for first-time buyers, investors, or those looking to enjoy the convenience and charm of Central Oahu living. One or more photos have been enhanced. Listing by: Redfin Corporation (808) 276-9186
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202605540"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "95-045"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Waikalani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "G207"
}
["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=abhVVwn1YeV&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "285000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1165) "Seller now offering a 2:1 rate Buydown at no cost to the Buyer!! This desirable corner unit, G207, offers added privacy and natural light with a comfortable, functional layout. The bright living area flows seamlessly to a private lanai—perfect for relaxing or entertaining while enjoying cool island breezes. The kitchen is efficiently designed with ample storage, and the bedroom provides a peaceful retreat with great light and closet space.
Ideally situated within the community, this unit is just moments from the park and community pool, making it easy to enjoy outdoor recreation and leisure. Enjoy the convenience of covered parking located close to the unit for easy access. Conveniently located near Mililani Town, you’ll have quick access to shopping, dining, and everyday essentials, along with close proximity to Schofield Barracks and Wheeler Army Airfield. Enjoy weekend getaways with approximately a 15-minute drive to Haleiwa and the world-famous North Shore Oahu.
A fantastic opportunity for first-time buyers, investors, or those looking to enjoy the convenience and charm of Central Oahu living. One or more photos have been enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["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) "182124.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "896"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(21) "Cathedral Pt-Melemanu"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1174.36"
}
["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) "RFIN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "gene.neal@redfin.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 276-9186"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(9) "Gene Neal"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19333694"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-08-21T09:24:13.513"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-03-26"
}
["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) "09:24:13.513"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27342679"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27342679"
[1]=>
string(8) "27342680"
[2]=>
string(8) "27342681"
[3]=>
string(8) "27342682"
[4]=>
string(8) "27342683"
[5]=>
string(8) "27342684"
[6]=>
string(8) "27342685"
[7]=>
string(8) "27342686"
[8]=>
string(8) "27342687"
[9]=>
string(8) "27342688"
[10]=>
string(8) "27342689"
[11]=>
string(8) "27342690"
[12]=>
string(8) "27342691"
[13]=>
string(8) "27342692"
[14]=>
string(8) "27342693"
[15]=>
string(8) "27342694"
[16]=>
string(8) "27342695"
[17]=>
string(8) "27342696"
[18]=>
string(8) "27342697"
[19]=>
string(8) "27342698"
[20]=>
string(8) "27342699"
[21]=>
string(8) "27342700"
[22]=>
string(8) "27342701"
[23]=>
string(8) "27342702"
[24]=>
string(8) "27342703"
[25]=>
string(8) "27342704"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202605540
)
[StreetNumber] => Array
(
[0] => 95-045
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] => G207
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=abhVVwn1YeV&mls=1
)
[ListPrice] => Array
(
[0] => 285000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Seller now offering a 2:1 rate Buydown at no cost to the Buyer!! This desirable corner unit, G207, offers added privacy and natural light with a comfortable, functional layout. The bright living area flows seamlessly to a private lanai—perfect for relaxing or entertaining while enjoying cool island breezes. The kitchen is efficiently designed with ample storage, and the bedroom provides a peaceful retreat with great light and closet space.
Ideally situated within the community, this unit is just moments from the park and community pool, making it easy to enjoy outdoor recreation and leisure. Enjoy the convenience of covered parking located close to the unit for easy access. Conveniently located near Mililani Town, you’ll have quick access to shopping, dining, and everyday essentials, along with close proximity to Schofield Barracks and Wheeler Army Airfield. Enjoy weekend getaways with approximately a 15-minute drive to Haleiwa and the world-famous North Shore Oahu.
A fantastic opportunity for first-time buyers, investors, or those looking to enjoy the convenience and charm of Central Oahu living. One or more photos have been enhanced.
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 182124.00
)
[SqftTotal] => Array
(
[0] => 896
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Cathedral Pt-Melemanu
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] => 1174.36
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RFIN
)
[ListAgentEmail] => Array
(
[0] => gene.neal@redfin.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 276-9186
)
[ListAgentFullName] => Array
(
[0] => Gene Neal
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19333694
)
[MatrixModifiedDT] => Array
(
[0] => 2026-08-21T09:24:13.513
)
[ListingContractDate] => Array
(
[0] => 2026-03-26
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 09:24:13.513
)
[_thumbnail_id] => Array
(
[0] => 27342679
)
[listing_image] => Array
(
[0] => 27342679
[1] => 27342680
[2] => 27342681
[3] => 27342682
[4] => 27342683
[5] => 27342684
[6] => 27342685
[7] => 27342686
[8] => 27342687
[9] => 27342688
[10] => 27342689
[11] => 27342690
[12] => 27342691
[13] => 27342692
[14] => 27342693
[15] => 27342694
[16] => 27342695
[17] => 27342696
[18] => 27342697
[19] => 27342698
[20] => 27342699
[21] => 27342700
[22] => 27342701
[23] => 27342702
[24] => 27342703
[25] => 27342704
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 21, 2026 - 9:24 AM
Information is deemed reliable but not guaranteed.
Copyright: 2026 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.
