94-510 Lumiaina Street Unit N201 Waipahu, HI 96797

Listing
Overview

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

FULLY INSURED • 2 PARKING STALLS • HOA UNDER $600 • PET FRIENDLY • MOTIVATED SELLERS OPEN HOUSE THIS SUNDAY 9 / 21 Welcome to this beautifully maintained 2 bed / 2 bath CORNER UNIT townhome in the highly sought-after Viewpointe at Waikele. Enjoy ocean and mountain views from your private lanai! This end-unit offers vaulted ceilings with no one above you, new A/C units in the living room and both bedrooms, modern ceiling fans, double-paned windows, and custom roller blinds in the living room. The kitchen features granite countertops and reverse osmosis water filtration. PLENTY of storage with multiple closets inside AND outside. Plus, there's the convenience of a full-size washer/dryer inside the unit. The community is perfectly located — just minutes to H-1, Waikele Premium Outlets, golf, dining, and more. VA buyers — take advantage of an ASSUMABLE VA LOAN. Listing by: Talk Realty LLC (808) 738-2087 

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202520744"
  }
  ["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) "N201"
  }
  ["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) "560000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(898) "FULLY INSURED • 2 PARKING STALLS • HOA UNDER $600 • PET FRIENDLY • MOTIVATED SELLERS 
OPEN HOUSE THIS SUNDAY 9 / 21

Welcome to this beautifully maintained 2 bed / 2 bath CORNER UNIT townhome in the highly sought-after Viewpointe at Waikele. Enjoy ocean and mountain views from your private lanai!

This end-unit offers vaulted ceilings with no one above you, new A/C units in the living room and both bedrooms, modern ceiling fans, double-paned windows, and custom roller blinds in the living room. The kitchen features granite countertops and reverse osmosis water filtration.

PLENTY of storage with multiple closets inside AND outside. Plus, there's the convenience of a full-size washer/dryer inside the unit.

The community is perfectly located — just minutes to H-1, Waikele Premium Outlets, golf, dining, and more.

VA buyers — take advantage of an ASSUMABLE VA LOAN."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(15) "Talk 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(0) ""
  }
  ["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(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(25) "Coastline,Mountain,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "589.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) "TALK"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "daniel@pineapplehi.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 738-2087"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Daniel Perea"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18989632"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-09-22T10:16:56.680"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-09-18"
  }
  ["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) "10:16:56.680"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27157015"
  }
  ["listing_image"]=>
  array(10) {
    [0]=>
    string(8) "27157015"
    [1]=>
    string(8) "27157016"
    [2]=>
    string(8) "27157017"
    [3]=>
    string(8) "27157018"
    [4]=>
    string(8) "27157019"
    [5]=>
    string(8) "27157020"
    [6]=>
    string(8) "27157021"
    [7]=>
    string(8) "27157022"
    [8]=>
    string(8) "27157023"
    [9]=>
    string(8) "27157024"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202520744
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => FULLY INSURED • 2 PARKING STALLS • HOA UNDER $600 • PET FRIENDLY • MOTIVATED SELLERS 
OPEN HOUSE THIS SUNDAY 9 / 21

Welcome to this beautifully maintained 2 bed / 2 bath CORNER UNIT townhome in the highly sought-after Viewpointe at Waikele. Enjoy ocean and mountain views from your private lanai!

This end-unit offers vaulted ceilings with no one above you, new A/C units in the living room and both bedrooms, modern ceiling fans, double-paned windows, and custom roller blinds in the living room. The kitchen features granite countertops and reverse osmosis water filtration.

PLENTY of storage with multiple closets inside AND outside. Plus, there's the convenience of a full-size washer/dryer inside the unit.

The community is perfectly located — just minutes to H-1, Waikele Premium Outlets, golf, dining, and more.

VA buyers — take advantage of an ASSUMABLE VA LOAN.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => daniel@pineapplehi.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 738-2087
        )

    [ListAgentFullName] => Array
        (
            [0] => Daniel Perea
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-09-22T10:16:56.680
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-09-18
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 10:16:56.680
        )

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

    [listing_image] => Array
        (
            [0] => 27157015
            [1] => 27157016
            [2] => 27157017
            [3] => 27157018
            [4] => 27157019
            [5] => 27157020
            [6] => 27157021
            [7] => 27157022
            [8] => 27157023
            [9] => 27157024
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 826
  • Year Built: 1999
  • Building Name: Viewpointe At Waikele

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 2
  • View: Coastline,Mountain,Sunset
  • Listing Office: Talk Realty LLC

  • Maintenance Fees: $589
  • Land Tenure: FS - Fee Simple

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 22, 2025 - 10:16 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.

Terms of Use Privacy Policy DMCA Policy
© Marcus Realty. All Rights Reserved.