I see that you are looking for a home in Colchester? I live in Lebanon and would be glad to give you more information on homes in that price range in towns from Newington and surrounding towns of Colchester too! Just call me or email me and I will be glad to help. It costs you nothing for me to work for you. Cathy 860-642-9918 or email@example.com
This listing was pulled from Postlets.com where the listing agent made a fake listing to promote Bank Owned and Foreclosed homes. You can see it here: http://www.postlets.com/res/1558732
As you can see there are actually pictures of 4 or 5 different homes there, and there actually is no "Main Street" in Colchester - - just a very small snippet of road before South Main starts.
I apologize, but that is the issue with Trulia.com - there is no quality control over where it pulls the listings from. To really search all of Colchester's listings or anywhere in CT, go to my website and click "Search Entire Listings Database" - you can also sign up for emails if interested.
Thank you and I apologize that some agents out there use deceptive means to try and drum up business.