$1,677,777

6779 Keller Lime Plant Rd Frederick, MD 21704

Adamstown Neighborhood

Estimated payment $10,591/month

Total Views 35,021
4 Beds
4.5 Baths
8,416 Sq Ft
$199 Price per Sq Ft

Highlights

  • Private Pool
  • Colonial Architecture
  • 2 Fireplaces
  • 6.53 Acre Lot
  • Deck
  • No HOA

About This Home

Experience unmatched luxury in this stunning 3 bedroom, four-and-a-half-bath estate, spanning over 8,500 square feet on a private six-acre lot. The grand marble foyer welcomes you into a beautifully designed space, including a formal dining room, living room, and play area. Basement has a big Den that can serve as a guess room.

The custom gourmet kitchen, equipped with Sub-Zero and Wolf appliances, dual islands, soft-close cabinetry, upgraded countertops, and a pot filler, is a chef's dream.

The upper-level master suite offers a serene retreat with a spa-inspired bathroom, while the lower level includes a fourth bedroom, full bath, entertainment area, and bar.

Outside, enjoy breathtaking sunsets by the in-ground pool and entertain with ease in the full outdoor kitchen. Hand-forged stair railings, oversized moldings, custom solid doors, custom window treatments, and exquisite millwork add to the home’s luxury.

Private tours are available for qualified buyers.

Listing Agent

Gloria Rojas

Compass License #RSR006598

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,724

Year Built

  • Built in 2008

Lot Details

  • 6.53 Acre Lot
  • Extensive Hardscape
  • Property is in excellent condition

Parking

  • 3 Car Attached Garage
  • Front Facing Garage

Home Design

  • Colonial Architecture
  • Fiberglass Roof
  • Stucco

Interior Spaces

  • Property has 3 Levels
  • 2 Fireplaces
  • Window Screens

Kitchen

  • Double Oven
  • Six Burner Stove
  • Cooktop
  • Built-In Microwave
  • Freezer
  • Dishwasher
  • Disposal

Flooring

  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Interior and Exterior Basement Entry
  • Sump Pump
  • Natural lighting in basement

Eco-Friendly Details

  • Energy-Efficient Windows

Outdoor Features

  • Private Pool
  • Deck
  • Exterior Lighting
  • Outdoor Grill
  • Brick Porch or Patio

Utilities

  • Central Heating and Cooling System
  • Heating System Powered By Owned Propane
  • Vented Exhaust Fan
  • Propane
  • Well
  • Electric Water Heater
  • On Site Septic

Community Details

  • No Home Owners Association
  • Frederick Heights Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1101039512

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,724

Year Built

Built in 2008

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • Exclusions: Kitchen, Master Beedroom, Living Room Chandeliers will NOT Convey. Playground will NOT convey.
  • Historic: No
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Federal Flood Zone: No
  • Year Built: 2008
  • Building Winterized: No
  • Remarks Public: Experience unmatched luxury in this stunning 3 bedroom, four-and-a-half-bath estate, spanning over 8,500 square feet on a private six-acre lot. The grand marble foyer welcomes you into a beautifully designed space, including a formal dining room, living room, and play area. Basement has a big Den that can serve as a guess room. The custom gourmet kitchen, equipped with Sub-Zero and Wolf appliances, dual islands, soft-close cabinetry, upgraded countertops, and a pot filler, is a chef's dream. The upper-level master suite offers a serene retreat with a spa-inspired bathroom, while the lower level includes a fourth bedroom, full bath, entertainment area, and bar. Outside, enjoy breathtaking sunsets by the in-ground pool and entertain with ease in the full outdoor kitchen. Hand-forged stair railings, oversized moldings, custom solid doors, custom window treatments, and exquisite millwork add to the home’s luxury. Private tours are available for qualified buyers.
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Cooktop, Built-In Microwave, Dishwasher, Disposal, Dryer, Exhaust Fan, Freezer, Microwave, Oven - Double, Six Burner Stove, Washer
  • Flooring Type: Ceramic Tile, Carpet
  • Window Features: Energy Efficient, Screens
  • Fireplaces Count: 2
  • Fireplace: Yes
  • Foundation Details: Other
  • Levels Count: 3
  • Basement: Yes
  • Basement Type: Daylight, Full, Fully Finished, Full, Interior Access, Outside Entrance, Rear Entrance, Sump Pump
  • Laundry Type: Main Floor
  • Total Sq Ft: 10133
  • Living Area Sq Ft: 8416
  • Price Per Sq Ft: 242.59
  • Above Grade Finished Sq Ft: 6916
  • Below Grade Finished Sq Ft: 1500
  • Below Grade Sq Ft: 1717
  • Total Below Grade Sq Ft: 3217
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 6779

