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

120 Tall Oaks Lane
Youngsville, LA 70592

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $278,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1750 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (337) 522-7554

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Garbage Disposer
Architectural Style: New Traditional
Construction Materials: Brick
Flooring: Tile, Wood, Laminate
Heating: Central Furnace, Fireplace
Interior Features: Ceiling Fans, Walk-in Closet(s), Whirlpool, Separate Shower, Cable Available, Crown Molding, Smoke Detector, Garage Door Opener, Cable Ready, Attic Access, Gas Stove Con, Computer Nook, MASTER BATH, All Window Treatments, Fiber Available, Electric Dryer Con, Electric Washer Con, 9+ Ft Ceiling, Varied Ceiling Heights, Icemaker Con
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3
Utilities: Cable Available, Electricity Available, Cable Connected

Window Features

Exterior Features: Fence, Landscaped, Outside Light, Rear Yard Access
Fencing: Fenced
Parking Features: Garage
Roof: Composition

Neighborhood/Schools

Elementary School/District: G T Lindon
Middle/Junior High School/District:
High School/District: SOUTHSIDE
Subvidision Name: Sugarland Estates

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Sugarland Estates is a quiet, family friendly neighborhood just outside the heart of Youngsville. It's just minutes from the new high school, the town center, Sugar Mill Pond, and the SportsPlex. The home at 120 Tall Oaks is like new. The home was built with style and quality in mind. From the outside, you will love the quaint curb appeal and distressed bricks used in the construction. Walking into the home, there is a long hallway that opens up into a beautifully open floor plan for your guests and family to enjoy. The bedrooms are split, which is what everyone is asking for! The kitchen is a chefs delight, with tons of granite counter space and a exquisite wood custom cabinets. This is the one you've been searching for.
MlsNumber: --
ListingId: 24000812


Listing Provided By: EXP Realty, LLC, original listing
Phone: (337) 522-7554
Office Phone: (337) 522-7554
Agent Name: Blake Weaver
Disclaimer: Copyright © 2024 Realtor Association of Acadiana. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 359 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;
Real Estate Expert Photo for Alisa Dudenhoeffer
Alisa Dudenhoeffer
ASCIICape Premier Realty
Call Today!: (239) 896-4401

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App