Title Page Background
DEBUG FN args: Array ( [0] => 2733 [1] => [2] => [3] => agent ) BEFORE: Site: 2733 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2733 Igate: njhud LocID: 2733 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 = 2733 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2733 [1] => [2] => [3] => lender ) BEFORE: Site: 2733 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2733 Igate: njhud LocID: 2733 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 = 2733 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2733 [1] => [2] => [3] => other ) BEFORE: Site: 2733 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2733 Igate: njhud LocID: 2733 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 = 2733 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

18297 Cr 1100
Flint, TX 75762

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $979,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2358 Square Feet
Agency: Keller Williams Realty-Tyler

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Cooktop - Electric, Oven - Double
Architectural Style: Other
Construction Materials: Brick, Cedar, Brick Veneer
Cooling: Zoned A/C
Heating: Central Furnace
Interior Features: Security System, Ceiling Fan
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Den, Kitchen, Utility Room
Security Features: Security System, Security Lighting

Window Features

Exterior Features: Porch, Sprinkler System, Security Lighting, Gutter(s)
Patio and Porch Features: Porch
Roof: Composition

Neighborhood/Schools

Elementary School/District: Owens
Middle/Junior High School/District:
High School/District: Tyler Legacy
Subvidision Name:

Description/Comments


Lot Size: 26 acre(s)
Property Type: Farm-Single Family Residence
Year Built: 1987
Notes: Located close to Lake Palestine just south of Noonday, this custom built home is waiting for you to make it yours. Gorgeous wrap around front porch clad in cedar plank make for an inviting entryway into this home with 3 bedrooms, 2 bathrooms, and a 2 car garage sitting on 26.65 rolling, wooded acres in Flint with an additional 2000 sqft of living space in a separate dwelling that is heated and cooled! Tall ceilings and wood floors in the entry and dining room greet you as you enter, then a large den with a wood burning fireplace provides ample opportunity to entertain. Step into the kitchen which includes a Jenn-Air cooktop and double ovens with a ton of countertop space. New luxury carpet adorns the den and all bedrooms. The primary bedroom is spacious with an ensuite bathroom with separate tub and shower and dual walk in closets. A massive utility room off of the kitchen includes additional flex space that can be used for an office, work out, or craft area. The large covered back porch is also clad in cedar plank siding and overlooks the backyard and the rest of your oasis. Across the drive from the house sits an additional building with over 2000 sqft of H/C living space. This extra building is completely finished out in custom wood plank walls and ceiling with built-in cabinets and bar, and a ready-to-use office in one corner. A blank canvas for the ultimate man-cave, she-shed, guest quarters, or all three! Privacy, convenience, space…this property has it all. Come see! Come BUY!
MlsNumber: --


Listing Provided By: Keller Williams Realty-Tyler, original listing
Phone: (903) 534-6600
Office Phone: (903) 534-6600
Agent Name: Judy Kunzman
Disclaimer: Copyright © 2024 Greater Tyler Association 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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => smith [3] => TX [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: smith State: TX Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: smith State: TX 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 = 2733 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for HADEN AND KAYLA RIGGS
HADEN AND KAYLA RIGGS
ASCIIRiggs Property Group, powered by KW
Call Today!: (903) 483-4135

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App