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!
1001 Queen Street Unit 2602 Honolulu, HI 96814
Listing Overview
Price: $1,418,000 Area: KAKAAKO Status: Active
This immaculate, modern residence boasts floor-to-ceiling windows that offer breathtaking panoramic ocean and city views from every room. Bright and airy unit features elegant quartz countertops, Bosch appliances, motorized shades, a wall-mounted TV, and a walk-in closet in the primary bedroom. Both bathrooms are equipped with soaking tubs, double sinks, and TOTO Washlets. The residence includes ultra-convenient spacious tandem parking stalls located next to the elevators on the Mezzanine level, and a storage locker for additional space. Enjoy direct access to Whole Foods Market from Ae'o, enhancing your convenience and lifestyle. Resort-style amenities, including a Rooftop Sky Terrace, two pools, Jacuzzi, a fully equipped gym, a sauna, steam room, BBQ cabanas, private party rooms, theater, guest suites, a karaoke room, playground, dog park, and more. Its prime location provides easy access to renowned restaurants, shops, movie theaters, Ala Moana Beach Park, Kewalo Boat Harbor, and Ala Moana Shopping Center. Embrace the vibrant Kakaako lifestyle and enjoy the ultimate in modern living at this stunning residence. Listing by: Coldwell Banker Realty (808) 286-5118
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428191"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1001"
}
["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) "2602"
}
["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) "1418000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1130) "This immaculate, modern residence boasts floor-to-ceiling windows that offer breathtaking panoramic ocean and city views from every room. Bright and airy unit features elegant quartz countertops, Bosch appliances, motorized shades, a wall-mounted TV, and a walk-in closet in the primary bedroom. Both bathrooms are equipped with soaking tubs, double sinks, and TOTO Washlets. The residence includes ultra-convenient spacious tandem parking stalls located next to the elevators on the Mezzanine level, and a storage locker for additional space. Enjoy direct access to Whole Foods Market from Ae'o, enhancing your convenience and lifestyle. Resort-style amenities, including a Rooftop Sky Terrace, two pools, Jacuzzi, a fully equipped gym, a sauna, steam room, BBQ cabanas, private party rooms, theater, guest suites, a karaoke room, playground, dog park, and more. Its prime location provides easy access to renowned restaurants, shops, movie theaters, Ala Moana Beach Park, Kewalo Boat Harbor, and Ala Moana Shopping Center. Embrace the vibrant Kakaako lifestyle and enjoy the ultimate in modern living at this stunning residence."
}
["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(3) "983"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2018"
}
["BuildingName"]=>
array(1) {
[0]=>
string(4) "Ae'o"
}
["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(49) "City,Coastline,Marina/Canal,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1094.36"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Kaahumanu"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(9) "Stevenson"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mckinley"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "hiromihawaiihomes@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 286-5118"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Hiromi Farmer"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-19T23:13:24.417"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18436133"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-17"
}
["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) "26810414"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26810414"
[1]=>
string(8) "26810415"
[2]=>
string(8) "26810416"
[3]=>
string(8) "26810417"
[4]=>
string(8) "26810418"
[5]=>
string(8) "26810419"
[6]=>
string(8) "26810420"
[7]=>
string(8) "26810421"
[8]=>
string(8) "26810422"
[9]=>
string(8) "26810423"
[10]=>
string(8) "26810424"
[11]=>
string(8) "26810425"
[12]=>
string(8) "26810426"
[13]=>
string(8) "26810427"
[14]=>
string(8) "26810428"
[15]=>
string(8) "26810429"
[16]=>
string(8) "26810430"
[17]=>
string(8) "26810431"
[18]=>
string(8) "26810432"
[19]=>
string(8) "26810433"
[20]=>
string(8) "26810434"
[21]=>
string(8) "26810435"
[22]=>
string(8) "26810436"
[23]=>
string(8) "26810437"
[24]=>
string(8) "26810438"
[25]=>
string(8) "26810439"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428191
)
[StreetNumber] => Array
(
[0] => 1001
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2602
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1418000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This immaculate, modern residence boasts floor-to-ceiling windows that offer breathtaking panoramic ocean and city views from every room. Bright and airy unit features elegant quartz countertops, Bosch appliances, motorized shades, a wall-mounted TV, and a walk-in closet in the primary bedroom. Both bathrooms are equipped with soaking tubs, double sinks, and TOTO Washlets. The residence includes ultra-convenient spacious tandem parking stalls located next to the elevators on the Mezzanine level, and a storage locker for additional space. Enjoy direct access to Whole Foods Market from Ae'o, enhancing your convenience and lifestyle. Resort-style amenities, including a Rooftop Sky Terrace, two pools, Jacuzzi, a fully equipped gym, a sauna, steam room, BBQ cabanas, private party rooms, theater, guest suites, a karaoke room, playground, dog park, and more. Its prime location provides easy access to renowned restaurants, shops, movie theaters, Ala Moana Beach Park, Kewalo Boat Harbor, and Ala Moana Shopping Center. Embrace the vibrant Kakaako lifestyle and enjoy the ultimate in modern living at this stunning residence.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 983
)
[YearBuilt] => Array
(
[0] => 2018
)
[BuildingName] => Array
(
[0] => Ae'o
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Coastline,Marina/Canal,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 1094.36
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kaahumanu
)
[MiddleOrJuniorSchool] => Array
(
[0] => Stevenson
)
[HighSchool] => Array
(
[0] => Mckinley
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => hiromihawaiihomes@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 286-5118
)
[ListAgentFullName] => Array
(
[0] => Hiromi Farmer
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-19T23:13:24.417
)
[Matrix_Unique_ID] => Array
(
[0] => 18436133
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[ListingContractDate] => Array
(
[0] => 2024-12-17
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26810414
)
[listing_image] => Array
(
[0] => 26810414
[1] => 26810415
[2] => 26810416
[3] => 26810417
[4] => 26810418
[5] => 26810419
[6] => 26810420
[7] => 26810421
[8] => 26810422
[9] => 26810423
[10] => 26810424
[11] => 26810425
[12] => 26810426
[13] => 26810427
[14] => 26810428
[15] => 26810429
[16] => 26810430
[17] => 26810431
[18] => 26810432
[19] => 26810433
[20] => 26810434
[21] => 26810435
[22] => 26810436
[23] => 26810437
[24] => 26810438
[25] => 26810439
)
)
