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

21616 Middletown Road
Freeland, MD 21053
Thomas Mooney with O'Conor, Mooney & Fitzgerald, original listing - (410) 321-8800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2700 Square Feet
Agency: O'Conor, Mooney & Fitzgerald
Agency Phone: (410) 321-8800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 79 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Welcome to "Hickory Farm" a charming property that offers a tranquil and picturesque setting nestled on just under 80 acres of rolling farmland, mature trees and abundant wildlife. As you enter through the gated property and drive down the long winding driveway you'll be greeted by the enchanting sight of a totally renovated contemporary farmhouse with a wrap-around porch that seamlessly blends modern amenities with rustic charm. Upon entering the main level you'll be greeted by the spacious great room, kitchen and living area. The centerpiece of the room is the floor-to-ceiling stone fireplace and the abundance of windows which fills the room with natural light creating an atmosphere of warmth and comfort. This space is great for entertaining and offers spectacular views of the 3.5 acre pond. Also, on the main level is the primary bedroom suite with a side balcony for you to enjoy your morning coffee. The lower level has additional living space with the original stone foundation adding a rustic touch to the family room, bar and another bath and bedroom with a side porch. Step outside the lower level and you'll discover another 2 story structure. This space could provide a unique and versatile use such as a guest cottage or home office, just use your imagination and creative ideas. In addition to the house there are a few more outbuildings. There is a detached two car garage that has been transformed into a man's cave, complete with a mini-split system for climate control, so you can store farm equipment or extra room to hang out. The 66' x 42 post & beam bank barn with 5+ stalls offers the perfect opportunity for equestrian enthusiasts or housing small farm animals. There is also a small wood shed and the open pavilion by the house. The house uses geo thermal for HVAC and additional updates are the full house generator, significantly upgraded Cable, Internet and WiFi and security features such as surveillance cameras, alarm system, the remote controlled main gate. The pond has a new overflow drain, 4 diffuser aeration system and is completely stocked with small & large mouth bass. It is important to note that this property is protected by a conservation easement and participates in an agricultural land preservation program. This ensures that the land cannot be subdivided and has been maintained by the same farmer for many years, preserving its natural beauty and agricultural heritage. Overall, this property is a blend of historical charm, contemporary design and breathtaking surroundings offering a unique lifestyle to embrace a peaceful place to relax, connect with nature and rejuvenate.
MlsNumber: --
ListingId: MDBC2094596


Listing Provided By: O'Conor, Mooney & Fitzgerald, original listing
Phone: (410) 321-8800
Office Phone: (410) 321-8800
Agent Name: Thomas Mooney
Disclaimer: Copyright © 2024 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 3254 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;
Real Estate Expert Photo for Araminta Morton
Araminta Morton
ASCIIBennett Realty Solutions
Call Today!: (202) 409-3530

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App