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
Price: $2,300,000 Area: PUNCHBOWL-LOWER Status: Active
PRIME INVESTMENT OPPORTUNITY - REALIZE IMMEDIATE INCOME UPSIDE OF 7% + 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) 825-4277
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) "2300000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "PUNCHBOWL-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(824) "PRIME INVESTMENT OPPORTUNITY - REALIZE IMMEDIATE INCOME UPSIDE OF 7% + 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) 825-4277"
}
["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-11-18T10:11:42.320"
}
["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) "10:11:42.320"
}
["_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] => 2300000.00
)
[Neighbourhood] => Array
(
[0] => PUNCHBOWL-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => PRIME INVESTMENT OPPORTUNITY - REALIZE IMMEDIATE INCOME UPSIDE OF 7% + 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) 825-4277
)
[ListAgentFullName] => Array
(
[0] => Stephanie Rae Band
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18997788
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-18T10:11:42.320
)
[ListingContractDate] => Array
(
[0] => 2025-10-01
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 10:11:42.320
)
[_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
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 18, 2025 - 10:11 AM
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.
