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
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 super-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) 738-3904
array(48) {
["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(40) "http://player.vimeo.com/video/1040225677"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1280000.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 super-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) "1068.68"
}
["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) 738-3904"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Hiromi Farmer"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-30T13:19:56.940"
}
["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"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "13:19:56.940"
}
}
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] => http://player.vimeo.com/video/1040225677
)
[ListPrice] => Array
(
[0] => 1280000.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 super-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] => 1068.68
)
[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) 738-3904
)
[ListAgentFullName] => Array
(
[0] => Hiromi Farmer
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-30T13:19:56.940
)
[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
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 13:19:56.940
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 30, 2025 - 1:19 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.
