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
1001 Queen Street Unit 2005 Honolulu, HI 96814
Listing Overview
Price: $830,000 Area: KAKAAKO Status: Active
Welcome to the Ae’o that is located in Kakaako at the Ward Village community. Neighborhood provides unique local retailers, world class retail and restaurants, movie theaters, Whole Foods, and so much more. Large spacious 1 Bedrooms 1 Bathrooms with a double vanity bathroom and large walk in closet. Ae’o also has a wide selection of resort-like amenities such as BBQ cabanas, movie theater, Sky Terrace on the top floor, indoor and outdoor fitness, recreation room, large lap pool and family pool, kids playground, and much more. Listing by: New Homes Realty LLC (808) 741-0679
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202528106"
}
["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) "2005"
}
["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(9) "830000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(535) "Welcome to the Ae’o that is located in Kakaako at the Ward Village community. Neighborhood provides unique local retailers, world class retail and restaurants, movie theaters, Whole Foods, and so much more. Large spacious 1 Bedrooms 1 Bathrooms with a double vanity bathroom and large walk in closet. Ae’o also has a wide selection of resort-like amenities such as BBQ cabanas, movie theater, Sky Terrace on the top floor, indoor and outdoor fitness, recreation room, large lap pool and family pool, kids playground, and much more."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(20) "New Homes Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "703"
}
["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) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(5) "15-20"
}
["View"]=>
array(1) {
[0]=>
string(10) "City,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "731.44"
}
["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) "NHRE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "jerryyang808@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 741-0679"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "YuFan Yang"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19176171"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-18T07:24:02.933"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-12-17"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "07:24:02.933"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27248519"
}
["listing_image"]=>
array(18) {
[0]=>
string(8) "27248519"
[1]=>
string(8) "27248520"
[2]=>
string(8) "27248521"
[3]=>
string(8) "27248522"
[4]=>
string(8) "27248523"
[5]=>
string(8) "27248524"
[6]=>
string(8) "27248525"
[7]=>
string(8) "27248526"
[8]=>
string(8) "27248527"
[9]=>
string(8) "27248528"
[10]=>
string(8) "27248529"
[11]=>
string(8) "27248530"
[12]=>
string(8) "27248531"
[13]=>
string(8) "27248532"
[14]=>
string(8) "27248533"
[15]=>
string(8) "27248534"
[16]=>
string(8) "27249034"
[17]=>
string(8) "27249035"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202528106
)
[StreetNumber] => Array
(
[0] => 1001
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 2005
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 830000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to the Ae’o that is located in Kakaako at the Ward Village community. Neighborhood provides unique local retailers, world class retail and restaurants, movie theaters, Whole Foods, and so much more. Large spacious 1 Bedrooms 1 Bathrooms with a double vanity bathroom and large walk in closet. Ae’o also has a wide selection of resort-like amenities such as BBQ cabanas, movie theater, Sky Terrace on the top floor, indoor and outdoor fitness, recreation room, large lap pool and family pool, kids playground, and much more.
)
[ListOfficeName] => Array
(
[0] => New Homes Realty LLC
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 703
)
[YearBuilt] => Array
(
[0] => 2018
)
[BuildingName] => Array
(
[0] => Ae'o
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 15-20
)
[View] => Array
(
[0] => City,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 731.44
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => NHRE
)
[ListAgentEmail] => Array
(
[0] => jerryyang808@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 741-0679
)
[ListAgentFullName] => Array
(
[0] => YuFan Yang
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19176171
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-18T07:24:02.933
)
[ListingContractDate] => Array
(
[0] => 2025-12-17
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 07:24:02.933
)
[_thumbnail_id] => Array
(
[0] => 27248519
)
[listing_image] => Array
(
[0] => 27248519
[1] => 27248520
[2] => 27248521
[3] => 27248522
[4] => 27248523
[5] => 27248524
[6] => 27248525
[7] => 27248526
[8] => 27248527
[9] => 27248528
[10] => 27248529
[11] => 27248530
[12] => 27248531
[13] => 27248532
[14] => 27248533
[15] => 27248534
[16] => 27249034
[17] => 27249035
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 18, 2025 - 7:24 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.
