Hawaii Living

Northbrook Melemanu #A404 (Waipio Acres)

1 / 25
Photo 1 of 95-2027 Waikalani Pl #A404, Mililani
Photo 2 of 95-2027 Waikalani Pl #A404, Mililani
Photo 3 of 95-2027 Waikalani Pl #A404, Mililani

95-2027 Waikalani Pl #A404, Mililani

Request Info / Schedule Showing
Call/Text Michelle (808) 352-2469 or send a message using the form below.
We are expert real estate agents who know Northbrook Melemanu very well and have sold many condos in Waipio Acres. We would be happy to assist you too.
Description
**HUGE PRICE REDUCTION** Stunningly Remodeled in 2023, Top-Floor, Corner Unit, No Stairs or Elevator Needed! Welcome to this three-bedroom, two-bathroom corner unit, with two assigned parking stalls. This home has been upgraded with high-end finishes, offering the perfect blend of style, comfort, & functionality. As you enter, you'll be greeted by the sleek stainless steel appliances & quartz countertops in the kitchen. The under-mount sinks & premium hardware throughout the kitchen & bathrooms highlight the meticulous attention to detail that went into the renovation. The spacious bedrooms feature ample closet space for easy organization, while the bathrooms exude luxury with a walk-in shower in the primary bath & sophisticated finishes. For added convenience, this unit comes with an in-unit washer/dryer, making daily chores a breeze. Step outside to enjoy not one, but two separate lanais perfect for sipping your morning coffee as you listen to the peaceful stream below, or unwinding with a glass of wine while surrounded by natures tranquility. This meticulously designed unit is a true gem. Don't miss the opportunity to call it your new home!
Recent Activity
  • Oct 06, 2025 Price $505,000
  • Aug 13, 2025 Listed at $535,000
  • Aug 13, 2025 Off Market
  • May 13, 2025 Back to Active
  • Apr 18, 2025 Under Contract
  • Mar 19, 2025 Listed at $535,000
  • May 19, 2023 Sold for $505,000
  • Apr 20, 2023 Under Contract
  • Apr 17, 2023 Listed at $499,000
Recent Sales
(Northbrook Melemanu)
  • #D306: 2 Bds | 1 Ba @ $410K (11/17/25)
  • #C403: 2 Bds | 1 Ba @ $410K (11/13/25)
  • #A103: 3 Bds | 2 Ba @ $504K (11/6/25)
  • #B407: 2 Bds | 1 Ba @ $383K (6/27/25)
  • #D404: 1 Bd | 1 Ba @ $297K (6/10/25)
  • #D904: 1 Bd | 1 Ba @ $352K (3/14/25)
  • #B306: 2 Bds | 1 Ba @ $451K (12/6/24)
  • #B102: 2 Bds | 1 Ba @ $450K (10/28/24)
  • #B203: 2 Bds | 1 Ba @ $410K (10/16/24)
  • #D405: 2 Bds | 1 Ba @ $415K (10/10/24)
  • #1006: 2 Bds | 1 Ba @ $450K (8/9/24)
  • #D506: 2 Bds | 1 Ba @ $400K (5/6/24)
  • #C301: 2 Bds | 1 Ba @ $430K (4/26/24)
  • #B101: 1 Bd | 1 Ba @ $355K (4/9/24)
  • #D104: 1 Bd | 1 Ba @ $369K (4/8/24)
  • #B104: 2 Bds | 1 Ba @ $450K (4/8/24)
  • #D801: 2 Bds | 1 Ba @ $385K (2/22/24)
  • #D605: 2 Bds | 1 Ba @ $415K (12/5/23)
  • #D705: 2 Bds | 1 Ba @ $435K (9/26/23)
  • #A404: 3 Bds | 2 Ba @ $505K (5/19/23)
  • #D501: 2 Bds | 1 Ba @ $422K (5/2/23)
  • #B401: 1 Bd | 1 Ba @ $350K (4/18/23)
  • #D906: 2 Bds | 1 Ba @ $430K (2/16/23)
  • #B303: 2 Bds | 1 Ba @ $410K (9/15/22)
  • #D301: 2 Bds | 1 Ba @ $370K (9/12/22)
  • #D1003: 1 Bd | 1 Ba @ $350K (7/29/22)
  • #D802: 2 Bds | 1 Ba @ $450K (6/8/22)
  • #D902: 2 Bds | 1 Ba @ $380K (4/29/22)
  • #A102: 3 Bds | 2 Ba @ $520K (4/1/22)
  • #D202: 2 Bds | 1 Ba @ $375K (1/6/22)
  • #D402: 2 Bds | 1 Ba @ $362K (12/13/21)
  • #C104: 2 Bds | 1 Ba @ $370K (11/8/21)
  • #A204: 3 Bds | 2 Ba @ $482K (9/16/21)
  • #D103: 1 Bd | 1 Ba @ $260K (7/19/21)
  • #D101: 2 Bds | 1 Ba @ $350K (5/26/21)
  • #D606: 2 Bds | 1 Ba @ $345K (5/7/21)
  • #B103: 2 Bds | 1 Ba @ $335K (2/4/21)
  • #D504: 1 Bd | 1 Ba @ $230K (11/18/20)
  • #C102: 2 Bds | 1 Ba @ $330K (10/29/20)
  • #C203: 2 Bds | 1 Ba @ $270K (10/15/20)
  • #hidden: 2 Bds | 1 Ba @ $340K (10/6/20)
  • #D102: 2 Bds | 1 Ba @ $348K (4/20/20)
  • #D806: 2 Bds | 1 Ba @ $295K (9/23/19)
  • #B307: 2 Bds | 1 Ba @ $279K (5/31/19)
  • #C202: 2 Bds | 1 Ba @ $295K (4/9/19)
  • #D204: 1 Bd | 1 Ba @ $210K (8/27/18)
  • #C201: 2 Bds | 1 Ba @ $300K (8/10/18)
  • #D804: 1 Bd | 1 Ba @ $207K (8/6/18)
  • #B205: 2 Bds | 1 Ba @ $286K (7/13/18)
  • #C405: 2 Bds | 1 Ba @ $310K (7/6/18)
