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

1318 Us 90a Hwy
Sheridan, TX 77475

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1800
Agency: Tri-County Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: NEWLY BUILT DUPLEX CLOSE TO SPLASHWAY!<br /> <br /> Currently used as an income producing vacation rental! This 60'X30' nicely finished building is sitting on a .42 acre lot on Hwy 90A in Sheridan, 7/10 of a mile from the premier family vacation spot, Splashway Waterpark & Campgrounds! <br /> <br /> The building is separated into 2 sides by a sound-barrier wall, with each side having its own central A/C unit and 200 SF porch space. The lot has perimeter fencing with new cross fence in front, gravel parking area in front, an aerobic septic system, large tankless 3.51 GPM Rheem water heater, spray foam insulation, Pex water lines, insulated windows, 200 amp electrical service (100 amp to each side), and electricity run to the front fence for future lighting, if needed.<br /> <br /> Side A is 920 sq ft, consisting of 2 bedrooms, 1 bathroom, a sleeping loft with closet, and open concept kitchen, dining, living room. The finishes include black pearl leathered granite with glass tile backsplash in the kitchen, tile shower with frosted glass door, a bluetooth speaker exhaust fan in the bathroom, 12 mm wood laminate flooring in the loft.<br /> <br /> Side B has 880 sq ft of air-conditioned space set up studio style. The great room has a kitchenette with full refrigerator, a sink and cooking range; a bar and seating area. The bathroom has a tile shower with frosted glass sliding door, bluetooth speaker exhaust fan & Samsung laundry center. A sleeping loft and mechanical closet are upstairs. <br /> <br /> All appliances convey with the sale & furnishings are negotiable!<br /> <br /> Large backyard area! Room to build a shop, playground, put in a pool.....<br /> <br /> There are many possibilities on how to utilize this space.....vacation rental, weekend getaway. Come take a look to see if this is the right investment for you!<br /> <br /> Call today to schedule your showing of this impressive property!
MlsNumber: 141476


Listing Provided By: Tri-County Realty, LLC, original listing
Name: Tri-County Realty, LLC
Phone: (979) 725-6006
Office Name: TRI-COUNTY REALTY, LLC
Office Phone: (979) 725-6006
Agent Name: Gary Helmcamp
Disclaimer: Copyright © 2024 South Central Texas 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