Hawaii Living

Aeo #PH 3904 (Kakaako)

1 / 25
  • Asking Price: $1,580,000

    $50,000 price drop 8 days ago

  • Beds: 2
  • Baths: 2
  • Living: 978 ft²
  • Built: 2018
  • Parking: 2
  • Maint. (HOA) Fees: $1,018 / month
  • Other Monthly Fee: $246 / month
  • Association Fees: $31 / month
  • Property Taxes: $832 / month ?
  • Est. Mortgage: $7,783 / mo - adjust loan
  • Time Listed for Sale: 21 days
  • Status Active
  • Tenure: Fee Simple
  • Buy without visiting ?
  • All Aeo condos for sale »
  • All Kakaako condos for sale »

1001 Queen St #PH 3904, Honolulu

Inquire / Showing / Video Tour
Call/Text Tracy (808) 372-2274 or use contact form.
Tracy Yamato

Tracy Yamato

Certified Residential Specialist
Realtor, RS-51972

Mobile: (808) 372-2274

Email: Tracy@HawaiiLiving.com

"Let my over 32 years of experience work for you."
Client Testimonials
We are expert real estate agents and have sold many condos in Aeo. We would be happy to assist you too.
Description
'04' stack unit located Diamond Head side of building with ocean views. Penthouse has 10 FOOT floor-to-ceiling windows which create an open feeling. Sold with additional STORAGE unit, located next to the 4th floor parking stall (P4-069) with EV CHARGER. Another parking stall is Mezz. (PM-026) so easy for getting in and out. Upgraded engineered wood flooring extended from the living areas into all bedrooms, motorized window covering throughout, TOTO Washlet in the main bathroom, installed California closet system in the all closets. Ae'o is located in one of the most desired new neighborhoods in Honolulu at Kakaako, Ward Village near Ala Moana Shopping Center. Ala Moana Beach Park, Magic Island, shopping, theater, and variety of restaurants. First class building amenities include two pools, BBQ pavilions, gym, saunas, movie theater, guest suites, dog play area, play ground, and more.
Recent Activity
  • Mar 19, 2025 Price $1,580,000
  • Mar 06, 2025 Listed at $1,630,000
