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


Keola Lai 600 Queen Street Unit 1407 Honolulu HI 96813

$835,000 | OahuRE Rebate $4,175 | Active

Price dropped on 03-18-2024. Original price was $850,000

Listed on 08-28-2023

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

1,045 Square Feet Living * $883 Total Association Fees

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

Learn How to Eliminate the Buyer’s Agent Commission..

Contact Us for a Showing and a 20% Commission Rebate.

Property Last Viewed: 04/26/2024 11:02 AM, Total Views Today: 2, Total Views: 729, 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 Keola Lai since this property was listed.

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

The last sale on July 2, 2015, used a VA loan, so it should be assumable at a lower interest rate.

Listed previously on April 23, 2015 for $689,000. View Details

Price Decreased 2 times. View Details

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

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

Price trends for Keola Lai.

There were 15 units sold in the last 2 years in the Keola Lai building.


Keola Lai 600 Queen Street  Unit 1407

Details * Showing Request * Top * 1 * Next

Click on any photo to view next photo.

Keola Lai 600 Queen Street  Unit 1407

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

Learn More About Our Selling Options

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

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

Keola Lai 600 Queen Street  Unit 1407

Details * Showing Request * Top * 22 * Previous

Older Photos From A Previous Listing

Keola Lai 600 Queen Street  Unit 1407

Keola Lai 600 Queen Street  Unit 1407

View additional older photos

Property Details

Top of Page * Showing Request * Questions?


MLS#: 202319937 * Questions?
Status: Active since 08-28-2023 See History
Price: $835,000
Rebate: $ 4,175 from OahuRE.com.
Monthly: $ 5,896.52 Update the default down payment and interest rate
  Monthly payment estimate for $ 835,000 price, 10% down, 6.60% interest rate, 30 year loan, $ 214 taxes, and $ 883 fees. Insurance not included.
Beds: 2   Baths: 2   Half: 0  Parking Spaces: 2
Living Sq Ft: 1,045
Land Tenure: FS - Fee Simple
Total Fees: $883
Lanai Sq Ft: 0
Address: 600 Queen Street 1407 Honolulu HI 96813
Region: Metro - Activity
Neighborhood: Kakaako - Activity
Street: Queen - Activity * Queen Street Stats
Building Name: Activity in Keola Lai * Keola Lai Stats
Charts: Charts for this Building
Statistics: Live Building Stats
Showing: Showing Request

Top of Page * Showing Request * Questions?

Original: $850,000
Change: $-15,000    -1.76%
Parcel#: 1-2-1-048-008-0089
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 242 days in Active or In Escrow Showing
Date: Listed: 08-28-2023
Date: Status Change: 08-28-2023
Recent History: Last Sold on 07-02-2015 for $689,000 - MLS# 201506141 - Seller's Agent: Judy Nishimura, Buyer's Agent: Gloria C Brasuel
Year Built: 2008 Remodeled:
View: City, Mountain, Ocean, Sunrise
Frontage:
Monthly Tax: $214 Year: 2023
Land: FS - Fee Simple
Condition: Excellent

Top of Page * Showing Request * Questions?

Description:

Beautiful, good as new, 2 bed, 2 bath, 2 spacious non-tandem parking stalls. Floor to ceiling windows in livingroom and primary bedroom, cooler side of the building. Enjoy city views, partial mountain and ocean views too. Spacious living room and kitchen, real wood cabinets, obscured glass features, granite counters, new stainless steel stove, large pantry closet, breakfast bar, space for full size dining! Preferred model, primary bedroom privately located at the end of long hall is quite spacious... room for kingsized furniture and desk or sitting area. Large primary bath, long double vanity, closet. Newer full size laundry set! Luxury, pet friendly condo, Energy Star rated, windows stylishly tinted filtering direct sunlight. Windows open wide for indoor outdoor feel. Keola Lai has phenomenal amenities: large heated pool, whirlpool, outdoor kitchen, BBQ and eating area, fitness center, elegant spaces, 24hr security, guest parking, EV chargers, car wash area. Exquisite building in Kakaako, walk to shop and dine- a classy condo that can quickly become "home" or home away. Fee of approximately $180/mo covers portion of shared common area electric. Less than most other condo fees.

 
 
