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

19150 Ne 75th Street
Williston, FL 32696

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $945,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 3492
Agency: Ocala Homes and Farms

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential
Year Built: 2017
Notes: Under contract-accepting backup offers. Modern Farm House with a pleasing floor plan and stunning curb appeal situated on highest elevation on the 9.7 acres, offering generous view of property, sunsets and sunrises. GENEROUS PRICE REDUCTION!!Seller says Bring an OFFER! Full length front porch and spacious back porch create even more living space! The side entry over sized garage offers an additional air-conditioned storage space,18 x10 door and access to the mudroom where storage and space for coats and boots has been created. When you step inside this modern farmhouse the ceilings through out are 10 feet in height with an inviting foyer. Barns doors to your right offer the privacy of an office with custom cabinetry for all your files and workspace. From the great room reveals an open floor plan concept connecting the kitchen, dining and sitting area. Also, custom crafted cabinetry shelving surrounds the fireplace adding to the functionality of the room. The bedrooms are arranged in a split plan format with the primary enjoying its own side of the home and includes a luxurious ensuite bathroom and walk in closets. Across the way are 3 bedrooms and 3 bathrooms. One bedroom has an ensuite bath and private entry, ideal for guests, in-laws, etc. Upstairs is the flex room, make it your own...game room, craft room, media room, etc., utilize the mini split a/c system and conserve energy at the same time. This modern farmhouse is truly unique featuring 3912 heated sq ft and 6129 sq ft under roof, 3 zones, upgraded stainless appliances, 2 ovens (one a convection) gas cooking, farm sink, refrigerator with two ice makers, huge walk in pantry and an amazing laundry room (you won't mind doing laundry in this one!).<br /> Let's not forget the 40x60 pole barn and there is a 100 amp box on the house ready for electric hook up for the barn. Just a short 5 minute drive into town, Williston offers plenty of restaurants, grocery, drugstore and this location isn't far from Ocala or Gainesville. Make an appointment to see this property soon! It's not going to last long!!!
MlsNumber: OM665678


Listing Provided By: Ocala Homes and Farms, original listing
Name: Ocala Homes and Farms
Phone: (352) 266-6181
Office Name: OCALA HOMES AND FARMS
Office Phone: (352) 390-6009
Agent Name: Carla Lord
Disclaimer: Copyright © 2024 Stellar 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