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 = 2775 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 = 2775 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 = 2775 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;

3701 N Us Highway 83
Crystal City, TX 78839
Gene Evans with eXp Realty, original listing - (888) 519-7431

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2064 Square Feet
Agency: eXp Realty
Agency Phone: (888) 519-7431

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1982
Notes: Welcome home to this spacious, 4 bedroom, 2 and a half bath home sitting on 1 acre of land, just North of Crystal City. Located less than a mile from town, and on a deep lot full of mature shade trees, this home offers space for even the largest of families. As you pull up into the front gate off Hwy 83, you are greeted with asphalt driveways and a beautiful mix of different ornamental and shade trees. Once closer you'll take notice of the new roof, two car garage and additional parking out back via a metal carport large enough for even tall Texas trucks! The home is brick on slab construction and has a newer central ac system. Upstairs there are additional window units for extra cooling the hot summer months. As you walk in you have a living room to your left and a formal dining room to the right. Step in a little further and you find a huge family room with vaulted ceilings, a fireplace and wrought iron railings leading upstairs. Just off the great room is the breakfast nook, spacious enough for a table for 6, which leads right into a kitchen with abundant countertop space, many cabinets and a full set of appliances are included. Also off the great room is the laundry area, and a half bath for your guest to use. Across the great room, we have under stairs storage. And just down the hall a master suite consisting of an oversized master bedroom, walk in closet, tons of storage, double vanity and tub shower combination. Upstairs offers a full bathroom and three guest bedrooms about equal in size. Out back there is a very large covered patio area, perfect for outdoor get togethers and weekend BBQ's. The backyard is big enough for kids to play, or pets to run free. Huge shade trees keep the backyard cool and inviting. There is even a storage shed at the back of the property for your lawn and garden tools.
MlsNumber: --
ListingId: 1807224


Listing Provided By: eXp Realty, original listing
Phone: (830) 486-9682
Office Phone: (888) 519-7431
Agent Name: Gene Evans
Disclaimer: Copyright © 2024 San Antonio Board 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App