Search Listings Advanced Search Open Houses Buyer's 20% Rebate Sell for 2% Sell for $3,500 Statistics Help Tools Saved Searches Testimonials Blog Contact ☰

Oahu Real Estate Logo

We've sold 2,090+ listings for over $1.34 billion, saving our clients over $12 million. See our sales on Google Maps.

Aalii

987 Queen Street Unit 3006 Honolulu HI 96814

$588,000 | Active

Contact us for an estimated $2,940 commission rebate and no obligation showing.

Sell for a $3,500 Flat Fee or 2% With Full Service.

Listed on 06-24-2026

0 Bedrooms, 1 Full Bath, 0 Half Baths, 1 Parking Spaces

367 Square Feet Living * $591 Total Association Fees

Save This Property to Receive Automatic Email Updates When the Status Changes

Recommended Comparables

Property Last Viewed: 10/05/2026 03:11 PM, Total Views Today: 0, Total Views: 31

Viewed History

Short Cuts

AI Prompts

Once copied, paste it into your favorite AI.



OahuRE.com Notes About This Property

View all new listings in the Aalii since this property was listed.

Listed previously on September 23, 2022 for $640,000. View Details

Fell out of escrow or Temporarily Withdrawn 1 time. View Details

There are 6 buildings in the same neighborhood with similar units for sale.

There are 20 buildings in the same region with similar units for sale.

There were 57 units sold in the last 2 years in the Aalii building.


987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 1 * Next

Click on any photo to view the next photo.

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 2 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 3 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 4 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 5 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 6 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 7 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 8 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 9 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 10 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 11 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 12 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 13 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 14 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 15 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 16 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 17 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 18 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 19 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 20 * Previous * Next

987 Queen Street  Unit 3006

Details * Showing Request with 20% Rebate * Top * 21 * Previous

Property Details

Top of Page * Showing Request with 20% Rebate * Questions?


MLS#: 202608242 * Questions?
Status: Active since 06-24-2026 See History
Price: $588,000
Monthly: $ 4,396.07 Update the default down payment and interest rate
  Monthly payment estimate for $ 588,000 price, 10% down, 7.4% interest rate, 30 year loan, $ 141 taxes, and $ 591 fees. Insurance not included.
Beds: 0   Baths: 1   Half: 0  Parking Spaces: 1
Living Sq Ft: 367
Land Tenure: FS - Fee Simple
Total Fees: $591
Lanai Sq Ft: 0
Address: 987 Queen Street 3006 Honolulu HI 96814
Region: Metro - Activity
Neighborhood: Kakaako - Activity
Street: Queen - Activity * Queen Street 3006 Stats
Building Name: Activity in Aalii * Aalii Stats
Statistics: Live Building Stats
Showing: Showing Request with 20% Rebate

Top of Page * Showing Request with 20% Rebate * Questions?

Original: $588,000
Change: $0    0.00%
Parcel#: 1-2-3-002-107-0542
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 107 days in Active or In Escrow Showing
Date: Listed: 06-24-2026
Date: Status Change: 06-24-2026
Recent History: Not on the MLS in the last 10 years
Year Built: 2019 Remodeled:
View: City, Coastline, Garden, Golf Course, Mountain, Ocean, Sunrise
Frontage:
Monthly Tax: $141 Year: 2025
Land: FS - Fee Simple
Condition: Above Average

Top of Page * Showing Request with 20% Rebate * Questions?

Description:

Start your day with golden sunrises and 30th floor ocean views from your Aalii smart home. Imagine being the first one to check the surf, from your bed! this preferred, rarely available "06 stack" is the closest tower studio to the ocean. this preferred Diamond Head/East facing apartment allows for natural, cool temperatures all day long! Come home to your thoughtfully decorated, Fully Furnished hotel-like suite complete with Bosch appliances. You're just a short elevator ride away from luxurious amenities such as 42nd floor Penthouse Sunset & Ocean facing Lounge Areas, Penthouse world class Gym, theatre/movie room, yoga Room, infinity Pool, Jacuzzi, Keiki Pool, Keiki Grassy Area & Playground, Dog run(Pet Friendly!), BBQ entertaining areas, & so much more! Aalii is located in the heart of Ward Village allowing close access to Whole Foods Market, Dining, Ward Village Community Park, Ala Moana Beach Park, Kewalo Basin/Harbor, Longs Drugstore and not far from Ala Moana Mall, Honolulu Airport and Foodland Farms. **Note: Maintenance fee includes master association (Ward Village) dues. **Note: unit is sub-metered, billed separately. Based on usage.

 
 
