Previous Next

94-246 Leoku Street Unit G125 Waipahu, HI 96797

Listing
Overview

Price: $407,000
Area: WAIPAHU-LOWER
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202605025"
  }
  ["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) "407000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPAHU-LOWER"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1191) "SELLER OFFERING $3000 Seller Credit to buyer at closing for buyer use towards closing costs.  Seller is also offering to cover assessment fee till end of December 2026.  Rarely available GROUND FLOOR unit with 10-ft ceilings in Leolua Regent!  This fully renovated turn-key 2-bedroom, 1-bath condo with 1 assigned parking stall features luxury vinyl plank flooring, fresh paint, quartz countertops, European-style self-closing cabinets, floor-to-ceiling bathroom tile, sliding glass shower door, mirrored closet doors, ceiling fans, and brand-new stainless steel appliances.  Conveniently located near Seafood City, Waipahu Shopping Center, the Post office, and freeway access.  Parking stall is close to the unit with ample street parking available.  Move-in ready and fully renovated, this home also offers access to community amenities including a sparkling swimming pool and laundry facilities.  Maintenance fee of $684.98/month includes electricity, water, hot water, and common area maintenance.  Temporary assessment began September 2024 and is payable for 10 years.  Seller is strictly selling "AS IS" but this is a true gem in a prime location - schedule your private showing today!"
  }
  ["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(9) "166878.00"
  }
  ["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(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "648.98"
  }
  ["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) 679-6878"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Leila C Corpuz"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19308338"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-06T11:22:26.517"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-03-04"
  }
  ["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) "11:22:26.517"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27323419"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "27323419"
    [1]=>
    string(8) "27323420"
    [2]=>
    string(8) "27323421"
    [3]=>
    string(8) "27323422"
    [4]=>
    string(8) "27323423"
    [5]=>
    string(8) "27323424"
    [6]=>
    string(8) "27323425"
    [7]=>
    string(8) "27323426"
    [8]=>
    string(8) "27323427"
    [9]=>
    string(8) "27323428"
    [10]=>
    string(8) "27323429"
    [11]=>
    string(8) "27323430"
    [12]=>
    string(8) "27323431"
    [13]=>
    string(8) "27323432"
    [14]=>
    string(8) "27323433"
    [15]=>
    string(8) "27323434"
    [16]=>
    string(8) "27323435"
    [17]=>
    string(8) "27323436"
    [18]=>
    string(8) "27323437"
    [19]=>
    string(8) "27323438"
    [20]=>
    string(8) "27323439"
    [21]=>
    string(8) "27323440"
    [22]=>
    string(8) "27323441"
    [23]=>
    string(8) "27323442"
    [24]=>
    string(8) "27323443"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202605025
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => SELLER OFFERING $3000 Seller Credit to buyer at closing for buyer use towards closing costs.  Seller is also offering to cover assessment fee till end of December 2026.  Rarely available GROUND FLOOR unit with 10-ft ceilings in Leolua Regent!  This fully renovated turn-key 2-bedroom, 1-bath condo with 1 assigned parking stall features luxury vinyl plank flooring, fresh paint, quartz countertops, European-style self-closing cabinets, floor-to-ceiling bathroom tile, sliding glass shower door, mirrored closet doors, ceiling fans, and brand-new stainless steel appliances.  Conveniently located near Seafood City, Waipahu Shopping Center, the Post office, and freeway access.  Parking stall is close to the unit with ample street parking available.  Move-in ready and fully renovated, this home also offers access to community amenities including a sparkling swimming pool and laundry facilities.  Maintenance fee of $684.98/month includes electricity, water, hot water, and common area maintenance.  Temporary assessment began September 2024 and is payable for 10 years.  Seller is strictly selling "AS IS" but this is a true gem in a prime location - schedule your private showing today!
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [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) 679-6878
        )

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

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-06T11:22:26.517
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-03-04
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:22:26.517
        )

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

    [listing_image] => Array
        (
            [0] => 27323419
            [1] => 27323420
            [2] => 27323421
            [3] => 27323422
            [4] => 27323423
            [5] => 27323424
            [6] => 27323425
            [7] => 27323426
            [8] => 27323427
            [9] => 27323428
            [10] => 27323429
            [11] => 27323430
            [12] => 27323431
            [13] => 27323432
            [14] => 27323433
            [15] => 27323434
            [16] => 27323435
            [17] => 27323436
            [18] => 27323437
            [19] => 27323438
            [20] => 27323439
            [21] => 27323440
            [22] => 27323441
            [23] => 27323442
            [24] => 27323443
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 1
• Land Area (sf): 166,878 sf
• 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: $649
• 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 March 6, 2026 - 11:22 AM Information is deemed reliable but not guaranteed. Copyright: 2026 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.