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
Perched high above the city, this exquisite and well-maintained 2-bedroom, 2-bath residence offers 1,518 sq. ft. of refined living space. The expansive, rectangular living room is framed by floor-to-ceiling windows that fill the home with natural light and capture stunning partial ocean views. The thoughtfully designed layout provides both comfort and privacy. Each room is generously sized, while the primary suite features a luxurious en-suite bath with a double vanity and breathtaking Diamond Head views. The gourmet kitchen is both stylish and functional, equipped with high-end Viking appliances, a gas stove, and granite countertops. This well-maintained residence also includes two standard parking stalls. Enjoy resort-style living with an array of exceptional amenities: a recreation deck, two tennis courts, a heated pool, spas, a walking path, fitness center, billiard room, movie theater, media and conference rooms, concierge-like services, and 24-hour security. Perfectly located near Ala Moana Shopping Center, Beach Park, and Ward Village, this home offers the best of Honolulu’s vibrant urban lifestyle, world-class dining, shopping, and entertainment all just moments away. Listing by: Jack Tyrrell & Company (808) 532-3330
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202523877"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1177"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Queen"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "2808"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96814"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(45) "https://my.matterport.com/show/?m=o8wauJDcEQv"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1650000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1198) "Perched high above the city, this exquisite and well-maintained 2-bedroom, 2-bath residence offers 1,518 sq. ft. of refined living space. The expansive, rectangular living room is framed by floor-to-ceiling windows that fill the home with natural light and capture stunning partial ocean views. The thoughtfully designed layout provides both comfort and privacy. Each room is generously sized, while the primary suite features a luxurious en-suite bath with a double vanity and breathtaking Diamond Head views. The gourmet kitchen is both stylish and functional, equipped with high-end Viking appliances, a gas stove, and granite countertops. This well-maintained residence also includes two standard parking stalls. Enjoy resort-style living with an array of exceptional amenities: a recreation deck, two tennis courts, a heated pool, spas, a walking path, fitness center, billiard room, movie theater, media and conference rooms, concierge-like services, and 24-hour security. Perfectly located near Ala Moana Shopping Center, Beach Park, and Ward Village, this home offers the best of Honolulu’s vibrant urban lifestyle, world-class dining, shopping, and entertainment all just moments away."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Jack Tyrrell & Company"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1518"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2006"
}
["BuildingName"]=>
array(1) {
[0]=>
string(7) "Koolani"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(39) "City,Coastline,Diamond Head,Ocean,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1893.52"
}
["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) "BAYS"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "jack@jtchawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 532-3330"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "John L Tyrrell"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19054319"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-23T17:00:02.030"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-10-18"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:02.030"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27192822"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27192822"
[1]=>
string(8) "27192823"
[2]=>
string(8) "27192824"
[3]=>
string(8) "27192825"
[4]=>
string(8) "27192826"
[5]=>
string(8) "27192827"
[6]=>
string(8) "27192828"
[7]=>
string(8) "27192829"
[8]=>
string(8) "27192830"
[9]=>
string(8) "27192831"
[10]=>
string(8) "27192832"
[11]=>
string(8) "27192833"
[12]=>
string(8) "27192834"
[13]=>
string(8) "27192835"
[14]=>
string(8) "27192836"
[15]=>
string(8) "27192837"
[16]=>
string(8) "27192838"
[17]=>
string(8) "27192839"
[18]=>
string(8) "27192840"
[19]=>
string(8) "27192841"
[20]=>
string(8) "27192842"
[21]=>
string(8) "27192843"
[22]=>
string(8) "27192844"
[23]=>
string(8) "27192845"
[24]=>
string(8) "27192846"
[25]=>
string(8) "27192847"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202523877
)
[StreetNumber] => Array
(
[0] => 1177
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2808
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=o8wauJDcEQv
)
[ListPrice] => Array
(
[0] => 1650000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Perched high above the city, this exquisite and well-maintained 2-bedroom, 2-bath residence offers 1,518 sq. ft. of refined living space. The expansive, rectangular living room is framed by floor-to-ceiling windows that fill the home with natural light and capture stunning partial ocean views. The thoughtfully designed layout provides both comfort and privacy. Each room is generously sized, while the primary suite features a luxurious en-suite bath with a double vanity and breathtaking Diamond Head views. The gourmet kitchen is both stylish and functional, equipped with high-end Viking appliances, a gas stove, and granite countertops. This well-maintained residence also includes two standard parking stalls. Enjoy resort-style living with an array of exceptional amenities: a recreation deck, two tennis courts, a heated pool, spas, a walking path, fitness center, billiard room, movie theater, media and conference rooms, concierge-like services, and 24-hour security. Perfectly located near Ala Moana Shopping Center, Beach Park, and Ward Village, this home offers the best of Honolulu’s vibrant urban lifestyle, world-class dining, shopping, and entertainment all just moments away.
)
[ListOfficeName] => Array
(
[0] => Jack Tyrrell & Company
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1518
)
[YearBuilt] => Array
(
[0] => 2006
)
[BuildingName] => Array
(
[0] => Koolani
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => City,Coastline,Diamond Head,Ocean,Other
)
[MaintenanceExpense] => Array
(
[0] => 1893.52
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => BAYS
)
[ListAgentEmail] => Array
(
[0] => jack@jtchawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 532-3330
)
[ListAgentFullName] => Array
(
[0] => John L Tyrrell
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19054319
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-23T17:00:02.030
)
[ListingContractDate] => Array
(
[0] => 2025-10-18
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:02.030
)
[_thumbnail_id] => Array
(
[0] => 27192822
)
[listing_image] => Array
(
[0] => 27192822
[1] => 27192823
[2] => 27192824
[3] => 27192825
[4] => 27192826
[5] => 27192827
[6] => 27192828
[7] => 27192829
[8] => 27192830
[9] => 27192831
[10] => 27192832
[11] => 27192833
[12] => 27192834
[13] => 27192835
[14] => 27192836
[15] => 27192837
[16] => 27192838
[17] => 27192839
[18] => 27192840
[19] => 27192841
[20] => 27192842
[21] => 27192843
[22] => 27192844
[23] => 27192845
[24] => 27192846
[25] => 27192847
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 23, 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.