Previous Next

94-529 Lumiaina Street Unit D204 Waipahu, HI 96797

Listing
Overview

Price: $454,999
Area: WAIKELE
Status: Pending

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202606422"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-529"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Lumiaina"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "D204"
  }
  ["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) "454999.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(7) "Pending"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1199) "LOWEST PRICED 2 BDRM IN WAIKELE! Seller has found replacement & says SELL! Seller MUST CONTRACT BY 5/15 creating an excellent opportunity for serious buyers. Don't miss your chance! Seller also willing to provide credit for buydown at higher sales price if Buyer would rather!

Spacious & Serene 2-Bed, 2-Bath - Largest Floor Plan in Mahi Ko! 

Welcome HOME to this clean & well-maintained 2-bedroom, 2-bath townhouse offering one of the largest layouts in Mahi Ko. Generous living spaces, excellent natural light, cool breezes, & a thoughtful floor plan, this home provides both comfort & functionality - perfect for first-time buyers, downsizes, or anyone looking for a low-maintenance lifestyle in a highly desirable community.

This unit is located in a private corner of the subdivision! Enjoy an open kitchen & living area, spacious bedrooms affording privacy & primary with en suite bath. This home includes 1 assigned parking stall conveniently located near the unit with additional parking on the street nearby. Visitor stalls are found right across the unit. 

Ideally situated close to shopping, schools, parks, restaurants, freeway and zipper lane access. BRING YOUR OFFER TODAY!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(20) "Kapolei Realty, Inc."
  }
  ["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) "504425.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "922"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1993"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(18) "Mahi Ko At Waikele"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "563.85"
  }
  ["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) "KLEI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "lealanigamboa@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 371-4352"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(20) "Lealani Marie Gamboa"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19358469"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-05-18T18:58:33.320"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-03-30"
  }
  ["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) "18:58:33.320"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27347141"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "27347141"
    [1]=>
    string(8) "27347142"
    [2]=>
    string(8) "27347143"
    [3]=>
    string(8) "27347144"
    [4]=>
    string(8) "27347145"
    [5]=>
    string(8) "27347146"
    [6]=>
    string(8) "27347147"
    [7]=>
    string(8) "27347148"
    [8]=>
    string(8) "27347149"
    [9]=>
    string(8) "27347150"
    [10]=>
    string(8) "27347151"
    [11]=>
    string(8) "27347152"
    [12]=>
    string(8) "27347153"
    [13]=>
    string(8) "27347154"
    [14]=>
    string(8) "27347155"
    [15]=>
    string(8) "27347156"
    [16]=>
    string(8) "27347157"
    [17]=>
    string(8) "27347158"
    [18]=>
    string(8) "27347159"
    [19]=>
    string(8) "27347160"
    [20]=>
    string(8) "27347161"
    [21]=>
    string(8) "27347162"
    [22]=>
    string(8) "27347163"
    [23]=>
    string(8) "27347164"
    [24]=>
    string(8) "27347165"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202606422
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => LOWEST PRICED 2 BDRM IN WAIKELE! Seller has found replacement & says SELL! Seller MUST CONTRACT BY 5/15 creating an excellent opportunity for serious buyers. Don't miss your chance! Seller also willing to provide credit for buydown at higher sales price if Buyer would rather!

Spacious & Serene 2-Bed, 2-Bath - Largest Floor Plan in Mahi Ko! 

Welcome HOME to this clean & well-maintained 2-bedroom, 2-bath townhouse offering one of the largest layouts in Mahi Ko. Generous living spaces, excellent natural light, cool breezes, & a thoughtful floor plan, this home provides both comfort & functionality - perfect for first-time buyers, downsizes, or anyone looking for a low-maintenance lifestyle in a highly desirable community.

This unit is located in a private corner of the subdivision! Enjoy an open kitchen & living area, spacious bedrooms affording privacy & primary with en suite bath. This home includes 1 assigned parking stall conveniently located near the unit with additional parking on the street nearby. Visitor stalls are found right across the unit. 

Ideally situated close to shopping, schools, parks, restaurants, freeway and zipper lane access. BRING YOUR OFFER TODAY!
        )

    [ListOfficeName] => Array
        (
            [0] => Kapolei Realty, Inc.
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Mahi Ko At Waikele
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => lealanigamboa@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 371-4352
        )

    [ListAgentFullName] => Array
        (
            [0] => Lealani Marie Gamboa
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-05-18T18:58:33.320
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-03-30
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 18:58:33.320
        )

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

    [listing_image] => Array
        (
            [0] => 27347141
            [1] => 27347142
            [2] => 27347143
            [3] => 27347144
            [4] => 27347145
            [5] => 27347146
            [6] => 27347147
            [7] => 27347148
            [8] => 27347149
            [9] => 27347150
            [10] => 27347151
            [11] => 27347152
            [12] => 27347153
            [13] => 27347154
            [14] => 27347155
            [15] => 27347156
            [16] => 27347157
            [17] => 27347158
            [18] => 27347159
            [19] => 27347160
            [20] => 27347161
            [21] => 27347162
            [22] => 27347163
            [23] => 27347164
            [24] => 27347165
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 2
• Land Area (sf): 504,425 sf
• Living (sf): 922
• Year Built: 1993
• Building Name: Mahi Ko At Waikele

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 1
• View: Garden
• Listing Office: Kapolei Realty, Inc.

FINANCIAL INFO

• Maintenance Fees: $564
• 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 18, 2026 - 6:58 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.