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

709 E Navarro Avenue
De Leon, TX 76444

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,750
Beds: 4
Baths:
Status: Active
SqFt: 3554 Square Feet
Agency: Cogburn Real Estate

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer, Dryer, Cooktop - Electric, Oven - Convection, Range - Gas, Refrigerator - Built-in
Architectural Style: Ranch
Construction Materials: Brick, Stone, Frame
Cooling: Attic Fan, Ceiling Fan(s)
Flooring: Concrete
Heating: Central Furnace, Solar Active And Passive, Fireplace, Fireplace - Insert
Interior Features: Pantry, Walk-in Closet(s), Built-in Features, Open Floorplan, Double Vanity, Granite Counters, Chandelier, Cable Tv Available, Sound System Wiring, Multiple Staircases, Smart Home System, High Speed Internet Available, Built-in Wine Cooler
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
Utilities: Cable Available

Window Features

Exterior Features: Fence, Lighting, Outdoor Kitchen, Balcony, Storage, Fire Pit, Private Entrance, Rv/Boat Parking, Rv Hookup, Covered Patio/Porch
Fencing: Fenced
Parking Features: Garage, Carport, Covered, Driveway, RV, Workshop, Boat
Other Features: Outdoor Kitchen, Storage, RV/Boat Storage
Patio and Porch Features: Patio, Porch
Roof: Metal

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Central Deleon

Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Welcome to this 2 story steel framed home including 4 bedrooms and 3.5 baths, measuring 3554 sq ft. This unique home is one that does not become available often. Located within the city limits of De Leon the home sits on approx. 4.69 acres(to be surveyed) with two water wells that are connected to the irrigation system, 49X50 insulated shop, the above ground pool, and pond on the property. The two water wells on the property hold and filter through two black storage tanks. Throughout the home you will see a walk-in pantry, matching built-ins, a walk through laundry-mudroom, a tankless water heater, dual-zone HVAC systems, and a natural gas log fireplace. Make sure to time your time when visiting the outside, the activities are endless for all ages, a 2nd story patio with stairwell to the 1st story, an above ground pool-deck, playground-sand pit, a dream playhouse, a tank with a dock-sitting area, and an outdoor kitchen that is ready to be connected and put to use. Give us a call today!
MlsNumber: --


Listing Provided By: Cogburn Real Estate, original listing
Phone: (254) 893-6666
Office Phone: (254) 893-6666
Agent Name: Torey Stockman
Disclaimer: Copyright © 2024 North Texas Real Estate Information Systems, Inc. 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