Previous Next

94-600 Lumiaina Street Unit W202 Waipahu, HI 96797

Take a Virtual Tour

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202507491"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-600"
  }
  ["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) "W202"
  }
  ["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(41) "https://player.vimeo.com/video/1068473286"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "484900.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(814) "Best value upstairs 2-bed/2-bath in Parkglen! Spacious ~835 sf second-floor unit with two parking stalls just steps away. Freshly painted and move-in ready, this home features an open layout with a private lanai for indoor/outdoor living, and a well-designed floor plan separating the bedrooms for privacy.

Parkglen at Waikele is known for its central location—close to Waikele Premium Outlets, golf course, and freeway access—yet tucked away in a quiet residential setting. Enjoy community amenities, nearby parks, and the convenience of shopping and dining within minutes.

Recently sold upstairs units closed higher—this is your opportunity to secure an excellent value. Seller is motivated—schedule your showing today!

 Staging furniture has been removed. 100% INSURANCE COVERAGE. Pet Friendly."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(19) "Kobatake 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) "770184.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "905"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1993"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(19) "Parkglen at Waikele"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["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(6) "872.70"
  }
  ["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) "KOBA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "chelsey@kobatakerealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 368-3320"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Chelsey K Flanagan"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18636469"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-10-06T07:40:26.133"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-03-23"
  }
  ["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) "07:40:26.133"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26930994"
  }
  ["listing_image"]=>
  array(23) {
    [0]=>
    string(8) "26930994"
    [1]=>
    string(8) "26930995"
    [2]=>
    string(8) "26930996"
    [3]=>
    string(8) "26930997"
    [4]=>
    string(8) "26930998"
    [5]=>
    string(8) "26930999"
    [6]=>
    string(8) "26931000"
    [7]=>
    string(8) "26931001"
    [8]=>
    string(8) "26931002"
    [9]=>
    string(8) "26931003"
    [10]=>
    string(8) "26931004"
    [11]=>
    string(8) "26931005"
    [12]=>
    string(8) "26931006"
    [13]=>
    string(8) "26931007"
    [14]=>
    string(8) "26931008"
    [15]=>
    string(8) "26931009"
    [16]=>
    string(8) "26931010"
    [17]=>
    string(8) "26931011"
    [18]=>
    string(8) "26931012"
    [19]=>
    string(8) "26931013"
    [20]=>
    string(8) "26931014"
    [21]=>
    string(8) "27154070"
    [22]=>
    string(8) "27154071"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202507491
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://player.vimeo.com/video/1068473286
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Best value upstairs 2-bed/2-bath in Parkglen! Spacious ~835 sf second-floor unit with two parking stalls just steps away. Freshly painted and move-in ready, this home features an open layout with a private lanai for indoor/outdoor living, and a well-designed floor plan separating the bedrooms for privacy.

Parkglen at Waikele is known for its central location—close to Waikele Premium Outlets, golf course, and freeway access—yet tucked away in a quiet residential setting. Enjoy community amenities, nearby parks, and the convenience of shopping and dining within minutes.

Recently sold upstairs units closed higher—this is your opportunity to secure an excellent value. Seller is motivated—schedule your showing today!

 Staging furniture has been removed. 100% INSURANCE COVERAGE. Pet Friendly.
        )

    [ListOfficeName] => Array
        (
            [0] => Kobatake Realty LLC
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => chelsey@kobatakerealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 368-3320
        )

    [ListAgentFullName] => Array
        (
            [0] => Chelsey K Flanagan
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-10-06T07:40:26.133
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-03-23
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 07:40:26.133
        )

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

    [listing_image] => Array
        (
            [0] => 26930994
            [1] => 26930995
            [2] => 26930996
            [3] => 26930997
            [4] => 26930998
            [5] => 26930999
            [6] => 26931000
            [7] => 26931001
            [8] => 26931002
            [9] => 26931003
            [10] => 26931004
            [11] => 26931005
            [12] => 26931006
            [13] => 26931007
            [14] => 26931008
            [15] => 26931009
            [16] => 26931010
            [17] => 26931011
            [18] => 26931012
            [19] => 26931013
            [20] => 26931014
            [21] => 27154070
            [22] => 27154071
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 2
• Land Area (sf): 770,184 sf
• Living (sf): 905
• Year Built: 1993
• Building Name: Parkglen at Waikele

KEY FEATURES

• Property Condition: Average
• Number of Parking Spaces: 2
• View: Garden,Other
• Listing Office: Kobatake Realty LLC

FINANCIAL INFO

• Maintenance Fees: $873
• 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 October 6, 2025 - 7:40 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.