Spectacular Sugarloaf views- 5 acre lot- this custom home took 3 years to plan and build with no expense spared for quality and custom features. This state of the art home offers 8000 finished square feet of living yet while spacious has a very human scale- pool features spa, 3 waterfalls, extensive hardscape, lighting and award winning pool house with kitchen and dining areas. The finished walk-out basement offers pool changing rooms and 2 full baths plus huge entertaining areas. The main level offers a master suite with marble foyer, 22x19 custom closet and dressing room, a marble spa bath and bedroom that opens to rear porch overlooking the pool. A true gourmet cook's kitchen has every amenity and opens to a main level familyroom with fireplace. Many thoughtful features such as a whole-house water balancing system offers equal pressure from each faucet. 2 propane generators offer almost full power in the event of a power outage. 4 zone heating is duel fuel with electric and propane back up. Rear hall off kitchen offer laundry and access to a 3 car side load garage. Urbana school district and only 5 minutes out of Urbana Village.
Single-familyProperty Type
2005Year Built
5 acresLot Size
$267Est. Price/Sq.Ft.
3 car garageParking
Listed by Rob Whalen• Long & Foster Real Estate, Inc.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
—
Baths
7
Stories
2
Lot width
—
Lot depth
—
Lot size
5 Acres
Year renovated
—
Sq. Ft.
7,267
Year built
2005
Style
Single Family Residential
County
Frederick County
APN
07 225962
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 17, 2026.
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 Attached Garage Spaces: 3
Garage Features: Garage - Side Entry, Garage Door Opener, Inside Access, Oversized
# of Total Garage and Parking Spaces: 3
Has Garage
# of Garage Spaces: 3
Attached Garage
Interior
Bedroom Information
# of Bedrooms On 1st Upper Level: 3
# of Bedrooms On Main Level: 1
# of Bedrooms On 1st Lower Level: 1
Bathroom Information
# of Bathrooms (Full) On 1st Upper Level: 3
# of Bathrooms (Half) On Main Level: 2
# of Bathrooms (Full) On Main Level: 1
# of Bathrooms (Full) On 1st Lower Level: 2
# of Bathrooms (Full) On All Upper Levels: 3
# of Bathrooms (Full) On All Lower Levels: 2
# of Bathrooms (Half): 2
# of Bathrooms (Full): 6
Interior Information
Appliances: Built-In Range, Commercial Range, Dishwasher, Disposal, Dryer, Icemaker, Instant Hot Water, Oven - Wall, Range Hood, Refrigerator, Washer, Water Heater