Previous Next

94-510 Lumiaina Street Unit J202 Waipahu, HI 96797

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202601768"
  }
  ["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) "J202"
  }
  ["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) "570000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(714) "Welcome to this beautiful, clean and meticulously maintained 2-bedroom, 2-full-bath upstairs end-unit townhome, where pride of
ownership truly shines. This unit is located in the highly sought after Viewpointe at Waikele neighborhood. Thoughtfully cared for and
move-in ready, this light-filled home offers added privacy as an end unit. Enjoy a quite meal on the large patio or just relax while enjoying the sunset. With well-manicured grounds in a prime location, enjoy living at its finest while conveniently located close to shopping malls, schools, parks, and more. Ideal for homeowners seeking comfort, a low-maintenance lifestyle in a desirable setting or portfolio investors looking for long term tenants."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(17) "Horita 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(10) "1019173.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "837"
  }
  ["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) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "714.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) "HRTA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(30) "sarahchandler@horitarealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 487-1561"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Sarah Chandler"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19236402"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-02-22T00:00:01.517"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-02-05"
  }
  ["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) "00:00:01.517"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27295043"
  }
  ["listing_image"]=>
  array(17) {
    [0]=>
    string(8) "27295043"
    [1]=>
    string(8) "27295044"
    [2]=>
    string(8) "27295045"
    [3]=>
    string(8) "27295046"
    [4]=>
    string(8) "27295047"
    [5]=>
    string(8) "27295048"
    [6]=>
    string(8) "27295049"
    [7]=>
    string(8) "27295050"
    [8]=>
    string(8) "27295051"
    [9]=>
    string(8) "27295052"
    [10]=>
    string(8) "27295053"
    [11]=>
    string(8) "27295054"
    [12]=>
    string(8) "27295055"
    [13]=>
    string(8) "27295056"
    [14]=>
    string(8) "27295057"
    [15]=>
    string(8) "27295058"
    [16]=>
    string(8) "27298661"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202601768
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to this beautiful, clean and meticulously maintained 2-bedroom, 2-full-bath upstairs end-unit townhome, where pride of
ownership truly shines. This unit is located in the highly sought after Viewpointe at Waikele neighborhood. Thoughtfully cared for and
move-in ready, this light-filled home offers added privacy as an end unit. Enjoy a quite meal on the large patio or just relax while enjoying the sunset. With well-manicured grounds in a prime location, enjoy living at its finest while conveniently located close to shopping malls, schools, parks, and more. Ideal for homeowners seeking comfort, a low-maintenance lifestyle in a desirable setting or portfolio investors looking for long term tenants.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => sarahchandler@horitarealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 487-1561
        )

    [ListAgentFullName] => Array
        (
            [0] => Sarah Chandler
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-02-22T00:00:01.517
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 00:00:01.517
        )

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

    [listing_image] => Array
        (
            [0] => 27295043
            [1] => 27295044
            [2] => 27295045
            [3] => 27295046
            [4] => 27295047
            [5] => 27295048
            [6] => 27295049
            [7] => 27295050
            [8] => 27295051
            [9] => 27295052
            [10] => 27295053
            [11] => 27295054
            [12] => 27295055
            [13] => 27295056
            [14] => 27295057
            [15] => 27295058
            [16] => 27298661
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: None
• Listing Office: Horita Realty LLC

FINANCIAL INFO

• Maintenance Fees: $714
• 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 February 22, 2026 - 12:00 AM 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.