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
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.