94-586 Lumiauau Street Unit N104 Waipahu, HI 96797

Listing
Overview

Price: $589,900
Area: WAIKELE
Status: Active Under Contract

Discover comfortable and convenient living in the desirable Highlands at Waikele! This 2Br/2Ba/2Pkg corner end, ground floor unit has remodeled kitchen, stainless steel appliances, new flooring and bathrooms. Enjoy the benefits of a prime Waikele location, with close to Waikele Center's shopping and dining, the Waikele Country Club and easy freeway access. This well-maintained community provides car wash, dog park, private yard and walking/jogging path. Whether you're a first-homebuyer or looking to downsize, this unit offers the perfect blend of comfort and convenience. Contact your favorite Realtor today to schedule a viewing. First Open House Sunday June 22, 2025, 1-4pm! Listing by: Ivy K Realty, LLC (808) 591-5660

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202514315"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-586"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Lumiauau"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "N104"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "589900.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(685) "Discover comfortable and convenient living in the desirable Highlands at Waikele! This 2Br/2Ba/2Pkg corner end, ground floor unit has remodeled kitchen, stainless steel appliances, new flooring and bathrooms. Enjoy the benefits of a prime Waikele location, with close to Waikele Center's shopping and dining, the Waikele Country Club and easy freeway access. This well-maintained community provides car wash, dog park, private yard and walking/jogging path. Whether you're a first-homebuyer or looking to downsize, this unit offers the perfect blend of comfort and convenience. Contact your favorite Realtor today to schedule a viewing.

First Open House Sunday June 22, 2025, 1-4pm!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(17) "Ivy K Realty, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "424057.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "905"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1994"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(20) "Highlands at Waikele"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "443.03"
  }
  ["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(6) "IVYK02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "marckumai@ivykrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 591-5660"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Marc T Kumai"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18814399"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-06-26T13:20:43.413"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-17"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "13:20:43.413"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27036104"
  }
  ["listing_image"]=>
  array(21) {
    [0]=>
    string(8) "27036104"
    [1]=>
    string(8) "27036105"
    [2]=>
    string(8) "27036106"
    [3]=>
    string(8) "27036107"
    [4]=>
    string(8) "27036108"
    [5]=>
    string(8) "27036109"
    [6]=>
    string(8) "27036110"
    [7]=>
    string(8) "27036111"
    [8]=>
    string(8) "27036112"
    [9]=>
    string(8) "27036113"
    [10]=>
    string(8) "27036114"
    [11]=>
    string(8) "27036115"
    [12]=>
    string(8) "27036116"
    [13]=>
    string(8) "27036117"
    [14]=>
    string(8) "27036118"
    [15]=>
    string(8) "27036119"
    [16]=>
    string(8) "27036120"
    [17]=>
    string(8) "27036121"
    [18]=>
    string(8) "27036122"
    [19]=>
    string(8) "27036123"
    [20]=>
    string(8) "27036124"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202514315
        )

    [StreetNumber] => Array
        (
            [0] => 94-586
        )

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => WAIKELE
        )

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

    [PublicRemarks] => Array
        (
            [0] => Discover comfortable and convenient living in the desirable Highlands at Waikele! This 2Br/2Ba/2Pkg corner end, ground floor unit has remodeled kitchen, stainless steel appliances, new flooring and bathrooms. Enjoy the benefits of a prime Waikele location, with close to Waikele Center's shopping and dining, the Waikele Country Club and easy freeway access. This well-maintained community provides car wash, dog park, private yard and walking/jogging path. Whether you're a first-homebuyer or looking to downsize, this unit offers the perfect blend of comfort and convenience. Contact your favorite Realtor today to schedule a viewing.

First Open House Sunday June 22, 2025, 1-4pm!
        )

    [ListOfficeName] => Array
        (
            [0] => Ivy K Realty, LLC
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Highlands at Waikele
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => marckumai@ivykrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 591-5660
        )

    [ListAgentFullName] => Array
        (
            [0] => Marc T Kumai
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-06-26T13:20:43.413
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-06-17
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 13:20:43.413
        )

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

    [listing_image] => Array
        (
            [0] => 27036104
            [1] => 27036105
            [2] => 27036106
            [3] => 27036107
            [4] => 27036108
            [5] => 27036109
            [6] => 27036110
            [7] => 27036111
            [8] => 27036112
            [9] => 27036113
            [10] => 27036114
            [11] => 27036115
            [12] => 27036116
            [13] => 27036117
            [14] => 27036118
            [15] => 27036119
            [16] => 27036120
            [17] => 27036121
            [18] => 27036122
            [19] => 27036123
            [20] => 27036124
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Land Area (sf): 424,057 sf
  • Living (sf): 905
  • Year Built: 1994
  • Building Name: Highlands at Waikele

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: None
  • Listing Office: Ivy K Realty, LLC

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

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 June 26, 2025 - 1:20 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.

© Marcus Realty. All Rights Reserved.