Our office will be closed on Monday, November 11th, 2024.
1001 Queen Street Unit 2502 Honolulu, HI 96814
Listing Overview
Price: $1,420,000 Area: KAKAAKO Status: Active
Resort Living in Ward Village! Enjoy contemporary living in the Ae'o Condominium located in the center of Ward Village. This exemplary 2 bedroom, 2 bath luxury unit offers spectacular views of the ocean and harbor from any room in your home. A well designed floor plan offers an open concept kitchen with state of the art Bosch appliances and quartz countertops. Ultramodern living with resort amenities includes a heated pool, modern gym, sauna, BBQ area, theater room, private dining room, outdoor exercise equipment, dog park and also suites for your visiting guest. Located only minutes from Ala Moana Center, shopping boutiques, movie theaters, restaurants and conveniently situated above Whole Foods Market. A must see! Listing by: Coldwell Banker Realty (808) 230-7295
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202419000"
}
["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) "2502"
}
["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) "1420000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1420000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(731) "Resort Living in Ward Village! Enjoy contemporary living in the Ae'o Condominium located in the center of Ward Village. This exemplary 2 bedroom, 2 bath luxury unit offers spectacular views of the ocean and harbor from any room in your home. A well designed floor plan offers an open concept kitchen with state of the art Bosch appliances and quartz countertops. Ultramodern living with resort amenities includes a heated pool, modern gym, sauna, BBQ area, theater room, private dining room, outdoor exercise equipment, dog park and also suites for your visiting guest. Located only minutes from Ala Moana Center, shopping boutiques, movie theaters, restaurants and conveniently situated above Whole Foods Market. A must see!"
}
["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(5) "Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1094.36"
}
["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) "CBPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "KenK@cbpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 230-7295"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Ken K Kawamoto"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-19T10:16:02.700"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18222494"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-19T10:16:02.700"
}
["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) "26700932"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26700932"
[1]=>
string(8) "26700933"
[2]=>
string(8) "26700934"
[3]=>
string(8) "26700935"
[4]=>
string(8) "26700936"
[5]=>
string(8) "26700937"
[6]=>
string(8) "26700938"
[7]=>
string(8) "26700939"
[8]=>
string(8) "26700940"
[9]=>
string(8) "26700941"
[10]=>
string(8) "26700942"
[11]=>
string(8) "26700943"
[12]=>
string(8) "26700944"
[13]=>
string(8) "26700945"
[14]=>
string(8) "26700946"
[15]=>
string(8) "26700947"
[16]=>
string(8) "26700948"
[17]=>
string(8) "26700949"
[18]=>
string(8) "26700950"
[19]=>
string(8) "26700951"
[20]=>
string(8) "26700952"
[21]=>
string(8) "26700953"
[22]=>
string(8) "26700954"
[23]=>
string(8) "26700955"
[24]=>
string(8) "26700956"
[25]=>
string(8) "26700957"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202419000
)
[StreetNumber] => Array
(
[0] => 1001
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2502
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1420000.00
)
[CurrentPrice] => Array
(
[0] => 1420000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Resort Living in Ward Village! Enjoy contemporary living in the Ae'o Condominium located in the center of Ward Village. This exemplary 2 bedroom, 2 bath luxury unit offers spectacular views of the ocean and harbor from any room in your home. A well designed floor plan offers an open concept kitchen with state of the art Bosch appliances and quartz countertops. Ultramodern living with resort amenities includes a heated pool, modern gym, sauna, BBQ area, theater room, private dining room, outdoor exercise equipment, dog park and also suites for your visiting guest. Located only minutes from Ala Moana Center, shopping boutiques, movie theaters, restaurants and conveniently situated above Whole Foods Market. A must see!
)
[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] => Ocean
)
[MaintenanceExpense] => Array
(
[0] => 1094.36
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP
)
[ListAgentEmail] => Array
(
[0] => KenK@cbpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 230-7295
)
[ListAgentFullName] => Array
(
[0] => Ken K Kawamoto
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-19T10:16:02.700
)
[Matrix_Unique_ID] => Array
(
[0] => 18222494
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-19T10:16:02.700
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26700932
)
[listing_image] => Array
(
[0] => 26700932
[1] => 26700933
[2] => 26700934
[3] => 26700935
[4] => 26700936
[5] => 26700937
[6] => 26700938
[7] => 26700939
[8] => 26700940
[9] => 26700941
[10] => 26700942
[11] => 26700943
[12] => 26700944
[13] => 26700945
[14] => 26700946
[15] => 26700947
[16] => 26700948
[17] => 26700949
[18] => 26700950
[19] => 26700951
[20] => 26700952
[21] => 26700953
[22] => 26700954
[23] => 26700955
[24] => 26700956
[25] => 26700957
)
)
