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
Short Cuts
- Details
- Instant Comparables
- Comparables by Bedrooms
- Other Comparable Options
- Short Link
- Similar Listings
- History from MLS
- Add to Saved Search
- Tax Info
- Tax Website
- Maps
- Buyer's Closing Cost Calculator
- Seller's Closing Cost Calculator
- Listing Traffic
- PDF No Photos
- PDF 2 Photos
- PDF All Photos
- Mortgage Calc
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.
There were 70 units sold in the last 2 years in the Ae'o building.
Details * Showing Request * Top * 1 * Next
Click on any photo to view next photo.
Details * Showing Request * Top * 2 * Previous * Next
Details * Showing Request * Top * 3 * Previous * Next
Details * Showing Request * Top * 4 * Previous * Next
Details * Showing Request * Top * 5 * Previous * Next
Details * Showing Request * Top * 6 * Previous * Next
Details * Showing Request * Top * 7 * Previous * Next
Details * Showing Request * Top * 8 * Previous * Next
Details * Showing Request * Top * 9 * Previous * Next
Details * Showing Request * Top * 10 * Previous * Next
Details * Showing Request * Top * 11 * Previous * Next
Details * Showing Request * Top * 12 * Previous * Next
Details * Showing Request * Top * 13 * Previous * Next
Details * Showing Request * Top * 14 * Previous * Next
Details * Showing Request * Top * 15 * Previous * Next
Details * Showing Request * Top * 16 * Previous * Next
Details * Showing Request * Top * 17 * Previous * Next
Details * Showing Request * Top * 18 * Previous * Next
Details * Showing Request * Top * 19 * Previous * Next
Details * Showing Request * Top * 20 * Previous * Next
Details * Showing Request * Top * 21 * Previous * Next
Details * Showing Request * Top * 22 * Previous
Older Photos From A Previous Listing
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 |
| 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 |
| 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. |
|
| 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 |
|
| 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 |
| 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 |
| 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: | |
| 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?
| 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
Best Comparable Properties by Building
Similar Properties Sorted by Smallest Price Difference First
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
Sex Offender Information
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?
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
Top of Page * Showing Request * Questions?
Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools
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
Top of Page * Showing Request * Questions?
|
|
| Neighborhoods Near Kakaako Shown on Google Earth | |
 |
|
Top of Page * Showing Request * Questions?
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?
Last 7 days of crime (you can then change it to go back further)
Top of Page * Showing Request * Questions?
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 |