94-1463 Waipio Uka Street Unit R101 Waipahu, HI 96797

Listing
Overview

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

ONLY LISTING AT THE POPULAR THE VILLAGES AT WAIPIO!!! Newly remodeled 2 bedroom 1 and 2 half baths. New flooring, appliances, quartz countertops and cabinets! Great elevated corner/end location that gives you the sense of privacy. Two story unit with a great big private fenced in yard, perfect for your pets, kids and friends to enjoy! Great place to host gatherings. Two half baths, with one on the lower level, which includes the stack washer & dryer. This spacious home has extra storage under the stairs, as well as a nice walk-in closet in the main bedroom. Ceiling fans and window A/Cs, but the cross breeze makes it very comfortable. The designated parking stall is in front and steps away. Guest parking available, as well as pool, playground and clubhouse to maximize your resort lifestyle at the complex. Easy to access H-2, right off of Ka Uka Blvd., near all the great shopping (Waikele Outlet Stores, Costco) and dining spots in Waipio & Waikele. Convenient to head to town, Ewa side or North Shore! For Military families, quick commute to Schofield Barracks, Wheeler Air Force Base & Hickam Air Force Base. Selling "As Is". Listing by: L. T. Service (808) 222-1788

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202421854"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "94-1463"
  }
  ["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) "R101"
  }
  ["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) "630000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "630000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPIO GENTRY"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1150) "ONLY LISTING AT THE POPULAR THE VILLAGES AT WAIPIO!!! Newly remodeled 2 bedroom 1 and 2 half baths. New flooring, appliances, quartz countertops and cabinets!  Great elevated corner/end location that gives you the sense of privacy.  Two story unit with a great big private fenced in yard, perfect for your pets, kids and friends to enjoy!  Great place to host gatherings.  Two half baths, with one on the lower level, which includes the stack washer & dryer.  This spacious home has extra storage under the stairs, as well as a nice walk-in closet in the main bedroom. Ceiling fans and window A/Cs, but the cross breeze makes it very comfortable.  The designated parking stall is in front and steps away.  Guest parking available, as well as pool, playground and clubhouse to maximize your resort lifestyle at the complex.  Easy to access H-2, right off of Ka Uka Blvd., near all the great shopping (Waikele Outlet Stores, Costco) and dining spots in Waipio & Waikele.  Convenient to head to town, Ewa side or North Shore! For Military families, quick commute to Schofield Barracks, Wheeler Air Force Base & Hickam Air Force Base.  Selling 
"As Is"."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "L. T. Service"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "470230.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "978"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1987"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(22) "Villages at Waipio The"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "712.43"
  }
  ["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) "LTSE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "BrianUy@icloud.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 222-1788"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(8) "Brian Uy"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-21T12:41:11.173"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18283742"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-25T17:08:06.187"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26708986"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26708986"
    [1]=>
    string(8) "26708987"
    [2]=>
    string(8) "26708988"
    [3]=>
    string(8) "26708989"
    [4]=>
    string(8) "26708990"
    [5]=>
    string(8) "26708991"
    [6]=>
    string(8) "26708992"
    [7]=>
    string(8) "26708993"
    [8]=>
    string(8) "26708994"
    [9]=>
    string(8) "26708995"
    [10]=>
    string(8) "26708996"
    [11]=>
    string(8) "26708997"
    [12]=>
    string(8) "26708998"
    [13]=>
    string(8) "26708999"
    [14]=>
    string(8) "26709000"
    [15]=>
    string(8) "26709001"
    [16]=>
    string(8) "26709002"
    [17]=>
    string(8) "26709003"
    [18]=>
    string(8) "26709004"
    [19]=>
    string(8) "26709005"
    [20]=>
    string(8) "26709006"
    [21]=>
    string(8) "26709007"
    [22]=>
    string(8) "26713957"
    [23]=>
    string(8) "26713958"
    [24]=>
    string(8) "26713959"
    [25]=>
    string(8) "26713960"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202421854
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => ONLY LISTING AT THE POPULAR THE VILLAGES AT WAIPIO!!! Newly remodeled 2 bedroom 1 and 2 half baths. New flooring, appliances, quartz countertops and cabinets!  Great elevated corner/end location that gives you the sense of privacy.  Two story unit with a great big private fenced in yard, perfect for your pets, kids and friends to enjoy!  Great place to host gatherings.  Two half baths, with one on the lower level, which includes the stack washer & dryer.  This spacious home has extra storage under the stairs, as well as a nice walk-in closet in the main bedroom. Ceiling fans and window A/Cs, but the cross breeze makes it very comfortable.  The designated parking stall is in front and steps away.  Guest parking available, as well as pool, playground and clubhouse to maximize your resort lifestyle at the complex.  Easy to access H-2, right off of Ka Uka Blvd., near all the great shopping (Waikele Outlet Stores, Costco) and dining spots in Waipio & Waikele.  Convenient to head to town, Ewa side or North Shore! For Military families, quick commute to Schofield Barracks, Wheeler Air Force Base & Hickam Air Force Base.  Selling 
"As Is".
        )

    [ListOfficeName] => Array
        (
            [0] => L. T. Service
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => BrianUy@icloud.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 222-1788
        )

    [ListAgentFullName] => Array
        (
            [0] => Brian Uy
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-21T12:41:11.173
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-09-25T17:08:06.187
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26708986
            [1] => 26708987
            [2] => 26708988
            [3] => 26708989
            [4] => 26708990
            [5] => 26708991
            [6] => 26708992
            [7] => 26708993
            [8] => 26708994
            [9] => 26708995
            [10] => 26708996
            [11] => 26708997
            [12] => 26708998
            [13] => 26708999
            [14] => 26709000
            [15] => 26709001
            [16] => 26709002
            [17] => 26709003
            [18] => 26709004
            [19] => 26709005
            [20] => 26709006
            [21] => 26709007
            [22] => 26713957
            [23] => 26713958
            [24] => 26713959
            [25] => 26713960
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Half Baths: 2
  • Land Area (sf): 470,230
  • Living (sf): 978
  • Year Built: 1987
  • Building Name: Villages at Waipio The

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: Mountain,Ocean
  • Listing Office: L. T. Service

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

CONTACT US

Marcus Realty

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