Inclusions: AC Split, Auto Garage Door Opener, Book Shelves, Dishwasher, Disposal, Dryer, Kitchenware, Linens, Microwave Hood, Range/Oven, Refrigerator, Washer, Water Heater

Amenities: BBQ, Condo Association Pool, Exercise Room, Fire Sprinkler, Heated Pool, Meeting Room, Patio/Deck, Pool on Property, Recreation Area, Recreation Room, Resident Manager, Restaurant, Security Guard, Trash Chute, Walking/Jogging Path, Whirlpool

Utilities: Construction: Concrete Lot Features: Floor: Ceramic Tile, Vinyl Disclosures: Licensed Owner, Listor Owner, Pets Allowed (Verify), Property Disclosure Stmt, See Remarks Land Recorded: Regular System Furnished: Negotiable

Possession: Other, Subject to Rental Lease Terms: 1031 Exchange, Cash, Conventional, Other, VA Sale Conditions: None Pet Friendly: Yes Occupancy: 54% Number of Parking Spaces: 1 Parking Spaces Number: 7092 Floor Number: 30 Elevators: 6 Management Company Name & Phone: Associa 8088360911

Top of Page * Showing Request with 20% Rebate * Questions?

Sold Price:
Concession:
Closed:
Sold Ratio:
Days Sold:
Land: $17,900
Building: $542,700  
Assessed Total: $560,600  
Assessed Ratio: 104.89%
Pool:
Location:
Parking: Assigned, Garage, Guest, Open - 1, Secured Entry

Top of Page * Showing Request with 20% Rebate * Questions?

District Locator: DOE Locator to Confirm District
Area Total: 0
Acres: 0.0000
Topography:
Building Style: High-Rise 7+ Stories
Building: Aalii
New Const: No

Top of Page * Showing Request with 20% Rebate * Questions?

Maint. Fee: $556
Assoc. Fee: $35
Other Fee: $0
Includes: Internet Service, Other Common Expenses, Sewer, Water
Total Fees: $591
Exemption: 0
Other: 0
Lanai Sq Ft: 0
Garage Sq Ft: 0
Avg Sq Ft Living: $1,602.18
Security: Keyed Elevator, Security Patrol, Video
Rental Income: $2,800
Zoning: Kak – Kakaako Community Development Project
Flood Zone: Zone AE * Check if this property is in a Flood Zone
Tsunami Zone: Check if this property is in a Tsunami Zone * Tsunami Info * Oahu Tsunami Map
Roofing:
Set-Backs: Roads:
Easements:

Top of Page * Showing Request with 20% Rebate * Questions?

Links:
Google Maps * Supermarkets * Schools * Private Schools * Hospitals * Restaurants * Gyms * Shopping * Attractions * Beaches * Churches * Tax Info including a Plat Map PDF and GIS Parcel Map and Building Sketch
Commuting:
Waikiki * Downtown * Ala Moana * Airport * Kapolei * Hawaii Kai * Kailua Town * Windward Mall * Waikele * North Shore
Barbers Point * Camp Smith * Fort Shafter * Hickam * Lualualei * K-Bay Marine * Pearl Harbor * Schofield * Tripler * Wheeler * VA Mortgage Info
Closing Cost Calculators:
Buyer's Closing Cost Calculator to estimate the buyer's closing cost.
Seller's Closing Cost Calculator to estimate the seller's closing cost.

Top of Page * Showing Request with 20% Rebate * Questions?


Core Logic Logo

Property History from MLS

Date MLS# Change Old Value New Value List Price Sold Price Assessed Total Land Building
06-24-2026 202608242 New Listing Active $588,000 $0 $560,600 $17,900 $542,700
06-04-2023 202220171 Cancelled Active Cancelled $640,000 $0 $191,300 $16,100 $175,200
04-20-2023 202220171 Back On Market In Escrow Showing Active $640,000 $0 $191,300 $16,100 $175,200
03-27-2023 202220171 Active Under Contract Active In Escrow Showing $640,000 $0 $191,300 $16,100 $175,200
09-23-2022 202220171 New Listing Active Active $640,000 $0 $191,300 $16,100 $175,200

