Previous Next

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

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202606696"
  }
  ["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) "O204"
  }
  ["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) "475000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPIO GENTRY"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1111) "Welcome home to The Villages at Waipio, a well-maintained and highly desirable pet-friendly community offering comfort, convenience, and exceptional value. This beautifully remodeled upstairs 2-bedroom, 1.5-bath residence features quartz countertops, modern cabinetry, luxury vinyl plank flooring, updated lighting and ceiling fans, and upgraded energy-efficient vinyl windows in the living room to help keep the home cooler and more comfortable. A whole-house fan further improves airflow and cooling. A custom coffee station with added dining storage adds both style and functionality. Enjoy peaceful mountain views, the added privacy of having no neighbors above, and a welcoming outdoor entry landing that offers the perfect space for plants or additional outdoor charm. Both bathrooms have been tastefully upgraded with new tile showers, tile flooring, and vanities. Community amenities include a private pool, clubhouse, playground, and car wash area, all conveniently located near freeway access, Costco Wholesale, Waikele Premium Outlets, golf, dining, and shopping. Schedule your private showing today!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["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) "770"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1987"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(22) "Villages At Waipio The"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "759.23"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Kanoelani"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(9) "Highlands"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(10) "Pearl City"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "LIST"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "hawaiianhomes808@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 265-3906"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Bridget Townsend"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19366182"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-05-24T17:00:02.360"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-05-15"
  }
  ["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) "17:00:02.360"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27394392"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27394392"
    [1]=>
    string(8) "27394393"
    [2]=>
    string(8) "27394394"
    [3]=>
    string(8) "27394395"
    [4]=>
    string(8) "27394396"
    [5]=>
    string(8) "27394397"
    [6]=>
    string(8) "27394398"
    [7]=>
    string(8) "27394399"
    [8]=>
    string(8) "27394400"
    [9]=>
    string(8) "27394401"
    [10]=>
    string(8) "27394402"
    [11]=>
    string(8) "27394403"
    [12]=>
    string(8) "27394404"
    [13]=>
    string(8) "27394405"
    [14]=>
    string(8) "27394406"
    [15]=>
    string(8) "27394407"
    [16]=>
    string(8) "27394408"
    [17]=>
    string(8) "27394409"
    [18]=>
    string(8) "27394410"
    [19]=>
    string(8) "27394411"
    [20]=>
    string(8) "27394412"
    [21]=>
    string(8) "27394413"
    [22]=>
    string(8) "27394414"
    [23]=>
    string(8) "27394415"
    [24]=>
    string(8) "27394416"
    [25]=>
    string(8) "27394417"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202606696
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome home to The Villages at Waipio, a well-maintained and highly desirable pet-friendly community offering comfort, convenience, and exceptional value. This beautifully remodeled upstairs 2-bedroom, 1.5-bath residence features quartz countertops, modern cabinetry, luxury vinyl plank flooring, updated lighting and ceiling fans, and upgraded energy-efficient vinyl windows in the living room to help keep the home cooler and more comfortable. A whole-house fan further improves airflow and cooling. A custom coffee station with added dining storage adds both style and functionality. Enjoy peaceful mountain views, the added privacy of having no neighbors above, and a welcoming outdoor entry landing that offers the perfect space for plants or additional outdoor charm. Both bathrooms have been tastefully upgraded with new tile showers, tile flooring, and vanities. Community amenities include a private pool, clubhouse, playground, and car wash area, all conveniently located near freeway access, Costco Wholesale, Waikele Premium Outlets, golf, dining, and shopping. Schedule your private showing today!
        )

    [ListOfficeName] => Array
        (
            [0] => List Sotheby's Int'l Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => hawaiianhomes808@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 265-3906
        )

    [ListAgentFullName] => Array
        (
            [0] => Bridget Townsend
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-05-24T17:00:02.360
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-05-15
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:00:02.360
        )

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

    [listing_image] => Array
        (
            [0] => 27394392
            [1] => 27394393
            [2] => 27394394
            [3] => 27394395
            [4] => 27394396
            [5] => 27394397
            [6] => 27394398
            [7] => 27394399
            [8] => 27394400
            [9] => 27394401
            [10] => 27394402
            [11] => 27394403
            [12] => 27394404
            [13] => 27394405
            [14] => 27394406
            [15] => 27394407
            [16] => 27394408
            [17] => 27394409
            [18] => 27394410
            [19] => 27394411
            [20] => 27394412
            [21] => 27394413
            [22] => 27394414
            [23] => 27394415
            [24] => 27394416
            [25] => 27394417
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent,Above Average
• Number of Parking Spaces: 1
• View: Garden
• Listing Office: List Sotheby's Int'l Realty

FINANCIAL INFO

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

SCHOOLS

• Elementary School: Kanoelani
• Middle School: Highlands
• High School: Pearl City

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 May 24, 2026 - 5:00 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.