Previous Next

94-246 Leoku Street Unit G125 Waipahu, HI 96797

Listing
Overview

Price: $409,777
Area: WAIPAHU-LOWER
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202519415"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-246"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Leoku"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "G125"
  }
  ["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) "409777.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPAHU-LOWER"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1179) "DO NOT MISS THIS OPPORTUNITY TO OWN This RARERY AVAILABLE GROUND FLR UNIT W/ 10 FT CEILING in Leolua Regent. It has been meticulously renovated with luxury finishes! Featuring 2 bedrooms, 1 bath, & 1 assigned parking & lots of street parking. This stunning condo boasts brand-new stainless steel appliances, new ceiling fans on all bedrooms, floor to ceiling bathroom tiles, fresh paint, soaring 10FT CEILINGS, and elegant luxury vinyl plank flooring throughout, self closing kitchen cabinets & drawers with European style cabinets, quartz countertop, sliding glass door in bathroom, mirror closet & ceiling fans on all bedrooms and dining area, stainless steel appliances & more. Located behind Seafood City Supermarket, Waipahu Shopping Center, & directly across from the Waipahu Post Office, w/ minutes away to freeway exit. Designated parking close to the unit. Move-In Ready & Fully Renovated! Enjoy community amenities, including a sparking pool and laundry facilities. Community amenities include swimming pool & laundry facilities. Maintenance Fee (includes electricity, water, hot water & common area upkeep) + Special Assessment started 9/24 & payable only for 10 years"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "712"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1969"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(13) "Leolua Regent"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "687.35"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Honowai"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "CBPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "leila.corpuz@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Leila C Corpuz"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18960080"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-10-31T14:57:14.600"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-09-03"
  }
  ["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) "14:57:14.600"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27134120"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "27134120"
    [1]=>
    string(8) "27134121"
    [2]=>
    string(8) "27134122"
    [3]=>
    string(8) "27134123"
    [4]=>
    string(8) "27134124"
    [5]=>
    string(8) "27134125"
    [6]=>
    string(8) "27134126"
    [7]=>
    string(8) "27134127"
    [8]=>
    string(8) "27134128"
    [9]=>
    string(8) "27134129"
    [10]=>
    string(8) "27134130"
    [11]=>
    string(8) "27134131"
    [12]=>
    string(8) "27134132"
    [13]=>
    string(8) "27134133"
    [14]=>
    string(8) "27134134"
    [15]=>
    string(8) "27134135"
    [16]=>
    string(8) "27134136"
    [17]=>
    string(8) "27134137"
    [18]=>
    string(8) "27134138"
    [19]=>
    string(8) "27134139"
    [20]=>
    string(8) "27134140"
    [21]=>
    string(8) "27134141"
    [22]=>
    string(8) "27134142"
    [23]=>
    string(8) "27134143"
    [24]=>
    string(8) "27134144"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202519415
        )

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => WAIPAHU-LOWER
        )

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

    [PublicRemarks] => Array
        (
            [0] => DO NOT MISS THIS OPPORTUNITY TO OWN This RARERY AVAILABLE GROUND FLR UNIT W/ 10 FT CEILING in Leolua Regent. It has been meticulously renovated with luxury finishes! Featuring 2 bedrooms, 1 bath, & 1 assigned parking & lots of street parking. This stunning condo boasts brand-new stainless steel appliances, new ceiling fans on all bedrooms, floor to ceiling bathroom tiles, fresh paint, soaring 10FT CEILINGS, and elegant luxury vinyl plank flooring throughout, self closing kitchen cabinets & drawers with European style cabinets, quartz countertop, sliding glass door in bathroom, mirror closet & ceiling fans on all bedrooms and dining area, stainless steel appliances & more. Located behind Seafood City Supermarket, Waipahu Shopping Center, & directly across from the Waipahu Post Office, w/ minutes away to freeway exit. Designated parking close to the unit. Move-In Ready & Fully Renovated! Enjoy community amenities, including a sparking pool and laundry facilities. Community amenities include swimming pool & laundry facilities. Maintenance Fee (includes electricity, water, hot water & common area upkeep) + Special Assessment started 9/24 & payable only for 10 years
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => leila.corpuz@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 596-0456
        )

    [ListAgentFullName] => Array
        (
            [0] => Leila C Corpuz
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-10-31T14:57:14.600
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 14:57:14.600
        )

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

    [listing_image] => Array
        (
            [0] => 27134120
            [1] => 27134121
            [2] => 27134122
            [3] => 27134123
            [4] => 27134124
            [5] => 27134125
            [6] => 27134126
            [7] => 27134127
            [8] => 27134128
            [9] => 27134129
            [10] => 27134130
            [11] => 27134131
            [12] => 27134132
            [13] => 27134133
            [14] => 27134134
            [15] => 27134135
            [16] => 27134136
            [17] => 27134137
            [18] => 27134138
            [19] => 27134139
            [20] => 27134140
            [21] => 27134141
            [22] => 27134142
            [23] => 27134143
            [24] => 27134144
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 1
• Living (sf): 712
• Year Built: 1969
• Building Name: Leolua Regent

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: None
• Listing Office: Coldwell Banker Realty

FINANCIAL INFO

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

SCHOOLS

• Elementary School: Honowai
• Middle School: Waipahu
• High School: Waipahu

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 October 31, 2025 - 2:57 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.