Listing
Overview
Price: $1,039,000
Area: WAIPAHU-LOWER
Status: Active
Welcome to a property that epitomizes the essence of urban living - a duplex strategically located close to both a rail station and Queens West Hospital. Boasting two beautifully remodeled 3-bedroom, 1-bath units, this versatile gem is ideal for extended families seeking to live together or astute investors looking for an income-generating opportunity. With ample parking and a sliding driveway gate ensuring privacy, this property offers the best of comfort and convenience. Awesome potential for this duplex as a multi-family living with AMX-2 zoning in Waipahu, or as an investment
property. Get your offers in early! Listing by: Keller Williams Honolulu (808) 212-9210
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202316851"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-103"
}
["PropertyType"]=>
array(1) {
[0]=>
string(12) "Multi-Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Pupupuhi"
}
["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(51) "https://my.matterport.com/show/?m=GXHQyXeucvH&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1039000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1039000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPAHU-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(623) "Welcome to a property that epitomizes the essence of urban living - a duplex strategically located close to both a rail station and Queens West Hospital. Boasting two beautifully remodeled 3-bedroom, 1-bath units, this versatile gem is ideal for extended families seeking to live together or astute investors looking for an income-generating opportunity. With ample parking and a sliding driveway gate ensuring privacy, this property offers the best of comfort and convenience. Awesome potential for this duplex as a multi-family living with AMX-2 zoning in Waipahu, or as an investment
property. Get your offers in early!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5646.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1971"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
NULL
}
["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(6) "KWPP01"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "adrienne@teamlally.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 212-9210"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Adrienne W Lally"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-04-03T12:12:41.503"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17452232"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-07-27T16:42:50.530"
}
["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) "25889223"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25889223"
[1]=>
string(8) "25889224"
[2]=>
string(8) "25889225"
[3]=>
string(8) "25889226"
[4]=>
string(8) "25889227"
[5]=>
string(8) "25889228"
[6]=>
string(8) "25889229"
[7]=>
string(8) "25889230"
[8]=>
string(8) "25889231"
[9]=>
string(8) "25889232"
[10]=>
string(8) "25889233"
[11]=>
string(8) "25889234"
[12]=>
string(8) "25889235"
[13]=>
string(8) "25889236"
[14]=>
string(8) "25889237"
[15]=>
string(8) "25889238"
[16]=>
string(8) "25889239"
[17]=>
string(8) "25889240"
[18]=>
string(8) "25889241"
[19]=>
string(8) "25889242"
[20]=>
string(8) "25889243"
[21]=>
string(8) "25889244"
[22]=>
string(8) "25889245"
[23]=>
string(8) "25889246"
[24]=>
string(8) "25889247"
[25]=>
string(8) "25889248"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "12:12:41.503"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202316851
)
[StreetNumber] => Array
(
[0] => 94-103
)
[PropertyType] => Array
(
[0] => Multi-Family
)
[StreetName] => Array
(
[0] => Pupupuhi
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=GXHQyXeucvH&mls=1
)
[ListPrice] => Array
(
[0] => 1039000.00
)
[CurrentPrice] => Array
(
[0] => 1039000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to a property that epitomizes the essence of urban living - a duplex strategically located close to both a rail station and Queens West Hospital. Boasting two beautifully remodeled 3-bedroom, 1-bath units, this versatile gem is ideal for extended families seeking to live together or astute investors looking for an income-generating opportunity. With ample parking and a sliding driveway gate ensuring privacy, this property offers the best of comfort and convenience. Awesome potential for this duplex as a multi-family living with AMX-2 zoning in Waipahu, or as an investment
property. Get your offers in early!
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 5646.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] => 1971
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[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] => KWPP01
)
[ListAgentEmail] => Array
(
[0] => adrienne@teamlally.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 212-9210
)
[ListAgentFullName] => Array
(
[0] => Adrienne W Lally
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-04-03T12:12:41.503
)
[Matrix_Unique_ID] => Array
(
[0] => 17452232
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-07-27T16:42:50.530
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25889223
)
[listing_image] => Array
(
[0] => 25889223
[1] => 25889224
[2] => 25889225
[3] => 25889226
[4] => 25889227
[5] => 25889228
[6] => 25889229
[7] => 25889230
[8] => 25889231
[9] => 25889232
[10] => 25889233
[11] => 25889234
[12] => 25889235
[13] => 25889236
[14] => 25889237
[15] => 25889238
[16] => 25889239
[17] => 25889240
[18] => 25889241
[19] => 25889242
[20] => 25889243
[21] => 25889244
[22] => 25889245
[23] => 25889246
[24] => 25889247
[25] => 25889248
)
[MatrixModifiedTime] => Array
(
[0] => 12:12:41.503
)
)
- Land Area (sf): 5,646 sf
- Year Built: 1971
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: None
- Listing Office: Keller Williams Honolulu
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on April 3, 2024 - 12:12 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.