Inclusions: AC Central, Blinds, Cable TV, Ceiling Fan, Dishwasher, Disposal, Dryer, Microwave Hood, Range/Oven, Refrigerator, Smoke Detector, Washer

Amenities: BBQ, Car Wash, Condo Association Pool, Exercise Room, Fire Sprinkler, Heated Pool, Other, Pool on Property, Recreation Area, Resident Manager, Security Guard, Trash Chute, Whirlpool

Utilities: Construction: Concrete, Double Wall Lot Features: Floor: Ceramic Tile, Laminate Disclosures: Pets Allowed (Verify), Property Disclosure Stmt, See Remarks Land Recorded: Regular System Furnished:

Possession: At Closing, Negotiable Terms: Cash, Conventional, VA Sale Conditions: None Pet Friendly: Yes Occupancy: 60% Number of Parking Spaces: 2 Parking Spaces Number: 5092,5046 Floor Number: 14 Elevators: 3 Management Company Name & Phone: Hawaiiana 808-593-9100

Top of Page * Showing Request * Questions?

Sold Price:
Concession:
Closed:
Sold Ratio:
Days Sold:
Land: $88,100
Building: $744,300  
Assessed Total: $832,400  
Assessed Ratio: 100.31%
Pool:
Location:
Parking: Assigned, Covered - 2, Guest

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: Keola Lai
New Const: No

Top of Page * Showing Request * Questions?

Maint. Fee: $883
Assoc. Fee: $0
Other Fee: $0
Includes: Cable TV, Internet Service, Other Common Expenses, Sewer, Water
Total Fees: $883
Exemption: 100000
Other: 0
Lanai Sq Ft: 0
Garage Sq Ft: 0
Avg Sq Ft Living: $799.04
Security: Key, Keyed Elevator, Security Patrol, Video
Rental Income: $0
Zoning: KA - State jurisdiction, refer
Flood Zone: Zone X * 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 Coldwell Banker Realty (808) 721-1600

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
03-18-2024 202319937 Price Decrease $845,000 $835,000 $835,000 $0 $832,400 $88,100 $744,300
10-27-2023 202319937 Price Decrease $850,000 $845,000 $835,000 $0 $832,400 $88,100 $744,300
08-28-2023 202319937 New Listing $850,000 Active $835,000 $0 $832,400 $88,100 $744,300
07-03-2015 201506141 Sold $850,000 Sold $689,000 $689,000 $682,100 $44,900 $637,200
06-25-2015 201506141 Pending In Escrow Showing In Escrow Not Showing $689,000 $689,000 $682,100 $44,900 $637,200
05-11-2015 201506141 Active Continue to Show Active In Escrow Showing $689,000 $689,000 $682,100 $44,900 $637,200
04-25-2015 201506141 New Listing Active Active $689,000 $689,000 $682,100 $44,900 $637,200

Top of Page * Showing Request * Questions?

Pet Friendly Building - Always confirm with Agent.

Pet Policy: 1 Pet - under 35 lbs.

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 Keola Lai

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

Rate:
5.85% 6.10% 6.35% 6.60% 6.85% 7.10% 7.35% 7.60% 8.10%
0% Down
$4,926$5,060$5,196$5,333$5,471$5,611$5,753$5,896$6,185
3.5% Down
$4,754$4,883$5,014$5,146$5,280$5,415$5,552$5,689$5,969
10% Down
$4,433$4,554$4,676$4,800$4,924$5,050$5,178$5,306$5,567
20% Down
$3,941$4,048$4,157$4,266$4,377$4,489$4,602$4,717$4,948
30% Down
$3,448$3,542$3,637$3,733$3,830$3,928$4,027$4,127$4,330
40% Down
$2,956$3,036$3,117$3,200$3,283$3,367$3,452$3,537$3,711
50% Down
$2,463$2,530$2,598$2,666$2,736$2,806$2,876$2,948$3,093

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 Keola Lai 600 Queen Street Unit 1407

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

Top of Page * Showing Request * Questions?



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