94-510 Lumiaina Street Unit J101 Waipahu, HI 96797

Listing
Overview

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

Experience comfort and convenience in this beautifully updated home, ready for you to move in! This rare ground-floor corner unit features 3 bedrooms, 2 full baths, and a spacious fully fenced courtyard with a lanai—perfect for outdoor living. The recently renovated kitchen boasts new quartz countertops and sleek cabinets, adding a modern touch to this cozy space. Additional updates include recently installed vinyl flooring. With one covered and one open parking space, this home is just minutes from Waikele Premium Outlets, shopping, dining, and easy freeway access. Don’t miss this opportunity! Special Assessment is for insurance and it is only from January 2025 through March 2025; To be paid in full by Sellers at closing. Seller is offering $5,000 credits towards the primary bathroom repair and patch painting. Listing by: Five Star Realty, Inc. (808) 753-7211

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202501354"
  }
  ["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) "J101"
  }
  ["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) "699000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(827) "Experience comfort and convenience in this beautifully updated home, ready for you to move in! This rare ground-floor corner unit features 3 bedrooms, 2 full baths, and a spacious fully fenced courtyard with a lanai—perfect for outdoor living. The recently renovated kitchen boasts new quartz countertops and sleek cabinets, adding a modern touch to this cozy space. Additional updates include recently installed vinyl flooring. With one covered and one open parking space, this home is just minutes from Waikele Premium Outlets, shopping, dining, and easy freeway access. Don’t miss this opportunity! Special Assessment is for insurance and it is only from January 2025 through March 2025; To be paid in full by Sellers at closing.  Seller is offering $5,000 credits towards the primary bathroom repair and patch painting."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Five Star Realty, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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(4) "1024"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1999"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(21) "Viewpointe at Waikele"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["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) "730.13"
  }
  ["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(6) "FIVE02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "Ruth@RuthSells.Homes"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 753-7211"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(19) "Ruth Manzano Javier"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18475618"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-16T15:00:01.053"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-01-06"
  }
  ["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) "15:00:01.053"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26828675"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26828675"
    [1]=>
    string(8) "26828676"
    [2]=>
    string(8) "26828677"
    [3]=>
    string(8) "26828678"
    [4]=>
    string(8) "26828679"
    [5]=>
    string(8) "26828680"
    [6]=>
    string(8) "26828681"
    [7]=>
    string(8) "26828682"
    [8]=>
    string(8) "26828683"
    [9]=>
    string(8) "26828684"
    [10]=>
    string(8) "26828685"
    [11]=>
    string(8) "26828686"
    [12]=>
    string(8) "26828687"
    [13]=>
    string(8) "26828688"
    [14]=>
    string(8) "26828689"
    [15]=>
    string(8) "26828690"
    [16]=>
    string(8) "26828691"
    [17]=>
    string(8) "26828692"
    [18]=>
    string(8) "26828693"
    [19]=>
    string(8) "26828694"
    [20]=>
    string(8) "26828695"
    [21]=>
    string(8) "26828696"
    [22]=>
    string(8) "26828697"
    [23]=>
    string(8) "26828698"
    [24]=>
    string(8) "26828699"
    [25]=>
    string(8) "26828700"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202501354
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience comfort and convenience in this beautifully updated home, ready for you to move in! This rare ground-floor corner unit features 3 bedrooms, 2 full baths, and a spacious fully fenced courtyard with a lanai—perfect for outdoor living. The recently renovated kitchen boasts new quartz countertops and sleek cabinets, adding a modern touch to this cozy space. Additional updates include recently installed vinyl flooring. With one covered and one open parking space, this home is just minutes from Waikele Premium Outlets, shopping, dining, and easy freeway access. Don’t miss this opportunity! Special Assessment is for insurance and it is only from January 2025 through March 2025; To be paid in full by Sellers at closing.  Seller is offering $5,000 credits towards the primary bathroom repair and patch painting.
        )

    [ListOfficeName] => Array
        (
            [0] => Five Star Realty, Inc.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Ruth@RuthSells.Homes
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 753-7211
        )

    [ListAgentFullName] => Array
        (
            [0] => Ruth Manzano Javier
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-16T15:00:01.053
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-01-06
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:00:01.053
        )

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

    [listing_image] => Array
        (
            [0] => 26828675
            [1] => 26828676
            [2] => 26828677
            [3] => 26828678
            [4] => 26828679
            [5] => 26828680
            [6] => 26828681
            [7] => 26828682
            [8] => 26828683
            [9] => 26828684
            [10] => 26828685
            [11] => 26828686
            [12] => 26828687
            [13] => 26828688
            [14] => 26828689
            [15] => 26828690
            [16] => 26828691
            [17] => 26828692
            [18] => 26828693
            [19] => 26828694
            [20] => 26828695
            [21] => 26828696
            [22] => 26828697
            [23] => 26828698
            [24] => 26828699
            [25] => 26828700
        )

)

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

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: None
  • Listing Office: Five Star Realty, Inc.

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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446