Title Page Background
DEBUG FN args: Array ( [0] => 1304 [1] => [2] => [3] => agent ) BEFORE: Site: 1304 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1304 Igate: njhud LocID: 1304 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1304 AND i.igate IN ('cihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1304 [1] => [2] => [3] => lender ) BEFORE: Site: 1304 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1304 Igate: njhud LocID: 1304 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1304 AND i.igate IN ('cihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1304 [1] => [2] => [3] => other ) BEFORE: Site: 1304 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1304 Igate: njhud LocID: 1304 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1304 AND i.igate IN ('cihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

713 Flag Creek Drive
Llano, TX 78643-0000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1792 Square Feet
Agency: Landmasters Hill Country
Agency Phone: (325) 247-5782

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator
Architectural Style: Ranch
Construction Materials: Brick
Flooring: Tile, Laminate
Heating: Central Furnace, Fireplace
Interior Features: Pantry, Walk-in Closet(s), Recessed Lighting, Breakfast Bar, Counters-solid Srfc
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Dining Room, Kitchen, Laundry, Living Room, Utility Room

Window Features

Exterior Features: Screened Porch, Fencing, Storage Building, Porch-covered, Automatic Gate, Pavilion, Court Yard Areas, Stonework, Open Concrete Areas
Fencing: Fenced, Gate
Parking Features: Garage
Other Features: Storage
Patio and Porch Features: Porch
Roof: Composition
View: Lake, Hills
Waterfront Features: Waterfront, 203 Of Waterfront

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: None

Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1972
Notes: Property has over 200' of LLano River open water and Llano bridge views. Details below: The property has a black wrought iron fence with solar lighting. A white stone entrance with a distinctive arched iron gate. It has 2, 17’ high flag poles. The driveway is lined with 10 “classic” lampposts. At the end of the driveway are 2 huge trees. The front porch is long, extra wide with a slanted overhang. This home features 4 sides natural brick. The carport is less than 2 years old. The outside of the home features 11 security lights. The AC unit and the roof were replaced in 2023. As you go in the front door, it does not open to the living area, you walk in to a nice foyer area. A gorgeous white stone fireplace highlights the living room. The master bedroom is oversized. There is a large, screened in back porch. There is a huge utility room. The garage has 2 work benches. In the back yard there is a firepit. There is a stable for storage that can be converted to a guest house. There are huge pecan trees in the lower area of the estate. Under the 2 biggest pecan trees there is a park grill. There is a 72’ “the bridge to nowhere”! First constructed for the grandkids to play on. There is a 17’ high flagpole at the edge of the bridge. To top off this estate is your own private beach, 208' in width. The area includes: A cinder block/landscaping timber fence, with solar accent lighting. A 14’x14’ covered pavilion. A 2nd grill next to the pavilion. 4 resort type umbrellas. Your private pier. The pier is 40’ in total
MlsNumber: --
ListingId: 166489


Listing Provided By: Landmasters Hill Country, original listing
Phone: (325) 247-1385
Office Phone: (325) 247-5782
Agent Name: Brenda Schneider
Disclaimer: Copyright © 2024 Highland Lakes Association of Realtors MLS. 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => ottawa [3] => MI [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: ottawa State: MI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: ottawa State: MI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1304 AND i.igate IN ('cihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Tish Poelman
Tish Poelman
ASCIITJ Homes of Keller Williams Grand Rapids North
Call Today!: (616) 730-1131

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App