Sounds like you want to rent a property - contacting an active local realtor is your best bet. Of course, i would be happy to help you in your search.
In Brentwood, you are looking at a price range of $1700 to $3000 with most good rentals falling somewhere close to $2,200.
My number is 925-752-3969 if you have more questions. Hope this helps!