Top of Page * Showing Request with 20% Rebate * Questions?


Comparables

Best Comparable Properties by Building

Comparable Properties Sorted by Smallest Price Difference First

Listings in Aalii

Listings in Kakaako Neighborhood

View listings near this one sorted by the closest listing on the top: 1 Mile, 2 Miles, 3 Miles, 4 Miles, 5 Miles

Top of Page * Showing Request with 20% Rebate * Questions?


City and County Public Information Links

City and County Logo

Tax Info including a Plat Map PDF and GIS Parcel Map

Department of Planning & Permitting All Permits

Tax Records and Property History in this Neighborhood

Tax Records and Property History in this Building

Top of Page * Showing Request with 20% Rebate * Questions?


Public Schools for This Property

Oahu public school map

View the public schools for this property

Top of Page * Showing Request with 20% Rebate * Questions?


Daily Watch List

Add to Daily Watch List by Parcel Number

Top of Page * Showing Request with 20% Rebate * Questions?



Google Maps

View this property's location * Top of Page

View Nearby Schools on Google Maps - Preschools, Elementary Schools, Middle Schools, or High Schools

View Nearby Parks, Farmer's Markets, and Best Restaurants on Google Maps

Directions from this property to nearest Grocery Store, Hospital, Gas Station, Beach Park, and Park

View Kakaako Neighborhood Boundary

All Neighborhood Boundaries in the Metro Region

Neighborhood Boundaries

View Full Size in Google Maps

Top of Page * Showing Request with 20% Rebate * Questions?



Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools

School Map

Top of Page * Showing Request with 20% Rebate * Questions?



View Directions on Google Maps to nearest Beach Access

View Beach Access Points All Over Oahu including Street View, Directions, and Facilities Info

Beach Access Map

Top of Page * Showing Request with 20% Rebate * Questions?



Google Earth

Neighborhoods Near Kakaako Shown on Google Earth
 
Googe Earth View

Top of Page * Showing Request with 20% Rebate * Questions?



Google Traffic Maps

Example Traffic Map

Top of Page * Showing Request with 20% Rebate * Questions?



Estimated Monthly Mortgage Payment

View OahuRE Mortgage and Interest Savings Calculator

Save $82,613.09 of interest charges by adding an extra payment of $100 per month. View details from the link above.

Rate:
6.65% 6.90% 7.15% 7.40% 7.65% 7.90% 8.15% 8.40% 8.90%
0% Down
$3,775$3,873$3,971$4,071$4,172$4,274$4,376$4,480$4,689
3.5% Down
$3,643$3,737$3,832$3,929$4,026$4,124$4,223$4,323$4,525
10% Down
$3,397$3,485$3,574$3,664$3,755$3,846$3,939$4,032$4,220
20% Down
$3,020$3,098$3,177$3,257$3,338$3,419$3,501$3,584$3,751
30% Down
$2,642$2,711$2,780$2,850$2,920$2,992$3,063$3,136$3,282
40% Down
$2,265$2,324$2,383$2,443$2,503$2,564$2,626$2,688$2,813
50% Down
$1,887$1,936$1,986$2,036$2,086$2,137$2,188$2,240$2,344

Top of Page * Showing Request with 20% Rebate * Questions?


Listing courtesy of Locations LLC


Active means currently for sale. Active Under Contract means in escrow but still showing and looking for offers. Pending means in escrow and not looking for offers. Hold means the property is temporarily off the market. Cancelled means it is off the market.

Buyer's rebate is 20% of our commission when we represent the buyer.

Based on the information from the Multiple Listing Service of HiCentral MLS, Ltd. Active listings last updated on 10.09.26. Information is deemed reliable but not guaranteed. Copyright: 2026 by HiCentral MLS, Ltd.

IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

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 and we offer you are 20% rebate on our commission. 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. The offer of compensation to cooperating participants is made only to the Participants and MLS Subscribers of HICMLS or Participants and MLS Subscribers of other Reciprocating Boards as set forth in that certain Multiple Listing Service Reciprocal Agreement, as amended from time to time, which is incorporated herein by reference

Our Privacy Policy