Where are you from @jimjamjoo? Interesting that a small North Notts town should be a subject of such discourse.
Mansfield is one of the UK's most deprived areas (in the top 20% as FB of 2019). Bassetlaw has areas of deprivation but fairs better than Mansfield. Both areas suffered due to the closing of the collieries and now the power stations.
Retford is small but the surroundings are lovely. 10-15 mins to Clumber Park. 20 mins to Sherwood Forest. 40 mins to Sheffield/Meadowhall.
Within the town there is King's Park (there is a child friendly play and water park). The main park can get busy on warm sunny days and some groups will leave litter......but you get that anywhere.
On the outskirts of town is the Idle Valley Nature Reserve - that's a lovely walk (different ones you can do and different things to see as the season's change).
There is close proximity to two good independent schools (3-18) as well as one very good state secondary in Tuxford or the Grammar school in Gainsborough. Majority of primaries are ok but check carefully as a couple are not!
Not much to do for kids/teenagers. Local shops are limited.....but there are plenty of cafes/bistros/pubs for eating out. Nearest cinema is Worksop .....decent enough and hardly ever busy. Bigger cinema chains in Doncaster and Sheffield.
House prices are good and there are some lovely areas in and around Retford/surrounding villages.
Biggest drawback - BREXIT voters! The town is insular and the prevailing political current is definitely right leaning. Currently represented by a new Tory MP (who seems as ineffectual as his Labour predecessor). Local Council is Labour. There are very few BAME families - there is (for now) a thriving and friendly Polish community.
Depends on what you want for your family. In my opinion it's far friendlier and attractive than Mansfield l/Worksop but not as nice as Newark (trains are more frequent to London from there). Not much for young families/teens, but within easy reach of Nottingham and Sheffield, the Peaks, east coast etc.
PM me if you want.....lived here all my life