Listing
Overview
Price: $422,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
This beautifully upgraded condo offers exceptional privacy, quiet, and quality. Positioned at the rear of the complex, away from traffic and common areas, Building B at Valleyview overlooks open green space and soaring Rainbow Eucalyptus canopy — a setting known to command a consistent market premium. Seldom available ground floor unit with peaceful views from two private, gated, lanais. Solid concrete construction and top-of-valley position cooled by trade winds create a naturally calm environment. Thoughtfully upgraded - smoothed concrete walls, fresh paint, updated plumbing and electrical, remodeled kitchen with Staron countertops, solid wood cabinetry, and built-in office. Structural and lasting improvements, not cosmetic gestures. Additional features include: an in-unit W/D, 2 BOD approved ACs, dedicated storage shed, 2 covered parking, and ample guest parking. It’s very PET friendly with a huge pool, BBQ areas, and is just up the hill from Melemanu park with a playground, basketball, and ball fields. Easy access to Costco, Walmart, restaurants, Mililani Town Center for shopping, Schofield/Wheeler, and North Shore. Make your appointment today, you will not be disappointed. Listing by: American Dream Realty LLC (808) 258-2436
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202607058"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "95-2055"
}
["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) "B105"
}
["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(41) "https://www.youtube.com/embed/of1lHN-pGCI"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "422000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "This beautifully upgraded condo offers exceptional privacy, quiet, and quality. Positioned at the rear of the complex, away from traffic and common areas, Building B at Valleyview overlooks open green space and soaring Rainbow Eucalyptus canopy — a setting known to command a consistent market premium. Seldom available ground floor unit with peaceful views from two private, gated, lanais. Solid concrete construction and top-of-valley position cooled by trade winds create a naturally calm environment. Thoughtfully upgraded - smoothed concrete walls, fresh paint, updated plumbing and electrical, remodeled kitchen with Staron countertops, solid wood cabinetry, and built-in office. Structural and lasting improvements, not cosmetic gestures. Additional features include: an in-unit W/D, 2 BOD approved ACs, dedicated storage shed, 2 covered parking, and ample guest parking. It’s very PET friendly with a huge pool, BBQ areas, and is just up the hill from Melemanu park with a playground, basketball, and ball fields. Easy access to Costco, Walmart, restaurants, Mililani Town Center for shopping, Schofield/Wheeler, and North Shore. Make your appointment today, you will not be disappointed."
}
["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(4) "1055"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "Valleyview Melemanu"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "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) "19375742"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-05-30T15:00:01.617"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-04-07"
}
["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) "15:00:01.617"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27353301"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27353301"
[1]=>
string(8) "27353302"
[2]=>
string(8) "27353303"
[3]=>
string(8) "27353304"
[4]=>
string(8) "27353305"
[5]=>
string(8) "27353306"
[6]=>
string(8) "27353307"
[7]=>
string(8) "27353308"
[8]=>
string(8) "27353309"
[9]=>
string(8) "27353310"
[10]=>
string(8) "27353311"
[11]=>
string(8) "27353312"
[12]=>
string(8) "27353313"
[13]=>
string(8) "27353314"
[14]=>
string(8) "27353315"
[15]=>
string(8) "27353316"
[16]=>
string(8) "27353317"
[17]=>
string(8) "27353318"
[18]=>
string(8) "27353319"
[19]=>
string(8) "27353320"
[20]=>
string(8) "27353321"
[21]=>
string(8) "27353322"
[22]=>
string(8) "27353323"
[23]=>
string(8) "27353324"
[24]=>
string(8) "27353325"
[25]=>
string(8) "27353326"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202607058
)
[StreetNumber] => Array
(
[0] => 95-2055
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => B105
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/of1lHN-pGCI
)
[ListPrice] => Array
(
[0] => 422000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This beautifully upgraded condo offers exceptional privacy, quiet, and quality. Positioned at the rear of the complex, away from traffic and common areas, Building B at Valleyview overlooks open green space and soaring Rainbow Eucalyptus canopy — a setting known to command a consistent market premium. Seldom available ground floor unit with peaceful views from two private, gated, lanais. Solid concrete construction and top-of-valley position cooled by trade winds create a naturally calm environment. Thoughtfully upgraded - smoothed concrete walls, fresh paint, updated plumbing and electrical, remodeled kitchen with Staron countertops, solid wood cabinetry, and built-in office. Structural and lasting improvements, not cosmetic gestures. Additional features include: an in-unit W/D, 2 BOD approved ACs, dedicated storage shed, 2 covered parking, and ample guest parking. It’s very PET friendly with a huge pool, BBQ areas, and is just up the hill from Melemanu park with a playground, basketball, and ball fields. Easy access to Costco, Walmart, restaurants, Mililani Town Center for shopping, Schofield/Wheeler, and North Shore. Make your appointment today, you will not be disappointed.
)
[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] => 1055
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Valleyview Melemanu
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 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] => 19375742
)
[MatrixModifiedDT] => Array
(
[0] => 2026-05-30T15:00:01.617
)
[ListingContractDate] => Array
(
[0] => 2026-04-07
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 15:00:01.617
)
[_thumbnail_id] => Array
(
[0] => 27353301
)
[listing_image] => Array
(
[0] => 27353301
[1] => 27353302
[2] => 27353303
[3] => 27353304
[4] => 27353305
[5] => 27353306
[6] => 27353307
[7] => 27353308
[8] => 27353309
[9] => 27353310
[10] => 27353311
[11] => 27353312
[12] => 27353313
[13] => 27353314
[14] => 27353315
[15] => 27353316
[16] => 27353317
[17] => 27353318
[18] => 27353319
[19] => 27353320
[20] => 27353321
[21] => 27353322
[22] => 27353323
[23] => 27353324
[24] => 27353325
[25] => 27353326
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 175,024 sf
- Living (sf): 1,055
- Year Built: 1973
- Building Name: Valleyview Melemanu
- Property Condition: Excellent
- Number of Parking Spaces: 2
- 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 30, 2026 - 3: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.