94-1451 Waipio Uka Street Unit L203 Waipahu, HI 96797

Listing
Overview

Price: $528,000
Area: WAIPIO GENTRY
Status: Active Under Contract

Welcome to pet-friendly (verify) Unit L203 at The Villages at Waipio. Lounge in the open living area with mountain views from the breezy lanai, or shut the windows and turn on the mini-split ACs units. Experience the luxury of fully renovated bathrooms with rainfall shower heads, a deep soaking tub, soft-close pocket doors, tiled walls and floors, a new stacked washer/dryer, and modern vanities. Enjoy the modern kitchen which boasts soft-close cabinetry, a pantry with deep drawers, an upgraded faucet, a garbage disposal, and a sleek new stainless steel refrigerator. Rest easy with a mobile-compatible Ring security system, and enjoy the convenience of attic storage with a collapsible ladder and USB charging ports throughout. This vibrant neighborhood of Waipio Gentry has everything you need within a short commute. Enjoy recreational activities at Patsy T. Mink Park. Grab groceries at Foodland or tackle errands at the nearby shopping center featuring Costco, Foodland and more. Need more shopping? Waikele Outlets are just down the road, offering Safeway, Lowe's, Office Max and Petco. Schedule your private showing today or join us for our weekly open houses! Listing by: Keller Williams Honolulu (951) 250-0565

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202417539"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "94-1451"
  }
  ["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) "L203"
  }
  ["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) "528000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "528000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPIO GENTRY"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1175) "Welcome to pet-friendly (verify) Unit L203 at The Villages at Waipio. Lounge in the open living area with mountain views from the breezy lanai, or shut the windows and turn on the mini-split ACs units. Experience the luxury of fully renovated bathrooms with rainfall shower heads, a deep soaking tub, soft-close pocket doors, tiled walls and floors, a new stacked washer/dryer, and modern vanities. Enjoy the modern kitchen which boasts soft-close cabinetry, a pantry with deep drawers, an upgraded faucet, a garbage disposal, and a sleek new stainless steel refrigerator. Rest easy with a mobile-compatible Ring security system, and enjoy the convenience of attic storage with a collapsible ladder and USB charging ports throughout.

This vibrant neighborhood of Waipio Gentry has everything you need within a short commute. Enjoy recreational activities at Patsy T. Mink Park. Grab groceries at Foodland or tackle errands at the nearby shopping center featuring Costco, Foodland and more. Need more shopping? Waikele Outlets are just down the road, offering Safeway, Lowe's, Office Max and Petco. Schedule your private showing today or join us for our weekly open houses!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "Keller Williams Honolulu"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "470230.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "912"
  }
  ["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(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "664.34"
  }
  ["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) "KWPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "julie.principe@kw.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(951) 250-0565"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Julie Principe"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-16T09:46:47.267"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18180472"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-08T16:22:05.097"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26662125"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26662125"
    [1]=>
    string(8) "26662126"
    [2]=>
    string(8) "26662127"
    [3]=>
    string(8) "26662128"
    [4]=>
    string(8) "26662129"
    [5]=>
    string(8) "26662130"
    [6]=>
    string(8) "26662131"
    [7]=>
    string(8) "26662132"
    [8]=>
    string(8) "26662133"
    [9]=>
    string(8) "26662134"
    [10]=>
    string(8) "26662135"
    [11]=>
    string(8) "26662136"
    [12]=>
    string(8) "26662137"
    [13]=>
    string(8) "26662138"
    [14]=>
    string(8) "26662139"
    [15]=>
    string(8) "26662140"
    [16]=>
    string(8) "26662141"
    [17]=>
    string(8) "26662142"
    [18]=>
    string(8) "26662143"
    [19]=>
    string(8) "26662144"
    [20]=>
    string(8) "26662145"
    [21]=>
    string(8) "26662146"
    [22]=>
    string(8) "26662147"
    [23]=>
    string(8) "26662148"
    [24]=>
    string(8) "26662149"
    [25]=>
    string(8) "26662150"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202417539
        )

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

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

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

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

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

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

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

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

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

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

    [CurrentPrice] => Array
        (
            [0] => 528000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to pet-friendly (verify) Unit L203 at The Villages at Waipio. Lounge in the open living area with mountain views from the breezy lanai, or shut the windows and turn on the mini-split ACs units. Experience the luxury of fully renovated bathrooms with rainfall shower heads, a deep soaking tub, soft-close pocket doors, tiled walls and floors, a new stacked washer/dryer, and modern vanities. Enjoy the modern kitchen which boasts soft-close cabinetry, a pantry with deep drawers, an upgraded faucet, a garbage disposal, and a sleek new stainless steel refrigerator. Rest easy with a mobile-compatible Ring security system, and enjoy the convenience of attic storage with a collapsible ladder and USB charging ports throughout.

This vibrant neighborhood of Waipio Gentry has everything you need within a short commute. Enjoy recreational activities at Patsy T. Mink Park. Grab groceries at Foodland or tackle errands at the nearby shopping center featuring Costco, Foodland and more. Need more shopping? Waikele Outlets are just down the road, offering Safeway, Lowe's, Office Max and Petco. Schedule your private showing today or join us for our weekly open houses!
        )

    [ListOfficeName] => Array
        (
            [0] => Keller Williams Honolulu
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => julie.principe@kw.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (951) 250-0565
        )

    [ListAgentFullName] => Array
        (
            [0] => Julie Principe
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-16T09:46:47.267
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-08T16:22:05.097
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26662125
            [1] => 26662126
            [2] => 26662127
            [3] => 26662128
            [4] => 26662129
            [5] => 26662130
            [6] => 26662131
            [7] => 26662132
            [8] => 26662133
            [9] => 26662134
            [10] => 26662135
            [11] => 26662136
            [12] => 26662137
            [13] => 26662138
            [14] => 26662139
            [15] => 26662140
            [16] => 26662141
            [17] => 26662142
            [18] => 26662143
            [19] => 26662144
            [20] => 26662145
            [21] => 26662146
            [22] => 26662147
            [23] => 26662148
            [24] => 26662149
            [25] => 26662150
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Land Area (sf): 470,230
  • Living (sf): 912
  • Year Built: 1987
  • Building Name: Villages At Waipio The

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 1
  • View: Mountain
  • Listing Office: Keller Williams Honolulu

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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446