Previous Next

94-510 Lumiaina Street Unit B202 Waipahu, HI 96797

Listing
Overview

Price: $475,000
Area: WAIKELE
Status: Sold (Limited photos per MLS privacy policy)

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202516715"
  }
  ["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) "B202"
  }
  ["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) "475000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(756) "Welcome to Viewpointe at Waikele! This desirable upstairs 2-bedroom, 1-bath unit offers a bright, open living space with vaulted ceilings. Enjoy cool island breezes from your private lanai, perfect for morning coffee or relaxing evenings. The unit was updated in 2025 with new Corian countertops in the kitchen, refinished cabinets, a new water heater, and kitchen flooring.  The unit includes two parking stalls, ample guest parking, and access to well-maintained community areas. Ideally located near Waikele Premium Outlets (retail and dining), parks, Waikele Golf Course, and easy freeway access, this home combines comfort and convenience in one of Waikele's most sought-after communities. Don't miss this opportunity to own a piece of Waikele living!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "True Real Estate Hawaii LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(10) "1019173.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "757"
  }
  ["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(12) "Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "540.33"
  }
  ["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) "KAIZ"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "justin@truerehawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 782-1771"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Justin Walthall"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-09-24"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18885478"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-09-24T09:53:37.183"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-08-04"
  }
  ["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) "09:53:37.183"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27093768"
  }
  ["listing_image"]=>
  array(17) {
    [0]=>
    string(8) "27093768"
    [1]=>
    string(8) "27093769"
    [2]=>
    string(8) "27093770"
    [3]=>
    string(8) "27093771"
    [4]=>
    string(8) "27093772"
    [5]=>
    string(8) "27093773"
    [6]=>
    string(8) "27093774"
    [7]=>
    string(8) "27093775"
    [8]=>
    string(8) "27093776"
    [9]=>
    string(8) "27093777"
    [10]=>
    string(8) "27093778"
    [11]=>
    string(8) "27093779"
    [12]=>
    string(8) "27093780"
    [13]=>
    string(8) "27093781"
    [14]=>
    string(8) "27093782"
    [15]=>
    string(8) "27093783"
    [16]=>
    string(8) "27093784"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202516715
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to Viewpointe at Waikele! This desirable upstairs 2-bedroom, 1-bath unit offers a bright, open living space with vaulted ceilings. Enjoy cool island breezes from your private lanai, perfect for morning coffee or relaxing evenings. The unit was updated in 2025 with new Corian countertops in the kitchen, refinished cabinets, a new water heater, and kitchen flooring.  The unit includes two parking stalls, ample guest parking, and access to well-maintained community areas. Ideally located near Waikele Premium Outlets (retail and dining), parks, Waikele Golf Course, and easy freeway access, this home combines comfort and convenience in one of Waikele's most sought-after communities. Don't miss this opportunity to own a piece of Waikele living!
        )

    [ListOfficeName] => Array
        (
            [0] => True Real Estate Hawaii LLC
        )

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

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

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

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

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

    [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] => Ocean,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => justin@truerehawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 782-1771
        )

    [ListAgentFullName] => Array
        (
            [0] => Justin Walthall
        )

    [CloseDate] => Array
        (
            [0] => 2025-09-24
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-09-24T09:53:37.183
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-08-04
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:53:37.183
        )

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

    [listing_image] => Array
        (
            [0] => 27093768
            [1] => 27093769
            [2] => 27093770
            [3] => 27093771
            [4] => 27093772
            [5] => 27093773
            [6] => 27093774
            [7] => 27093775
            [8] => 27093776
            [9] => 27093777
            [10] => 27093778
            [11] => 27093779
            [12] => 27093780
            [13] => 27093781
            [14] => 27093782
            [15] => 27093783
            [16] => 27093784
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: Ocean,Sunset
• Listing Office: True Real Estate Hawaii LLC

FINANCIAL INFO

• Maintenance Fees: $540
• 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 September 24, 2025 - 9:53 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.