201 Ohua Avenue Unit Mauka 3706 Honolulu, HI 96815

Listing
Overview

Price: $848,000
Area: WAIKIKI
Status: Sold

Feel at home in this legally licensed Airbnb condo in Waikiki, just two blocks from world's ioconic Waikiki Sunset Beach. Perfect as a vacation home or investment property, this 1-bedroom, 1-bathroom unit offers the convenience of a full kitchen, allowing guests to enjoy home-cooked meals, and a covered parking stall for easy access. The open style interior includes an ocean-view lanai, offering a serene escape. The building features a range of amenities, including a swimming pool, BBQ area, children's playground, library, community laundry facilities, spa, and gym. Currently managed by Aqua-Aston Hotel, this condo is an excellent choice for short-term rentals in a prime location in Waikiki. Listing by: CENTURY 21 Hawaiian Style (808) 955-6551

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202421097"
  }
  ["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(10) "Mauka 3706"
  }
  ["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) "848000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(700) "Feel at home in this legally licensed Airbnb condo in Waikiki, just two blocks from world's ioconic Waikiki Sunset Beach. Perfect as a vacation home or investment property, this 1-bedroom, 1-bathroom unit offers the convenience of a full kitchen, allowing guests to enjoy home-cooked meals, and a covered parking stall for easy access. The open style interior includes an ocean-view lanai, offering a serene escape. The building features a range of amenities, including a swimming pool, BBQ area, children's playground, library, community laundry facilities, spa, and gym. Currently managed by Aqua-Aston Hotel, this condo is an excellent choice for short-term rentals in a prime location in Waikiki."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(25) "CENTURY 21 Hawaiian Style"
  }
  ["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(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "600"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1979"
  }
  ["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(10) "City,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "902.00"
  }
  ["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(8) "Mckinley"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "HSTL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "aimee.hawaii@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 955-6551"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(9) "Aimee Kim"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-14"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-04-14T15:43:22.000"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18262928"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26695535"
  }
  ["listing_image"]=>
  array(15) {
    [0]=>
    string(8) "26695535"
    [1]=>
    string(8) "26695536"
    [2]=>
    string(8) "26695537"
    [3]=>
    string(8) "26695538"
    [4]=>
    string(8) "26695539"
    [5]=>
    string(8) "26695540"
    [6]=>
    string(8) "26695541"
    [7]=>
    string(8) "26695542"
    [8]=>
    string(8) "26695543"
    [9]=>
    string(8) "26695544"
    [10]=>
    string(8) "26695545"
    [11]=>
    string(8) "26695546"
    [12]=>
    string(8) "26701073"
    [13]=>
    string(8) "26701074"
    [14]=>
    string(8) "26701075"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-09-15"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "15:43:22.000"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202421097
        )

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

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

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

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

    [UnitNumber] => Array
        (
            [0] => Mauka 3706
        )

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Feel at home in this legally licensed Airbnb condo in Waikiki, just two blocks from world's ioconic Waikiki Sunset Beach. Perfect as a vacation home or investment property, this 1-bedroom, 1-bathroom unit offers the convenience of a full kitchen, allowing guests to enjoy home-cooked meals, and a covered parking stall for easy access. The open style interior includes an ocean-view lanai, offering a serene escape. The building features a range of amenities, including a swimming pool, BBQ area, children's playground, library, community laundry facilities, spa, and gym. Currently managed by Aqua-Aston Hotel, this condo is an excellent choice for short-term rentals in a prime location in Waikiki.
        )

    [ListOfficeName] => Array
        (
            [0] => CENTURY 21 Hawaiian Style
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => aimee.hawaii@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 955-6551
        )

    [ListAgentFullName] => Array
        (
            [0] => Aimee Kim
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-04-14T15:43:22.000
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26695535
            [1] => 26695536
            [2] => 26695537
            [3] => 26695538
            [4] => 26695539
            [5] => 26695540
            [6] => 26695541
            [7] => 26695542
            [8] => 26695543
            [9] => 26695544
            [10] => 26695545
            [11] => 26695546
            [12] => 26701073
            [13] => 26701074
            [14] => 26701075
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-09-15
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:43:22.000
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Living (sf): 600
  • Year Built: 1979
  • Building Name: Waikiki Banyan

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: City,Ocean
  • Listing Office: CENTURY 21 Hawaiian Style

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

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

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 14, 2025 - 3:43 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.