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

8924 Waterchase Circle
Fort Worth, TX 76120

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 4
Baths:
Status: Active
SqFt: 4971 Square Feet
Agency: ARC Realty DFW

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Refrigerator, Garbage Disposer, Cooktop - Gas, Oven - Double, Oven - Convection
Architectural Style: Mediterranean
Construction Materials: Stucco
Cooling: Attic Fan, Zoned A/C, Ceiling Fan(s)
Flooring: Carpet, Tile, Wood
Heating: Central Furnace, Fireplace
Interior Features: Kitchen Island, Pantry, Wet Bar, Walk-in Closet(s), Eat-in Kitchen, Built-in Features, Double Vanity, Granite Counters, Natural Woodwork, Chandelier, Cable Tv Available, High Speed Internet Available, Decorative Lighting
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
Utilities: Cable Available

Window Features

Exterior Features: Fence, Lighting, Gas Grill, Balcony, Rain Gutters, Private Yard, Outdoor Grill, Built-in Barbecue, Covered Patio/Porch, Attached Grill
Fencing: Fenced
Parking Features: Garage, Driveway
Patio and Porch Features: Patio, Porch
Roof: Composition

Neighborhood/Schools

Elementary School/District: Loweryrd
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Waterchase Estates Add

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Welcome to this luxurious retreat! This stunning residence boasts elegance and comfort, offering the epitome of refined living. You are greeted by a Mediterranean exterior with balconies that wrap around the home, providing views of the neighborhood. Upon entering, you are welcomed by travertine flooring that leads you through the floor plan featuring two master suites, ideal for a mother-in-law suite or out of town guests. Both suites have large closets and spacious master bathrooms. Storage is abundant throughout the property, providing convenience and organization. The large gourmet kitchen boasts tons of storage and flows into an expansive breakfast room. The oversized dining room is off the kitchen and can accommodate all your guests. In the upstairs game room, you'll find a wet bar and plenty of space. Step outside to an outdoor oasis, complete with a patio, fountain, gas log fireplace and built in gas grill. Don't miss the opportunity to make this your new home.
MlsNumber: --


Listing Provided By: ARC Realty DFW, original listing
Phone: (817) 929-8921
Office Phone: (817) 609-4115
Agent Name: Gail Burdine
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