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

2813 Tally Ho Court
Sykesville, MD 21784

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $995,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3676
Agency: VYBE Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 2013
Notes: Breathtaking 4BR/3.5BA grand Colonial sits atop a beautifully landscaped yard surrounded by adult trees in the peaceful neighborhood of Derby Farms. Make your way through the neighborhood to the driveway entrance of your new home. The long/wide driveway takes you just outside the three-car garage with a walkway leading to the covered porch boasting stacked stone columns with an entry portoco. Step into an stunning open concept floor plan boasting tons of natural light with gorgeous hardwood flooring throughout. The spacious entry offers a view of almost every living space on the main floor beginning with french glass doors leading to a home office and a large opening into the oversized dining room. Walk through into the heart of the home featuring an amazing kitchen, breakfast room, and spacious family room featuring a gas fireplace with a brick accent wall. The kitchen offers plenty of cabinets, a large walk-in pantry closet, stainless steel appliances including a micro/wall oven combo and gas cooktop, a double sink set into a large island with a raised breakfast bar offering seating and bookcase shelving on either side. Between the kitchen and dining room, on the way to the mud room, is a butler's pantry with a beverage fridge. The mud room gives you access to the three-car garage and features wainscoting with a built-in bench and coat hooks. Pass by the half bath on the way to the stairway leading to the second floor offering a grand primary suite featuring a large walk-in closet, an impressive walk-through closet, and a primary ensuite featuring a large walk-in shower, a soaking tub, and a double sink vanity with a primping station between. The second bedroom is a primary size with a private full bath, third and fourth bedrooms feature a jack-n-jill full bath between them, and the convenience of second floor laundry. The lower level is a blank slate with tons of potential to become additional living space, and features a sliding door to the fenced yard. From the breakfast room step out to a covered deck with steps to the paved patio featuring stone walls and a built-in serving station, ideal when hosting family events. This home is move-in ready and has so much to offer new homeowners. Imagine all this and in close proximity to shopping, restaurants, and commuter routes.
MlsNumber: MDCR2019426


Listing Provided By: VYBE Realty, original listing
Name: VYBE Realty
Phone: (410) 220-4648
Office Name: VYBE Realty
Office Phone: (410) 220-4648
Agent Name: PETE WONG
Disclaimer: Copyright © 2024 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App