454 Namahana Street Unit 404 Honolulu, HI 96815

Take a Virtual Tour

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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

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.