95-273 Waikalani Drive Unit D1006 Mililani, HI 96789

Listing
Overview

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

LOCATED IN LOVELY LAUNANI VALLEY, THIS NEWLY REMODELED, QUITE & PRIVATE CORNER END UNIT, 3 BEDROOM 2 BATH CONDO, PRIMARY BEDROOM HAS A WALKIN CLOSET, UPGRADED KITCHEN WITH SHAKER CABINETS AND QUARTZ COUNTER TOPS, NEW VINYL PLANKING FLOORS THROUGHOUT THE CONDO, FRESHLY PAINTED, ENJOY THE LUSH & SERENE PANORAMIC VIEW RIGHT OUTSIDE YOUR FRONT DOOR, BEAUTIFUL TREE TOP VIEW WITH COOL BREEZES FROM YOUR PRIVATE LANAI AND ENJOY YOUR MORNING COFFEE, HIGH SPEED INTERNET AND CABLE INCLUDED IN YOUR DUES, 2 COVERED SIDE BY SIDE PARKING STALLS, AMENITIES INCLUDE BBQ AREA, PLAYGROUND AND SALT WATER POOL TO HOST YOUR NEXT FAMILY GATHERING. CENTRALLY LOCATED WITH EASY ACCESS TO H2 AND KAM HWY, NEAR MILILANI TOWN, SCHOFIELD BARRACKS AND WHEELER ARMY AIR BASE, RESTAURANTS AND FAMOUS NORTH SHORES BEACHES. RESIDENT MANAGER AND SECURITY Listing by: Fahrni Realty (808) 780-1948 

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202414494"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "95-273"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Waikalani"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Drive"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(5) "D1006"
  }
  ["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) "495000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(826) "LOCATED IN LOVELY LAUNANI VALLEY, THIS NEWLY REMODELED, QUITE & PRIVATE CORNER END UNIT, 3 BEDROOM 2 BATH CONDO, PRIMARY BEDROOM HAS A WALKIN CLOSET, UPGRADED KITCHEN WITH SHAKER CABINETS AND QUARTZ COUNTER TOPS, NEW VINYL PLANKING FLOORS THROUGHOUT THE CONDO, FRESHLY PAINTED, ENJOY THE LUSH & SERENE PANORAMIC VIEW RIGHT OUTSIDE YOUR FRONT DOOR, BEAUTIFUL TREE TOP VIEW WITH COOL BREEZES FROM YOUR PRIVATE LANAI AND ENJOY YOUR MORNING COFFEE, HIGH SPEED INTERNET AND CABLE INCLUDED IN YOUR DUES, 2 COVERED SIDE BY SIDE PARKING STALLS, AMENITIES INCLUDE BBQ AREA, PLAYGROUND AND SALT WATER POOL TO HOST YOUR NEXT FAMILY GATHERING. CENTRALLY LOCATED WITH EASY ACCESS TO H2 AND KAM HWY, NEAR MILILANI TOWN, SCHOFIELD BARRACKS AND WHEELER ARMY AIR BASE, RESTAURANTS AND FAMOUS NORTH SHORES BEACHES. RESIDENT MANAGER AND SECURITY"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Fahrni 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(10) "1135914.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1120"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1976"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(19) "Waikalani Woodlands"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(4) "8-14"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "880.00"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Wheeler"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Wheeler"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Leilehua"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "FAHR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(29) "jerome@fahrnirealtyhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 780-1948"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Jerome Edayan"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-01-09T10:00:48.180"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18078619"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Central"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26591286"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "26591286"
    [1]=>
    string(8) "26591287"
    [2]=>
    string(8) "26591288"
    [3]=>
    string(8) "26591289"
    [4]=>
    string(8) "26591290"
    [5]=>
    string(8) "26591291"
    [6]=>
    string(8) "26591292"
    [7]=>
    string(8) "26591293"
    [8]=>
    string(8) "26591294"
    [9]=>
    string(8) "26591295"
    [10]=>
    string(8) "26591296"
    [11]=>
    string(8) "26591297"
    [12]=>
    string(8) "26591298"
    [13]=>
    string(8) "26591299"
    [14]=>
    string(8) "26591300"
    [15]=>
    string(8) "26591301"
    [16]=>
    string(8) "26735823"
    [17]=>
    string(8) "26735824"
    [18]=>
    string(8) "26735825"
    [19]=>
    string(8) "26735826"
    [20]=>
    string(8) "26735827"
    [21]=>
    string(8) "26735828"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-06-18"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "10:00:48.180"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202414494
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => LOCATED IN LOVELY LAUNANI VALLEY, THIS NEWLY REMODELED, QUITE & PRIVATE CORNER END UNIT, 3 BEDROOM 2 BATH CONDO, PRIMARY BEDROOM HAS A WALKIN CLOSET, UPGRADED KITCHEN WITH SHAKER CABINETS AND QUARTZ COUNTER TOPS, NEW VINYL PLANKING FLOORS THROUGHOUT THE CONDO, FRESHLY PAINTED, ENJOY THE LUSH & SERENE PANORAMIC VIEW RIGHT OUTSIDE YOUR FRONT DOOR, BEAUTIFUL TREE TOP VIEW WITH COOL BREEZES FROM YOUR PRIVATE LANAI AND ENJOY YOUR MORNING COFFEE, HIGH SPEED INTERNET AND CABLE INCLUDED IN YOUR DUES, 2 COVERED SIDE BY SIDE PARKING STALLS, AMENITIES INCLUDE BBQ AREA, PLAYGROUND AND SALT WATER POOL TO HOST YOUR NEXT FAMILY GATHERING. CENTRALLY LOCATED WITH EASY ACCESS TO H2 AND KAM HWY, NEAR MILILANI TOWN, SCHOFIELD BARRACKS AND WHEELER ARMY AIR BASE, RESTAURANTS AND FAMOUS NORTH SHORES BEACHES. RESIDENT MANAGER AND SECURITY
        )

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

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Waikalani Woodlands
        )

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

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

    [StoriesType] => Array
        (
            [0] => 8-14
        )

    [View] => Array
        (
            [0] => Mountain
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => jerome@fahrnirealtyhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 780-1948
        )

    [ListAgentFullName] => Array
        (
            [0] => Jerome Edayan
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-01-09T10:00:48.180
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26591286
            [1] => 26591287
            [2] => 26591288
            [3] => 26591289
            [4] => 26591290
            [5] => 26591291
            [6] => 26591292
            [7] => 26591293
            [8] => 26591294
            [9] => 26591295
            [10] => 26591296
            [11] => 26591297
            [12] => 26591298
            [13] => 26591299
            [14] => 26591300
            [15] => 26591301
            [16] => 26735823
            [17] => 26735824
            [18] => 26735825
            [19] => 26735826
            [20] => 26735827
            [21] => 26735828
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-06-18
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 10:00:48.180
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Land Area (sf): 1,135,914 sf
  • Living (sf): 1,120
  • Year Built: 1976
  • Building Name: Waikalani Woodlands

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: Mountain
  • Listing Office: Fahrni Realty

  • Maintenance Fees: $880
  • Land Tenure: FS - Fee Simple

  • Elementary School: Wheeler
  • Middle School: Wheeler
  • High School: Leilehua

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 9, 2025 - 10:00 AM 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.

Terms of Use Privacy Policy DMCA Policy
© Marcus Realty. All Rights Reserved.