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

812 Locust Road
Havre De Grace, MD 21078
Daniel McGhee with Homeowners Real Estate, original listing - (410) 967-5995

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3444 Square Feet
Agency: Homeowners Real Estate
Agency Phone: (410) 967-5995

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Welcome to "the Castle on Locust Rd" this elegant 3 bed, 3 full bath custom home was built in 2007 with integrity and high quality craftsmanship, no detail was left untouched. This home sits minutes from Rt 40 and I-95 but also just two and a half blocks from the water and offers partial water views in summer and clear water views in the fall/winter. Two blocks away at the end of Erie St lies the marina and just a couple blocks more brings you to all the shopping and restaurants that downtown Havre De Grace has to offer. There is also a children's park and walking trail at the end of Locust Rd.<br /> Pull into the large driveway and park in the oversized (400 sq ft) two car garage and enter in through the back of the home, or walk the steps to the massive wrap around front porch. Swing on the swing or sit in a rocking chair and admire the views with vacant lots to the side and to the front with water beyond. Entering through the front door brings you to the main level which is covered in high quality cherry wood flooring. To the left is a family room, which could also serve as a formal dining room if you prefer. This flows into the dine in kitchen which has granite countertops, a granite island, custom ginger glazed cabinetry and all stainless steel appliances. A door off of the kitchen area leads to the garage and also to the rear yard. This backyard is like your own private oasis, with high privacy fencing you are in your own world. Admire the landscaping out back, the stone patio that runs along the side of the house to the rear yard, the rock gardens and flower gardens, and garden pond with small waterfall. There is a retractable awning on the side patio, and a $10K hot tub with a pergola in the rear. There is also a chicken coop that can either stay or go at buyers preference.<br /> Back inside, exiting the other side of the kitchen brings you to a large living room with an electric fireplace and wood mantel. The step down next to this room that leads to the basement has a full bath with tub/shower combo at the top of the basement steps. Heading into the fully finished basement brings you to an entertainers dream with a custom bar with fridge and plumbing nearby, a theatre room with a $9K theatre/sound system, an adjoining recreation room with stone laminate flooring, a pool table and a bar to watch TV from while you eat. Down here you will find the mechanical room with an 80 gallon hot water heater and one of the two HVAc units (This property is dual zoned).<br /> Heading to the upstairs brings you to a large owners suite with great views out of the bay windows, a large custom walk in closet, and private bath with jacuzzi tub and shower. Also on this floor is another full bath with tub/shower combo, as well as two more bedrooms, one of which has its own private office or bonus room for whatever your needs may be. No expenses were spared on this home. The carpet on the third floor is new, there is custom trim and crown molding throughout, cieling fans throughout, ring doorbell, security lights and camera and the whole house is prewired for cable. This home is truly one of a kind, a unique gem in historic Havre De Grace and is waiting for you to come call it home!
MlsNumber: --
ListingId: MDHR2034340


Listing Provided By: Homeowners Real Estate, original listing
Phone: (410) 836-9399
Office Phone: (410) 967-5995
Agent Name: Daniel McGhee
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.


Local Real Estate Expert

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 = 1194 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;
The Ritchie Group
ASCIIBerkshire Hathaway HomeServices Homesale Realty
Call Today!: (410) 215-1123

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App