201 Ohua Avenue Unit 3006 Honolulu, HI 96815

Listing
Overview

Price: $800,000
Area: WAIKIKI
Status: Active

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: Locations LLC (808) 256-7467

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) "800000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(788) "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(13) "Locations LLC"
  }
  ["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) "533"
  }
  ["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) "LOCA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(30) "cory.tsuda@locationshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 256-7467"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Cory G Tsuda"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18687921"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-04-20T17:00:01.877"
  }
  ["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) "17:00:01.877"
  }
  ["_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] => 800000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => 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] => Locations LLC
        )

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

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

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

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

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

    [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] => LOCA
        )

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 256-7467
        )

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

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-04-20T17:00:01.877
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:00:01.877
        )

    [_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): 533
  • Year Built: 1977
  • Building Name: Waikiki Banyan

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: City,Coastline,Ocean
  • Listing Office: Locations LLC

  • 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 April 20, 2025 - 5:00 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.