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

This property was cancelled and is not for sale.

$1,375,000 | Cancelled

Contact us for an estimated $6,875 commission rebate and no obligation showing.

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

Listed on 01-22-2026 * 0 Days until Cancelled on 01-22-2026

2 Bedrooms, 2 Full Baths, 0 Half Baths, 2 Parking Spaces

824 Square Feet Living * $1,287 Total Association Fees

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

Recommended Comparables

Property Last Viewed: 07/04/2026 08:11 PM, Total Views Today: 0, Total Views: 49

Viewed History

Short Cuts



OahuRE.com Notes About This Property

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

The last sale on July 7, 2026, used Cash financing, so it is not an assumable mortgage.

Listed previously on January 22, 2026 for $1,375,000. View Details

Listed previously on November 18, 2021 for $1,550,000. View Details

Price Decreased 4 times. View Details

Withdrawn 1 time. View Details

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

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

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


987 Queen Street  Unit 3702

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

Click on any photo to view the next photo.

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

987 Queen Street  Unit 3702

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

Property Details

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


MLS#: 202600761 * Questions?
Status: Cancelled See History
Price: $1,375,000
Monthly: $ 9,696.95 Update the default down payment and interest rate
  Monthly payment estimate for $ 1,375,000 price, 10% down, 6.43% interest rate, 30 year loan, $ 645 taxes, and $ 1,287 fees. Insurance not included.
Beds: 2   Baths: 2   Half: 0  Parking Spaces: 2
Living Sq Ft: 824
Land Tenure: FS - Fee Simple
Total Fees: $1,287
Lanai Sq Ft: 41
Address: 987 Queen Street 3702 Honolulu HI 96814
Region: Metro - Activity
Neighborhood: Kakaako - Activity
Street: Queen - Activity * Queen Street 3702 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: $1,350,000
Change: $25,000    1.85%
Parcel#: 1-2-3-002-107-0664
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 0 days in Active or In Escrow Showing
Date: Listed: 01-22-2026
Date: Status Change: 01-22-2026
Year Built: 2019 Remodeled:
View: City, Marina/Canal, Ocean
Frontage: Other
Monthly Tax: $645 Year: 2025
Land: FS - Fee Simple
Condition: Excellent

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

Description:

A'alii is centrally located in Ward Village close to Whole Foods and other food and commercial establishments. Short walking distance to Ala Moana Beach Park for your recreational needs. This preferred "02 Stack" Diamond Head side corner unit has never been occupied; almost brand new! Physical layout of this desirable high floor unit with 2 bedrooms and 2 full baths is well organized for the convenience of occupants in mind. Bosch appliances, natural stone counter tops, window shades, 2 closet systems and more! Excellent amenities are among the benefits which enhance the living quality of this unit. Priced to sell with special storage. This storage unit is located right next to #3702 main entrance (see photos); separate door & owner purchased separately. And exceptionally convenient parking spaces; one space located on the 2nd level at the garage entrance. The second space also located on the 2nd level with additional storage. Must see!!!

 
 
Inclusions: AC Split, Cable TV, Dishwasher, Disposal, Drapes, Dryer, Microwave Hood, Range/Oven, Refrigerator, Smoke Detector, Washer, Water Heater

Amenities: BBQ, Condo Association Pool, Dog Park, Exercise Room, Fire Sprinkler, Heated Pool, Meeting Room, Playground, Recreation Area, Recreation Room, Resident Manager, Security Guard, Storage, Trash Chute, Whirlpool

Utilities: Construction: Above Ground, Concrete, Double Wall Lot Features: Floor: Laminate, W/W Carpet Disclosures: Property Disclosure Stmt Land Recorded: Regular System Furnished: Partial

Possession: At Closing Terms: Cash, Conventional Sale Conditions: None Pet Friendly: No Occupancy: 52% Number of Parking Spaces: 2 Parking Spaces Number: 2-133, 2-048 Floor Number: 37 Elevators: 6 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: $39,000
Building: $1,305,900  
Assessed Total: $1,344,900  
Assessed Ratio: 102.24%
Pool:
Location:
Parking: Assigned, Covered - 2, Guest, Street

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: $1,252
Assoc. Fee: $35
Other Fee: $0
Includes: Hot Water, Internet Service, Other Common Expenses, Sewer, Water
Total Fees: $1,287
Exemption: 0
Other: 0
Lanai Sq Ft: 41
Garage Sq Ft: 0
Avg Sq Ft Living: $1,668.69
Security: Key, Security Patrol, Video
Rental Income: $0
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
07-07-2026 202601377 Sold In Escrow Showing Sold $1,295,000 $1,250,000 $1,344,900 $39,000 $1,305,900
06-15-2026 202601377 Active Under Contract Active In Escrow Showing $1,295,000 $1,250,000 $1,344,900 $39,000 $1,305,900
04-21-2026 202601377 Price Decrease $1,375,000 $1,295,000 $1,295,000 $1,250,000 $1,344,900 $39,000 $1,305,900
01-22-2026 202601377 New Listing $1,375,000 Active $1,295,000 $1,250,000 $1,344,900 $39,000 $1,305,900
01-22-2026 202600761 Cancelled Active Cancelled $1,375,000 $0 $1,344,900 $39,000 $1,305,900
01-22-2026 202600761 Price Increase $1,350,000 $1,375,000 $1,375,000 $0 $1,344,900 $39,000 $1,305,900
01-22-2026 202600761 New Listing $1,350,000 Active $1,375,000 $0 $1,344,900 $39,000 $1,305,900
11-15-2022 202129226 Withdrawn Active Cancelled $1,350,000 $0 $281,700 $34,700 $247,000
09-13-2022 202129226 Price Decrease $1,395,000 $1,350,000 $1,350,000 $0 $281,700 $34,700 $247,000
03-15-2022 202129226 Price Decrease $1,495,000 $1,395,000 $1,350,000 $0 $281,700 $34,700 $247,000
01-18-2022 202129226 Price Decrease $1,550,000 $1,495,000 $1,350,000 $0 $281,700 $34,700 $247,000
11-22-2021 202129226 New Listing $1,550,000 Active $1,350,000 $0 $281,700 $34,700 $247,000

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

Rate:
5.68% 5.93% 6.18% 6.43% 6.68% 6.93% 7.18% 7.43% 7.93%
0% Down
$7,963$8,182$8,404$8,628$8,854$9,083$9,315$9,548$10,022
3.5% Down
$7,684$7,896$8,109$8,326$8,544$8,765$8,989$9,214$9,671
10% Down
$7,167$7,364$7,563$7,765$7,969$8,175$8,383$8,594$9,020
20% Down
$6,370$6,546$6,723$6,902$7,083$7,267$7,452$7,639$8,018
30% Down
$5,574$5,727$5,883$6,039$6,198$6,358$6,520$6,684$7,016
40% Down
$4,778$4,909$5,042$5,177$5,313$5,450$5,589$5,729$6,013
50% Down
$3,982$4,091$4,202$4,314$4,427$4,542$4,657$4,774$5,011

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 Diamond Head Realty


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