94-509 Lumiauau Street Waipahu, HI 96797

Listing
Overview

Price: $1,350,000
Area: WAIKELE
Status: Active Under Contract

Beautifully updated Waikele single-family home views over the fairway of the Waikele Country Club features vaulted ceilings and a light-filled living room that frames the golf course vista. Downstairs, a large covered lanai invites relaxing evenings and entertaining, while upstairs, the primary bedroom extends onto a large balcony/lanai, offering sweeping views, breeze and a private outdoor retreat. The generous lot offers a large backyard, perfect for outdoor activities and leisure, and the driveway accommodates more than three (3+) parking spaces, vaulted ceiling, 28 PV Owned panels, a bedroom downstairs with a shower. Convenience reigns: this home is just minutes from direct freeway access, Waikele Premium Outlets and surrounding shopping/dining. Combine all this with the feel of an elevated, resort-style backyard view, and you have a home that blends comfort, style and practicality. Truly...one that balances outstanding, ample outdoor space, impressive parking and a premier fairway view setting. Listing by: Coldwell Banker Realty (808) 676-7200

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202525916"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-509"
  }
  ["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) "1350000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKELE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1014) "Beautifully updated Waikele single-family home views over the fairway of the Waikele Country Club features vaulted ceilings and a light-filled living room that frames the golf course vista. Downstairs, a large covered lanai invites relaxing evenings and entertaining, while upstairs, the primary bedroom extends onto a large balcony/lanai, offering sweeping views, breeze and a private outdoor retreat. The generous lot offers a large backyard, perfect for outdoor activities and leisure, and the driveway accommodates more than three (3+) parking spaces, vaulted ceiling, 28 PV Owned panels, a bedroom downstairs with a shower. Convenience reigns: this home is just minutes from direct freeway access, Waikele Premium Outlets and surrounding shopping/dining. Combine all this with the feel of an elevated, resort-style backyard view, and you have a home that blends comfort, style and practicality. Truly...one that balances outstanding, ample outdoor space, impressive parking and a premier fairway view setting."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["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) "6101.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1703"
  }
  ["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) "3"
  }
  ["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(6) "CBPP15"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "janie.kim@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 676-7200"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(9) "Janie Kim"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19132132"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-12-27T17:22:38.300"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-12-05"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(17) "Golf Course,Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:22:38.300"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27238658"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27238658"
    [1]=>
    string(8) "27238659"
    [2]=>
    string(8) "27238660"
    [3]=>
    string(8) "27238661"
    [4]=>
    string(8) "27238662"
    [5]=>
    string(8) "27238663"
    [6]=>
    string(8) "27238664"
    [7]=>
    string(8) "27238665"
    [8]=>
    string(8) "27238666"
    [9]=>
    string(8) "27238667"
    [10]=>
    string(8) "27238668"
    [11]=>
    string(8) "27238669"
    [12]=>
    string(8) "27238670"
    [13]=>
    string(8) "27238671"
    [14]=>
    string(8) "27238672"
    [15]=>
    string(8) "27238673"
    [16]=>
    string(8) "27238674"
    [17]=>
    string(8) "27238675"
    [18]=>
    string(8) "27238676"
    [19]=>
    string(8) "27238677"
    [20]=>
    string(8) "27238678"
    [21]=>
    string(8) "27238679"
    [22]=>
    string(8) "27238680"
    [23]=>
    string(8) "27238681"
    [24]=>
    string(8) "27238682"
    [25]=>
    string(8) "27238683"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202525916
        )

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

    [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] => 1350000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Beautifully updated Waikele single-family home views over the fairway of the Waikele Country Club features vaulted ceilings and a light-filled living room that frames the golf course vista. Downstairs, a large covered lanai invites relaxing evenings and entertaining, while upstairs, the primary bedroom extends onto a large balcony/lanai, offering sweeping views, breeze and a private outdoor retreat. The generous lot offers a large backyard, perfect for outdoor activities and leisure, and the driveway accommodates more than three (3+) parking spaces, vaulted ceiling, 28 PV Owned panels, a bedroom downstairs with a shower. Convenience reigns: this home is just minutes from direct freeway access, Waikele Premium Outlets and surrounding shopping/dining. Combine all this with the feel of an elevated, resort-style backyard view, and you have a home that blends comfort, style and practicality. Truly...one that balances outstanding, ample outdoor space, impressive parking and a premier fairway view setting.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

    [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] => CBPP15
        )

    [ListAgentEmail] => Array
        (
            [0] => janie.kim@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 676-7200
        )

    [ListAgentFullName] => Array
        (
            [0] => Janie Kim
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-12-27T17:22:38.300
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-12-05
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:22:38.300
        )

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

    [listing_image] => Array
        (
            [0] => 27238658
            [1] => 27238659
            [2] => 27238660
            [3] => 27238661
            [4] => 27238662
            [5] => 27238663
            [6] => 27238664
            [7] => 27238665
            [8] => 27238666
            [9] => 27238667
            [10] => 27238668
            [11] => 27238669
            [12] => 27238670
            [13] => 27238671
            [14] => 27238672
            [15] => 27238673
            [16] => 27238674
            [17] => 27238675
            [18] => 27238676
            [19] => 27238677
            [20] => 27238678
            [21] => 27238679
            [22] => 27238680
            [23] => 27238681
            [24] => 27238682
            [25] => 27238683
        )

)

  • BedsTotal: 4
  • Full Baths: 3
  • Land Area (sf): 6,101 sf
  • Living (sf): 1,703
  • Year Built: 1994

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 3
  • View: Golf Course
  • Listing Office: Coldwell Banker Realty

  • 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 December 27, 2025 - 5:22 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.

© Marcus Realty. All Rights Reserved.