Back To Top

Your Niagara

SELECT p.*, pao.office_Name, pb.building_BedroomsTotal, pb.building_BathroomTotal, pb.building_HalfBathTotal, ( SELECT CONCAT( image_directory, image_id ) FROM rets_property_image WHERE property_ID = p.property_ID AND image_type != '' ORDER BY image_SequenceId ASC LIMIT 1 ) AS property_image , (3959 * acos(cos(radians(43.168687634481)) * cos(radians(p.`property_latitude`)) * cos(radians(p.`property_longitude`) - radians(-79.250364191055)) + sin(radians(43.168687634481)) * sin(radians(p.`property_latitude`)))) AS distance FROM nrcrealty AS j INNER JOIN rets_property AS p ON p.property_id = j.property_id LEFT JOIN rets_property_to_agent AS pta ON pta.property_id = p.property_id LEFT JOIN rets_property_agent AS pa ON pa.agent_ID = pta.agent_id LEFT JOIN rets_property_agent_office AS pao ON pao.office_ID = pa.agent_office_id LEFT JOIN rets_property_building AS pb ON pb.property_id = p.property_id WHERE p.property_id IN ( ) ORDER BY distance ASC, p.property_last_saved DESC
Population: 133,115

St. Catharines

There are many reasons why the Garden City is a great place to call home! St. Catharines offers all the amenities of city life while maintaining its small town warmth and charm. This vital area of the Niagara Region has a lot to offer its residents whether they are young families or retirees. St. Catharines boasts a vibrant downtown business area with fine local restaurants and cafes, as well as the new Meridian Centre Sports Complex and the new Brock Centre for the Arts. In addition to public beaches residents can also enjoy many public libraries and recreation centres, well maintained parks and numerous festivals throughout the year such as the Grape and Wine festival which takes place every autumn. Port Dalhousie, located on the southern shores of Lake Ontario, is a quaint historic harbour-front village and is also the terminus of the first three Welland canals which were built in 1820. For almost 100 years, Port Dalhousie has been home to the Royal Canadian Henley Regatta in which rowers from all over the world come to compete. Port Dalhousie features two historic light houses built in the late 1800’s as well as a beautiful antique carousel which visitors can ride for the price of 5 cents each, as well as, a public beach, lakeside marina, and many shops and restaurants.

Royal LePage Offices

33 Maywood Ave.
St. Catharines, ON. L2R 1C5
905 688 4561

Sorry, no listings were found with these parameters.