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

1694 Henry Prairie Road
Franklin, TX 77856
Laura Stanley with Captiva Realty, original listing - (979) 324-4363

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3082 Square Feet
Agency: Captiva Realty
Agency Phone: (979) 324-4363

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Welcome to your dream retreat perched atop 18.79 acres of rolling countryside, offering some of the most breathtaking hilltop views in Robertson County. Located in the sought-after Franklin ISD, this custom-built 4 bedroom, 2.5 bath home spans over 3,000 sq.ft. of living space, perfectly blending comfort, style, and functionality. Inside, you'll find engineered vinyl plank flooring, custom millwork, and LED lighting throughout. A spacious walk-in attic with built-in shelving offers potential for future living space. The chef’s kitchen boasts a porcelain farm sink, propane range, stainless appliances, expansive island, and a butler’s pantry. Enjoy the formal dining with front-acreage views, cozy living room with brick fireplace, or breakfast area overlooking the backyard oasis. The primary suite features a spa-like bath with stand-alone tub, double vanity, large walk-in shower, and dual closets. A tankless water heater offers year-round comfort, while an interior engineered storm shelter provides added security. Outside, entertain under a pergola and covered patio, or relax in the in-ground fiberglass saltwater pool overlooking panoramic views of the countryside. The property also includes a 1,200 sq.ft. shop, attached carport, 2,500-gallon rainwater tank, and is currently under an agriculture exemption. This rare hilltop haven offers space, serenity, and sophistication, whether you're looking to entertain, unwind, or grow your homestead dreams. Call today to schedule a tour!
MlsNumber: --
ListingId: 25004988


Listing Provided By: Captiva Realty, original listing
Phone: (512) 626-2443
Office Phone: (979) 324-4363
Agent Name: Laura Stanley
Disclaimer: Copyright © 2025 Bryan-College Station Regional MLS. 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