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

4116 Harford Creamery Rd
White Hall, MD 21161
Bill Schilling with Bel Air, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,950,000
Beds: 9
Baths: Full: 5, ½: 3
Status: Active
SqFt: --
Agency: Bel Air
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 115 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 2006
Notes: This Magnificent 115 Acre Country Estate features the Majestic 4-Level Custom built Colonial home in 2006 with over 10,000 square feet of finished living space. This Masterpiece was Built and Owned by the well renown and Distinguished Art Wood, who is known primarily throughout Harford and Baltimore Counties for his Quality of Craftsmanship and Building Skills , Architectural Choices and Details to each and every Home he constructed during his 40 Years in the Building Profession . The Entry into Jarretts Recovery Farm, is mirrored with Manicured Grounds which surround the property, Scenic & Panoramic views are Endless ,plus Superb Stone Hardscape which is continuous from the front Courtyard, to the Retaining and Flower walls, Walkways and Covered Patios, plus the Stone Front entry to this Gem! This Impeccable Home Boosts Generous size Rooms on All Four Finished Levels which exhibits 9-bedrooms, 5 full bath , 3 -(1/2 baths), 3-Two-sided Fireplaces + 1- Stone raised Hearth Fireplace, Lovely In-Law Apartment, Elevator, Geothermal Heat, Propane- powered Whole house Generator, Wet bar, Theater Room, Game Room, Library, Fitness Room, An Art Room, 3-Car Garage and an Enormous amount of Storage for any occasion! As you enter the home from the Welcoming Courtyard you will be amazed as you open the Stately Entry Door and be Greeted by a Breathtaking 26 X 20 Two Story Foyer with Gleaming Porcelain flooring, Brazilian Cherry curved Dual staircase, a Retractable Luxurious & Glistening Crystal Chandelier and nonetheless a Dual view Overlook where your Home Tour Begins. The Two-Sided Fireplace in the 2-Story Family Room is accented by the Starburst windows with Spectacular Pastoral views. The Main level offers a Gourmet kitchen with Granite Countertops with an Ogee edge, Brazilian Cherry Hardwood flooring, Grand Center Island, Viking Gas Stove, Pleasant Breakfast Bar, Italian Carved Marble Stove Canopy, Italian Subway Tile, Wine rack, Walk-in Pantry, Beautiful Dining area with French Doors to the Elevated Extensive Deck. The Stunning Library features all Cherry built-in Cabinetry. Next you move toward the Primary Bedroom with Two -Story ceilings, Marvellous Gas fireplace, Berber carpet, + access to the Elevated Deck. The Splendid Primary Bathroom features Ceramic Tile flooring, an Over-the Top Soaking Tub, 4-Foot tile shower, Dual Sink with built-in Cherry Cabinetry, Separate Water Closets, Two extensive Walk-in Closets ,each with Dressing areas and Window seats. A Gorgeous Formal Dining room, Mud room, Spacious Laundry room with plenty of Cabinetry, a Luxurious Living room all with Brazilian Cherry Hardwood Flooring along with 2 -(1/2 baths) which complete this State of the Art Main Level. The First upper level has 6 bedrooms, 3-Full Baths, an Exercise room and Don't forget the Elevator Stops Here! Upper level 2 has another Bedroom, Bonus room and Storage room. The Lower Level Family Room offers a Stone Raised Hearth Fireplace, Game Room + access to the Patio along with your Movie Theater with 8 Leather Recliners and elevated seating. The Wet bar area has Granite Countertops, Electric Stove, Fridge and Dishwasher. Then you travel down the hallway to the In-Law Apartment with a Full kitchen, Full bath and your very own Private walkout level access. Each Level of this Outstanding Home exhibits a Significant Layout Design with a Dedicated Purpose by the Builder; and All Final Touches reflect his Pride in Profession"". It's Absolutely Awesome! In addition to the main dwelling there is a 3 bedroom, 2 1/2 bath Cape Cod tenant house built in 2007. This property is also enhanced by a bank barn, nine stall horse barn, 90 x 42 machinery shed, fenced pastures, stream, a pond with an island and wooded and tillable acreage. One of a Kind....Guaranteed!
MlsNumber: --
ListingId: MDHR2034818


Listing Provided By: Bel Air, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Bill Schilling
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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 = 3259 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 Joanna Dieter
Joanna Dieter
ASCIIVybe Realty
Call Today!: (410) 949-6855

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App