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 = 32 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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 = 32 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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 = 32 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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;

11472 Linna Lane
Tuscaloosa, AL 35474
Contact the OSC Team - Sandy Pines with D.R. Horton - Birmingham, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2164 Square Feet
Agency: D.R. Horton - Birmingham
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Sandy Pines: Visit Sandy Pines by D.R. Horton, our new home community in Tuscaloosa, Alabama! Located just minutes away from the University of Alabama and Shelton State Community College in Moundville, AL, making this a great place for potential homebuyers with a commute to these college towns. Moundville is filled with a rich archeological history as well and offers places to hike for outdoor adventurers. Sandy Pines is conveniently situated right off AL-69 S, offering quick access to all the fine dining, shopping, and entertainment Tuscaloosa has to offer. Sandy Pines features home plans up to 1,272 square feet to larger plans up to 2,511 square feet, with elegant kitchens, stylish and durable flooring. The easy-to-use Smart Home Technology Package included in every home provides the ultimate convenience, allowing you to control key features with the touch of a button. Featured conveniences include lighting automation, IQ panel, video doorbell, keyless front door entry, and temperature control from the ease of your phone. Home to the University of Alabama, Tuscaloosa is a bustling city of innovation and economic growth, featuring a lively downtown district, the largest outdoor amphitheater in West Alabama, the River Market, and the Gateway Innovation and Discovery Center. Tuscaloosa is perfect for outdoor-inspired lifestyles, with its winding two-mile path along the Black Warrior River and almost 2,000 acres of green space, including over 35 parks, boat landings, six activity centers, and an 18-hole award-winning golf course. Plus, youre just minutes from boating, fishing, or relaxing on Lake Tuscaloosa. These homes will sell quickly, so tour Sandy Pines today and discover your new home!
MlsNumber: --
ListingId: 37521+240-37521-375210000-0085


Listing Provided By: D.R. Horton - Birmingham, original listing
Phone: (205) 851-0574
Agent Name: Contact the OSC Team - Sandy Pines
Disclaimer: Copyright © 2024 D.R. Horton. 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