The office will be closed on Friday, July 4th, in observance of Independence Day and will re-open on Monday.
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) "202311600"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-103"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single 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(622) "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(1) "6"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5646.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1496"
}
["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]=>
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(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:07.377"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17342728"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-06-14T12:30:46.777"
}
["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) "25889196"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25889196"
[1]=>
string(8) "25889197"
[2]=>
string(8) "25889198"
[3]=>
string(8) "25889199"
[4]=>
string(8) "25889200"
[5]=>
string(8) "25889201"
[6]=>
string(8) "25889202"
[7]=>
string(8) "25889203"
[8]=>
string(8) "25889204"
[9]=>
string(8) "25889205"
[10]=>
string(8) "25889206"
[11]=>
string(8) "25889207"
[12]=>
string(8) "25889208"
[13]=>
string(8) "25889209"
[14]=>
string(8) "25889210"
[15]=>
string(8) "25889211"
[16]=>
string(8) "25889212"
[17]=>
string(8) "25889213"
[18]=>
string(8) "25889214"
[19]=>
string(8) "25889215"
[20]=>
string(8) "25889216"
[21]=>
string(8) "25889217"
[22]=>
string(8) "25889218"
[23]=>
string(8) "25889219"
[24]=>
string(8) "25889220"
[25]=>
string(8) "25889221"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "12:12:07.377"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202311600
)
[StreetNumber] => Array
(
[0] => 94-103
)
[PropertyType] => Array
(
[0] => Single 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] => 6
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5646.00
)
[SqftTotal] => Array
(
[0] => 1496
)
[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:07.377
)
[Matrix_Unique_ID] => Array
(
[0] => 17342728
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-06-14T12:30:46.777
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25889196
)
[listing_image] => Array
(
[0] => 25889196
[1] => 25889197
[2] => 25889198
[3] => 25889199
[4] => 25889200
[5] => 25889201
[6] => 25889202
[7] => 25889203
[8] => 25889204
[9] => 25889205
[10] => 25889206
[11] => 25889207
[12] => 25889208
[13] => 25889209
[14] => 25889210
[15] => 25889211
[16] => 25889212
[17] => 25889213
[18] => 25889214
[19] => 25889215
[20] => 25889216
[21] => 25889217
[22] => 25889218
[23] => 25889219
[24] => 25889220
[25] => 25889221
)
[MatrixModifiedTime] => Array
(
[0] => 12:12:07.377
)
)
BedsTotal: 6
Full Baths: 2
Land Area (sf): 5,646 sf
Living (sf): 1,496
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.
© Marcus Realty. All Rights Reserved.