Our office will be closed on Monday, November 11th, 2024.
1177 Queen Street Unit 2404 Honolulu, HI 96814
Listing Overview
Price: $1,199,000 Area: KAKAAKO Status: Active
The breathtaking vibrant ocean views and expansive coastline are captured from all rooms through floor-to-ceiling walls of windows, gracing all spaces with natural light. Chefs will enjoy the gas stove, the stainless-steel Viking appliances, and the tastefully appointed finishes of the gourmet kitchen. Special touches include roll up blinds, custom decorative painting, and framed mirrored doors on closets and the kitchen pantry. You will be pleased with this unit’s easy side-by-side parking on the first floor. The amenities are amazing and include a World Class Concierge, 24/7 security, Pool and Spa, BBQ Cabanas, Tennis and Pickleball courts, Theater, Billiard Room, Putting Green, Party Room, a Pet Park, and Island Spa & Club. Conveniently located near a large sandy beach park, the Ala Moana Shopping Center, restaurants, theaters, and downtown. Listing by: Coldwell Banker Realty (808) 738-3904
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202417948"
}
["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) "2404"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1199000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1199000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(858) "The breathtaking vibrant ocean views and expansive coastline are captured from all rooms through floor-to-ceiling walls of windows, gracing all spaces with natural light. Chefs will enjoy the gas stove, the stainless-steel Viking appliances, and the tastefully appointed finishes of the gourmet kitchen. Special touches include roll up blinds, custom decorative painting, and framed mirrored doors on closets and the kitchen pantry. You will be pleased with this unit’s easy side-by-side parking on the first floor. The amenities are amazing and include a World Class Concierge, 24/7 security, Pool and Spa, BBQ Cabanas, Tennis and Pickleball courts, Theater, Billiard Room, Putting Green, Party Room, a Pet Park, and Island Spa & Club. Conveniently located near a large sandy beach park, the Ala Moana Shopping Center, restaurants, theaters, and downtown."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["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) "1157"
}
["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(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(29) "City,Coastline,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1265.42"
}
["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(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "lisah@cbrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3904"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Lisa Haeringer"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-05T11:10:56.503"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18192633"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-19T15:36:06.897"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26701475"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26701475"
[1]=>
string(8) "26701476"
[2]=>
string(8) "26701477"
[3]=>
string(8) "26701478"
[4]=>
string(8) "26701479"
[5]=>
string(8) "26701480"
[6]=>
string(8) "26701481"
[7]=>
string(8) "26701482"
[8]=>
string(8) "26701483"
[9]=>
string(8) "26701484"
[10]=>
string(8) "26701485"
[11]=>
string(8) "26701486"
[12]=>
string(8) "26701487"
[13]=>
string(8) "26701488"
[14]=>
string(8) "26701489"
[15]=>
string(8) "26701490"
[16]=>
string(8) "26701491"
[17]=>
string(8) "26701492"
[18]=>
string(8) "26701493"
[19]=>
string(8) "26701494"
[20]=>
string(8) "26701495"
[21]=>
string(8) "26701496"
[22]=>
string(8) "26701497"
[23]=>
string(8) "26701498"
[24]=>
string(8) "26701499"
[25]=>
string(8) "26701500"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202417948
)
[StreetNumber] => Array
(
[0] => 1177
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2404
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1199000.00
)
[CurrentPrice] => Array
(
[0] => 1199000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => The breathtaking vibrant ocean views and expansive coastline are captured from all rooms through floor-to-ceiling walls of windows, gracing all spaces with natural light. Chefs will enjoy the gas stove, the stainless-steel Viking appliances, and the tastefully appointed finishes of the gourmet kitchen. Special touches include roll up blinds, custom decorative painting, and framed mirrored doors on closets and the kitchen pantry. You will be pleased with this unit’s easy side-by-side parking on the first floor. The amenities are amazing and include a World Class Concierge, 24/7 security, Pool and Spa, BBQ Cabanas, Tennis and Pickleball courts, Theater, Billiard Room, Putting Green, Party Room, a Pet Park, and Island Spa & Club. Conveniently located near a large sandy beach park, the Ala Moana Shopping Center, restaurants, theaters, and downtown.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1157
)
[YearBuilt] => Array
(
[0] => 2006
)
[BuildingName] => Array
(
[0] => Koolani
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Coastline,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 1265.42
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => lisah@cbrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3904
)
[ListAgentFullName] => Array
(
[0] => Lisa Haeringer
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-05T11:10:56.503
)
[Matrix_Unique_ID] => Array
(
[0] => 18192633
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-19T15:36:06.897
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26701475
)
[listing_image] => Array
(
[0] => 26701475
[1] => 26701476
[2] => 26701477
[3] => 26701478
[4] => 26701479
[5] => 26701480
[6] => 26701481
[7] => 26701482
[8] => 26701483
[9] => 26701484
[10] => 26701485
[11] => 26701486
[12] => 26701487
[13] => 26701488
[14] => 26701489
[15] => 26701490
[16] => 26701491
[17] => 26701492
[18] => 26701493
[19] => 26701494
[20] => 26701495
[21] => 26701496
[22] => 26701497
[23] => 26701498
[24] => 26701499
[25] => 26701500
)
)
