Listing
Overview
Price: $410,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
Welcome to this charming 2-bedroom, 1-bathroom apartment in a quiet and peaceful neighborhood! This well-maintained unit comes with one assigned parking stall and offers a comfortable layout with natural light throughout. Amenities, include a sparkling swimming pool, BBQ area, and a nearby park—perfect for relaxation and entertaining. With plenty of street parking for guests, convenience is at your doorstep. Located near shopping, dining, and easy freeway access, this home is ideal for first-time buyers or investors. Don’t miss this opportunity—schedule your showing today! A few photos have been virtually staged/enhanced (items removed virtually). Listing by: BHGRE Advantage Realty (808) 738-3600
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202503340"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "95-020"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Waihonu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "C505"
}
["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(59) "https://listings.hetproductions.com/sites/gelkwjz/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "410000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(663) "Welcome to this charming 2-bedroom, 1-bathroom apartment in a quiet and peaceful neighborhood! This well-maintained unit comes with one assigned parking stall and offers a comfortable layout with natural light throughout. Amenities, include a sparkling swimming pool, BBQ area, and a nearby park—perfect for relaxation and entertaining. With plenty of street parking for guests, convenience is at your doorstep. Located near shopping, dining, and easy freeway access, this home is ideal for first-time buyers or investors. Don’t miss this opportunity—schedule your showing today! A few photos have been virtually staged/enhanced (items removed virtually)."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["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(0) ""
}
["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(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "767.00"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "KarenL@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Karen C Lar Rieu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18528533"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-22T17:00:01.350"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-02-18"
}
["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) "17:00:01.350"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26886873"
}
["listing_image"]=>
array(18) {
[0]=>
string(8) "26886873"
[1]=>
string(8) "26886874"
[2]=>
string(8) "26886875"
[3]=>
string(8) "26886876"
[4]=>
string(8) "26886877"
[5]=>
string(8) "26886878"
[6]=>
string(8) "26886879"
[7]=>
string(8) "26886880"
[8]=>
string(8) "26886881"
[9]=>
string(8) "26886882"
[10]=>
string(8) "26886883"
[11]=>
string(8) "26886884"
[12]=>
string(8) "26886885"
[13]=>
string(8) "26886886"
[14]=>
string(8) "26886887"
[15]=>
string(8) "26886888"
[16]=>
string(8) "26886889"
[17]=>
string(8) "26886890"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202503340
)
[StreetNumber] => Array
(
[0] => 95-020
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waihonu
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => C505
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/gelkwjz/unbranded
)
[ListPrice] => Array
(
[0] => 410000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to this charming 2-bedroom, 1-bathroom apartment in a quiet and peaceful neighborhood! This well-maintained unit comes with one assigned parking stall and offers a comfortable layout with natural light throughout. Amenities, include a sparkling swimming pool, BBQ area, and a nearby park—perfect for relaxation and entertaining. With plenty of street parking for guests, convenience is at your doorstep. Located near shopping, dining, and easy freeway access, this home is ideal for first-time buyers or investors. Don’t miss this opportunity—schedule your showing today! A few photos have been virtually staged/enhanced (items removed virtually).
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[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] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 767.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kipapa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Mililani
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => KarenL@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3600
)
[ListAgentFullName] => Array
(
[0] => Karen C Lar Rieu
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18528533
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-22T17:00:01.350
)
[ListingContractDate] => Array
(
[0] => 2025-02-18
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.350
)
[_thumbnail_id] => Array
(
[0] => 26886873
)
[listing_image] => Array
(
[0] => 26886873
[1] => 26886874
[2] => 26886875
[3] => 26886876
[4] => 26886877
[5] => 26886878
[6] => 26886879
[7] => 26886880
[8] => 26886881
[9] => 26886882
[10] => 26886883
[11] => 26886884
[12] => 26886885
[13] => 26886886
[14] => 26886887
[15] => 26886888
[16] => 26886889
[17] => 26886890
)
)
- BedsTotal: 2
- Full Baths: 1
- Living (sf): 896
- Year Built: 1973
- Building Name: Cathedral Pt-Melemanu
- Property Condition: Above Average
- Number of Parking Spaces: 1
- View: Mountain
- Listing Office: BHGRE Advantage Realty
- Maintenance Fees: $767
- Land Tenure: FS - Fee Simple
- Elementary School: Kipapa
- Middle School: Mililani
- High School: Mililani
