Previous Next

94-870 Lumiauau Street Unit N204 Waipahu, HI 96797

Listing
Overview

Price: $515,000
Area: WAIKELE
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202608891"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-870"
  }
  ["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) "N204"
  }
  ["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) "515000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(885) "Welcome to Hoomaka Village – Comfort, Convenience, and Island Living at Its Best!
Discover this beautifully located unit in the desirable Waikele community, just minutes from everything you need.
Perfectly positioned near Waikele Premium Outlet, you’ll enjoy easy access to popular retail shops, dining options, and everyday essentials.
This unit offers the ideal blend of lifestyle and location, convenient access to community pool, parks, green spaces, walking paths
and easy commuting with nearby bus routes and quick freeway access.
Whether you're relaxing at the pool, exploring the neighborhood parks, or enjoying the convenience of nearby amenities, this location truly has it all.
Don’t miss this opportunity to own a unit in one of the area’s most convenient and sought-after communities. Perfect for homeowners and investors alike—schedule your showing today!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "Tsujimura & Associates, 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(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "886"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1991"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(15) "Hoomaka Village"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Sunrise,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "574.45"
  }
  ["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) "LTSU"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "LTSUJIMURA@TAAREALTY.COM"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 388-3630"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Lester S Tsujimura"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19431609"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-05-10T17:00:01.900"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-05-01"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:00:01.900"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27381914"
  }
  ["listing_image"]=>
  array(19) {
    [0]=>
    string(8) "27381914"
    [1]=>
    string(8) "27381915"
    [2]=>
    string(8) "27381916"
    [3]=>
    string(8) "27381917"
    [4]=>
    string(8) "27381918"
    [5]=>
    string(8) "27381919"
    [6]=>
    string(8) "27381920"
    [7]=>
    string(8) "27381921"
    [8]=>
    string(8) "27381922"
    [9]=>
    string(8) "27381923"
    [10]=>
    string(8) "27381924"
    [11]=>
    string(8) "27381925"
    [12]=>
    string(8) "27381926"
    [13]=>
    string(8) "27381927"
    [14]=>
    string(8) "27381928"
    [15]=>
    string(8) "27381929"
    [16]=>
    string(8) "27381930"
    [17]=>
    string(8) "27381931"
    [18]=>
    string(8) "27381932"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202608891
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to Hoomaka Village – Comfort, Convenience, and Island Living at Its Best!
Discover this beautifully located unit in the desirable Waikele community, just minutes from everything you need.
Perfectly positioned near Waikele Premium Outlet, you’ll enjoy easy access to popular retail shops, dining options, and everyday essentials.
This unit offers the ideal blend of lifestyle and location, convenient access to community pool, parks, green spaces, walking paths
and easy commuting with nearby bus routes and quick freeway access.
Whether you're relaxing at the pool, exploring the neighborhood parks, or enjoying the convenience of nearby amenities, this location truly has it all.
Don’t miss this opportunity to own a unit in one of the area’s most convenient and sought-after communities. Perfect for homeowners and investors alike—schedule your showing today!
        )

    [ListOfficeName] => Array
        (
            [0] => Tsujimura & Associates, LLC
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Hoomaka Village
        )

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

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

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

    [View] => Array
        (
            [0] => Sunrise,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => LTSUJIMURA@TAAREALTY.COM
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 388-3630
        )

    [ListAgentFullName] => Array
        (
            [0] => Lester S Tsujimura
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-05-10T17:00:01.900
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-05-01
        )

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 27381914
            [1] => 27381915
            [2] => 27381916
            [3] => 27381917
            [4] => 27381918
            [5] => 27381919
            [6] => 27381920
            [7] => 27381921
            [8] => 27381922
            [9] => 27381923
            [10] => 27381924
            [11] => 27381925
            [12] => 27381926
            [13] => 27381927
            [14] => 27381928
            [15] => 27381929
            [16] => 27381930
            [17] => 27381931
            [18] => 27381932
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 2
• Living (sf): 886
• Year Built: 1991
• Building Name: Hoomaka Village

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: Sunrise,Sunset
• Listing Office: Tsujimura & Associates, LLC

FINANCIAL INFO

• Maintenance Fees: $574
• 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 May 10, 2026 - 5: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.