Previous Next

94-510 Lumiaina Street Unit L201 Waipahu, HI 96797

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202513066"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-510"
  }
  ["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) "L201"
  }
  ["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) "575000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(911) "Welcome to this desirable end-unit townhome in Viewpointe at Waikele—one of the most beautifully maintained communities in the area. This 2-bedroom, 2-bath home with vaulted ceilings offers coastal, mountain, and Diamond Head views, plus 2 parking stalls (1 covered, 1 open). Enjoy modern upgrades including vinyl plank flooring (2025), interior and ceiling paint (2022), and double-paned windows and sliding doors for energy efficiency. Both bedrooms feature mirrored closet doors, with the primary suite offering an additional closet for extra storage. Stay comfortable year-round with Friedrich window A/C units and updated appliances, including refrigerator and in-unit washer/dryer. Ideally located with quick access to the freeway, and just minutes from Waikele Premium Outlets, Costco, Safeway, golf courses, parks, schools, and more. Don’t miss this fantastic opportunity to own in a prime location."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["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(10) "1019173.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "826"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1999"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(21) "Viewpointe At Waikele"
  }
  ["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(38) "Coastline,Diamond Head,Mountain,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "595.00"
  }
  ["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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(29) "TeamEpicHawaiiHomes@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 748-1171"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(17) "Tina Marie Gamble"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18777570"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-06T17:00:01.583"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-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) "17:00:01.583"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27013470"
  }
  ["listing_image"]=>
  array(21) {
    [0]=>
    string(8) "27013470"
    [1]=>
    string(8) "27013471"
    [2]=>
    string(8) "27013472"
    [3]=>
    string(8) "27013473"
    [4]=>
    string(8) "27013474"
    [5]=>
    string(8) "27013475"
    [6]=>
    string(8) "27013476"
    [7]=>
    string(8) "27013477"
    [8]=>
    string(8) "27013478"
    [9]=>
    string(8) "27013479"
    [10]=>
    string(8) "27013480"
    [11]=>
    string(8) "27013481"
    [12]=>
    string(8) "27013482"
    [13]=>
    string(8) "27013483"
    [14]=>
    string(8) "27013484"
    [15]=>
    string(8) "27013485"
    [16]=>
    string(8) "27013486"
    [17]=>
    string(8) "27013487"
    [18]=>
    string(8) "27013488"
    [19]=>
    string(8) "27013489"
    [20]=>
    string(8) "27013490"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202513066
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to this desirable end-unit townhome in Viewpointe at Waikele—one of the most beautifully maintained communities in the area. This 2-bedroom, 2-bath home with vaulted ceilings offers coastal, mountain, and Diamond Head views, plus 2 parking stalls (1 covered, 1 open). Enjoy modern upgrades including vinyl plank flooring (2025), interior and ceiling paint (2022), and double-paned windows and sliding doors for energy efficiency. Both bedrooms feature mirrored closet doors, with the primary suite offering an additional closet for extra storage. Stay comfortable year-round with Friedrich window A/C units and updated appliances, including refrigerator and in-unit washer/dryer. Ideally located with quick access to the freeway, and just minutes from Waikele Premium Outlets, Costco, Safeway, golf courses, parks, schools, and more. Don’t miss this fantastic opportunity to own in a prime location.
        )

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

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Viewpointe At Waikele
        )

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

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

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

    [View] => Array
        (
            [0] => Coastline,Diamond Head,Mountain,Sunset
        )

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 748-1171
        )

    [ListAgentFullName] => Array
        (
            [0] => Tina Marie Gamble
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-06T17:00:01.583
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-05-30
        )

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 27013470
            [1] => 27013471
            [2] => 27013472
            [3] => 27013473
            [4] => 27013474
            [5] => 27013475
            [6] => 27013476
            [7] => 27013477
            [8] => 27013478
            [9] => 27013479
            [10] => 27013480
            [11] => 27013481
            [12] => 27013482
            [13] => 27013483
            [14] => 27013484
            [15] => 27013485
            [16] => 27013486
            [17] => 27013487
            [18] => 27013488
            [19] => 27013489
            [20] => 27013490
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 2
• Land Area (sf): 1,019,173 sf
• Living (sf): 826
• Year Built: 1999
• Building Name: Viewpointe At Waikele

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: Coastline,Diamond Head,Mountain,Sunset
• Listing Office: eXp Realty

FINANCIAL INFO

• Maintenance Fees: $595
• 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 July 6, 2025 - 5:00 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.