Midlothian market intelligence