RENTED 09/01/2023
Photos
About
Details
Open Houses
Neighborhood
Amenties & Features
Prices
Schools
Price history
Activity
Taxes
Tour report
Recently sold
Map View
Harbor Square unit 24G, Downtown condo
4 min walk to Irwin Memorial Park
29 min walk to Ala Moana Beach
28 min walk to Point Panic
28 min walk to Point Panics
About lifestyles
Available 2 bedroom, 2 bath on 24th floor at HARBOR SQUARE. Convenient downtown location. Walk to work, Beautiful City and Partial Ocean Views. Unit includes full kitchen with cook top with air fryer, vinyl flooring, fully renovated bathrooms, central air conditioning, and open lanai. Utilities included: Electricity, internet, water/sewer. Long term lease. Six months minimum. No pets, no smoking. Parking is available to rent from third party manager & Street parking. Renters Insurance required. Building amenities include: 24/7 security, laundry room, pool, BBQ. **Appointments only by PHONE CALL (808) 223-1688 & TEXT
Read more
Rental details
624 sqft interior area
- Condo building Harbor Square
- Year Built 1971
- Year Remodeled 2022
- Original list price $2,800
- Days on market 103
- Price per sqft $4/sqft
- Baths 2
- Beds 2
-
Address
225 Queen Street unit 24G, Honolulu, HI, 96813
- Total area 740 sqft
- Open Lanai area 116 sqft
- Neighborhood Downtown
- Land SqFt 67,910 sqft
- Furnished Type Full
- Rental Type Long Term
- Date Available September 1, 2023
- View City, Ocean, Other
- Pets allowed No data
Open Houses
No upcoming open houses
Neighborhood: Downtown
Nearby & commute
Walkability
Coffee shops
—
no data
Bus stop
—
no data
Supermarket
—
no data
Costco
—
no data
Hospital
—
no data
Park
—
no data
Beach
—
no data
Elementary school
—
no data
Middle school
—
no data
High school
—
no data
Local airport
—
no data
18 / 20
Most Walkable
►
18-20
Most Walkable
15-18
Very walkable
10-15
Somewhat walkable
1-10
Car dependent
Walkability according to the National Walkability Index
Amenities & Features
Ceramic Tile, Vinyl floors
Floors
Ceramic Tile, Vinyl
Furnished
Full
Security
24-hr. Security, Key, Security Patrol, Video
Utilities
AC Central, Cable, Electricity, Hot Water, Internet, Sewer, Trash, Water
Property Condition
Excellent
Building Style
High-Rise 7+ Stories
View
City, Ocean, Other
Amenities
BBQ, Community Laundry, Pool on Property, Recreation Area, Resident Manager, Security Guard, Trash Chute
Unit features
AC Central, Cable TV, Corner/End, Drapes, Lanai, Range/Oven, Refrigerator, Smoke Detector
Downtown prices
Average price $1.63m
Neighborhood average sales price*
$1.63m
Neighborhood median sales price*
$1.02m
Number or sales*
6
*last 6 months
Schools
15 schools with rating up to 8
| School rating | Distance | |
|---|---|---|
|
Kawaiaha'o Church School
872 Mission Lane,
Honolulu, HI 96813
Elementary School
|
0.351mi | |
| out of 10 |
Myron B. Thompson Academy - A New Century Public Charter School
1040 Richards St,
Honolulu, HI 96813
Middle School
|
0.424mi |
| out of 10 |
Myron B. Thompson Academy - A New Century Public Charter School
1040 Richards St,
Honolulu, HI 96813
High School
|
0.424mi |
| School rating | Distance | |
|---|---|---|
|
Kawaiaha'o Church School
872 Mission Lane,
Honolulu, HI 96813
|
0.351mi | |
| out of 10 |
Myron B. Thompson Academy - A New Century Public Charter School
1040 Richards St,
Honolulu, HI 96813
|
0.424mi |
|
St Andrews Priory School
224 Queen Emma Square,
Honolulu, HI 96813
|
0.461mi | |
|
K12 International Academy
1390 Miller Street ,
Honolulu, HI 96813
|
0.501mi | |
| out of 10 |
Voyager - A Public Charter School
547 Halekauwila St,
Honolulu, HI 96813
|
0.539mi |
| School rating | Distance | |
|---|---|---|
| out of 10 |
Myron B. Thompson Academy - A New Century Public Charter School
1040 Richards St,
Honolulu, HI 96813
|
0.424mi |
|
St Andrews Priory School
224 Queen Emma Square,
Honolulu, HI 96813
|
0.461mi | |
|
K12 International Academy
1390 Miller Street ,
Honolulu, HI 96813
|
0.501mi | |
|
The Keystone School
1390 Miller Street,
Honolulu, HI 96813
|
0.501mi | |
| out of 10 |
Central Middle School
1302 Queen Emma St,
Honolulu, HI 96813
|
0.529mi |
| School rating | Distance | |
|---|---|---|
| out of 10 |
Myron B. Thompson Academy - A New Century Public Charter School
1040 Richards St,
Honolulu, HI 96813
|
0.424mi |
|
St Andrews Priory School
224 Queen Emma Square,
Honolulu, HI 96813
|
0.461mi | |
|
The Keystone School
1390 Miller Street,
Honolulu, HI 96813
|
0.501mi | |
|
K12 International Academy
1390 Miller Street ,
Honolulu, HI 96813
|
0.501mi | |
|
Pacific Buddhist Academy
1710 Pali Highway,
Honolulu, HI 96813
|
0.937mi |
School ratings provided by Greatschools.org
© 2023. All rights reserved.
Price history
Rented Sep 1, 2023
| Date | Event | Price | $/sqft | Source |
|---|---|---|---|---|
| Sep 1, 2023 | Rented | $2,800 | $3.78 | MLS #202319398 |
| Aug 22, 2023 | New Listing rental | $2,800 +30.23% | $3.78 | MLS #202319398 |
| Mar 8, 2021 | Sold | $329,000 +43.04% from last sold price | $444.59 | Public Record |
| Jan 15, 2021 | Active Under Contract | $329,000 | $444.59 | MLS #202100589 |
| Jan 9, 2021 | New Listing | $329,000 +43.04% | $444.59 | MLS #202100589 |
| Oct 10, 2018 | Rented | $2,150 | $2.91 | MLS #201826860 |
| Oct 5, 2018 | New Listing rental | $2,150 -2.27% | $2.91 | MLS #201826860 |
| Jun 8, 2014 | Rented | $2,200 | $2.97 | MLS #201411726 |
| Jun 4, 2014 | New Listing rental | $2,200 +29.41% | $2.97 | MLS #201411726 |
| Apr 7, 2011 | Rented | $1,700 | $2.30 | MLS #1104172 |
| Apr 6, 2011 | New Listing rental | $1,700 | $2.30 | MLS #1104172 |
| Apr 4, 2011 | Sold | $230,000 -7.63% from last sold price | $310.81 | Public Record |
| Apr 4, 2011 | In Escrow - not showing | $249,000 | $336.49 | MLS #1100449 |
| Feb 3, 2011 | Active Under Contract | $249,000 | $336.49 | MLS #1100449 |
| Jan 12, 2011 | New Listing | $249,000 | $336.49 | MLS #1100449 |
Tax & MLS details 225 Queen Street unit 24G, Honolulu, HI, 96813
34 - BMX-4 Central Business Mix zoning / MLS #202319398
TMK
1-2-1-016-015-0135
Zoning
34 - BMX-4 Central Business Mix
Flood Zone
Zone X
Lease renegotiation date
Sep 1, 2023
Listed by
Locations LLC
(808) 735-4200
(808) 735-4200
MLS #
202319398
Hawaii House tour report for this rental
No reviews yet
Stunning views
Ocean views
Open floorplan
Needs Work
Street noise
We do not have a Hawaii House tour report for this listing yet.
As soon as we do, we post it here.
As soon as we do, we post it here.
Recently sold nearby 225 Queen Street unit 24G in Downtown
Frequently asked questions for 225 Queen Street unit 24G
When was this rental built and last sold?
This house was build in 1971 and sold in 2023.
What is the full address of this rental?
225 Queen Street unit 24G, Honolulu, HI, 96813.
Are there beaches near 225 Queen Street unit 24G?
The nearest beach is 1.098 miles away, called Ala Moana Beach. It should take about 29 min walk.
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. Copyright 2023 by HiCentral Mls, Ltd. Listing courtesy of Locations LLC. Some 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. 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. Hawaii House Inc. is a real estate brokerage firm licensed to conduct business in the State of Hawaii. Information deemed reliable, but not guaranteed.
Listings last updated on August 31, 2023.
Hawaii House Last checked less than a minute ago.
Downtown & nearby Neighborhoods
- Ala Moana homes for sale
- Alewa Heights homes for sale
- Aliamanu homes for sale
- Chinatown homes for sale
- Dillingham homes for sale
More
Less