Past Sales
(Aeo)
  • #909: 1 Bd | 1 Ba @ $699K (3/24/25)
  • #3313: 1 Bd | 1 Ba @ $775K (3/19/25)
  • #2501: 3 Bds | 3 Ba @ $1.85M (2/26/25)
  • #2502: 2 Bds | 2 Ba @ $1.3M (2/5/25)
  • #2306: 2 Bds | 2 Ba @ $1.295M (2/5/25)
  • #1502: 2 Bds | 2 Ba @ $1.28M (1/21/25)
  • #1805: 1 Bd | 1 Ba @ $830K (12/19/24)
  • #1305: 1 Bd | 1 Ba @ $810K (11/25/24)
  • #2108: 1 Bd | 1 Ba @ $857K (10/4/24)
  • #1708: 1 Bd | 1 Ba @ $855K (9/30/24)
  • #1201: 3 Bds | 3 Ba @ $1.75M (9/26/24)
  • #1512: 2 Bds | 2 Ba @ $1.31M (9/18/24)
  • #1213: 1 Bd | 1 Ba @ $780K (9/13/24)
  • #2800: 3 Bds | 3 Ba @ $2.1M (8/19/24)
  • #1000: 2 Bds | 2 Ba @ $1.55M (7/3/24)
  • #2202: 2 Bds | 2 Ba @ $1.378M (6/7/24)
  • #2715: 2 Bds | 2 Ba @ $1.09M (5/30/24)
  • #3112: 2 Bds | 2 Ba @ $1.43M (4/24/24)
  • #2709: 1 Bd | 1 Ba @ $830K (4/24/24)
  • #1103: 1 Bd | 1 Ba @ $785K (4/22/24)
  • #1806: 2 Bds | 2 Ba @ $1.32M (4/9/24)
  • #1012: 2 Bds | 2 Ba @ $1.199M (4/8/24)
  • #1901: 3 Bds | 3 Ba @ $1.925M (3/28/24)
  • #2209: 1 Bd | 1 Ba @ $810K (3/18/24)
  • #3001: 3 Bds | 3 Ba @ $2.05M (3/6/24)
  • #1108: 1 Bd | 1 Ba @ $870K (3/5/24)
  • #1301: 3 Bds | 3 Ba @ $1.78M (2/21/24)
  • #2503: 1 Bd | 1 Ba @ $860K (12/15/23)
  • #2603: 1 Bd | 1 Ba @ $888K (11/9/23)
  • #1609: 1 Bd | 1 Ba @ $715K (10/31/23)
  • #1404: 2 Bds | 2 Ba @ $1.19M (9/28/23)
  • #2708: 1 Bd | 1 Ba @ $885K (9/22/23)
  • #1400: 3 Bds | 3 Ba @ $1.955M (9/11/23)
  • #2100: 3 Bds | 3 Ba @ $1.95M (9/1/23)
  • #1308: 1 Bd | 1 Ba @ $850K (8/7/23)
  • #3500: 3 Bds | 3 Ba @ $1.95M (7/21/23)
  • #3804: 2 Bds | 2 Ba @ $1.4M (6/23/23)
  • #1711: Studio | 1 Ba @ $605K (6/15/23)
  • #PH4013: 1 Bd | 1 Ba @ $905K (6/8/23)
  • #3408: 1 Bd | 1 Ba @ $885K (5/15/23)
  • #808: 1 Bd | 1 Ba @ $788K (5/12/23)
  • #2212: 2 Bds | 2 Ba @ $1.3M (4/27/23)
  • #2901: 3 Bds | 3 Ba @ $1.999M (4/13/23)
  • #1704: 2 Bds | 2 Ba @ $1.28M (3/15/23)
  • #3502: 2 Bds | 2 Ba @ $1.348M (2/21/23)
  • #3512: 2 Bds | 2 Ba @ $1.48M (1/31/23)
  • #1804: 2 Bds | 2 Ba @ $1.25M (1/4/23)
  • #1607: Studio | 1 Ba @ $576K (12/23/22)
  • #2102: 2 Bds | 2 Ba @ $1.325M (11/30/22)
  • #2910: Studio | 1 Ba @ $680K (11/7/22)
Blog
More Details
  • Owner, Tax & Resale History
  • HOA Fees / ft²: $1.29
  • Price / ft²: $1,616
  • Other Condos Price / ft²
  • Cash vs Financing Buyers
  • HOA Fees Include: Cable TV, Internet Service, Other Common Expenses, Sewer, Water
  • Zoning: Kak – Kakaako Community Development Project
  • Flood Zone: Zone AE
  • View: City, Coastline, Mountain, Ocean, Sunrise
  • Furnished: Partial
  • Property Condition: Excellent
  • Owner Occupancy: 32%
  • Management Company: Associa
  • Security Features: Key, Keyed Elevator, Security Patrol, Video
  • Amenities: BBQ, Dog Park, Exercise Room, Fire Sprinkler, Heated Pool, Meeting Room, Other, Patio/Deck, Playground, Pool on Property, Private Yard, Recreation Area, Recreation Room, Resident Manager, Sauna, Security Guard, Storage, Trash Chute, Whirlpool
  • TMK: 1-2-3-2-106-445
  • Tax Assessed Land: $69,500
  • Tax Assessed Improvements: $1,455,000
  • Tax Assessed Total: $1,524,500
  • Courtesy: Aska Gateway Estates Inc / (808) 922-2992
  • MLS: 202502206
Ask Tracy a Question
About Aeo
  • Address: 1001 Queen St, Honolulu, HI 96814.
     
  • Built: 2018, 466 Units on 40 Floors, Studio - 3BR, Pets: OK (verify)
     
  • Amenities: Rooftop Terrace, Lap Pool, Leisure Pool, Children's Play Area, 6 Covered Outdoor Dining Pavilions & Cabanas, Gym, Outdoor Workout Space, yoga Area, 3 Guest Suites, Steam & Dry Sauna, Movie Theater, Karaoke Room Private Dining Room with Catering Kitchen, Dog Run.
     
  • Short-term Vacation Renting: Not Allowed.
     
  • Developer: Howard Hughes Corporation.

Aeo, part of Ward Village’s 2nd phase in Kakaako, w  ..... Read more.




