Previous Next

95-2027 Waikalani Place Unit A204 Mililani, HI 96789

Listing
Overview

Price: $530,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202428843"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "95-2027"
  }
  ["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) "A204"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "530000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1176) "Charming 3-Bedroom, 2-Bath Condo in Peaceful Waipio
Nestled in a serene neighborhood of Waipio, this inviting 3-bedroom, 2-bathroom condo offers the perfect blend of comfort and tranquility. Situated near lush green spaces, the property enjoys a calm and quiet while still being conveniently close to all the amenities you need.

The spacious living area is bathed in natural light, creating a warm and welcoming atmosphere. The well-appointed kitchen features modern appliances, ample cabinetry, and a breakfast bar – ideal for casual dining or entertaining guests. The living room opens up to a private lanai, where you can unwind and enjoy the peaceful surroundings.

The master suite is a true retreat, complete with an ensuite bathroom for added privacy and convenience. Two additional bedrooms offer flexible space for family, guests, or home office needs. Both bathrooms are well-maintained and updated, offering a spa-like feel with contemporary finishes.

Whether you’re looking for your first home or a peaceful retreat, this condo in Waipio offers the perfect blend of comfort, convenience, and tranquility. Don’t miss the opportunity to make it yours!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1138"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(19) "Northbrook-Melemanu"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(12) "Garden,Other"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1004.00"
  }
  ["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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "ben@pineapplehi.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 420-5082"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Ben Janszen"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18453900"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-01-12T17:00:01.160"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-12-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) "17:00:01.160"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26820986"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26820986"
    [1]=>
    string(8) "26820987"
    [2]=>
    string(8) "26820988"
    [3]=>
    string(8) "26820989"
    [4]=>
    string(8) "26820990"
    [5]=>
    string(8) "26820991"
    [6]=>
    string(8) "26820992"
    [7]=>
    string(8) "26820993"
    [8]=>
    string(8) "26820994"
    [9]=>
    string(8) "26820995"
    [10]=>
    string(8) "26820996"
    [11]=>
    string(8) "26820997"
    [12]=>
    string(8) "26820998"
    [13]=>
    string(8) "26820999"
    [14]=>
    string(8) "26821000"
    [15]=>
    string(8) "26821001"
    [16]=>
    string(8) "26821002"
    [17]=>
    string(8) "26821003"
    [18]=>
    string(8) "26821004"
    [19]=>
    string(8) "26821005"
    [20]=>
    string(8) "26821006"
    [21]=>
    string(8) "26821007"
    [22]=>
    string(8) "26821008"
    [23]=>
    string(8) "26821009"
    [24]=>
    string(8) "26821010"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202428843
        )

    [StreetNumber] => Array
        (
            [0] => 95-2027
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Waikalani
        )

    [StreetSuffix] => Array
        (
            [0] => Place
        )

    [UnitNumber] => Array
        (
            [0] => A204
        )

    [City] => Array
        (
            [0] => Mililani
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96789
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 530000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WAIPIO ACRES/WAIKALANI WOODLANDS
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Charming 3-Bedroom, 2-Bath Condo in Peaceful Waipio
Nestled in a serene neighborhood of Waipio, this inviting 3-bedroom, 2-bathroom condo offers the perfect blend of comfort and tranquility. Situated near lush green spaces, the property enjoys a calm and quiet while still being conveniently close to all the amenities you need.

The spacious living area is bathed in natural light, creating a warm and welcoming atmosphere. The well-appointed kitchen features modern appliances, ample cabinetry, and a breakfast bar – ideal for casual dining or entertaining guests. The living room opens up to a private lanai, where you can unwind and enjoy the peaceful surroundings.

The master suite is a true retreat, complete with an ensuite bathroom for added privacy and convenience. Two additional bedrooms offer flexible space for family, guests, or home office needs. Both bathrooms are well-maintained and updated, offering a spa-like feel with contemporary finishes.

Whether you’re looking for your first home or a peaceful retreat, this condo in Waipio offers the perfect blend of comfort, convenience, and tranquility. Don’t miss the opportunity to make it yours!
        )

    [ListOfficeName] => Array
        (
            [0] => eXp Realty
        )

    [BedsTotal] => Array
        (
            [0] => 3
        )

    [BathsFull] => Array
        (
            [0] => 2
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 
        )

    [SqftTotal] => Array
        (
            [0] => 1138
        )

    [YearBuilt] => Array
        (
            [0] => 1973
        )

    [BuildingName] => Array
        (
            [0] => Northbrook-Melemanu
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => One
        )

    [View] => Array
        (
            [0] => Garden,Other
        )

    [MaintenanceExpense] => Array
        (
            [0] => 1004.00
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => EXPI
        )

    [ListAgentEmail] => Array
        (
            [0] => ben@pineapplehi.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 420-5082
        )

    [ListAgentFullName] => Array
        (
            [0] => Ben Janszen
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18453900
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-01-12T17:00:01.160
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-12-26
        )

    [MLSAreaMajor] => Array
        (
            [0] => Central
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 17:00:01.160
        )

    [_thumbnail_id] => Array
        (
            [0] => 26820986
        )

    [listing_image] => Array
        (
            [0] => 26820986
            [1] => 26820987
            [2] => 26820988
            [3] => 26820989
            [4] => 26820990
            [5] => 26820991
            [6] => 26820992
            [7] => 26820993
            [8] => 26820994
            [9] => 26820995
            [10] => 26820996
            [11] => 26820997
            [12] => 26820998
            [13] => 26820999
            [14] => 26821000
            [15] => 26821001
            [16] => 26821002
            [17] => 26821003
            [18] => 26821004
            [19] => 26821005
            [20] => 26821006
            [21] => 26821007
            [22] => 26821008
            [23] => 26821009
            [24] => 26821010
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Living (sf): 1,138
• Year Built: 1973
• Building Name: Northbrook-Melemanu

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 2
• View: Garden,Other
• Listing Office: eXp Realty

FINANCIAL INFO

• Maintenance Fees: $1,004
• Land Tenure: FS - Fee Simple

SCHOOLS

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on January 12, 2025 - 5:00 PM Information is deemed reliable but not guaranteed. Copyright: 2025 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.