Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2760 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2760 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2760 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1900 S Blue Bell Rd
Brenham, TX 77833

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,000,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 2913
Agency: MARKET REALTY, INC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 1969
Notes: Beautiful landscaped 10 acres in the heart of Brenham in a growing area. Close to schools, Blue Bell Creamery, Blue Bell aquatic center, retirement center and professional offices. Vintage 1970?s classic ranch style 4bd/2ba home with custom features and 2 car carport. Property also includes an office/guesthouse with 1bdrm/1bath, living/kitchen and utility. <br /> <br /> Ideal location for a townhome development. Located at the corner of Blue Bell Road (FM 577) and East Stone Street in Brenham. Zoned B-2 so many possibilities for development. SELLER TO CLEAR THE SITE WHERE THE FORMER GREENHOUSE OPERATION EXISTED. REMAINING BUILDINGS WILL BE THE FINE TRADITIONAL RESIDENCE, OFFICE AND EQUIPMENT BUILDING. This awesome corner location that is extensively landscaped would make a beautiful shaded green belt area for a multi family, professional office or townhouse development. In close proximity to the major retailers along HWY 290, Wal-Mart, Home Depot, Lowes, Hobby Lobby, PetSmart, Marshalls, Tractor Supply, HEB, Walgreens, many hotels and other retailers and restaurants such as Chili?s, Applebee?s, Mod Pizza, Taco Bell, Whataburger, Burger King, Hartz Chicken, Dairy Bar, Bushes Chicken and many others. Only a half mile form Blue Bell Creameries Brenham?s landmark tourist destination. A short distance to historic downtown Brenham with plenty of fine dining establishments, boutiques, theater and live music venues. Brenham?s EDF business park is nearby at FM 577 and HWY 290 and includes the Blinn College Tech training facility. <br /> <br /> Property features: City utilities, several access points along FM 577 and East Stone Street. Nearby businesses include professional offices, medical offices, warehouses, C-store, storage, assisted living, schools and high end residential.
MlsNumber: 138211


Listing Provided By: MARKET REALTY, INC., original listing
Name: MARKET REALTY, INC.
Phone: (979) 836-9600
Office Name: MARKET REALTY, INC.
Office Phone: (979) 836-9600
Agent Name: Susan Kiel
Disclaimer: Copyright © 2024 South Central Texas Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App