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

484 County Road 1886
Sunset, TX 76270
Kimberly Daniel with All Cities Realty, original listing - (817) 516-5617

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $960,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 3415 Square Feet
Agency: All Cities Realty
Agency Phone: (817) 516-5617

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: 15-Acre Ag Exempt Country Retreat with Stocked Pond, Solar Power, Well Water, Rectangle Shaped Property, Oversized Septic, RV parking and Gorgeous Views !<br /> Escape to this stunning 15-acre country estate, offering an almost self-sufficient lifestyle with solar power, no electric or water bills, a stocked fishing pond, 2 expansive shops. Building 1 is an insulated 30 x 40 with a restroom and building 2 is an insulated & painted 60 X 40, each has their own entrance + roll up doors ! Building 2 is finished as an entertainment space with 2 stories for seating 100+ (perfect for Party Barn). At the heart of the property sits a spacious 2,455 sq. ft. home, designed for comfort and energy efficiency. A bright & airy open concept floor plan that seamlessly connects the living, dining, and kitchen areas;Perfect for entertaining or relaxing with family. Kitchen features tons of cabinets, granite countertops & stainless steel appliances, double oven & a breakfast bar ! Primary bedroom features an oversized custom walk in closet; Primary bath has granite counters, double sinks, loads of storage & oversized shower boasting dual shower heads. True Split Bedroom floorplan with neutral colors, ample closets, ceiling fans and allergy free flooring ! Laundry room has granite counters, utility sink, large folding counter, built in ironing board & lots of cabinets for storage. True mudroom with storage for muddy boots, coats & separate from everything else? You got it ..Outdoors you will find the property fully fenced in barbed wire & entrance gate. A private, fully stocked pond with bass, perch, crappie, & catfish is fishing delight. RV parking is easy with rock pad,a 50 amp plug in & dump station available. Perfectly blending modern comfort with off-grid sustainability, this unique property is ideal for those seeking the Homesteading Lifestyle or a Live + Work Lifestyle. Seller has spent over $300k in improvements since 2022.
MlsNumber: --
ListingId: 20833526


Listing Provided By: All Cities Realty, original listing
Phone: (940) 577-5330
Office Phone: (817) 516-5617
Agent Name: Kimberly Daniel
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App