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

3800 Faithon P Lucas Sr Boulevard
Mesquite, TX 75181
Susannah McIntosh with Halo Group Realty, original listing - (214) 239-1889

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2589 Square Feet
Agency: Halo Group Realty
Agency Phone: (214) 239-1889

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: RARE ONE-OF-A-KIND PROPERTY – COUNTRY LIVING JUST MINUTES FROM DOWNTOWN DALLAS! Enjoy the best of both worlds with this stunning hilltop custom-built brick single-story home situated on 5+ acres, offering breathtaking views of the Dallas skyline along with unforgettable sunrises and sunsets. Bring your horses! No HOA! This property is full of possibilities! Thoughtfully designed, this home features an engineered post-tension slab on piers (to gray shale or bedrock) foundation with a 10 inch thick concrete footing and retaining wall. With 3 bedrooms, 3 full baths, 2 living areas, and 2 dining areas this home boasts high ceilings, wood and tile flooring, and a seamless open-concept layout. A wall of large windows along the back of the home floods the space with natural light. The spacious Great Room opens to the kitchen and features an Austin stone fireplace and French doors leading to the covered back porch—ideal for entertaining. The second living area with wood floors, French doors, and custom built-ins makes a perfect study or flex room. The chef’s kitchen includes custom cabinetry with pull-out drawers, granite countertops, stainless steel appliances, double convection ovens, 6-burner gas cooktop, pantry, island with prep sink and built-in icemaker, and a large breakfast bar. The primary suite has wood floors, while the secondary bedrooms are carpeted. A unique guest bath features an antique vanity and pedestal tub. A large partially finished attic space over the garage (with stair access) offers tons of storage or opportunities for future expansion. Outside, enjoy a 900 sq ft insulated metal workshop with power and two overhead doors, located on a paved driveway. Whether you want space for projects or hobbies this shop delivers. After the road construction is complete the front fence will be replaced making the entire property fully fenced with no-climb wire. Convenient access to I-20, 635, 80 and 175. Don’t miss your chance to own this truly special property!
MlsNumber: --
ListingId: 20939092


Listing Provided By: Halo Group Realty, original listing
Phone: (214) 726-5436
Office Phone: (214) 239-1889
Agent Name: Susannah McIntosh
Disclaimer: Copyright © 2025 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.


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 = 3294 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Brandon Yates
Brandon Yates
ASCIIJPAR
Call Today!: (214) 729-3043

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App