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

Aalii

987 Queen Street Unit 508 Honolulu HI 96814

$495,000 | Active

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

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

Listed on 07-15-2025

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

364 Square Feet Living * $654 Total Association Fees

View Virtual Tour

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

Recommended Comparables

Property Last Viewed: 09/16/2025 10:32 PM, Total Views Today: 0, Total Views: 116

Viewed History

Short Cuts



OahuRE.com Notes About This Property

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

Seller is selling `As Is` and may not want to do repairs or issue credits during the inspection period.

Listed previously on July 8, 2024 for $575,000. View Details

Price Decreased 5 times. View Details

Expired 1 time. View Details

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

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

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



Ask ChatGPT about this Property


987 Queen Street  Unit 508

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

Click on any photo to view the next photo.

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

987 Queen Street  Unit 508

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

Property Details

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


MLS#: 202516182 * Questions?
Status: Active since 07-15-2025 See History
Price: $495,000
Monthly: $ 3,722.12 Update the default down payment and interest rate
  Monthly payment estimate for $ 495,000 price, 10% down, 6.87% interest rate, 30 year loan, $ 143 taxes, and $ 654 fees. Insurance not included.
Beds: 0   Baths: 1   Half: 0  Parking Spaces: 1
Living Sq Ft: 364
Land Tenure: FS - Fee Simple
Total Fees: $654
Lanai Sq Ft: 0
Address: 987 Queen Street 508 Honolulu HI 96814
Region: Metro - Activity
Neighborhood: Kakaako - Activity
Street: Queen - Activity * Queen Street 508 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: $495,000
Change: $0    0.00%
Parcel#: 1-2-3-002-107-0084
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 64 days in Active or In Escrow Showing
Date: Listed: 07-15-2025
Date: Status Change: 07-15-2025
Recent History: Expired Listing - Listed for 364 days starting on 07-08-2024 - MLS# 202415611
Year Built: 2019 Remodeled:
View: City
Frontage:
Monthly Tax: $143 Year: 2025
Land: FS - Fee Simple
Condition: Excellent, Above Average

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

Description:

Discover exceptional value at A'ali'i, Ward Village's award-winning tower in America's best planned community, where this thoughtfully designed studio offers premium living at an unbeatable price. Featuring generous square footage that extends onto your private lanai, this residence showcases natural stone countertops, European porcelain tile, luxury vinyl flooring, and a sleek Studio Becker kitchen with integrated refrigerator, complemented by individual split A/C and a premium Bosch washer/dryer for elevated comfort. Residents enjoy two distinct amenity experiences: the sky-high luxury of Lanai 42 on the 42nd floor with its state-of-the-art fitness center, sophisticated sky lounge, tranquil yoga studio, and versatile event spaces framed by breathtaking panoramic views, plus the resort-style recreation of the 8th floor featuring a sparkling pool, relaxing jacuzzi, family-friendly children's area, multiple cabanas, indoor/outdoor dining pavilions, and BBQ stations perfect for entertaining. Step outside your lobby into the vibrant heart of Ward Village, where world-class dining, boutique shopping, artisanal coffee, & wellness spas await, with the pristine sands of Ala Moana Beach.

 
 
Inclusions: AC Split, Dishwasher, Dryer, Microwave Hood, Range/Oven, Refrigerator, Washer

Amenities: BBQ, Dog Park, Exercise Room, Fire Sprinkler, Meeting Room, Patio/Deck, Playground, Pool on Property, Recreation Area, Security Guard, Trash Chute, Whirlpool

Utilities: Construction: Concrete, Other Lot Features: Floor: Vinyl Disclosures: Property Disclosure Stmt Land Recorded: Regular System Furnished: None

Possession: 45 Days or Less Terms: Cash, Conventional Sale Conditions: None Pet Friendly: No Occupancy: 20% Number of Parking Spaces: 1 Parking Spaces Number: 3-018 Floor Number: 5 Elevators: 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,300
Building: $565,700  
Assessed Total: $583,000  
Assessed Ratio: 84.91%
Pool:
Location:
Parking: Assigned, Covered - 1

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: $508
Assoc. Fee: $31
Other Fee: $115
Includes: Internet Service, Other Common Expenses, Sewer, Water
Total Fees: $654
Exemption: 0.00
Other: 0
Lanai Sq Ft: 0
Garage Sq Ft: 0
Avg Sq Ft Living: $1,359.89
Security: Key, Keyed Elevator, Security Patrol, Video
Rental Income: $2,250
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-15-2025 202516182 New Listing Active $495,000 $0 $583,000 $17,300 $565,700
07-08-2025 202415611 Expired Active Expired $499,000 $0 $650,100 $16,500 $633,600
06-16-2025 202415611 Price Decrease $519,000 $499,000 $499,000 $0 $650,100 $16,500 $633,600
12-09-2024 202415611 Price Decrease $529,000 $519,000 $499,000 $0 $650,100 $16,500 $633,600
11-18-2024 202415611 Price Decrease $539,000 $529,000 $499,000 $0 $650,100 $16,500 $633,600
10-29-2024 202415611 Price Decrease $559,000 $539,000 $499,000 $0 $650,100 $16,500 $633,600
10-11-2024 202415611 Price Decrease $575,000 $559,000 $499,000 $0 $650,100 $16,500 $633,600
07-08-2024 202415611 New Listing $575,000 Active $499,000 $0 $650,100 $16,500 $633,600

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


Comparables

Best Comparable Properties by Building

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

Rate:
6.12% 6.37% 6.62% 6.87% 7.12% 7.37% 7.62% 7.87% 8.37%
0% Down
$3,006$3,087$3,168$3,250$3,333$3,417$3,502$3,587$3,761
3.5% Down
$2,901$2,979$3,057$3,136$3,217$3,298$3,379$3,462$3,629
10% Down
$2,705$2,778$2,851$2,925$3,000$3,075$3,152$3,229$3,385
20% Down
$2,405$2,469$2,534$2,600$2,667$2,734$2,802$2,870$3,008
30% Down
$2,104$2,161$2,218$2,275$2,333$2,392$2,451$2,511$2,632
40% Down
$1,804$1,852$1,901$1,950$2,000$2,050$2,101$2,152$2,256
50% Down
$1,503$1,543$1,584$1,625$1,667$1,709$1,751$1,794$1,880

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 Ota Realty Consultants, 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 09.17.25. Information is deemed reliable but not guaranteed. Copyright: 2025 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