$1,580,000
$50K PRICE DROP

Ae'o 1001 Queen St Unit PH 3904 Honolulu, HI 96814

Kaka'ako Neighborhood

Estimated payment $9,589/month

Total Views 2,952
2 Beds
2 Baths
978 Sq Ft
$1,616 Price per Sq Ft

Highlights

  • Ocean View
  • Heated Pool
  • Wood Flooring
  • Fitness Center
  • Clubhouse
  • 3-minute walk to Victoria Ward Park

About This Home

'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.

Listing Agent

Aki Nakano

Shimizu Gateways Inc Brokerage Phone: (808) 922-2992 License #RB-20684 Listed on: 03/06/2025

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $9,980

Year Built

  • Built in 2018

Lot Details

  • Property is in excellent condition

HOA Fees

  • $31 Monthly HOA Fees

Property Views

Interior Spaces

  • 978 Sq Ft Home
  • 1-Story Property
  • Closed Circuit Camera

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 2 Full Bathrooms

Parking

  • 2 Parking Spaces
  • Covered Parking
  • Guest Parking
  • Assigned Parking

Pool

Listing and Financial Details

  • Assessor Parcel Number 1-2-3-002-106-0445

Community Details

Overview

  • Association fees include common areas, cable TV, internet, ground maintenance, maintenance structure, sewer, water
  • Ae'o Condos
  • Kakaako Subdivision

Amenities

  • Building Patio
  • Community Barbecue Grill
  • Community Deck or Porch
  • Sauna
  • Trash Chute
  • Clubhouse
  • Meeting Room
  • Community Storage Space

Recreation

  • Community Playground
  • Community Spa
  • Dog Park
  • Recreational Area

Security

  • Security Guard
  • Resident Manager or Management On Site
  • Card or Code Access
  • Secure Elevator
  • Fire Sprinkler System

Property Details

Home Type

Condominium

Est. Annual Taxes

$9,980

Year Built

Built in 2018

Lot Details

0

HOA Fees

$31 per month

Listing Details

  • Architectural Style: High Rise
  • Building Name: Ae'o
  • Inclusions: Auto Garage Door Opener,Blinds,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater
  • Property Sub Type: Condominium
  • Prop. Type: Residential
  • Year Built: 2018
  • Attribution Contact: (808) 922-2992
  • CommunityFeatures: Barbecue, Clubhouse, Conference/Meeting Room, Deck/Porch, Dog Park, Fitness, Other, Playground, Patio, Pool, Recreation Area, Sauna, Storage Facilities, Trash Chute
  • SecurityFeatures: Closed Circuit Camera(s), Elevator Secured, Key Card Entry, Fire Sprinkler System, Security Guard
  • Association Amenities: Management
  • MLS Status: Active
  • Subdivision Name: KAKAAKO
  • Entry Level: 39
  • Unit Levels: One
  • Living Area: 978.0
  • New Construction: No
  • Tax Year: 2024
  • Special Features: None

Interior Features

  • Flooring: Ceramic Tile, Hardwood
  • Furnished: Partially
  • Spa Features: Community
  • Full Bathrooms: 2
  • Total Bedrooms: 2

Exterior Features

  • Construction Type: Double Wall, Concrete
  • Lot Features: Private
  • Pool Features: Heated
  • Property Condition: Excellent
  • View: Coastline, City, Mountain(s), Ocean, Sunrise
  • View: Yes
  • Disclosures: Seller Disclosure

Garage/Parking

  • Parking Features: Assigned, Covered, Guest, Two Spaces, Secured
  • Total Parking Spaces: 2.0

Condo/Co-op/Association

  • Association Fee: 31.0
  • Association #2 Fee: 246.0

Fee Information

  • Association Fee Includes: Common Areas, Cable TV, Internet, Maintenance Grounds, Maintenance Structure, Sewer, Water

Lot Info

  • Parcel Number: 1-2-3-002-106-0445
  • Zoning Description: Kak – Kakaako Community Development Project

Multi Family

  • Maintenance Expense: 1017.57

Tax Info

  • Tax Annual Amount: 9979.92

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/20/2025 03/20/25 Price Changed $1,580,000 -3.1% $1,616 / Sq Ft
03/06/2025 03/06/25 For Sale $1,630,000 -- $1,667 / Sq Ft
Source: HiCentral MLS (Honolulu Board of REALTORS®)

