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 = 1196 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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 = 1196 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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 = 1196 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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;

14079 Crataegus Court
Galena, MD 21635
Justin Kennedy with Keller Williams Flagship of Maryland, original listing - (410) 729-7700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,249,000
Beds: 6
Baths: Full: 5, ½: 2
Status: Active
SqFt: 5961 Square Feet
Agency: Keller Williams Flagship of Maryland
Agency Phone: (410) 729-7700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Welcome to 14079 Crataegus Ct- a magnificent custom 6-bedroom home built in 1995 with stunning architecture. It is located in the rural community of Gentle Winds, just minutes from the eastern shore and 10 minutes from Middletown. You are greeted by beautiful, varied, mature landscaping and hardscaping with stone walkways as you pull into the circular driveway. This private retreat offers scenic views of the 1-acre stocked pond, attracting birds and abundant wildlife.<br /> <br /> Upon entering the home, you will find yourself in a massive two-story foyer with marble flooring, built-in bench seating, stone planters, 28-foot vaulted ceilings, and a 43-foot wide heated marble entryway leading to the floating marble staircase. Both upper and main floors feature primary bedroom suites with bathrooms that feature soaking tubs, stand-alone showers, and heated floors made easily accessible by an elevator. In addition to the primary suites, there are four sprawling bedrooms and three bathrooms. The custom-designed kitchen boasts beautiful granite countertops, an island for added workspace, and top-of-the-line appliances for all your cooking needs. Additionally, there is an eat-in area, a wet bar perfect for casual meals or entertaining guests, and a stunning stone gas fireplace to keep you cozy while you cook.<br /> The separate dining room boasts beautiful hardwood floors with intricately designed inlays. The main floor includes a separate family room and den, laundry room, walk-in pantry, office space, two half baths, and two additional stone fireplaces with gas inserts.<br /> <br /> The outdoor terrace features a built-in hot tub and grill, and the house has three geothermal HVAC systems with seven thermostats, which puts it at the top of the energy efficiency chart. A three-car side-entry garage provides ample space for your vehicles on-road or off. <br /> <br /> The backyard and back patio are the highlight of this property. The stonework on this multi-level patio is incredible with its built-in grill and hot tub - the perfect setting to bring your friends and family over to entertain or have a relaxing evening to yourself. If boating and a day on the water are part of your plans for the day, the convenience of local marinas and water access are only minutes away. There are too many great things to say about this truly one-of-a-kind estate. It's ready for its new owners. Schedule your showing today!
MlsNumber: --
ListingId: MDKE2003830


Listing Provided By: Keller Williams Flagship of Maryland, original listing
Phone: (410) 729-7700
Office Phone: (410) 729-7700
Agent Name: Justin Kennedy
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