An incredible and unique opportunity awaits you. This recently totally remodeled Farmhouse suited on nearly 130 acres of private, rolling farmland with panoramic views, is just what you have been dreaming of. This amazing property provides so many potential uses. Currently used for beef and cropland production. The beauty of this property begins outside with a long private paved driveway, a tailored exterior with a covered front porch and gorgeous pond. Numerous outbuildings including a newer 60 x 156 foot barn with manure storage, bank barn, 2 oversized machine storage barns, recently updated dairy barn with 3 stalls, automatic waters and wash room perfect for show animal set up, poultry barn and detached garage. Several fenced pastures suited for all your livestock needs and plenty of cropland. Let your imagination run wild with the endless possibilities. Enjoy the breathtaking sunrises and sunsets from the second level balcony or patio with root cellar underneath. Inside you are welcomed by an open floor plan, gleaming 6 inch wide red oak hardwood floors, upgraded lighting, a soft neutral color palette, stone fireplace, a gourmet kitchen, and large windows with beautiful views uniting inside and out making this home so memorable. Warm hardwood floors welcome you in the open foyer and usher you into the living room featuring a stone, wood burning fireplace with custom mantel. The open kitchen is a feast for the eyes with gleaming granite countertops, stainless steel appliances, an abundance of cabinetry, an oversized center island that provides additional working surface and bar seating, while recessed and pendant lights provide the perfect balance of illumination and ambiance. The adjoining dining area with a farmhouse style chandelier with plenty of space for both formal and casual occasions. A powder room with an outside entrance, tiled floor and slop sink. Additional room for relaxing or office area. Gleaming hardwood floors flow up to the second level into the ample sized primary suite with a walk-in closet with barn door, on-suite bath with custom tiled shower. Three additional cozy bedrooms with closets and ceiling fans. The hallway bathroom features a large dual sink vanity with granite top, mirrored wall, chic lighting, and a shower with custom title and built-in laundry area with cabinets and plenty of counter space. This level also features access to the covered balcony—the perfect spot to unwind, nature watch or just enjoy the views. To complete the comfort and luxury of this wonderful home you will find the perfect spot for entertaining on the third level. This open, spacious room facilitates entertaining family and friends, featuring cathedral ceilings, built in sitting areas, wall to wall carpet and plenty of storage. The farm is enrolled in (MALPF) Program. Come see this one today and make all your dreams come true.
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Zoning
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Frederick County
APN
1111286534
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 4, 2021.
A
Agricultural District
The purpose of the Agricultural District (A) is to preserve productive agricultural land and the character and quality of the rural environment and to prevent urbanization where roads and other public facilities are scaled to meet only rural needs.
Permitted uses
Include but are not limited to:
Agriculture
Greenhouse / nursery
Winery & vineyard
Housing-Group
Housing-Single unit
Housing-Multiple units
Housing-Mobile home park
Property details
Parking
Parking Information
# of Detached Garage Spaces: 1
Garage Features: Garage - Front Entry, Other
# of Total Garage and Parking Spaces: 1
Has Garage
# of Garage Spaces: 1
Paved Driveway
Detached Garage, Driveway, Off Street, Other
Interior
Virtual Tour
Bedroom Information
# of Bedrooms On 1st Upper Level: 4
Bathroom Information
# of Bathrooms (Full) On 1st Upper Level: 2
# of Bathrooms (Half) On Main Level: 1
# of Bathrooms (Full) On All Upper Levels: 2
# of Bathrooms (Half): 1
# of Bathrooms (Full): 2
Interior Information
Appliances: Dishwasher, Dryer - Front Loading, Exhaust Fan, Microwave, Oven/Range - Electric, Refrigerator, Stainless Steel Appliances, Washer - Front Loading, Water Heater
Full, Improved, Outside Entrance, Walkout Level, Other
Exterior
Property Information
Total Below Grade Sq. Ft.: 0
Improvement Assessed Value: $364,900
Ownership Interest: Fee Simple
Year Built Source: Estimated
Building Information
Construction Materials: Vinyl Siding
Foundation Details: Stone, Other
Other Structures: Above Grade, Below Grade
Outdoor Living Structures: Balcony, Patio(s), Porch(es)
Roof: Shingle
Structure Type: Detached
Other Structures: Bank Barn, Barn, Barn/Farm Building, Dairy Barn, Cattle/Dairy Barn, Garage(s), Machine Shed, Office/Studio, Poultry House, Silo(s), Other
Exterior Information
Outbuilding(s), Other
Fencing: Electric, High Tensile
Lot Information
Lot Features: Cleared, Partly Wooded, Pond, Open, Other
Has Water View
Tidal Water: No
Land Information
Crops Included: No
Land Assessed Value: $149,200
Tillable Acres: 75.00
Farm Information
Farm Features: Feed Barn, Shed(s), Silo(s)
Land Area Source: Estimated
Land Area Units: Acres
Beef, Hay, Mixed Use, Livestock, Pasture
Remarks: Pastures have automatic waters, all outbuildings in great shape.
Farm Land Preservation: Yes
Above Grade Information
Finished Sq.Ft.: 2,516
Finished Sq.Ft. Source: Estimated
Below Grade Information
Unfinished Sq.Ft. Source: Estimated
Finished Sq.Ft. Source: Estimated
Financial
Tax Information
Agricultural Tax Due: Yes
County Tax: $5,961
Tax Assessed Value: $511,400
Tax Year: 2021
Tax Annual Amount: $6,109
Assessments Information
Year Assessed: 2021
Utilities
Utilities Information
Central Air
Cooling Type: Central A/C, Ceiling Fan(s)
Cooling Fuel: Electric
Heat Pump - Oil BackUp, Heat Pump(s), Radiant
Heating Fuel: Electric, Oil
Hot Water: Electric
Sewer Septic: Septic = # of BR
Water Source: Private
Location
School Information
School District Name: FREDERICK COUNTY PUBLIC SCHOOLS
School District Source: Listing Agent
Location Information
Outside City Limits
Directions: From 15 N, take MD-26 east toward US-15 North, Gettysburg, continue onto Liberty Rd, follow onto Woodsboro Pike for 9.5 miles, turn left onto Detour Rd, destination is on the right hand side about 2 miles down. Signs Hung,
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Frederick County
APN: 1111286534
Home facts updated by county records on Sep 4, 2021
Around this home
Schools
New Midway/Woodsboro Elementary School
Public PreK-5 • Assigned • 2.0mi
8/10
Walkersville Middle School
Public 6-8 • Assigned • 9.0mi
9/10
Walkersville High School
Public 9-12 • Assigned • 9.5mi
6/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
3/10 Fire Factor
0.15% chance of being in a wildfire in next 30 years
6/10 Heat Factor
7 days above 102° expected this year, 16 days in 30 years
4/10 Wind Factor
10% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Keymar, MD • 21757
Average low and high temperatures (°F)
36
23
41
27
60
39
68
47
73
54
84
64
89
71
81
61
78
58
68
46
56
39
42
28
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.2 hours in
June and 4 hours in December, placing it below the
U.S. average for solar exposure.
9.2 hrs
4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.59M – $1.93M
Reach more buyers when you sell with Redfin. Save up to $16,735 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.