<% Set conTRRN = Server.CreateObject("ADODB.Connection") strconTRRN = "DSN=WebSQL; Database=TRRN; UID=trrn_public; PWD=trr457" conTRRN.Open strconTRRN Set rs = Server.CreateObject("ADODB.Recordset") If Request.QueryString("mode")="FarmandRanch" Then sqlrs = "SELECT * FROM Property INNER JOIN Users ON Property.UserName = Users.UserName WHERE (Users.OfficeID = 14) AND Property.PropertyType = 'Residential (Farm-Ranch)' AND (Property.Status = 'Active' Or Property.Status = 'Pending' Or Property.Status = 'PendingCTS') Order By Property.ListPrice DESC" ElseIf request.querystring("mode") = "Residential" Then sqlrs = "SELECT * FROM Property INNER JOIN Users ON Property.UserName = Users.UserName WHERE (Users.OfficeID = 14) AND Property.PropertyType = 'Residential (Town-S/D)' AND (Property.Status = 'Active' Or Property.Status = 'Pending' Or Property.Status = 'PendingCTS') Order By Property.ListPrice DESC" ElseIf request.querystring("mode") = "Acreage" Then sqlrs = "SELECT * FROM Property INNER JOIN Users ON Property.UserName = Users.UserName WHERE (Users.OfficeID = 14) AND Property.PropertyType = 'Acreage' AND (Property.Status = 'Active' Or Property.Status = 'Pending' Or Property.Status = 'PendingCTS') Order By Property.ListPrice DESC" ElseIf request.querystring("mode") = "Lots" Then sqlrs = "SELECT * FROM Property INNER JOIN Users ON Property.UserName = Users.UserName WHERE (Users.OfficeID = 14) AND Property.PropertyType = 'Lot' AND (Property.Status = 'Active' Or Property.Status = 'Pending' Or Property.Status = 'PendingCTS') Order By Property.ListPrice DESC" ElseIf request.querystring("mode") = "Commercial" Then sqlrs = "SELECT * FROM Property INNER JOIN Users ON Property.UserName = Users.UserName WHERE (Users.OfficeID = 14) AND Property.PropertyType = 'Commercial' AND (Property.Status = 'Active' Or Property.Status = 'Pending' Or Property.Status = 'PendingCTS') Order By Property.ListPrice DESC" Else sqlrs = "SELECT * FROM Property INNER JOIN Users ON Property.UserName = Users.UserName WHERE (Users.OfficeID = 14) AND (Property.Status = 'Active' Or Property.Status = 'Pending' Or Property.Status = 'PendingCTS') Order By Property.ListPrice DESC" End If rs.Open sqlrs, conTRRN, 0, 3 %> Market Realty

Market Realty, Inc.

   
 Doak Lambert
Mr. Lambert is a purebred livestock auctioneer and owner of Lambert Auction Co., Inc. He has been a full time auctioneer since 1988 and conducts purebred cattle and horse auctions throughout the United States. He is a graduate of Texas A&M University where he holds a Bachelor of Science in Animal Science. While at A&M, he was a member of the Livestock and Meats Judging Teams and president of the Block & Bridle Club. Mr. Lambert attended Missouri Auction School in 1986 and was the 1989 Texas State Champion Auctioneer. In 2006, Mr. Lambert and ringman, Cody Long, teamed up to win the team championship of the World Auto Auction Competition. He is a member of both the National Auctioneers Association and the Texas Auctioneers Association. Prior to starting his own auction company, he was involved in several facets of the livestock industry including a cow/calf operation, a stocker operation and a feed lot operation. Today, in addition to selling several purebred sales, Mr. Lambert is also an auctioneer at numerous auto auctions throughout the Dallas-Fort Worth Metroplex. He also works with several charities including Make-A-Wish, Big Brother/Big Sister, Juvenile Diabetes, The Epilepsy Foundation and Habitat for Humanity.





Mark is the owner/operator of Switzer Auction Services in Bellville, TX, which has been in business since 1986.Mark has bilingual auctioneering capabilities and is currently licensed as an auctioneer in the states of Texas and Louisiana. He has received the Certified Auctioneers Institute (CAI) designation, the highest designation in the auction industry. He is a member of the National Auctioneers Association, and the Texas Auctioneers Association, and is a licensed Texas Real Estate Agent.






Geary has been an Auctioneer for 14 years, as well as a real estate broker for 16 years.  He was had lifetime experience in agriculture, having been an Agricultural Extension Agent for over 3 years.  He has further experience in ranch management and has 13 years of business ownership experience.  He is a sales representative for national irrigation equipment, and is the owner of a purebred cattle and horse operation.  He earned a B.S. in Animal Science from Texas A&M University in 1976.  Geary is a member of: American Red Brangus Assoc., International Brangus Breeders Assoc., American Miniature Horse Assoc., American Miniature Horse Registry, Washington County Fair Assoc., and First Baptist Church. 




 Geary Stutts



 Mark Switzer





Bookmark This Site

To Contact Us:

2201 Becker Dr Brenham TX 77833
400 N Main St Burton TX 77835
108 W Thigpen Carmine TX 78932

Brenham Email– agents@marketrealty.com Carmine Email– market@industryinet.com
Burton Email-  burton@marketrealty.com

Brenham P 979-836-9600 Fax 979-836-6689 Burton P 979-289-2159 Fax 979-289-2159
Carmine P 979-278-3866 Fax 979-278-3866


 

<% rs.close conTRRN.close %>