94-099 Waipahu Street Unit B318 Waipahu, HI 96797

Listing
Overview

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

Tenant-occupied with a one-year lease in place; sale subject to existing tenancy. Leolua Regent one-bedroom, third-floor end unit offering stable rental income and low operating overhead. The end-unit layout provides added privacy and natural light, with garden and pool views from both the living room and bedroom. Located near the rail station with shopping and dining nearby, supporting consistent tenant demand. Includes a desirable end parking stall visible from the unit, with additional street parking available along Waipahu Street and Leoku Street. Maintenance fees include all utilities, simplifying expense management. Building amenities include a pool, community laundry, and on-site resident manager. Listing by: Realty Brokerage LLC (808) 224-4292

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202601389"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-099"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "B318"
  }
  ["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) "270000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPAHU-LOWER"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(716) "Tenant-occupied with a one-year lease in place; sale subject to existing tenancy.
Leolua Regent one-bedroom, third-floor end unit offering stable rental income and low operating overhead. The end-unit layout provides added privacy and natural light, with garden and pool views from both the living room and bedroom.
Located near the rail station with shopping and dining nearby, supporting consistent tenant demand. Includes a desirable end parking stall visible from the unit, with additional street parking available along Waipahu Street and Leoku Street.
Maintenance fees include all utilities, simplifying expense management. Building amenities include a pool, community laundry, and on-site resident manager."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(20) "Realty Brokerage LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["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) "447"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1965"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(13) "Leolua Regent"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(5) "Three"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "490.20"
  }
  ["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) "RBRO"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "Shirley.Ames@outlook.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 224-4292"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Shirley C Ames"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19226595"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-01-22T16:36:59.577"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-01-22"
  }
  ["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) "16:36:59.577"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27280609"
  }
  ["listing_image"]=>
  array(15) {
    [0]=>
    string(8) "27280609"
    [1]=>
    string(8) "27280610"
    [2]=>
    string(8) "27280611"
    [3]=>
    string(8) "27280612"
    [4]=>
    string(8) "27280613"
    [5]=>
    string(8) "27280614"
    [6]=>
    string(8) "27280615"
    [7]=>
    string(8) "27280616"
    [8]=>
    string(8) "27280617"
    [9]=>
    string(8) "27280618"
    [10]=>
    string(8) "27280619"
    [11]=>
    string(8) "27280620"
    [12]=>
    string(8) "27280621"
    [13]=>
    string(8) "27280622"
    [14]=>
    string(8) "27280623"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202601389
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Tenant-occupied with a one-year lease in place; sale subject to existing tenancy.
Leolua Regent one-bedroom, third-floor end unit offering stable rental income and low operating overhead. The end-unit layout provides added privacy and natural light, with garden and pool views from both the living room and bedroom.
Located near the rail station with shopping and dining nearby, supporting consistent tenant demand. Includes a desirable end parking stall visible from the unit, with additional street parking available along Waipahu Street and Leoku Street.
Maintenance fees include all utilities, simplifying expense management. Building amenities include a pool, community laundry, and on-site resident manager.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Shirley.Ames@outlook.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 224-4292
        )

    [ListAgentFullName] => Array
        (
            [0] => Shirley C Ames
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-01-22T16:36:59.577
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-01-22
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:36:59.577
        )

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

    [listing_image] => Array
        (
            [0] => 27280609
            [1] => 27280610
            [2] => 27280611
            [3] => 27280612
            [4] => 27280613
            [5] => 27280614
            [6] => 27280615
            [7] => 27280616
            [8] => 27280617
            [9] => 27280618
            [10] => 27280619
            [11] => 27280620
            [12] => 27280621
            [13] => 27280622
            [14] => 27280623
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Land Area (sf): 166,878 sf
  • Living (sf): 447
  • Year Built: 1965
  • Building Name: Leolua Regent

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: Garden
  • Listing Office: Realty Brokerage LLC

  • Maintenance Fees: $490
  • 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 January 22, 2026 - 4:36 PM 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.

© Marcus Realty. All Rights Reserved.