Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
229 Paoakalani Avenue Unit 1904 Honolulu, HI 96815
Listing Overview
Price: $725,000 Area: WAIKIKI Status: Sold (Limited photos per MLS privacy policy)
Discover the perfect opportunity to own a highly sought-after 1-bedroom unit in the popular Waikiki Sunset! This fully furnished hotel unit boasts the largest 1-bedroom floor plan, featuring a lanai and an open living/kitchen layout. Enjoy partial ocean and Diamond Head views! The unit is part of the hotel rental program with Aston Waikiki Sunset and has a NUC (Non-Conforming Use Certificate). Recent hotel upgrades in 2019 include new carpet, fresh paint, and the removal of popcorn ceilings, ensuring a modern and comfortable living space. The building offers great amenities such as BBQ facilities, a pool, community laundry, an exercise room, and 24-hour security. Located in a prime area, you'll be close to the world-famous Waikiki Beach, Kapiolani Park, the zoo, restaurants, shopping, and much more. The unit also comes with one unassigned parking stall, adding to the convenience. Listing by: Coldwell Banker Realty (808) 596-0456
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202507274"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "229"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Paoakalani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "1904"
}
["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) "725000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(892) "Discover the perfect opportunity to own a highly sought-after 1-bedroom unit in the popular Waikiki Sunset! This fully furnished hotel unit boasts the largest 1-bedroom floor plan, featuring a lanai and an open living/kitchen layout. Enjoy partial ocean and Diamond Head views! The unit is part of the hotel rental program with Aston Waikiki Sunset and has a NUC (Non-Conforming Use Certificate). Recent hotel upgrades in 2019 include new carpet, fresh paint, and the removal of popcorn ceilings, ensuring a modern and comfortable living space. The building offers great amenities such as BBQ facilities, a pool, community laundry, an exercise room, and 24-hour security. Located in a prime area, you'll be close to the world-famous Waikiki Beach, Kapiolani Park, the zoo, restaurants, shopping, and much more. The unit also comes with one unassigned parking stall, adding to the convenience."
}
["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) "49963.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "631"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1979"
}
["BuildingName"]=>
array(1) {
[0]=>
string(14) "Waikiki Sunset"
}
["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(23) "City,Diamond Head,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "927.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "CBPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(28) "tytus.szymanski@cbrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Tytus Szymanski"
}
["CloseDate"]=>
array(1) {
[0]=>
string(10) "2025-11-14"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18630115"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-15T22:00:47.977"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-03-19"
}
["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) "22:00:47.977"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26926665"
}
["listing_image"]=>
array(17) {
[0]=>
string(8) "26926665"
[1]=>
string(8) "26926666"
[2]=>
string(8) "26926667"
[3]=>
string(8) "26926668"
[4]=>
string(8) "26926669"
[5]=>
string(8) "26926670"
[6]=>
string(8) "26926671"
[7]=>
string(8) "26926672"
[8]=>
string(8) "26926673"
[9]=>
string(8) "26926674"
[10]=>
string(8) "26926675"
[11]=>
string(8) "26926676"
[12]=>
string(8) "26926677"
[13]=>
string(8) "26926678"
[14]=>
string(8) "26926679"
[15]=>
string(8) "26926680"
[16]=>
string(8) "26926681"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202507274
)
[StreetNumber] => Array
(
[0] => 229
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Paoakalani
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 1904
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 725000.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Sold
)
[PublicRemarks] => Array
(
[0] => Discover the perfect opportunity to own a highly sought-after 1-bedroom unit in the popular Waikiki Sunset! This fully furnished hotel unit boasts the largest 1-bedroom floor plan, featuring a lanai and an open living/kitchen layout. Enjoy partial ocean and Diamond Head views! The unit is part of the hotel rental program with Aston Waikiki Sunset and has a NUC (Non-Conforming Use Certificate). Recent hotel upgrades in 2019 include new carpet, fresh paint, and the removal of popcorn ceilings, ensuring a modern and comfortable living space. The building offers great amenities such as BBQ facilities, a pool, community laundry, an exercise room, and 24-hour security. Located in a prime area, you'll be close to the world-famous Waikiki Beach, Kapiolani Park, the zoo, restaurants, shopping, and much more. The unit also comes with one unassigned parking stall, adding to the convenience.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 49963.00
)
[SqftTotal] => Array
(
[0] => 631
)
[YearBuilt] => Array
(
[0] => 1979
)
[BuildingName] => Array
(
[0] => Waikiki Sunset
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Diamond Head,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 927.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP
)
[ListAgentEmail] => Array
(
[0] => tytus.szymanski@cbrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 596-0456
)
[ListAgentFullName] => Array
(
[0] => Tytus Szymanski
)
[CloseDate] => Array
(
[0] => 2025-11-14
)
[Matrix_Unique_ID] => Array
(
[0] => 18630115
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-15T22:00:47.977
)
[ListingContractDate] => Array
(
[0] => 2025-03-19
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 22:00:47.977
)
[_thumbnail_id] => Array
(
[0] => 26926665
)
[listing_image] => Array
(
[0] => 26926665
[1] => 26926666
[2] => 26926667
[3] => 26926668
[4] => 26926669
[5] => 26926670
[6] => 26926671
[7] => 26926672
[8] => 26926673
[9] => 26926674
[10] => 26926675
[11] => 26926676
[12] => 26926677
[13] => 26926678
[14] => 26926679
[15] => 26926680
[16] => 26926681
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 15, 2025 - 10: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.