Listing
Overview
Price: $2,850,000
Area: PUNCHBOWL-LOWER
Status: Active
PRIME INVESTMENT OPPORTUNITY - REALIZE IMMEDIATE INCOME UPSIDE OF 5.7-6% CAP RATE W/ ONLY A FEW MINOR CHANGES!! - In the heart of Honolulu this 9-unit property at 404 Magellan Ave offers a strong foundation with 9 separate electric meters, 9 separate gas meters, and individual gas water heaters for each unit—a rare setup that maximizes tenant independence and reduces ownership expenses. The building is currently generating income with solid rental history, and offers excellent upside potential: simply increase rents to market value or enhance returns with light remodeling or upgrades. This property provides flexibility and long-term growth opportunities in a highly desirable location close to schools, shops, and major transit routes. A must-see for investors looking for cash flow today and room to grow tomorrow! Listing by: Compass (808) 773-9390
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202521036"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "404"
}
["PropertyType"]=>
array(1) {
[0]=>
string(12) "Multi-Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Magellan"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96813"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(61) "https://www.youtube.com/embed/k3y-dFPSqZo?si=WzIviUoBnByuC8Q-"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2850000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "PUNCHBOWL-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(826) "PRIME INVESTMENT OPPORTUNITY - REALIZE IMMEDIATE INCOME UPSIDE OF 5.7-6% CAP RATE W/ ONLY A FEW MINOR CHANGES!! - In the heart of Honolulu this 9-unit property at 404 Magellan Ave offers a strong foundation with 9 separate electric meters, 9 separate gas meters, and individual gas water heaters for each unit—a rare setup that maximizes tenant independence and reduces ownership expenses. The building is currently generating income with solid rental history, and offers excellent upside potential: simply increase rents to market value or enhance returns with light remodeling or upgrades. This property provides flexibility and long-term growth opportunities in a highly desirable location close to schools, shops, and major transit routes. A must-see for investors looking for cash flow today and room to grow tomorrow!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5376.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3978"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1948"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "9"
}
["StoriesType"]=>
array(1) {
[0]=>
string(5) "Three"
}
["View"]=>
array(1) {
[0]=>
string(13) "City,Mountain"
}
["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(4) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "stephanie@hawaiidreamhomes.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 773-9390"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Stephanie Rae Band"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18997788"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-10T16:06:50.590"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-10-01"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "16:06:50.590"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27172207"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "27172207"
[1]=>
string(8) "27172208"
[2]=>
string(8) "27172209"
[3]=>
string(8) "27172210"
[4]=>
string(8) "27172211"
[5]=>
string(8) "27172212"
[6]=>
string(8) "27172213"
[7]=>
string(8) "27172214"
[8]=>
string(8) "27172215"
[9]=>
string(8) "27172216"
[10]=>
string(8) "27172217"
[11]=>
string(8) "27172218"
[12]=>
string(8) "27172219"
[13]=>
string(8) "27172220"
[14]=>
string(8) "27172221"
[15]=>
string(8) "27172222"
[16]=>
string(8) "27172223"
[17]=>
string(8) "27172224"
[18]=>
string(8) "27172225"
[19]=>
string(8) "27172226"
[20]=>
string(8) "27172227"
[21]=>
string(8) "27172228"
[22]=>
string(8) "27172229"
[23]=>
string(8) "27172230"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202521036
)
[StreetNumber] => Array
(
[0] => 404
)
[PropertyType] => Array
(
[0] => Multi-Family
)
[StreetName] => Array
(
[0] => Magellan
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96813
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/k3y-dFPSqZo?si=WzIviUoBnByuC8Q-
)
[ListPrice] => Array
(
[0] => 2850000.00
)
[Neighbourhood] => Array
(
[0] => PUNCHBOWL-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => PRIME INVESTMENT OPPORTUNITY - REALIZE IMMEDIATE INCOME UPSIDE OF 5.7-6% CAP RATE W/ ONLY A FEW MINOR CHANGES!! - In the heart of Honolulu this 9-unit property at 404 Magellan Ave offers a strong foundation with 9 separate electric meters, 9 separate gas meters, and individual gas water heaters for each unit—a rare setup that maximizes tenant independence and reduces ownership expenses. The building is currently generating income with solid rental history, and offers excellent upside potential: simply increase rents to market value or enhance returns with light remodeling or upgrades. This property provides flexibility and long-term growth opportunities in a highly desirable location close to schools, shops, and major transit routes. A must-see for investors looking for cash flow today and room to grow tomorrow!
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 5376.00
)
[SqftTotal] => Array
(
[0] => 3978
)
[YearBuilt] => Array
(
[0] => 1948
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 9
)
[StoriesType] => Array
(
[0] => Three
)
[View] => Array
(
[0] => City,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => stephanie@hawaiidreamhomes.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 773-9390
)
[ListAgentFullName] => Array
(
[0] => Stephanie Rae Band
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18997788
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-10T16:06:50.590
)
[ListingContractDate] => Array
(
[0] => 2025-10-01
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:06:50.590
)
[_thumbnail_id] => Array
(
[0] => 27172207
)
[listing_image] => Array
(
[0] => 27172207
[1] => 27172208
[2] => 27172209
[3] => 27172210
[4] => 27172211
[5] => 27172212
[6] => 27172213
[7] => 27172214
[8] => 27172215
[9] => 27172216
[10] => 27172217
[11] => 27172218
[12] => 27172219
[13] => 27172220
[14] => 27172221
[15] => 27172222
[16] => 27172223
[17] => 27172224
[18] => 27172225
[19] => 27172226
[20] => 27172227
[21] => 27172228
[22] => 27172229
[23] => 27172230
)
)
- Land Area (sf): 5,376 sf
- Living (sf): 3,978
- Year Built: 1948
- Property Condition: Average
- Number of Parking Spaces: 9
- View: City,Mountain
- Listing Office: Compass
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 10, 2025 - 4:06 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.