Beds/Baths

  • Bedrooms: 4
  • All Lower Level Bedrooms: 1
  • Lower Level Bedroom: 1
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 3
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 3.00
  • Lower Levels Bathrooms: 1.00
  • Upper Level Full Bathrooms: 3
  • Lower Level Full Bathrooms: 1
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Stucco
  • Exterior Features: Bbq Grill, Extensive Hardscape, Exterior Lighting
  • Roof: Fiberglass
  • Spa: No
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Personal
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 3.00
  • Garage: Yes
  • Garage Features: Garage - Front Entry
  • Attached Garage Spaces: 3
  • Total Garage And Parking Spaces: 3
  • Type Of Parking: Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Propane - Owned
  • Heating Type: Central
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: On Site Septic
  • Utilities: Electric Available, Water Available, Propane
  • Water Source: Well
  • Municipal Trash: No

Condo/Co-op/Association

  • Condo Co-Op Association: No
  • HOA: No
  • Senior Community: No
  • Association Recreation Fee: No

Schools

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
  • School District Key: 121139693024
  • School District Source: Listing Agent

Lot Info

  • Horses: No
  • Additional Parcels: No
  • Land Use Code: R
  • Lot Size Acres: 6.53
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 284447.00
  • Outdoor Living Structures: Patio(s), Porch(es), Deck(s), Brick
  • Property Condition: Excellent, Very Good
  • Year Assessed: 2024
  • Zoning: R
  • In City Limits: No

Rental Info

  • Ground Rent Exists: No
  • Lease Considered: No
  • Pets: No Pet Restrictions
  • Pets Allowed: Yes
  • Vacation Rental: No
  • Property Manager: No

Tax Info

  • Tax Annual Amount: 14724.00
  • Assessor Parcel Number: 1101039512
  • Tax Total Finished Sq Ft: 8416
  • County Tax Payment Frequency: Annually
  • Tax Data Updated: No
  • Tax Year: 2024

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/15/2024 08/15/24 For Sale $1,677,777 +39.8% $199 / Sq Ft
04/28/2021 04/28/21 Sold $1,200,000 -8.4% $141 / Sq Ft
02/18/2021 02/18/21 Pending -- -- --
02/16/2021 02/16/21 For Sale $1,310,000 -- $154 / Sq Ft
Source: Bright MLS

Similar Homes in Frederick, MD

  • 101 E 2nd St, Frederick, MD 21701

    $1,390,000

    • 6 Beds
    • 4 Baths
    • 5,409 Sq Ft
    • 101 E 2nd St
    • Frederick, MD

    A rare opportunity is presented with this charming and exceptional property located in the heart of the award-winning historic city of Frederick, Maryland, one of Money Magazine’s “50 Best Places to Live in the US” in 2024 for its history, culture, enviable social and food scene, and flourishing economy. This luxurious property, known as The Jacob Brunner House, is on the Frederick County

    Lori Rogers Keller Williams Realty Centre

    Section Image
  • 2704 Hillfield Dr, Frederick, MD 21702

    $1,500,000

    • 6 Beds
    • 5.5 Baths
    • 5,660 Sq Ft
    • 2704 Hillfield Dr
    • Frederick, MD

    Rarely available in the highly sought after Kellerton Community, this exquisite 6-bedroom, 5.5-bath luxury home, built in 2022, boasts exceptional design and premium upgrades throughout. Featuring a 3-car attached garage, a grand double staircase, and a heated in-ground saltwater pool, this residence offers a resort-style living experience.Upon entry, you'll be greeted by stunning LVP

    Janelle Harwood Compass

    Section Image

Source: Bright MLS

MLS Number: MDFR2052880

Bright MLS