94-559 Hiaku Place Waipahu, HI 96797

Listing
Overview

Price: $1,250,000
Area: WAIPAHU-LOWER
Status: Active

Calling all investors or multi-generational families! This unique Waipahu property offers endless possibilities. Located on a fenced in lot, this fixer upper features 4 separate living units, which is perfect for rental income, a family compound, or potential redevelopment. Downstairs: Two units, each with 2 bedrooms and 1 bathroom. Upstairs: A spacious 4-bedroom, 2-bathroom unit alongside a renovated 1-bedroom, 1-bathroom unit. Additionally, there is a detached recreation room with its own street access, as well as ample street parking on Waipahu Street. The large patio and backyard space offer endless possibilities for outdoor gatherings and relaxation. This property is in need of some TLC but offers great potential for those ready to bring it to life. Don't miss out on this incredible opportunity to invest in the heart of Waipahu! Listing by: SC Realty, LLC (808) 687-1314

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202423423"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-559"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Hiaku"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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(10) "1250000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1250000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "WAIPAHU-LOWER"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(845) "Calling all investors or multi-generational families! This unique Waipahu property offers endless possibilities. Located on a fenced in lot, this fixer upper features 4 separate living units, which is perfect for rental income, a family compound, or potential redevelopment. Downstairs: Two units, each with 2 bedrooms and 1 bathroom. Upstairs: A spacious 4-bedroom, 2-bathroom unit alongside a renovated 1-bedroom, 1-bathroom unit. Additionally, there is a detached recreation room with its own street access, as well as ample street parking on Waipahu Street. The large patio and backyard space offer endless possibilities for outdoor gatherings and relaxation. This property is in need of some TLC but offers great potential for those ready to bring it to life. Don't miss out on this incredible opportunity to invest in the heart of Waipahu!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "SC Realty, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "9180.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "4536"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1972"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(18) "Needs Major Repair"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(13) "August Ahrens"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "SCRE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "dchong@screaltyhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 687-1314"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Daniel K Chong"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-21T11:28:17.170"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18310229"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-18T15:14:12.830"
  }
  ["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) "26737079"
  }
  ["listing_image"]=>
  array(10) {
    [0]=>
    string(8) "26737079"
    [1]=>
    string(8) "26737080"
    [2]=>
    string(8) "26737081"
    [3]=>
    string(8) "26737082"
    [4]=>
    string(8) "26737083"
    [5]=>
    string(8) "26737084"
    [6]=>
    string(8) "26737085"
    [7]=>
    string(8) "26737086"
    [8]=>
    string(8) "26737087"
    [9]=>
    string(8) "26737088"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202423423
        )

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

    [PropertyType] => Array
        (
            [0] => Single Family
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Calling all investors or multi-generational families! This unique Waipahu property offers endless possibilities. Located on a fenced in lot, this fixer upper features 4 separate living units, which is perfect for rental income, a family compound, or potential redevelopment. Downstairs: Two units, each with 2 bedrooms and 1 bathroom. Upstairs: A spacious 4-bedroom, 2-bathroom unit alongside a renovated 1-bedroom, 1-bathroom unit. Additionally, there is a detached recreation room with its own street access, as well as ample street parking on Waipahu Street. The large patio and backyard space offer endless possibilities for outdoor gatherings and relaxation. This property is in need of some TLC but offers great potential for those ready to bring it to life. Don't miss out on this incredible opportunity to invest in the heart of Waipahu!
        )

    [ListOfficeName] => Array
        (
            [0] => SC Realty, LLC
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Needs Major Repair
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => dchong@screaltyhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 687-1314
        )

    [ListAgentFullName] => Array
        (
            [0] => Daniel K Chong
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-21T11:28:17.170
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-10-18T15:14:12.830
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26737079
            [1] => 26737080
            [2] => 26737081
            [3] => 26737082
            [4] => 26737083
            [5] => 26737084
            [6] => 26737085
            [7] => 26737086
            [8] => 26737087
            [9] => 26737088
        )

)

  • BedsTotal: 9
  • Full Baths: 5
  • Land Area (sf): 9,180
  • Living (sf): 4,536
  • Year Built: 1972

  • Property Condition: Needs Major Repair
  • Number of Parking Spaces: 2
  • View: None
  • Listing Office: SC Realty, LLC

  • Land Tenure: FS - Fee Simple

  • Elementary School: August Ahrens
  • Middle School: Waipahu
  • High School: Waipahu

CONTACT US

Marcus Realty

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