94-1457 Waipio Uka Street Unit O203 Waipahu, HI 96797

Take a Virtual Tour

Listing
Overview

Price: $480,000
Area: WAIPIO GENTRY
Status: Active

Great starter home and a wonderful opportunity for a first-time homebuyer. This charming two-bedroom townhome features an open kitchen and open-concept layout that creates a bright, comfortable living space. The primary bedroom includes a convenient half bath, while a full bathroom serves the home. Good storage space and AC to keep you cool. Assigned parking stall included for added convenience. Located in The Villages at Waipio, residents can enjoy the playground, clubhouse, pool and lounging area, car wash area and a pet-friendly environment. Centrally situated in the vibrant Waipio Gentry neighborhood, you’ll appreciate the easy access to everything you need—Central Oahu Regional Park, Costco, Foodland, Waikele Outlets, Lowe’s, OfficeMax, Petco, and more, all within a short commute. Schedule your private showing today and make this townhome your own! Some photos have been virtually staged. Listing by: Redfin Corporation (808) 201-2821

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202528097"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "94-1457"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(10) "Waipio Uka"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "O203"
  }
  ["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(51) "https://my.matterport.com/show/?m=9sE91ULUZiy&mls=1"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "480000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPIO GENTRY"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(911) "Great starter home and a wonderful opportunity for a first-time homebuyer. This charming two-bedroom townhome features an open kitchen and open-concept layout that creates a bright, comfortable living space. The primary bedroom includes a convenient half bath, while a full bathroom serves the home. Good storage space and AC to keep you cool. Assigned parking stall included for added convenience. Located in The Villages at Waipio, residents can enjoy the playground, clubhouse, pool and lounging area, car wash area and a pet-friendly environment. Centrally situated in the vibrant Waipio Gentry neighborhood, you’ll appreciate the easy access to everything you need—Central Oahu Regional Park, Costco, Foodland, Waikele Outlets, Lowe’s, OfficeMax, Petco, and more, all within a short commute. Schedule your private showing today and make this townhome your own! Some photos have been virtually staged."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "Redfin Corporation"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "871"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1987"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(22) "Villages At Waipio The"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "723.41"
  }
  ["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) "RFIN"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "shannon.among@redfin.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 201-2821"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Shannon P Among"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19175904"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-12-26T12:19:25.497"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-12-23"
  }
  ["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) "12:19:25.497"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27252959"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27252959"
    [1]=>
    string(8) "27252960"
    [2]=>
    string(8) "27252961"
    [3]=>
    string(8) "27252962"
    [4]=>
    string(8) "27252963"
    [5]=>
    string(8) "27252964"
    [6]=>
    string(8) "27252965"
    [7]=>
    string(8) "27252966"
    [8]=>
    string(8) "27252967"
    [9]=>
    string(8) "27252968"
    [10]=>
    string(8) "27252969"
    [11]=>
    string(8) "27252970"
    [12]=>
    string(8) "27252971"
    [13]=>
    string(8) "27252972"
    [14]=>
    string(8) "27252973"
    [15]=>
    string(8) "27252974"
    [16]=>
    string(8) "27252975"
    [17]=>
    string(8) "27252976"
    [18]=>
    string(8) "27252977"
    [19]=>
    string(8) "27252978"
    [20]=>
    string(8) "27252979"
    [21]=>
    string(8) "27252980"
    [22]=>
    string(8) "27252981"
    [23]=>
    string(8) "27254326"
    [24]=>
    string(8) "27254327"
    [25]=>
    string(8) "27254328"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202528097
        )

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

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

    [StreetName] => Array
        (
            [0] => Waipio Uka
        )

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://my.matterport.com/show/?m=9sE91ULUZiy&mls=1
        )

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

    [Neighbourhood] => Array
        (
            [0] => WAIPIO GENTRY
        )

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

    [PublicRemarks] => Array
        (
            [0] => Great starter home and a wonderful opportunity for a first-time homebuyer. This charming two-bedroom townhome features an open kitchen and open-concept layout that creates a bright, comfortable living space. The primary bedroom includes a convenient half bath, while a full bathroom serves the home. Good storage space and AC to keep you cool. Assigned parking stall included for added convenience. Located in The Villages at Waipio, residents can enjoy the playground, clubhouse, pool and lounging area, car wash area and a pet-friendly environment. Centrally situated in the vibrant Waipio Gentry neighborhood, you’ll appreciate the easy access to everything you need—Central Oahu Regional Park, Costco, Foodland, Waikele Outlets, Lowe’s, OfficeMax, Petco, and more, all within a short commute. Schedule your private showing today and make this townhome your own! Some photos have been virtually staged.
        )

    [ListOfficeName] => Array
        (
            [0] => Redfin Corporation
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Villages At Waipio The
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => shannon.among@redfin.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 201-2821
        )

    [ListAgentFullName] => Array
        (
            [0] => Shannon P Among
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-12-26T12:19:25.497
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 12:19:25.497
        )

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

    [listing_image] => Array
        (
            [0] => 27252959
            [1] => 27252960
            [2] => 27252961
            [3] => 27252962
            [4] => 27252963
            [5] => 27252964
            [6] => 27252965
            [7] => 27252966
            [8] => 27252967
            [9] => 27252968
            [10] => 27252969
            [11] => 27252970
            [12] => 27252971
            [13] => 27252972
            [14] => 27252973
            [15] => 27252974
            [16] => 27252975
            [17] => 27252976
            [18] => 27252977
            [19] => 27252978
            [20] => 27252979
            [21] => 27252980
            [22] => 27252981
            [23] => 27254326
            [24] => 27254327
            [25] => 27254328
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Half Baths: 1
  • Living (sf): 871
  • Year Built: 1987
  • Building Name: Villages At Waipio The

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: None
  • Listing Office: Redfin Corporation

  • Maintenance Fees: $723
  • 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 26, 2025 - 12:19 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.