I think the best advice I've gotten about writing is that you should write the story the way it should be, then make compromises later if you have to.
Excellent advice if you are writing for someone else. Or if you want
to feel good about yourself as a creative person.
The reality is a working writer and a low budget filmmaker does not
have the luxury of this advice.
All writing and filmmaking is compromise. I write a lot of TV. I have
sever restrictions. I cannot write the story the way it should be - I
must write what they can and will shoot.
As a low budget filmmaker I must write what I can shoot.
I've seen years of this, "Ok, I want this script to be cheap, so I'll write a whole movie set on a sidewalk and in my apartment"
If I watch a movie and it starts out in a small apartment, and stays there for 10 minutes, I skip ahead to 20 minutes in. If they are still in that apartment, or their car, or a sidewalk, or a parking garage, I shut it off.
Unless it is truly excellent. If the story fits the limited location,
the actors are excellent, the photography inspired, the editing
sharp, the production design perfect you will continue to watch.
And if you do just skip and then shut off a truly excellent movie
only because of it's limited locations you are, perhaps, missing
out on something interesting.
I am not suggesting in any way to NOT look for great locations.
I even answered the question on best to approach someone about
shooting on their property. I'm saying there is nothing wrong with
using what you have.