More Details
  • Owner, Tax & Resale History
  • HOA Fees / ft²: $1.27
  • Price / ft²: $490
  • HOA Fees Include: Other Common Expenses, Sewer, Water
  • Year Remodeled: 2023
  • Zoning: 11 - A-1 Low Density Apartment
  • Flood Zone: Zone D
  • View: Garden
  • Furnished: Partial
  • Property Condition: Excellent
  • Owner Occupancy: 54%
  • Management Company: Associa Hawaii
  • Amenities: BBQ, Community Association Pool, Recreation Area
  • TMK: 1-9-5-12-30-16
  • Tax Assessed Land: $163,200
  • Tax Assessed Improvements: $308,400
  • Tax Assessed Total: $471,600
  • Courtesy: Century 21 Island Homes / (808) 888-7513
  • MLS: 202517964
Ask Michelle a Question
The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on December 05, 2025.Information is deemed reliable but not guaranteed.
Other Northbrook Melemanu Listings
$480,000
Northbrook Melemanu #A102
3 Bds | 2 Ba
1,030 ft²
$475,000
Northbrook Melemanu #A301
3 Bds | 2 Ba
1,030 ft²
$439,000
Northbrook Melemanu #B306
2 Bds | 1 Ba
799 ft²
$420,000
Northbrook Melemanu #D401
2 Bds | 1 Ba
799 ft²
Other Waipio Acres Condos
$465,000
Waikalani #D1006
3 Bds | 2 Ba
1,023 ft²
$574,000
Evergreen Terrace #C303
3 Bds | 2 Ba
1,289 ft²
$415,000
Waikalani #D 502
2 Bds | 1 Ba
793 ft²
$620,000
Sixty Parkside #301
3 Bds | 2 Ba
1,212 ft²
$359,999
Waipio Gardens #1C
2 Bds | 1 Ba
682 ft²
$345,000
Waipiolani #D133
2 Bds | 1 Ba
620 ft²
  • Asking Price: $505,000
Description
**HUGE PRICE REDUCTION** Stunningly Remodeled in 2023, Top-Floor, Corner Unit, No Stairs or Elevator Needed! Welcome to this three-bedroom, two-bathroom corner unit, with two assigned parking stalls. This home has been upgraded with high-end finishes, offering the perfect blend of style, comfort, & functionality. As you enter, you'll be greeted by the sleek stainless steel appliances & quartz countertops in the kitchen. The under-mount sinks & premium hardware throughout the kitchen & bathrooms highlight the meticulous attention to detail that went into the renovation. The spacious bedrooms feature ample closet space for easy organization, while the bathrooms exude luxury with a walk-in shower in the primary bath & sophisticated finishes. For added convenience, this unit comes with an in-unit washer/dryer, making daily chores a breeze. Step outside to enjoy not one, but two separate lanais perfect for sipping your morning coffee as you listen to the peaceful stream below, or unwinding with a glass of wine while surrounded by natures tranquility. This meticulously designed unit is a true gem. Don't miss the opportunity to call it your new home!
    The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on December 05, 2025.Information is deemed reliable but not guaranteed.
    • Oct 06, 2025 Price $505,000
    • Aug 13, 2025 Listed at $535,000
    • Aug 13, 2025 Off Market
    • May 13, 2025 Back to Active
    • Apr 18, 2025 Under Contract
    • Mar 19, 2025 Listed at $535,000
    • May 19, 2023 Sold for $505,000
    • Apr 20, 2023 Under Contract
    • Apr 17, 2023 Listed at $499,000
    Other Northbrook Melemanu Listings
    $480,000
    Northbrook Melemanu #A102
    3 Bds | 2 Ba
    1,030 ft²
    $475,000
    Northbrook Melemanu #A301
    3 Bds | 2 Ba
    1,030 ft²
    $439,000
    Northbrook Melemanu #B306
    2 Bds | 1 Ba
    799 ft²
    $420,000
    Northbrook Melemanu #D401
    2 Bds | 1 Ba
    799 ft²
    You do not own the land, but have the right to use the land until an expiration year. At expiration the ownership typically reverts back to the land owner.
    Buyer and Seller have reached an agreement and are under contract. The sale may be subject to one or more contingencies.
    We have handled many transactions for clients who purchase Hawaii real estate without visiting. By request, we can prepare thorough property videos to ensure you are familiar with every detail necessary. All documents can be signed remotely.
    Buyer and Seller have reached an agreement and are under contract. The sale is expected to close / record soon.
    We will be happy to work with you as a Buyer's agent. Call us to learn more: 808-943-9000.
    Note: A Seller's agent has a fiduciary responsibility towards the Seller. Working with a Buyer's agent objectives and goals are aligned, at no cost to you, the Buyer.
    Other fees could be a special assessment, reserve contributions etc.
    DOM = Days On Market. Our site shows listings immediately. A brand new listing may show DOM 2 or 3 days, if listing agent did not upload the same day listing agreement was executed.
    Includes estimated monthly mortgage payment, maintenance / HOA fees & property taxes. The estimate does not include insurance premiums.
    Learn about property tax rates.