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.
{"property_id":"md257_MDFR2052880","above_ground_sqft":"6916","allow_address":null,"amenities":null,"appliances":"Cooktop,Built-In Microwave,Dishwasher,Disposal,Dryer,Exhaust Fan,Freezer,Microwave,Oven - Double,Six Burner Stove,Washer","approval_cond":"Standard","architecture":"Stucco","avg_utilities":null,"basement":"Y","basement_sqft":null,"basement_type":"Daylight, Full,Fully Finished,Full,Interior Access,Outside Entrance,Rear Entrance,Sump Pump","baths_half":null,"baths_threequarters":null,"building_num":null,"basement_finished":null,"builder":null,"car_storage":null,"construction":"N","cooling":"Central A\/C","county":"FREDERICK","covenants":null,"date_measured":null,"depth":null,"design_features":null,"descriptions":"Standard","dining_room":null,"dining_room_loc":null,"directions":null,"electricity":null,"elementary_school":null,"email":"gloria.rojas@compass.com","faces":null,"facilities":null,"farm_features":null,"farm_operation":null,"features":"Other","families":null,"family_room":null,"family_room_loc":null,"fee1":null,"financing":null,"fireplace":null,"fireplace_loc":null,"fireplace_num":"2","flooring":null,"game_room":null,"game_room_loc":null,"gas":"Propane - Owned","green_hers_score":null,"green_leed_certified":null,"green_ngbs_certified":null,"green_star_certified":null,"heat":"Central","hoa":"N","hoa_fee":null,"hoa_fee_freq":null,"horses":null,"horse_facility":null,"horse_features":null,"inclusions":null,"kitchen":null,"kitchen_loc":null,"lake_acres":null,"lake_depth":null,"laundry":null,"laundry_loc":null,"listor":"Gloria Rojas","living_room":null,"living_room_loc":null,"lot_size":null,"lot_size_text":null,"maintained_by":null,"master_br":null,"master_br_loc":null,"media_room":null,"media_room_loc":null,"middle_school":null,"min_lease":null,"model":null,"notes":null,"office":null,"office_loc":null,"older_housing":null,"outdoor_features":"BBQ Grill,Extensive Hardscape,Exterior Lighting","ownership_type":"Fee Simple","parking_covered":null,"permit":null,"pets":null,"ph_listor":null,"ph_office":"7033106111","pool":"Yes - Personal","pool_features":null,"property_name":null,"public_remarks":"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\u2019s luxury.Private tours are available for qualified buyers.","roofing":"Fiberglass","school_district":null,"seller_type":"803293882668","senior_community":"N","sewer":"On Site Septic","sr_high_school":null,"status":null,"stories":"3","study_den":null,"study_den_loc":null,"style":"Colonial","tap_gas":null,"tap_sewer":null,"tap_water":null,"taxes":"14724.0","terms":"Garage - Front Entry","tour_url":"https:\/\/real.vision\/6779-keller-lime-plant-road-1?o=u","tour_url2":null,"tour_url3":null,"type":"Detached","units":null,"unit_floors":null,"utilities":null,"view":"N","water":null,"water_front":"N","water_front_ft":null,"well":"N","year":"2008","zoned":null,"property_uid":"803293882668","listing_status":"active","mls_status":null,"mls_id":"md257","listing_num":"MDFR2052880","acreage":null,"acres":"6.53","address":null,"address_direction":null,"address_flg":null,"address_num":"6779","agent_id":"106510","area":null,"baths_total":"5.00","bedrooms_total":"4","car_spaces":"3","city":"FREDERICK","coseller_id":null,"coagent_id":null,"days_on_market":null,"finished_sqft_total":null,"geocode_address":"6779 KELLER LIME PLANT RD","geocode_status":null,"lat":"39.35588","lon":"-77.4309","office_id":"COMPS5","office_name":"Compass","orig_price":"1677777","photo_count":"69","previous_price":null,"price":"1677777","pricerange_min":null,"pricerange_max":null,"prop_img":"http:\/\/bright-media02.prd.brightmls.com\/bright\/images\/0000\/8032\/9396\/4566\/803293964566_1440_1080_WM_ACIzqA5LgJx_2YLk.jpg","property_type":"Residential","sqft_total":null,"state":"MD","street_type":null,"street_name":"KELLER LIME PLANT","sub_area":"FREDERICK HEIGHTS","unit":null,"zip_code":"21703","listing_dt":"2024-08-15","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":null,"seller_office_id":null,"sold_dt":null,"sold_price":null,"update_dt":"2024-10-22 14:20:07","create_dt":"2024-08-16 02:53:31","marketing_headline_txt":null,"use_marketing_description_txt":null,"banner_flg":null,"banner_headline":null,"banner_location":null,"banner_description":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}