The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on March 27, 2025.Information is deemed reliable but not guaranteed.
Other Aeo Listings
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,418,000
Aeo #2602
2 Bds | 2 Ba
983 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,388,000
Aeo #2504
2 Bds | 2 Ba
985 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,350,000
AE'O #2002
2 Bds | 2 Ba
983 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,350,000
Aeo #1804
2 Bds | 2 Ba
978 ft²
Other Kakaako Condos
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,500,000
Symphony Honolulu #4505
2 Bds | 2 Ba
1,278 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,690,000
Koolani #2602
2 Bds | 2 Ba
1,561 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,450,000
Aalii #1202
2 Bds | 2 Ba
826 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,415,000
Koula #2507
2 Bds | 2 Ba
968 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,795,000
Anaha #1406
2 Bds | 2 Ba
1,244 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$1,598,000
Pacifica Honolulu #4707
3 Bds | 3 Ba
1,521 ft²
  • Asking Price: $1,580,000

    $50,000 price drop 8 days ago

Description
'04' stack unit located Diamond Head side of building with ocean views. Penthouse has 10 FOOT floor-to-ceiling windows which create an open feeling. Sold with additional STORAGE unit, located next to the 4th floor parking stall (P4-069) with EV CHARGER. Another parking stall is Mezz. (PM-026) so easy for getting in and out. Upgraded engineered wood flooring extended from the living areas into all bedrooms, motorized window covering throughout, TOTO Washlet in the main bathroom, installed California closet system in the all closets. Ae'o is located in one of the most desired new neighborhoods in Honolulu at Kakaako, Ward Village near Ala Moana Shopping Center. Ala Moana Beach Park, Magic Island, shopping, theater, and variety of restaurants. First class building amenities include two pools, BBQ pavilions, gym, saunas, movie theater, guest suites, dog play area, play ground, and more.
    The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on March 27, 2025.Information is deemed reliable but not guaranteed.
    • Mar 19, 2025 Price $1,580,000
    • Mar 06, 2025 Listed at $1,630,000
    • Address: 1001 Queen St, Honolulu, HI 96814.
       
    • Built: 2018, 466 Units on 40 Floors, Studio - 3BR, Pets: OK (verify)
       
    • Amenities: Rooftop Terrace, Lap Pool, Leisure Pool, Children's Play Area, 6 Covered Outdoor Dining Pavilions & Cabanas, Gym, Outdoor Workout Space, yoga Area, 3 Guest Suites, Steam & Dry Sauna, Movie Theater, Karaoke Room Private Dining Room with Catering Kitchen, Dog Run.
       
    • Short-term Vacation Renting: Not Allowed.
       
    • Developer: Howard Hughes Corporation.

    Aeo, part of Ward Village’s 2nd phase in Kakaako, w  ..... Read more.




    Other Aeo Listings
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    $1,418,000
    Aeo #2602
    2 Bds | 2 Ba
    983 ft²
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    $1,388,000
    Aeo #2504
    2 Bds | 2 Ba
    985 ft²
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    $1,350,000
    AE'O #2002
    2 Bds | 2 Ba
    983 ft²
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    $1,350,000
    Aeo #1804
    2 Bds | 2 Ba
    978 ft²
    You do not own the land, but have the right to use the land until an expiration year. At expiration the ownership typically reverts back to the land owner.
    Buyer and Seller have reached an agreement and are under contract. The sale may be subject to one or more contingencies.
    We have handled many transactions for clients who purchase Hawaii real estate without visiting. By request, we can prepare thorough property videos to ensure you are familiar with every detail necessary. All documents can be signed remotely.
    Buyer and Seller have reached an agreement and are under contract. The sale is expected to close / record soon.
    We will be happy to work with you as a Buyer's agent. Call us to learn more: 808-943-9000.
    Note: A Seller's agent has a fiduciary responsibility towards the Seller. Working with a Buyer's agent objectives and goals are aligned, at no cost to you, the Buyer.
    Other fees could be a special assessment, reserve contributions etc.
    DOM = Days On Market. Our site shows listings immediately. A brand new listing may show DOM 2 or 3 days, if listing agent did not upload the same day listing agreement was executed.
    Includes estimated monthly mortgage payment, maintenance / HOA fees & property taxes. The estimate does not include insurance premiums.
    Learn about property tax rates.