Listing
Overview
Price: $1,345,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 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) "1345000.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-10-14T11:14:36.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"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "11:14:36.417"
}
}
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] => 1345000.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-10-14T11:14:36.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
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:14:36.417
)
)
- BedsTotal: 2
- Full Baths: 2
- Living (sf): 983
- Year Built: 2018
- Building Name: Ae'o
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: City,Coastline,Marina/Canal,Mountain,Ocean,Sunset
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $1,069
- Land Tenure: FS - Fee Simple
- Elementary School: Kaahumanu
- Middle School: Stevenson
- High School: Mckinley
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 14, 2025 - 11:14 AM
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.
© Marcus Realty. All Rights Reserved.