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 223 Honolulu HI 96814

Important: See the Active listing for this property

This property was cancelled and is not for sale.

$540,000 | Cancelled

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

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

Listed on 09-30-2024 * 67 Days until Cancelled on 12-06-2024

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

282 Square Feet Living * $412 Total Association Fees

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

Recommended Comparables

Property Last Viewed: 07/17/2026 12:03 PM, Total Views Today: 0, Total Views: 109

Viewed History

Short Cuts



OahuRE.com Notes About This Property

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

Listed previously on November 13, 2025 for $525,000. View Details

Price Decreased 3 times. View Details

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

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

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


987 Queen Street  Unit 223

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

Click on any photo to view the next photo.

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

987 Queen Street  Unit 223

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

Property Details

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


MLS#: 202422236 * Questions?
Status: Cancelled See History
Price: $540,000
Monthly: $ 3,706.82 Update the default down payment and interest rate
  Monthly payment estimate for $ 540,000 price, 10% down, 6.69% interest rate, 30 year loan, $ 162 taxes, and $ 412 fees. Insurance not included.
Beds: 0   Baths: 1   Half: 0  Parking Spaces: 1
Living Sq Ft: 282
Land Tenure: FS - Fee Simple
Total Fees: $412
Lanai Sq Ft: 0
Address: 987 Queen Street 223 Honolulu HI 96814
Region: Metro - Activity
Neighborhood: Kakaako - Activity
Street: Queen - Activity * Queen Street 223 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: $540,000
Change: $0    0.00%
Parcel#: 1-2-3-002-107-0021
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 67 days in Active or In Escrow Showing
Date: Listed: 09-30-2024
Date: Status Change: 12-06-2024
Year Built: 2019 Remodeled:
View: Garden
Frontage:
Monthly Tax: $162 Year: 2024
Land: FS - Fee Simple
Condition: Excellent

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

Description:

This sleek, and modern studio is located on the podium section of Kakaako's popular "Aalii." This units offers a convenient (private entrance) parking location which is very close to the podium and unit entrance. Situated on the podium level allows beautiful views of Victoria Ward Park. This beautifully designed studio offers high end Italian furnishings/built-ins to maximize space with elegance and comfort.

This is an ideal space for a minimalist lifestyle yet boasts a sophisticated living area. "Aalii" residents especially enjoy all of the luxury amenities including BBQs, dog park, gym, and meeting rooms. Located in the vibrant Kakaako area, you are steps away from all of the excitement, beauty, and conveniences that this community has to offer.

 
 
Inclusions: AC Split, Blinds, Cable TV, Convection Oven, Dishwasher, Disposal, Dryer, Refrigerator, Smoke Detector, Washer, Water Heater

Amenities: BBQ, Dog Park, Doorman, Exercise Room, Fire Sprinkler, Heated Pool, Meeting Room, Pool on Property, Resident Manager, Sauna, Security Guard

Utilities: Construction: Concrete, Steel Frame Lot Features: Floor: Laminate Disclosures: Property Disclosure Stmt Land Recorded: Regular System Furnished: Full

Possession: At Closing, Subject to Rental Lease Terms: Cash, Conventional Sale Conditions: None Pet Friendly: No Occupancy: 20% Number of Parking Spaces: 1 Parking Spaces Number: 7-006 Floor Number: 2 Elevators: Management Company Name & Phone: Associa 808 836 0911

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

Sold Price:
Concession:
Closed:
Sold Ratio:
Days Sold:
Land: $12,800
Building: $542,200  
Assessed Total: $555,000  
Assessed Ratio: 97.30%
Pool:
Location:
Parking: Assigned, Garage

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: $412
Assoc. Fee: $0
Other Fee: $0
Includes: Cable TV, Electricity, Hot Water, Internet Service, Sewer, Water
Total Fees: $412
Exemption: 0
Other: 0
Lanai Sq Ft: 0
Garage Sq Ft: 0
Avg Sq Ft Living: $1,914.89
Security: Card, Key, Keyed Elevator, Security Patrol, Video
Rental Income: $0
Zoning: 13 - A-3 High Density Apartment
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
04-14-2026 202525416 Price Decrease $515,000 $499,999 $499,999 $0 $494,500 $13,400 $481,100
02-19-2026 202525416 Price Decrease $520,000 $515,000 $499,999 $0 $494,500 $13,400 $481,100
12-17-2025 202525416 Price Decrease $525,000 $520,000 $499,999 $0 $494,500 $13,400 $481,100
11-13-2025 202525416 New Listing $525,000 Active $499,999 $0 $494,500 $13,400 $481,100
12-06-2024 202422236 Cancelled Active Cancelled $540,000 $0 $555,000 $12,800 $542,200
10-02-2024 202422236 New Listing Active Active $540,000 $0 $555,000 $12,800 $542,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?


Sex Offender Information

Attorney General Logo

View a map of Sex Offenders for this Zip Code

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 $67,963.43 of interest charges by adding an extra payment of $100 per month. View details from the link above.

Rate:
5.94% 6.19% 6.44% 6.69% 6.94% 7.19% 7.44% 7.69% 8.19%
0% Down
$3,217$3,304$3,392$3,481$3,571$3,662$3,754$3,846$4,034
3.5% Down
$3,104$3,188$3,273$3,359$3,446$3,534$3,622$3,712$3,893
10% Down
$2,895$2,973$3,053$3,133$3,214$3,296$3,378$3,462$3,631
20% Down
$2,573$2,643$2,714$2,785$2,857$2,929$3,003$3,077$3,227
30% Down
$2,252$2,313$2,374$2,437$2,500$2,563$2,628$2,692$2,824
40% Down
$1,930$1,982$2,035$2,089$2,143$2,197$2,252$2,308$2,420
50% Down
$1,608$1,652$1,696$1,740$1,785$1,831$1,877$1,923$2,017

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



Crime Mapping

Last 7 days of crime (you can then change it to go back further)

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


Listing courtesy of Keller Williams Honolulu


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