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

Oahu Real Estate Logo

20% Rebate for Buyers
$3,500 Flat Fee for Sellers
2% Full Service for Sellers


Ae'o 1001 Queen Street Unit 1204 Honolulu HI 96814

This property was withdrawn and is not for sale.

$1,245,000 | OahuRE Rebate $6,225 | Withdrawn

Buyer's Agent Commission is 2.5%

Eliminate the Buyer's Agent Commission

Price dropped on 06-30-2020. Original price was $1,275,000

Listed on 03-11-2020 * 125 Days until Withdrawn on 07-14-2020

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

978 Square Feet Living * $949 Total Association Fees

Sell for a $3,500 Flat Fee or 2% with full service.

Contact us for a showing.

View Virtual Tour

Property Last Viewed: 05/18/2022 08:21 AM, Total Views Today: 0, Total Views: 230, Viewed History

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

Comparables by Bedrooms

Short Cuts

Update the default down payment and interest rate.



OahuRE.com Notes About This Property

View all new listings in the Ae'o since this property was listed.

Listed previously on July 14, 2020 for $1,245,000. View Details

Listed previously on December 9, 2018 for $1,498,000. View Details

Withdrawn previously on March 19, 2019 after 100 days on market. View Details

Price Decreased 7 times. View Details

Withdrawn 2 times. View Details

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

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

Price trends for Ae'o.

There were 70 units sold in the last 2 years in the Ae'o building.


Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 1 * Next

Click on any photo to view next photo.

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 2 * Previous * Next

Learn More About Our Selling Options

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 3 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 4 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 5 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 6 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 7 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 8 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 9 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 10 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 11 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 12 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 13 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 14 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 15 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 16 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 17 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 18 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 19 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 20 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 21 * Previous * Next

Ae'o 1001 Queen Street  Unit 1204

Details * Showing Request * Top * 22 * Previous

Older Photos From A Previous Listing

Ae'o 1001 Queen Street  Unit 1204

Ae'o 1001 Queen Street  Unit 1204

View additional older photos

Property Details

Top of Page * Showing Request * Questions?


MLS#: 202005136 * Questions?
Status: Withdrawn See History
Price: $1,245,000
Rebate: $ 6,225 from OahuRE.com.
Monthly: $ 5,835.80 Update the default down payment and interest rate
  Monthly payment estimate for $ 1,245,000 price, 10% down, 3.11% interest rate, 30 year loan, $ 96 taxes, and $ 949 fees. Insurance not included.
Beds: 2   Baths: 2   Half: 0  Parking Spaces: 2
Living Sq Ft: 978
Land Tenure: FS - Fee Simple
Total Fees: $949
Lanai Sq Ft: 0
Address: 1001 Queen Street 1204 Honolulu HI 96814
Region: Metro - Activity
Neighborhood: Kakaako - Activity
Street: Queen - Activity * Queen Street Stats
Building Name: Activity in Ae'o * Ae'o Stats
Charts: Charts for this Building
Statistics: Live Building Stats
Showing: Showing Request

Top of Page * Showing Request * Questions?

Original: $1,275,000
Change: $-30,000    -2.35%
Parcel#: 1-2-3-002-106-0065
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 125 days in Active or In Escrow Showing
Date: Listed: 03-11-2020
Date: Status Change: 07-14-2020
Year Built: 2018 Remodeled:
View: City, Coastline, Ocean
Frontage: Other
Monthly Tax: $96 Year: 2019
Land: FS - Fee Simple
Condition: Excellent

Top of Page * Showing Request * Questions?

Description:

Welcome home to Ae'o, Ward Village's newest island-modern luxury destination. This well-priced 2 bedroom, 2 bath unit offers incredible value as 2 bedroom unit in Ae'o. Located on the desired Diamond Head side, panoramic sapphire and turquoise ocean views captivate throughout the 978 sq.ft contemporary floor plan. An unrivaled casual island lifestyle awaits with direct access to Kakaako's flagship Whole Foods, nearby boutique shops, restaurants, and entertainment options throughout Ward Village and just two blocks from Ala Moana Beach Park and Ala Moana Shopping Center.

Sold with additional storage unit, located next to the parking stall. Resort-style amenities include two swimming pools, theater room, dining room, exercise gym, guest suites, 24-hour security & more await in award-winning Ward Village's newest icon, Ae'o.

 
 
Inclusions: AC Central, Auto Garage Door Opener, Blinds, Cable TV, Dishwasher, Disposal, Dryer, Microwave Hood, Range/Oven, Refrigerator, Smoke Detector, Washer

Amenities: BBQ, Exercise Room, Fire Sprinkler, Meeting Room, Pool on Property, Recreation Area, Recreation Room, Resident Manager, Sauna, Security Guard, Storage, Trash Chute, Whirlpool

Utilities: Construction: Concrete, Double Wall Lot Features: Floor: Hardwood, W/W Carpet Disclosures: Call Listor, Pets Allowed (Verify), Property Disclosure Stmt Land Recorded: Regular System Furnished: None

Possession: At Closing Terms: Cash, Conventional Sale Conditions: None Pet Friendly: Yes Occupancy: 50% Number of Parking Spaces: 2 Parking Spaces Number: 6057, 6058 Floor Number: 12 Elevators: 0 Management Company Name & Phone: Hawaiiana 593-9100

Top of Page * Showing Request * Questions?

Sold Price:
Concession:
Closed:
Sold Ratio:
Days Sold:
Land: $64,200
Building: $264,900  
Assessed Total: $329,100  
Assessed Ratio: 378.30%
Pool:
Location:
Parking: Assigned, Covered - 2, Tandem

