Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
94-547 Hiahia Loop Waipahu, HI 96797
Listing Overview
Price: $1,200,000 Area: WAIPAHU-LOWER Status: Active Under Contract
Discover the incredible potential of this one-of-a-kind property - perfect for multi-generational living, or reside upstairs and rent the other two units downstairs. With its thoughtful layout and flexible design this home offers endless possibilities to fit your lifestyle or investment goals. The main residence features a bright and inviting upstairs space with 3 bedrooms and 1.5 baths, complete with its own private entrance. Downstairs, you'll find two additional living areas designed for versatility. One includes 2 bedrooms, 2 bathrooms, and a kitchen - perfect for extended family or guests. The second features 2 bedrooms and 1 bathroom, offering its own private entrance, allowing it to function as a rental unit with a wet bar. New roof was installed in 2019. Number of bathrooms does not match the TMK records. Enjoy an enclosed side patio and a spacious backyard with fruit trees. Whether you're looking for a multi-family home, an investment opportunity, or a space that grows with your needs - this property truly has it all. Schedule your private showing today and experience its unmatched potential! OPEN HOUSE on Sunday November 16th from 2:00 to 5:00pm. Listing by: Coldwell Banker Realty (808) 676-7200
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202524948"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-547"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Hiahia"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Loop"
}
["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) "1200000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPAHU-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1175) "Discover the incredible potential of this one-of-a-kind property - perfect for multi-generational living, or reside upstairs and rent the other two units downstairs. With its thoughtful layout and flexible design this home offers endless possibilities to fit your lifestyle or investment goals. The main residence features a bright and inviting upstairs space with 3 bedrooms and 1.5 baths, complete with its own private entrance. Downstairs, you'll find two additional living areas designed for versatility. One includes 2 bedrooms, 2 bathrooms, and a kitchen - perfect for extended family or guests. The second features 2 bedrooms and 1 bathroom, offering its own private entrance, allowing it to function as a rental unit with a wet bar. New roof was installed in 2019. Number of bathrooms does not match the TMK records. Enjoy an enclosed side patio and a spacious backyard with fruit trees. Whether you're looking for a multi-family home, an investment opportunity, or a space that grows with your needs - this property truly has it all. Schedule your private showing today and experience its unmatched potential! OPEN HOUSE on Sunday November 16th from 2:00 to 5:00pm."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "8103.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3190"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1972"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["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(6) "CBPP15"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "hazel.roces@cbpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 676-7200"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Hazel D Roces"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19084129"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-17T13:56:55.980"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-05"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "13:56:55.980"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27210721"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27210721"
[1]=>
string(8) "27210722"
[2]=>
string(8) "27210723"
[3]=>
string(8) "27210724"
[4]=>
string(8) "27210725"
[5]=>
string(8) "27210726"
[6]=>
string(8) "27210727"
[7]=>
string(8) "27210728"
[8]=>
string(8) "27210729"
[9]=>
string(8) "27210730"
[10]=>
string(8) "27210731"
[11]=>
string(8) "27210732"
[12]=>
string(8) "27210733"
[13]=>
string(8) "27210734"
[14]=>
string(8) "27210735"
[15]=>
string(8) "27210736"
[16]=>
string(8) "27210737"
[17]=>
string(8) "27210738"
[18]=>
string(8) "27210739"
[19]=>
string(8) "27210740"
[20]=>
string(8) "27210741"
[21]=>
string(8) "27210742"
[22]=>
string(8) "27210743"
[23]=>
string(8) "27210744"
[24]=>
string(8) "27210745"
[25]=>
string(8) "27210746"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202524948
)
[StreetNumber] => Array
(
[0] => 94-547
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hiahia
)
[StreetSuffix] => Array
(
[0] => Loop
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1200000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU-LOWER
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Discover the incredible potential of this one-of-a-kind property - perfect for multi-generational living, or reside upstairs and rent the other two units downstairs. With its thoughtful layout and flexible design this home offers endless possibilities to fit your lifestyle or investment goals. The main residence features a bright and inviting upstairs space with 3 bedrooms and 1.5 baths, complete with its own private entrance. Downstairs, you'll find two additional living areas designed for versatility. One includes 2 bedrooms, 2 bathrooms, and a kitchen - perfect for extended family or guests. The second features 2 bedrooms and 1 bathroom, offering its own private entrance, allowing it to function as a rental unit with a wet bar. New roof was installed in 2019. Number of bathrooms does not match the TMK records. Enjoy an enclosed side patio and a spacious backyard with fruit trees. Whether you're looking for a multi-family home, an investment opportunity, or a space that grows with your needs - this property truly has it all. Schedule your private showing today and experience its unmatched potential! OPEN HOUSE on Sunday November 16th from 2:00 to 5:00pm.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 7
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 8103.00
)
[SqftTotal] => Array
(
[0] => 3190
)
[YearBuilt] => Array
(
[0] => 1972
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[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] => CBPP15
)
[ListAgentEmail] => Array
(
[0] => hazel.roces@cbpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 676-7200
)
[ListAgentFullName] => Array
(
[0] => Hazel D Roces
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19084129
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-17T13:56:55.980
)
[ListingContractDate] => Array
(
[0] => 2025-11-05
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 13:56:55.980
)
[_thumbnail_id] => Array
(
[0] => 27210721
)
[listing_image] => Array
(
[0] => 27210721
[1] => 27210722
[2] => 27210723
[3] => 27210724
[4] => 27210725
[5] => 27210726
[6] => 27210727
[7] => 27210728
[8] => 27210729
[9] => 27210730
[10] => 27210731
[11] => 27210732
[12] => 27210733
[13] => 27210734
[14] => 27210735
[15] => 27210736
[16] => 27210737
[17] => 27210738
[18] => 27210739
[19] => 27210740
[20] => 27210741
[21] => 27210742
[22] => 27210743
[23] => 27210744
[24] => 27210745
[25] => 27210746
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 17, 2025 - 1:56 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.
