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

4589 Ashville Hwy
Monticello, FL 32344
Kelsey Lohman with Lohman Realty LLC, original listing - (850) 556-2130

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $735,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3911 Square Feet
Agency: Lohman Realty LLC
Agency Phone: (850) 556-2130

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: PRICED $35,000 BELOW RECENT APPRAISAL!! Welcome to your forever home on the most stunningly manicured 5.5+ acres nestled in a serene country setting. This is truly a showstopper starting right at the beginning with its grand gated entrance leading to a picturesque rocking chair front porch and a modern farmhouse aesthetic. Walking in the front door you’ll be greeted by a cathedral vault ceiling, a stone wood-burning fireplace and a stunning catwalk staircase that creates the focal point for the heart of the home with its beautiful architectural details. With an open and inviting feel leading you to the kitchen, you won’t miss the gorgeous white cabinets, stainless steel appliances and large island perfect for entertaining and large gatherings. This primary suite is sure to catch your attention offering a separate sitting area with French doors leading out the front porch or to cozy up with a book next to the double-sided fireplace. The bedroom is expansive with huge bay windows allowing tons of natural light to flow through. The primary bathroom is brilliant and luxurious with its floor to ceiling marble and massive curbless shower featuring two showering stations and a built-in bench. This walk-in closet will suit anyone’s needs with its expansive island, built in drawers and floor to ceiling shoe rack! Upstairs features two large guest bedrooms with charming dormers overlooking the front. Off one guest room you will find an epic theater room equipped with glow in the dark carpet and the perfect setup for any avid movie watchers - you can fit a projector, stadium seating & a popcorn machine! Off the other guest room is an additional bonus room for a perfect teen hangout, office space, gym setup, you name it! As if the house wasn’t enough, there is also a 2,400 sqft workshop with four roll-up garage doors, electricity and tons of storage for large equipment. There’s also a concrete RV parking pad with 50 amp hookups! The main home is equipped with a whole house generator as well as a 2022 roof to provide peace of mind for the long term. This property truly has it all in the most private and tranquil setting. Come see for yourself and don’t miss this opportunity! *Audio/video surveillance inside home*
MlsNumber: --
ListingId: 379764


Listing Provided By: Lohman Realty LLC, original listing
Phone: (850) 556-2130
Office Phone: (850) 556-2130
Agent Name: Kelsey Lohman
Disclaimer: Copyright © 2024 Tallahassee 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