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

11745 Maid At Arms Ln
Berlin, MD 21811

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 4
Baths: 4
Status: Active
SqFt: --
Agency: Long & Foster Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2007
Notes: LOCATED IN WEST OCEAN CITY- LESS THAN 3 MILES TO OC BOARDWALK!! 2 PRIMARY SUITES ON FIRST FLOOR! HOA is $295/month includes amenities, lawn maintenance, weeding, mulching, and so much more. Nestled within the prestigious gated community of marina and golf community of Glen Riddle, enjoy access to an array of amenities including a fitness center, outdoor pool, splash pad, clubhouse, boat ramp, marina, tennis courts, kayak launch, club house, and 2 world-class golf courses. To top it off, indulge in fine dining at Ruth's Chris Steakhouse (located in Glen Riddle) and within 3 mile radius is Home Depot, Walmart, shopping, dining, medical, sought-after private and public schools, word-class fishing, boating, beaches, bays and more just moments from your doorstep. Remarkable 4-bedroom, 3.5-bathroom residence nestled on a prime wooded extra wide golf course homesite. From the moment you approach, the pride in ownership is evident in every meticulously maintained detail. Infrequently occupied, this sanctuary has been used less than 7 days per year in impeccable condition. Upon crossing the threshold, be prepared to be captivated by the seamless fusion of space and sophistication. Gleaming hardwood floors pave the way through an open floor plan, leading you from the welcoming foyer into a family room boasting a soaring ceiling. Natural light dances through stacked picture windows, framing breathtaking views of the surrounding nature and golf course, while a fireplace with built-in bookcases. The gourmet kitchen features granite countertops, an abundance of white cabinetry, large center island with seating, and a walk-in pantry. Adjacent to the kitchen, a dining room offers an ideal setting for both casual meals and elegant dinner parties alike. Step outside to discover a screened porch off the great room, as well as a large deck overlooking the tranquil woods and golf course-perfect spot to bask in the sun or savor the cool summer breezes. Retreat to the first-floor primary suite, where luxury abounds with a spacious walk-in closet and a spa-like ensuite featuring a dual vanity, stall shower, and deep soaking tub-your personal oasis of relaxation awaits. Additionally, a second primary bedroom on the main level provides both comfort and convenience with its own well-appointed ensuite. Ascending to the second level, two spacious loft areas offer versatile spaces for work or play, while two additional guest bedrooms enjoy private access to a shared bathroom. Completing the home, an oversized two-car garage provides convenient interior access. Embark on a lifestyle of luxury and leisure in this coastal haven-an unparalleled retreat where every moment is infused with beauty and relaxation.
MlsNumber: MDWO2020842


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Northrop - Bethany
Office Phone: (888) 536-0216
Agent Name: Shannon S Hunt
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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 = 1205 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;
Real Estate Expert Photo for Jennifer Light
Jennifer Light
ASCIIColdwell Banker Realty
Call Today!: (443) 632-6372

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App