94-533 Ulieo Street Waipahu, HI 96797
Listing
Overview
Price: $839,000
Area: WAIPAHU ESTATES
Status: Sold (Limited photos per MLS privacy policy)
NEW LISTING! Tremendous value and potential in this rarely available 4 bedroom, 2 bath SINGLE-LEVEL home in the desirable Waipahu Estates neighborhood. This is the first-ever offering of the property, which is PRICED TO SELL as the lowest-priced home in the neighborhood with no HOA fees! Amazing location next Waipahu town and only half-mile from Waikele shopping center. Situated on a level 5,000+ sqft lot on a quiet side street, the home features a functional layout with great bones and a 192 sqft covered front lanai - perfect for relaxing or extension. Needing some TLC and updates, this is a fantastic opportunity for buyers looking to renovate and customize to their taste. Built with durable CMU block framing, bring your contractor and bring your vision to life! Full of plantation-era charm, the spacious backyard includes a shed and mature lemon, tangelo trees. Conveniently located near H-1 freeway, Waikele Premium Outlets, neighborhood parks, shops, restaurants and much more! Priced well below tax-assessed value - don’t miss this one! Sold "as is." Listing by: BHGRE Advantage Realty (808) 228-3332
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202513051"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-533"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Ulieo"
}
["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) "839000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "WAIPAHU ESTATES"
}
["Status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1068) "NEW LISTING! Tremendous value and potential in this rarely available 4 bedroom, 2 bath SINGLE-LEVEL home in the desirable Waipahu Estates neighborhood. This is the first-ever offering of the property, which is PRICED TO SELL as the lowest-priced home in the neighborhood with no HOA fees! Amazing location next Waipahu town and only half-mile from Waikele shopping center. Situated on a level 5,000+ sqft lot on a quiet side street, the home features a functional layout with great bones and a 192 sqft covered front lanai - perfect for relaxing or extension. Needing some TLC and updates, this is a fantastic opportunity for buyers looking to renovate and customize to their taste. Built with durable CMU block framing, bring your contractor and bring your vision to life! Full of plantation-era charm, the spacious backyard includes a shed and mature lemon, tangelo trees. Conveniently located near H-1 freeway, Waikele Premium Outlets, neighborhood parks, shops, restaurants and much more! Priced well below tax-assessed value - don’t miss this one! Sold "as is.""
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5171.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1272"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1977"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(4) "Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["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(6) "Ahrens"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "ADVG03"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "JaymesS@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 228-3332"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Jaymes K Song"
}
["CloseDate"]=>
array(1) {
[0]=>
string(10) "2025-07-02"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18777094"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-07-02T16:53:15.480"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-05-30"
}
["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) "16:53:15.480"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27014613"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27014613"
[1]=>
string(8) "27014614"
[2]=>
string(8) "27014615"
[3]=>
string(8) "27014616"
[4]=>
string(8) "27014617"
[5]=>
string(8) "27014618"
[6]=>
string(8) "27014619"
[7]=>
string(8) "27014620"
[8]=>
string(8) "27014621"
[9]=>
string(8) "27014622"
[10]=>
string(8) "27014623"
[11]=>
string(8) "27014624"
[12]=>
string(8) "27014625"
[13]=>
string(8) "27014626"
[14]=>
string(8) "27014627"
[15]=>
string(8) "27014628"
[16]=>
string(8) "27014629"
[17]=>
string(8) "27014630"
[18]=>
string(8) "27014631"
[19]=>
string(8) "27014632"
[20]=>
string(8) "27014633"
[21]=>
string(8) "27014634"
[22]=>
string(8) "27014635"
[23]=>
string(8) "27014636"
[24]=>
string(8) "27014637"
[25]=>
string(8) "27014638"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202513051
)
[StreetNumber] => Array
(
[0] => 94-533
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ulieo
)
[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] => 839000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU ESTATES
)
[Status] => Array
(
[0] => Sold
)
[PublicRemarks] => Array
(
[0] => NEW LISTING! Tremendous value and potential in this rarely available 4 bedroom, 2 bath SINGLE-LEVEL home in the desirable Waipahu Estates neighborhood. This is the first-ever offering of the property, which is PRICED TO SELL as the lowest-priced home in the neighborhood with no HOA fees! Amazing location next Waipahu town and only half-mile from Waikele shopping center. Situated on a level 5,000+ sqft lot on a quiet side street, the home features a functional layout with great bones and a 192 sqft covered front lanai - perfect for relaxing or extension. Needing some TLC and updates, this is a fantastic opportunity for buyers looking to renovate and customize to their taste. Built with durable CMU block framing, bring your contractor and bring your vision to life! Full of plantation-era charm, the spacious backyard includes a shed and mature lemon, tangelo trees. Conveniently located near H-1 freeway, Waikele Premium Outlets, neighborhood parks, shops, restaurants and much more! Priced well below tax-assessed value - don’t miss this one! Sold "as is."
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5171.00
)
[SqftTotal] => Array
(
[0] => 1272
)
[YearBuilt] => Array
(
[0] => 1977
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Fair
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Ahrens
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waipahu
)
[HighSchool] => Array
(
[0] => Waipahu
)
[ListOfficeMLSID] => Array
(
[0] => ADVG03
)
[ListAgentEmail] => Array
(
[0] => JaymesS@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 228-3332
)
[ListAgentFullName] => Array
(
[0] => Jaymes K Song
)
[CloseDate] => Array
(
[0] => 2025-07-02
)
[Matrix_Unique_ID] => Array
(
[0] => 18777094
)
[MatrixModifiedDT] => Array
(
[0] => 2025-07-02T16:53:15.480
)
[ListingContractDate] => Array
(
[0] => 2025-05-30
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:53:15.480
)
[_thumbnail_id] => Array
(
[0] => 27014613
)
[listing_image] => Array
(
[0] => 27014613
[1] => 27014614
[2] => 27014615
[3] => 27014616
[4] => 27014617
[5] => 27014618
[6] => 27014619
[7] => 27014620
[8] => 27014621
[9] => 27014622
[10] => 27014623
[11] => 27014624
[12] => 27014625
[13] => 27014626
[14] => 27014627
[15] => 27014628
[16] => 27014629
[17] => 27014630
[18] => 27014631
[19] => 27014632
[20] => 27014633
[21] => 27014634
[22] => 27014635
[23] => 27014636
[24] => 27014637
[25] => 27014638
)
)
- BedsTotal: 4
- Full Baths: 2
- Land Area (sf): 5,171 sf
- Living (sf): 1,272
- Year Built: 1977
- Property Condition: Fair
- Number of Parking Spaces: 2
- View: None
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Ahrens
- Middle School: Waipahu
- High School: Waipahu
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 2, 2025 - 4:53 PM
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.
