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

1075 County Road 2744
Mico, TX 78056

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,199,999
Beds: 3
Baths: 2
Status: Active
SqFt: 2751
Agency: Option One Real Estate, LLC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 2005
Notes: The House is 2751 square feet. Shop is over 6400 square feet. Nestled in the serene Hill Country, this 7.50 acre retreat offers breathtaking views that stretch for miles, providing a peaceful and tranquil atmosphere. The centerpiece of this property is a luxurious saltwater pool, inviting residents and guests alike to relax and unwind amidst the natural beauty of the surroundings. The main residence has been meticulously renovated from top to bottom, showcasing exquisite craftsmanship and attention to detail. It features three bedrooms and two bathrooms, a formal dining room perfect for elegant gatherings, and a cozy breakfast room ideal for enjoying morning meals with a view. The heart of the home is the custom kitchen, boasting 125 drawers and cabinets that provide ample storage space for culinary enthusiasts. Equipped with high-end appliances and modern amenities, this kitchen is a chef's dream come true. For entertaining guests, there's a covered patio that overlooks the stunning landscape, creating an inviting space for outdoor gatherings and leisurely evenings. Adding to the appeal of this property is an 874 -square-foot guest house with a private patio that is 224 square-feet, offering privacy and comfort for visitors. Additionally, there's an impressive RV storage barn measuring 80 feet long and 17 feet 6 inches wide, providing ample storage for recreational vehicles and equipment. Also included is a spacious shop area with an office that is 4800 square-feet. There is a complete mezzanine covering the entire ceiling of the garage easily accessible via an elevator for added convenience. 2 acres of this property are fenced and gated around the house to ensure security. Overall, this Hill Country retreat is a haven of luxury, tranquility, and functionality, offering an unparalleled living experience amidst nature's beauty. The murphy bed, and ALL shop equipment and tools will not convey.
MlsNumber: 1760642


Listing Provided By: Option One Real Estate, LLC., original listing
Name: Option One Real Estate, LLC.
Phone: (210) 389-5266
Office Name: Option One Real Estate
Office Phone: (210) 389-5266
Agent Name: Victoria Summers
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