I can get the information for you on whichever area you are interested in but keep in mind some properties are sold in distress so you all this has to be calculated into the equation. Is there a particular property you are looking at? If so, I can get you comps on sq ft in that area just to give you an idea. good luck :)
Price per square foot alone may not tell you much. Were they short sales or REO's? In what condition? Do you know the neighborhood of each?
I love all the data that's available on line these days, but there are some times when a human really can give you a better answer
I do have a general price/sqft chart for Brentwood that you can download from my website at http://www.tomschieber.com/blog/featured-posts/brentwood-hom (click the charts and graphs link at the bottom of the post).
However - price/sqft is a very limiting metric. Smaller houses sell for more per sqft than larger houses, and features, amenities and of course LOCATION are too important to ignore - which is what happens when you're just looking at price/sqft.
If you do not have an agent please contact me. The link below is a list of homes for sale in Brentwood.
Depending on the reason for your search, there are other resources, like your Realtor. If you're looking for properties to use as comps for property you are about to buy or sell, or if you are looking for comps to use for applying for property tax reassessment, your best bet is a realtor who can discuss marketability and market value.