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(42.993695141947)) * cos(radians(p.`property_latitude`)) * cos(radians(p.`property_longitude`) - radians(-799.250748775)) + sin(radians(42.993695141947)) * 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: 52,293

Welland


Known as the Rose City, Welland is at the heart of the Niagara Peninsula and easily accessible by all major transportation corridors. With a population of 50,631 (2011) Welland has it all from rural serenity to a thriving urban centre. Land and home prices are very competitive and relatively low as compared to much of Southern Ontario, making it a very affordable place to live. Welland is a commercial transportation hub located in the middle of the Welland Canal which links the St. Lawrence Seaway System to all major rail lines and connects directly to main highways. That’s why Welland is often referred to as the place “where rails and water meet”. Welland is just a 1 ½ hour drive from Toronto and a 45 minute drive to Buffalo, N.Y., thus providing quick and easy access to major amenities such as airports, national sporting events, concerts and much more.Welland has a large French speaking population and celebrates its multicultural Francophone heritage with the annual Folklore Festival. The Welland Food Festival and the Rose Festival are also well known summer attractions to the area.  Furthermore, Welland offers many different recreational facilities for residents to enjoy, such as the new Youngs Sports Plex featuring a FIFA regulation-sized indoor soccer field, 4 indoor tennis courts, and another 5 FIFA regulation outdoor soccer fields for sports enthusiasts. Welland is also home to Niagara College which,  with its 8,997 full-time students and 15,000 continuing education students is a centre of activity within the city.


Royal LePage Offices

#2-637 Niagara St., Welland, ON, L3C 1L9
905-734-4545
welland@royallepage.ca

Sorry, no listings were found with these parameters.