The Can See My House From Here trophy in Borderlands 2 is story-related and can't be missed.
You will unlock the trophy once you complete the 11th story mission "Bright Lights, Flying City". The steps below (taken from the Xbox 360 guide on TA by mast3r 0r0m1s):
*** Spoiler - click to reveal ***- Use Fast Travel station and get to your friends
- Go to the extraction point
- Cross waterway
- Pick up lunar supply beacon
- Kill Gluttonous Thresher
- Go to Overlook and deploy beacon
- Establish Fast Travel link and defend it