201 Ohua Avenue Unit 3006 Honolulu, HI 96815

Listing
Overview

Price: $775,000
Area: WAIKIKI
Status: Sold (Limited photos per MLS privacy policy)

NEW PRICE - $775,000. High floor 1-bedroom 1-bath fully furnished in the Mauka Tower of Waikiki Banyan with a NUC (nonconforming use certificate)!! Unit is ADA accessible. The Waikiki Banyan is one of few buildings in Waikiki that have full kitchens and allow short term rentals, ideal to live or vacation rental. Close proximity to Waikiki Beach, restaurants, shopping and much more! Amenities include a pool, BBQ area, fitness room, tennis court, and ground floor mini mart. Unit is in the Aqua-Aston hotel rental pool. Maintenance fees are $902.20 per month. Special assessment is $570.78 per month, ending at the end of the year. Becker Sandwich lease is $52.50 per month until November 2035. Monthly property taxes based on 2024 assessed values. Seller to do a 1031 exchange at no cost to the buyer. Listing by: Coldwell Banker Realty (808) 596-0456 

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202509943"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "201"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(4) "Ohua"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Avenue"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "3006"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "775000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(808) "NEW PRICE - $775,000. High floor 1-bedroom 1-bath fully furnished in the Mauka Tower of Waikiki Banyan with a NUC (nonconforming use certificate)!! Unit is ADA accessible. The Waikiki Banyan is one of few buildings in Waikiki that have full kitchens and allow short term rentals, ideal to live or vacation rental. Close proximity to Waikiki Beach, restaurants, shopping and much
more! Amenities include a pool, BBQ area, fitness room, tennis court, and ground floor mini mart. Unit is in the
Aqua-Aston hotel rental pool. Maintenance fees are $902.20 per month. Special assessment is $570.78 per month,
ending at the end of the year. Becker Sandwich lease is $52.50 per month until November 2035. Monthly property taxes
based on 2024 assessed values. Seller to do a 1031 exchange at no cost to the buyer."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "99796.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "600"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1977"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(14) "Waikiki Banyan"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(20) "City,Coastline,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "902.20"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Jefferson"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "CBPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "cory.tsuda@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Cory G Tsuda"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-10-13"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18687921"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-10-13T09:27:53.743"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-14"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:27:53.743"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26957833"
  }
  ["listing_image"]=>
  array(17) {
    [0]=>
    string(8) "26957833"
    [1]=>
    string(8) "26957834"
    [2]=>
    string(8) "26957835"
    [3]=>
    string(8) "26957836"
    [4]=>
    string(8) "26957837"
    [5]=>
    string(8) "26957838"
    [6]=>
    string(8) "26957839"
    [7]=>
    string(8) "26957840"
    [8]=>
    string(8) "26957841"
    [9]=>
    string(8) "26957842"
    [10]=>
    string(8) "26957843"
    [11]=>
    string(8) "26957844"
    [12]=>
    string(8) "26957845"
    [13]=>
    string(8) "26957846"
    [14]=>
    string(8) "26957847"
    [15]=>
    string(8) "26957848"
    [16]=>
    string(8) "26957849"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202509943
        )

    [StreetNumber] => Array
        (
            [0] => 201
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Ohua
        )

    [StreetSuffix] => Array
        (
            [0] => Avenue
        )

    [UnitNumber] => Array
        (
            [0] => 3006
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96815
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 775000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WAIKIKI
        )

    [Status] => Array
        (
            [0] => Sold
        )

    [PublicRemarks] => Array
        (
            [0] => NEW PRICE - $775,000. High floor 1-bedroom 1-bath fully furnished in the Mauka Tower of Waikiki Banyan with a NUC (nonconforming use certificate)!! Unit is ADA accessible. The Waikiki Banyan is one of few buildings in Waikiki that have full kitchens and allow short term rentals, ideal to live or vacation rental. Close proximity to Waikiki Beach, restaurants, shopping and much
more! Amenities include a pool, BBQ area, fitness room, tennis court, and ground floor mini mart. Unit is in the
Aqua-Aston hotel rental pool. Maintenance fees are $902.20 per month. Special assessment is $570.78 per month,
ending at the end of the year. Becker Sandwich lease is $52.50 per month until November 2035. Monthly property taxes
based on 2024 assessed values. Seller to do a 1031 exchange at no cost to the buyer.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [BedsTotal] => Array
        (
            [0] => 1
        )

    [BathsFull] => Array
        (
            [0] => 1
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 99796.00
        )

    [SqftTotal] => Array
        (
            [0] => 600
        )

    [YearBuilt] => Array
        (
            [0] => 1977
        )

    [BuildingName] => Array
        (
            [0] => Waikiki Banyan
        )

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

    [ParkingTotal] => Array
        (
            [0] => 1
        )

    [StoriesType] => Array
        (
            [0] => 21+
        )

    [View] => Array
        (
            [0] => City,Coastline,Ocean
        )

    [MaintenanceExpense] => Array
        (
            [0] => 902.20
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => Jefferson
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => Washington
        )

    [HighSchool] => Array
        (
            [0] => Kaimuki
        )

    [ListOfficeMLSID] => Array
        (
            [0] => CBPP
        )

    [ListAgentEmail] => Array
        (
            [0] => cory.tsuda@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 596-0456
        )

    [ListAgentFullName] => Array
        (
            [0] => Cory G Tsuda
        )

    [CloseDate] => Array
        (
            [0] => 2025-10-13
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18687921
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-10-13T09:27:53.743
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-04-14
        )

    [MLSAreaMajor] => Array
        (
            [0] => Metro
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 09:27:53.743
        )

    [_thumbnail_id] => Array
        (
            [0] => 26957833
        )

    [listing_image] => Array
        (
            [0] => 26957833
            [1] => 26957834
            [2] => 26957835
            [3] => 26957836
            [4] => 26957837
            [5] => 26957838
            [6] => 26957839
            [7] => 26957840
            [8] => 26957841
            [9] => 26957842
            [10] => 26957843
            [11] => 26957844
            [12] => 26957845
            [13] => 26957846
            [14] => 26957847
            [15] => 26957848
            [16] => 26957849
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Land Area (sf): 99,796 sf
  • Living (sf): 600
  • Year Built: 1977
  • Building Name: Waikiki Banyan

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: City,Coastline,Ocean
  • Listing Office: Coldwell Banker Realty

  • Maintenance Fees: $902
  • Land Tenure: FS - Fee Simple

  • Elementary School: Jefferson
  • Middle School: Washington
  • High School: Kaimuki

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 October 13, 2025 - 9:27 AM Information is deemed reliable but not guaranteed. Copyright: 2026 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.

Terms of Use Privacy Policy DMCA Policy
© Marcus Realty. All Rights Reserved.