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
Listing Overview
Price: $48,000
Area: WAIKIKI
Status: Active
Studio unit in Waikiki featuring Ala Wai Canal and mountain views. This well maintained move in ready leasehold unit offers a lease through 2044. Maintenance fees conveniently include electricity water sewer and gas. Enjoy a spacious open lanai perfect for morning coffee or evening cocktails. Ideally located just minutes from world famous Waikiki Beach the Honolulu Zoo shopping dining Kapahulu Avenue and more. Live the Hawaii lifestyle. Must see to appreciate. Listing by: Redfin Corporation (808) 201-2821
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202528207"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "454"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Namahana"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "404"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96815"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=a9UiKSY6yXZ&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(8) "48000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(464) "Studio unit in Waikiki featuring Ala Wai Canal and mountain views. This well maintained move in ready leasehold unit offers a lease through 2044. Maintenance fees conveniently include electricity water sewer and gas. Enjoy a spacious open lanai perfect for morning coffee or evening cocktails. Ideally located just minutes from world famous Waikiki Beach the Honolulu Zoo shopping dining Kapahulu Avenue and more. Live the Hawaii lifestyle. Must see to appreciate."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "0"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "4400.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "451"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1967"
}
["BuildingName"]=>
array(1) {
[0]=>
string(15) "Regency Ala Wai"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "0"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(12) "Marina/Canal"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "938.97"
}
["LandTenure"]=>
array(1) {
[0]=>
string(14) "LH - Leasehold"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "RFIN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "mike.demello@redfin.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 201-2821"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Michael D DeMello"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19179136"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-24T12:19:18.163"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-12-23"
}
["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) "12:19:18.163"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27252688"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "27252688"
[1]=>
string(8) "27252689"
[2]=>
string(8) "27252690"
[3]=>
string(8) "27252691"
[4]=>
string(8) "27252692"
[5]=>
string(8) "27252693"
[6]=>
string(8) "27252694"
[7]=>
string(8) "27252695"
[8]=>
string(8) "27252696"
[9]=>
string(8) "27252697"
[10]=>
string(8) "27252698"
[11]=>
string(8) "27252699"
[12]=>
string(8) "27252700"
[13]=>
string(8) "27252701"
[14]=>
string(8) "27252702"
[15]=>
string(8) "27252703"
[16]=>
string(8) "27252704"
[17]=>
string(8) "27252705"
[18]=>
string(8) "27252706"
[19]=>
string(8) "27252707"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202528207
)
[StreetNumber] => Array
(
[0] => 454
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Namahana
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 404
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=a9UiKSY6yXZ&mls=1
)
[ListPrice] => Array
(
[0] => 48000.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Studio unit in Waikiki featuring Ala Wai Canal and mountain views. This well maintained move in ready leasehold unit offers a lease through 2044. Maintenance fees conveniently include electricity water sewer and gas. Enjoy a spacious open lanai perfect for morning coffee or evening cocktails. Ideally located just minutes from world famous Waikiki Beach the Honolulu Zoo shopping dining Kapahulu Avenue and more. Live the Hawaii lifestyle. Must see to appreciate.
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 4400.00
)
[SqftTotal] => Array
(
[0] => 451
)
[YearBuilt] => Array
(
[0] => 1967
)
[BuildingName] => Array
(
[0] => Regency Ala Wai
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 0
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Marina/Canal
)
[MaintenanceExpense] => Array
(
[0] => 938.97
)
[LandTenure] => Array
(
[0] => LH - Leasehold
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RFIN
)
[ListAgentEmail] => Array
(
[0] => mike.demello@redfin.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 201-2821
)
[ListAgentFullName] => Array
(
[0] => Michael D DeMello
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19179136
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-24T12:19:18.163
)
[ListingContractDate] => Array
(
[0] => 2025-12-23
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 12:19:18.163
)
[_thumbnail_id] => Array
(
[0] => 27252688
)
[listing_image] => Array
(
[0] => 27252688
[1] => 27252689
[2] => 27252690
[3] => 27252691
[4] => 27252692
[5] => 27252693
[6] => 27252694
[7] => 27252695
[8] => 27252696
[9] => 27252697
[10] => 27252698
[11] => 27252699
[12] => 27252700
[13] => 27252701
[14] => 27252702
[15] => 27252703
[16] => 27252704
[17] => 27252705
[18] => 27252706
[19] => 27252707
)
)
Full Baths: 1
Land Area (sf): 4,400 sf
Living (sf): 451
Year Built: 1967
Building Name: Regency Ala Wai
Property Condition: Average
View: Marina/Canal
Listing Office: Redfin Corporation
Maintenance Fees: $939
Land Tenure: LH - Leasehold
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 24, 2025 - 12:19 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.