Similar Homes in Honolulu, HI

  • 1001 Queen St Unit 2602, Honolulu, HI 96814

    $1,355,000

    • 2 Beds
    • 2 Baths
    • 983 Sq Ft
    • 1001 Queen St
    • Unit 2602
    • Honolulu, HI

    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

    Hiromi Farmer Coldwell Banker Realty

    Section Image
  • 1022 Prospect St Unit 903E, Honolulu, HI 96822

    $1,200,000

    • 2 Beds
    • 2 Baths
    • 1,711 Sq Ft
    • 1022 Prospect St
    • Unit 903E
    • Honolulu, HI

    Modern Elegance Meets Island Living at Royal Vista in this fully reimagined 2-bed/2-bath residence offering 1,711 sq. ft. of interior space. Completely renovated down to the studs and professionally curated, this high-floor unit starts with porcelain tile flooring and floor-to-ceiling Fleetwood windows (Cat III rated) that frame the stunning views and fill the space with light. The

    Scott Larimer Berkshire Hathaway HmSvc HI RE

    Section Image
  • 383 Kalaimoku St Unit 1916, Honolulu, HI 96815

    $1,758,800

    • 2 Beds
    • 2 Baths
    • 1,142 Sq Ft
    • 383 Kalaimoku St
    • Unit 1916
    • Honolulu, HI

    Discover unparalleled luxury in this fully furnished 2-bedroom, 2-bathroom corner unit located on the 19th floor of the prestigious Ritz-Carlton Residences in Waikiki. Enjoy the outdoors from your private covered lanai, an ideal spot to unwind while watching Friday night fireworks or simply soaking in the Hawaiian ambiance. As a resident of The Ritz-Carlton Residences, indulge in world-class

    Hanako Hata Starts International HI, Inc.

    Section Image
  • 1100 Ala Moana Blvd Unit 610, Honolulu, HI 96814

    $1,865,000

    • 2 Beds
    • 2 Baths
    • 1,164 Sq Ft
    • 1100 Ala Moana Blvd
    • Unit 610
    • Honolulu, HI

    Don't miss to be the 1st resident to this bright and spacious 2-bedroom, 2-bathroom unit in the most luxurious condo located in a highly sought-after building of Victoria Place just steps away from the vibrant heart of Honolulu. With 1,164 square feet of living space, this unit offers a modern, open-concept layout that's perfect for both entertaining and relaxing. Large windows allow natural

    Hanako Hata Starts International HI, Inc.

    Section Image
  • 7007 Hawaii Kai Dr Unit L14, Honolulu, HI 96825

    $1,200,000

    • 3 Beds
    • 2 Baths
    • 1,296 Sq Ft
    • 7007 Hawaii Kai Dr
    • Unit L14
    • Honolulu, HI

    Experience the ultimate Hawaii Kai lifestyle in this super private, marina-front, end-unit residence in the gated community of Mawaena Kai. Enjoy stunning, unobstructed views of Koko Head and direct marina access- perfect for paddle boarding & kayaking- right from your backyard. This spacious 3 bedroom, 2 bathroom townhome has 2 parking stalls- 1 covered with added attic storage space, 1

    Jessica White Caron B Realty

    Section Image
  • 1001 Queen St Unit 2506, Honolulu, HI 96814

    $1,320,000

    • 2 Beds
    • 2 Baths
    • 983 Sq Ft
    • 1001 Queen St
    • Unit 2506
    • Honolulu, HI

    Welcome to this furnished and rarely lived-in 2-bedroom 2-bath residence in the heart of the thriving Kakaako neighborhood. Situated on the preferred Diamond Head side of Ae’o building, this thoughtfully designed unit features floor-to-ceiling windows boasting stunning ocean, city & mountain views. Its efficient layout, complete with premium Bosch stainless steel appliances, quartz counter

    Mei Pang, R REMAX Hawaii

    Section Image
  • 1001 Queen St Unit 3315, Honolulu, HI 96814

    $1,150,000

    • 2 Beds
    • 2 Baths
    • 867 Sq Ft
    • 1001 Queen St
    • Unit 3315
    • Honolulu, HI

    Enjoy this beautiful 2 bed 2 bath high floor corner unit located on the 33rd floor of Ae'o, an iconic building in the vibrant Ward Village with direct access to Whole Foods store. Residents at Ae'o experience world-class amenities, such as a rooftop sky deck, resort-style pools, private dining rooms, a fitness center, and guest suites. With its prime location near Ala Moana Beach, shopping,

    Jie Gonsowski Corcoran Pacific Properties

    Section Image
  • 1000 Auahi St Unit 2510, Honolulu, HI 96814

    $1,550,000

    • 2 Beds
    • 2 Baths
    • 942 Sq Ft
    • 1000 Auahi St
    • Unit 2510
    • Honolulu, HI

    Desired corner-end unit with two lanais facing the mountain and Diamond Head side, offering great cross ventilation and beautiful views! Unit features designer wallpaper accents in living room and bedrooms, motorized blinds, Toto Bidet washlets, new ceiling fan & light system, new All-in-One Washer and Dryer system and more! Ko’ula has beautiful resort style amenities including large lap pool,

    Ken Treichler Real Select International LLC

    Section Image
  • 1000 Auahi St Unit 1504, Honolulu, HI 96814

    $1,795,000

    • 2 Beds
    • 2 Baths
    • 1,133 Sq Ft
    • 1000 Auahi St
    • Unit 1504
    • Honolulu, HI

    Welcome to Koula — meaning “red sugar cane” — ideally located next to the planned Central Park in Howard Hughes’ award-winning master-planned Ward Village. As one of its signature luxury towers, Koula blends modern comfort with island elegance. This 2-bedroom, 2-bath unit on the Diamond Head and Ocean and views through 8'8" floor-to-ceiling windows. Both bedrooms were upgraded to hardwood

    jung min yoo Hilina'i Homes Incorporated

    Section Image

Source: HiCentral MLS (Honolulu Board of REALTORS®)

MLS Number: 202502206

HiCentral MLS (Honolulu Board of REALTORS®)