94-1172 Halelehua Street Waipahu, HI 96797

Listing
Overview

Price: $635,000
Area: WAIPAHU ESTATES
Status: Pending

Incredible opportunity to own your own piece of paradise at an affordable price. Enjoy the proximity to the renowned Waikele Premium Outlet Shopping Center, Waipahu’s Soccer Complex, Lowes, Costco and easy access to interstate’s H-1 and H-2. This 5-bedroom, 3-bathroom home has adequate space for any family. Don’t miss your opportunity to own a piece of Aloha. Buyers check with City, County, Zoning, Tax, and other records to their satisfaction. AS-IS SALE property. Listing by: REALHome Services & Solutions (470) 482-6054

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202513444"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "94-1172"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Halelehua"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["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(9) "635000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(15) "WAIPAHU ESTATES"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(7) "Pending"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(474) "Incredible opportunity to own your own piece of paradise at an affordable price. Enjoy the proximity to the renowned Waikele Premium Outlet Shopping Center, Waipahu’s Soccer Complex, Lowes, Costco and easy access to interstate’s H-1 and H-2. This 5-bedroom, 3-bathroom home has adequate space for any family. Don’t miss your opportunity to own a piece of Aloha. Buyers check with City, County, Zoning, Tax, and other records to their satisfaction. AS-IS SALE property."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(29) "REALHome Services & Solutions"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5119.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3170"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["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(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "RHSS"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "zellnerrealty@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(470) 482-6054"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Jamarr Zellner"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18788718"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-06-13T07:53:20.837"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-04"
  }
  ["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) "07:53:20.837"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27019512"
  }
  ["listing_image"]=>
  array(15) {
    [0]=>
    string(8) "27019512"
    [1]=>
    string(8) "27019513"
    [2]=>
    string(8) "27019514"
    [3]=>
    string(8) "27019515"
    [4]=>
    string(8) "27019516"
    [5]=>
    string(8) "27019517"
    [6]=>
    string(8) "27019518"
    [7]=>
    string(8) "27019519"
    [8]=>
    string(8) "27019520"
    [9]=>
    string(8) "27019521"
    [10]=>
    string(8) "27019522"
    [11]=>
    string(8) "27019523"
    [12]=>
    string(8) "27019524"
    [13]=>
    string(8) "27019525"
    [14]=>
    string(8) "27019526"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202513444
        )

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => WAIPAHU ESTATES
        )

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

    [PublicRemarks] => Array
        (
            [0] => Incredible opportunity to own your own piece of paradise at an affordable price. Enjoy the proximity to the renowned Waikele Premium Outlet Shopping Center, Waipahu’s Soccer Complex, Lowes, Costco and easy access to interstate’s H-1 and H-2. This 5-bedroom, 3-bathroom home has adequate space for any family. Don’t miss your opportunity to own a piece of Aloha. Buyers check with City, County, Zoning, Tax, and other records to their satisfaction. AS-IS SALE property.
        )

    [ListOfficeName] => Array
        (
            [0] => REALHome Services & Solutions
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (470) 482-6054
        )

    [ListAgentFullName] => Array
        (
            [0] => Jamarr Zellner
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-06-13T07:53:20.837
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-06-04
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 07:53:20.837
        )

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

    [listing_image] => Array
        (
            [0] => 27019512
            [1] => 27019513
            [2] => 27019514
            [3] => 27019515
            [4] => 27019516
            [5] => 27019517
            [6] => 27019518
            [7] => 27019519
            [8] => 27019520
            [9] => 27019521
            [10] => 27019522
            [11] => 27019523
            [12] => 27019524
            [13] => 27019525
            [14] => 27019526
        )

)

  • BedsTotal: 5
  • Full Baths: 3
  • Land Area (sf): 5,119 sf
  • Living (sf): 3,170
  • Year Built: 1973

  • Property Condition: Average
  • Number of Parking Spaces: 2
  • View: None
  • Listing Office: REALHome Services & Solutions

  • 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 June 13, 2025 - 7:53 AM 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.