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

3755 Anaqua
Beeville, TX 78102
Kegan Perez with MGM Real Estate, LLC, original listing - (361) 358-2010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $609,999
Beds: 7
Baths: Full: 4
Status: Active
SqFt: 3920 Square Feet
Agency: MGM Real Estate, LLC
Agency Phone: (361) 358-2010

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Farm-Farm
Year Built: 2021
Notes: Escape to Country Living on 20 Acres with Two Beautiful Manufactured Homes and Endless Opportunities! Nestled on 20 sprawling acres of peaceful countryside, this unique property offers not just one, but two modern manufactured homes and a wealth of outdoor amenities! The land features a stock tank fed by a seasonal creek, perfect for fishing, and lush vegetation that makes it ideal for hunting enthusiasts. An old structure is present that could serve as a third home site, since it's equipped with electric and its own water well. An RV spot also affords additional housing options. The first home, addressed 3755 Anaqua, is a spacious 2021 Clayton Homes "The Breeze 2.5" offering 4 bedrooms, 2 baths, and 2,128 sq. ft. of living space. The second home, at 3751 Anaqua, is a 2020 Clayton Homes "The Bluebonnet Breeze", featuring 3 bedrooms, 2 baths, and 1,792 sq. ft of living space. Both homes are well-maintained and provide ample space for family living, rental income, or hosting guests. Whether you're looking for a serene family retreat, an investment opportunity, or a ranch-style escape with hunting and fishing right at your doorstep, this property has it all. One day notice required please to prepare & the Sellers prefer Mon-Fri showings after 3pm or anytime on weekends.
MlsNumber: --
ListingId: 113161


Listing Provided By: MGM Real Estate, LLC, original listing
Phone: (361) 358-2010
Office Phone: (361) 358-2010
Agent Name: Kegan Perez
Disclaimer: Copyright © 2024 Bee County 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