Listing
Overview
Price: $390,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
Welcome to Mililani and the quiet enclave of Valleyview Melemanu. This 2-bedroom unit is “move in ready” and has a 2.25% assumable VA loan. It has a fully renovated and thoughtfully designed kitchen that features granite countertops, custom Thompsonville wood cabinets, extended countertops, an oversized stainless-steel sink, custom subway tile backsplash, an extraordinary amount of storage space, and new/newer appliances. NO stairs or elevators; your garage parking stall is on the same level as the unit, you can walk right in. Additional features include a full-size washer and dryer, ceramic tile flooring throughout, ceiling fans in every room, private lanai, and A/C in the primary bedroom. Valleyview is a very pet friendly complex that allows up to 2 pets with no size restrictions and has low monthly maintenance fees, a huge community association pool, and a covered BBQ/picnic area. You will love living near Melemanu Park with endless green space, ball courts, and playgrounds. This is your chance to live in Mililani, one of the most affordable and safest neighborhoods and also in one of the highest rated school districts on Oahu. Make your appointment anytime, it’s easy to see. Listing by: American Dream Realty LLC (808) 258-2436
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202609011"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "95-2043"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Waikalani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "A205"
}
["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(50) "https://hommati.tours/tour/2618102?play=no&mls=yes"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "390000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1204) "Welcome to Mililani and the quiet enclave of Valleyview Melemanu. This 2-bedroom unit is “move in ready” and has a 2.25% assumable VA loan. It has a fully renovated and thoughtfully designed kitchen that features granite countertops, custom Thompsonville wood cabinets, extended countertops, an oversized stainless-steel sink, custom subway tile backsplash, an extraordinary amount of storage space, and new/newer appliances. NO stairs or elevators; your garage parking stall is on the same level as the unit, you can walk right in. Additional features include a full-size washer and dryer, ceramic tile flooring throughout, ceiling fans in every room, private lanai, and A/C in the primary bedroom. Valleyview is a very pet friendly complex that allows up to 2 pets with no size restrictions and has low monthly maintenance fees, a huge community association pool, and a covered BBQ/picnic area. You will love living near Melemanu Park with endless green space, ball courts, and playgrounds. This is your chance to live in Mililani, one of the most affordable and safest neighborhoods and also in one of the highest rated school districts on Oahu. Make your appointment anytime, it’s easy to see."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(25) "American Dream Realty LLC"
}
["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) "175024.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "896"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "Valleyview Melemanu"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(7) "One,4-7"
}
["View"]=>
array(1) {
[0]=>
string(15) "Garden,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "831.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) "ADRL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "gregstudt@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 258-2436"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Gregory D Studt"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19435109"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-05-24T17:00:02.360"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-05-06"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:02.360"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27384377"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27384377"
[1]=>
string(8) "27384378"
[2]=>
string(8) "27384379"
[3]=>
string(8) "27384380"
[4]=>
string(8) "27384381"
[5]=>
string(8) "27384382"
[6]=>
string(8) "27384383"
[7]=>
string(8) "27384384"
[8]=>
string(8) "27384385"
[9]=>
string(8) "27384386"
[10]=>
string(8) "27384387"
[11]=>
string(8) "27384388"
[12]=>
string(8) "27384389"
[13]=>
string(8) "27384390"
[14]=>
string(8) "27384391"
[15]=>
string(8) "27384392"
[16]=>
string(8) "27384393"
[17]=>
string(8) "27384394"
[18]=>
string(8) "27384395"
[19]=>
string(8) "27384396"
[20]=>
string(8) "27384397"
[21]=>
string(8) "27384398"
[22]=>
string(8) "27384399"
[23]=>
string(8) "27384400"
[24]=>
string(8) "27384401"
[25]=>
string(8) "27384402"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202609011
)
[StreetNumber] => Array
(
[0] => 95-2043
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => A205
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://hommati.tours/tour/2618102?play=no&mls=yes
)
[ListPrice] => Array
(
[0] => 390000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to Mililani and the quiet enclave of Valleyview Melemanu. This 2-bedroom unit is “move in ready” and has a 2.25% assumable VA loan. It has a fully renovated and thoughtfully designed kitchen that features granite countertops, custom Thompsonville wood cabinets, extended countertops, an oversized stainless-steel sink, custom subway tile backsplash, an extraordinary amount of storage space, and new/newer appliances. NO stairs or elevators; your garage parking stall is on the same level as the unit, you can walk right in. Additional features include a full-size washer and dryer, ceramic tile flooring throughout, ceiling fans in every room, private lanai, and A/C in the primary bedroom. Valleyview is a very pet friendly complex that allows up to 2 pets with no size restrictions and has low monthly maintenance fees, a huge community association pool, and a covered BBQ/picnic area. You will love living near Melemanu Park with endless green space, ball courts, and playgrounds. This is your chance to live in Mililani, one of the most affordable and safest neighborhoods and also in one of the highest rated school districts on Oahu. Make your appointment anytime, it’s easy to see.
)
[ListOfficeName] => Array
(
[0] => American Dream Realty LLC
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 175024.00
)
[SqftTotal] => Array
(
[0] => 896
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Valleyview Melemanu
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One,4-7
)
[View] => Array
(
[0] => Garden,Mountain
)
[MaintenanceExpense] => Array
(
[0] => 831.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kipapa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Mililani
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => ADRL
)
[ListAgentEmail] => Array
(
[0] => gregstudt@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 258-2436
)
[ListAgentFullName] => Array
(
[0] => Gregory D Studt
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19435109
)
[MatrixModifiedDT] => Array
(
[0] => 2026-05-24T17:00:02.360
)
[ListingContractDate] => Array
(
[0] => 2026-05-06
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:02.360
)
[_thumbnail_id] => Array
(
[0] => 27384377
)
[listing_image] => Array
(
[0] => 27384377
[1] => 27384378
[2] => 27384379
[3] => 27384380
[4] => 27384381
[5] => 27384382
[6] => 27384383
[7] => 27384384
[8] => 27384385
[9] => 27384386
[10] => 27384387
[11] => 27384388
[12] => 27384389
[13] => 27384390
[14] => 27384391
[15] => 27384392
[16] => 27384393
[17] => 27384394
[18] => 27384395
[19] => 27384396
[20] => 27384397
[21] => 27384398
[22] => 27384399
[23] => 27384400
[24] => 27384401
[25] => 27384402
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 175,024 sf
- Living (sf): 896
- Year Built: 1973
- Building Name: Valleyview Melemanu
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 1
- View: Garden,Mountain
- Listing Office: American Dream Realty LLC
- Maintenance Fees: $831
- Land Tenure: FS - Fee Simple
- Elementary School: Kipapa
- Middle School: Mililani
- High School: Mililani
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on May 24, 2026 - 5:00 PM
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.
© Marcus Realty. All Rights Reserved.