Top of Page * Showing Request * Questions?

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

Top of Page * Showing Request * Questions?

Maint. Fee: $885
Assoc. Fee: $26
Other Fee: $38
Includes: Cable TV, Internet Service, Other Common Expenses, Sewer, Water
Total Fees: $949
Exemption: 0
Other: 0
Lanai Sq Ft: 0
Garage Sq Ft: 0
Avg Sq Ft Living: $1,273.01
Security: Key, Keyed Elevator, 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 * 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.

Listing courtesy of Sachi HI Pacific Century Prop.

Top of Page * Showing Request * Questions?


Core Logic Logo

Property History from MLS

Date MLS# Change Old Value New Value List Price Sold Price Assessed Total Land Building
11-20-2020 202017239 Sold In Escrow Showing Sold $1,135,000 $1,115,000 $1,150,800 $63,200 $1,087,600
10-07-2020 202017239 In Escrow Showing Active In Escrow Showing $1,135,000 $1,115,000 $1,150,800 $63,200 $1,087,600
10-01-2020 202017239 Price Decrease $1,195,000 $1,135,000 $1,135,000 $1,115,000 $1,150,800 $63,200 $1,087,600
08-07-2020 202017239 Price Decrease $1,245,000 $1,195,000 $1,135,000 $1,115,000 $1,150,800 $63,200 $1,087,600
07-14-2020 202017239 New Listing $1,245,000 Active $1,135,000 $1,115,000 $1,150,800 $63,200 $1,087,600
07-14-2020 202005136 Withdrawn Active Withdrawn $1,245,000 $0 $329,100 $64,200 $264,900
06-30-2020 202005136 Price Decrease $1,275,000 $1,245,000 $1,245,000 $0 $329,100 $64,200 $264,900
03-11-2020 202005136 New Listing $1,275,000 Active $1,245,000 $0 $329,100 $64,200 $264,900
03-19-2019 201830885 Withdrawn Active Withdrawn $1,185,000 $0 $152,000 $63,700 $88,300
03-15-2019 201830885 Price Decrease $1,274,000 $1,185,000 $1,185,000 $0 $152,000 $63,700 $88,300
02-10-2019 201830885 Price Decrease $1,370,000 $1,274,000 $1,185,000 $0 $152,000 $63,700 $88,300
01-26-2019 201830885 Price Increase $137,000 $1,370,000 $1,185,000 $0 $152,000 $63,700 $88,300
01-26-2019 201830885 Price Decrease $1,398,000 $137,000 $1,185,000 $0 $152,000 $63,700 $88,300
12-18-2018 201830885 Price Decrease $1,498,000 $1,398,000 $1,185,000 $0 $152,000 $63,700 $88,300
12-10-2018 201830885 New Listing $1,498,000 Active $1,185,000 $0 $152,000 $63,700 $88,300

Top of Page * Showing Request * Questions?


Comparables

Instant Comparables

Comparables with Options

Multiple Comparable Options

Best Comparable Properties by Building

Similar Properties Sorted by Smallest Price Difference First

Listings in Ae'o

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 * 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 General Information

Department of Planning & Permitting All Permits

Dept. of Emergency Management Public Safety Info

Tax Records and Property History in this Neighborhood

Tax Records and Property History in this Building

Top of Page * Showing Request * Questions?


Sex Offender Information

Attorney General Logo

View a map of Sex Offenders for this Zip Code

Top of Page * Showing Request * Questions?


Daily Watch List

Add to Daily Watch List by Parcel Number

Top of Page * Showing Request * 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 nearby Airbnb locations.

View Kakaako Neighborhood Boundary

View Tax Records

All Neighborhood Boundaries in the Metro Region

Neighborhood Boundaries

View Full Size in Google Maps

Top of Page * Showing Request * Questions?



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

School Map

Top of Page * Showing Request * 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 * Questions?



Google Earth

Neighborhoods Near Kakaako Shown on Google Earth
 
Googe Earth View

Top of Page * Showing Request * Questions?



Google Traffic Maps

Example Traffic Map

Top of Page * Showing Request * Questions?



Estimated Monthly Mortgage Payment

View OahuRE Mortgage and Interest Savings Calculator

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

Rate:
2.36% 2.61% 2.86% 3.11% 3.36% 3.61% 3.86% 4.11% 4.61%
0% Down
$4,829$4,991$5,155$5,323$5,494$5,667$5,844$6,023$6,390
3.5% Down
$4,660$4,816$4,975$5,137$5,301$5,469$5,639$5,812$6,166
10% Down
$4,346$4,492$4,640$4,791$4,944$5,101$5,259$5,421$5,751
20% Down
$3,863$3,993$4,124$4,258$4,395$4,534$4,675$4,818$5,112
30% Down
$3,380$3,494$3,609$3,726$3,846$3,967$4,091$4,216$4,473
40% Down
$2,897$2,994$3,093$3,194$3,296$3,400$3,506$3,614$3,834
50% Down
$2,415$2,495$2,578$2,662$2,747$2,834$2,922$3,012$3,195

Top of Page * Showing Request * Questions?



Crime Mapping

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

Top of Page * Showing Request * Questions?



Yelp

Popular Yelp Links Sorted by Review Count Near Ae'o 1001 Queen Street Unit 1204

Most Popular, Restaurants, Shopping, Arts & Entertainment, Active Life Activities

Top of Page * Showing Request * Questions?



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 05.25.22. Information is deemed reliable but not guaranteed. Copyright: 2022 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