Previous Next

94-551 Lumiauau Street Waipahu, HI 96797

Listing
Overview

Price: $1,399,000
Area: WAIKELE
Status: Active

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202419217"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-551"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Lumiauau"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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(10) "1399000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1094) "Rarely available Single-Family home in Highland View Estates at Waikele, minutes to Waikele Premium Outlets.  This excellent home with 4 bedrooms 3 full bathrooms just finished with a makeover inside out, brand-new paint interior and exterior.  Open floor plan with family room next to the kitchen, ceramic tiled floor & newly installed vinyl plank flooring, new window coverings, all brand-new window A/Cs in every room.  Renovation includes brand-new kitchen cabinets, appliances, counter tops, deep sinks & faucets, all new bathroom vanities, counter-tops, sinks, vanity mirrors, light fixtures, etc.  Second level features a large open lanai with direct frontage of a beautiful golf course view surrounded with lush greenery; added space includes a loft on second floor; there’s a covered porch area leading out from the living room.  Well-maintained outdoor landscaped yard with natural stone tiles, and all brand-new porch wall lanterns have been replaced.  Property comes with automatic 2-car garage system. Feel the comfort of living in a tranquil, convenient, and great neighborhood!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "Terraco Realty LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5000.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2378"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1994"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(11) "Golf Course"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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) "TRCO"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "helenl@terracorealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 728-9238"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Helen Q Lai"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-01-06T17:16:22.873"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18228453"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(11) "Golf Course"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26685174"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26685174"
    [1]=>
    string(8) "26685175"
    [2]=>
    string(8) "26685176"
    [3]=>
    string(8) "26685177"
    [4]=>
    string(8) "26685178"
    [5]=>
    string(8) "26685179"
    [6]=>
    string(8) "26685180"
    [7]=>
    string(8) "26685181"
    [8]=>
    string(8) "26685182"
    [9]=>
    string(8) "26685183"
    [10]=>
    string(8) "26685184"
    [11]=>
    string(8) "26685185"
    [12]=>
    string(8) "26685186"
    [13]=>
    string(8) "26685187"
    [14]=>
    string(8) "26685188"
    [15]=>
    string(8) "26685189"
    [16]=>
    string(8) "26685190"
    [17]=>
    string(8) "26685191"
    [18]=>
    string(8) "26685192"
    [19]=>
    string(8) "26685193"
    [20]=>
    string(8) "26685194"
    [21]=>
    string(8) "26685195"
    [22]=>
    string(8) "26685196"
    [23]=>
    string(8) "26685197"
    [24]=>
    string(8) "26685198"
    [25]=>
    string(8) "26685199"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-09-06"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:16:22.873"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202419217
        )

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

    [PropertyType] => Array
        (
            [0] => Single Family
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Rarely available Single-Family home in Highland View Estates at Waikele, minutes to Waikele Premium Outlets.  This excellent home with 4 bedrooms 3 full bathrooms just finished with a makeover inside out, brand-new paint interior and exterior.  Open floor plan with family room next to the kitchen, ceramic tiled floor & newly installed vinyl plank flooring, new window coverings, all brand-new window A/Cs in every room.  Renovation includes brand-new kitchen cabinets, appliances, counter tops, deep sinks & faucets, all new bathroom vanities, counter-tops, sinks, vanity mirrors, light fixtures, etc.  Second level features a large open lanai with direct frontage of a beautiful golf course view surrounded with lush greenery; added space includes a loft on second floor; there’s a covered porch area leading out from the living room.  Well-maintained outdoor landscaped yard with natural stone tiles, and all brand-new porch wall lanterns have been replaced.  Property comes with automatic 2-car garage system. Feel the comfort of living in a tranquil, convenient, and great neighborhood!
        )

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

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Golf Course
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => helenl@terracorealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 728-9238
        )

    [ListAgentFullName] => Array
        (
            [0] => Helen Q Lai
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-01-06T17:16:22.873
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26685174
            [1] => 26685175
            [2] => 26685176
            [3] => 26685177
            [4] => 26685178
            [5] => 26685179
            [6] => 26685180
            [7] => 26685181
            [8] => 26685182
            [9] => 26685183
            [10] => 26685184
            [11] => 26685185
            [12] => 26685186
            [13] => 26685187
            [14] => 26685188
            [15] => 26685189
            [16] => 26685190
            [17] => 26685191
            [18] => 26685192
            [19] => 26685193
            [20] => 26685194
            [21] => 26685195
            [22] => 26685196
            [23] => 26685197
            [24] => 26685198
            [25] => 26685199
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-09-06
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:16:22.873
        )

)

PROPERTY INFO

• BedsTotal: 4
• Full Baths: 3
• Land Area (sf): 5,000 sf
• Living (sf): 2,378
• Year Built: 1994

KEY FEATURES

• Property Condition: Excellent,Above Average
• Number of Parking Spaces: 4
• View: Golf Course
• Listing Office: Terraco Realty LLC

FINANCIAL INFO

• 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 January 6, 2025 - 5:16 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.