Fifty+ Condos for Sale in the St. John's Area - Listings updated throughout the day

 

Contact Us

Provide a valid email address.
Newsletter consent

*Your information will never be shared with any third party.

Contact Info

The Hann Group

385 E White Hills Rd.
St. John's, NL A1A 5X7

1-709-728-1169
info@LarryHann.com

Follow Us

Filter agent's by last name

All H
Portrait of Larry Hann, Realtor® CBA.®.

Larry Hann

Realtor® CBA.®
#smedia-tag#

 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` <= '100000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '100000' AND `price` <= '200000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '200000' AND `price` <= '300000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '300000' AND `price` <= '400000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '400000' AND `price` <= '500000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '500000' AND `price` <= '600000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '600000' AND `price` <= '700000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '700000' AND `price` <= '800000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '800000' AND `price` <= '900000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '900000' AND `price` <= '1000000' LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `price` >= '1000000' LIMIT 1' at line 1

Sort by:

 

  • All Listings
Sort by:
Something went wrong when loading #property-valuation#. Sorry for the inconvenience.

Latest From Our Blog...

Welcome to your real estate blog!

Your first blog post Before you get started make sure to update your blog's title, metadata and hero image. You can find these... Read More

Testimonial

I recently engaged the services of Larry to sell a large condominium unit in St. John's during a not so good time of the year - winter. Despite the time of year and the poor local economy, Larry's marketing strategy and persistent personal follow-up generated significant interests/showings and, before the snow shovels were put away, the unit was sold. I strongly recommend Larry and his team.

2017

Dave Cook
Testimonial

I want to take time to thank you for helping me buy my investment condo in St. John’s. Your personal interest and commitment made it an easy, enjoyable transaction. Buying a property sight unseen can be a daunting prospect but you knew exactly how to handle all the details. Your referrals to other professionals such as lawyers and insurance brokers were impeccable. I was fortunate to choose a professional with strong personal ethics and integrity. Thank you again, Larry, for such a great effort, with your help I was able to purchase just what I had been looking for, and I appreciate that your service didn’t just end after the deal was closed. I would recommend Larry’s service to any of my friends

Lillian Dodds
Testimonial

Words cannot express our appreciation for everything Larry has done to ensure our recent condo purchase and sale went smoothly. We relied quite heavily on Larry for his knowledge of the condominium market and his many recommendations, as well as his proven marketing strategy. Larry was always available when we needed him and he essentially guided us through the process from start to finish, with exceptional follow-up throughout. You will not find a more professional or dedicated real estate agent.

July 2013

Bill and Margo Noseworthy
Testimonial

I can’t say enough good things about Larry’s help when I sold my brother’s condo. He answered all my questions and made sure that the condo was prepped and ready for the market. The marketing was top notch with great pictures, a well written description and easily found online. His team handled all the paperwork. It was a smooth transaction from beginning to end. I will encourage my family and friends to use his services and I would not think of going elsewhere should I need to use a real estate agent in the future. Many, many thanks Larry.

Molly McGrath