Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
201 Ohua Avenue Unit Mauka 3706 Honolulu, HI 96815
Listing Overview
Price: $900,000 Area: WAIKIKI Status: Active
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) 561-3050
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) "900000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["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) "722.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) 561-3050"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(9) "Aimee Kim"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-23T19:39:39.223"
}
["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) "19:39:39.223"
}
}
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] => 900000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active
)
[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] => 722.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) 561-3050
)
[ListAgentFullName] => Array
(
[0] => Aimee Kim
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-23T19:39:39.223
)
[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] => 19:39:39.223
)
)
