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.122791920782)) * cos(radians(p.`property_latitude`)) * cos(radians(p.`property_longitude`) - radians(-799.2059763413)) + sin(radians(43.122791920782)) * 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
Stroll through downtown streets and visit many small shops and restaurants, or visit one of the numerous recreational parks in the city. Thorold has a strong history in the Niagara Region. First surveyed in 1788, Thorold has since transitioned from multiple small townships and communities into the City of Thorold. Along with many recreational parks, Thorold is home to numerous historical sites including Decew House, The Old Fire Hall Chestnut Hall, St Johns School House and and the Soldiers’ Monument.
Sorry, no listings were found with these parameters.