10303 Maracaibo Mews • New Market, MD 21774

$1,250,000 • Beds: 5 • Baths: 4 full • Sq. Feet: 4812 • MLS ID: MDFR2079628 • Subdivision: COLDSTREAM • School Dist: FREDERICK COUNTY PUBLIC SCHOOLS
***RARE & AMAZING OPPORTUNITY TO OWN YOUR VERY OWN DREAM HOME***EXTRAORDINARY LAKE FRONT BEAUTY***SPECTACULAR 5 BEDROOM/4 BATH WATERFRONT HOME WITH ALMOST 5000 SQUARE FEET ON 3 BEAUTIFULLY FINISHED LEVELS IN THE SOUGHT-AFTER COLDSTREAM COMMUNITY JUST STEPS FROM THE LARGEST BEACH IN LOVELY LAKE LINGANORE***BREATHTAKING WATER VIEWS FROM ALMOST EVERY ROOM***BUILD A PRIVATE DOCK & BRING YOUR PONTOON BOAT & START LIVING THE FABULOUS LAKE LIFE***This STUNNING home enjoys UPGRADES THROUGH OUT including SOARING CEILINGS, SOLID WOOD staircase & flooring on the top two levels, TWO CAR GARAGE, DOUBLE DECKS, a GOURMET KITCHEN, STONE WOOD BURNING FIREPLACE, MAIN LEVEL BEDROOM & Full BATH, ENORMOUS OWNERS SUITE with TRAY CEILING, COFFEE BAR & LUXURY BATH***FULLY FINISHED BASEMENT with IN-LAW SUITE with Kitchenette, Full bath & large Exercise Room***Cinch Home Warranty***CLOSE TO ALL AMENITIES***SWIM, BOAT, FISH, HIKE, ENJOY COMMUNITY SUMMER CONCERT SERIES, FARMERS MARKET, AND SO MUCH MORE***MUST SEE*** View this listing at: http://yorkpahomes.com/mls=MDFR2079628

Property Features

  • Garage: 2
  • Taxes: $9,617
  • Basement: Yes
  • Exterior: Brick Veneer,Brick Front,Vinyl Siding
  • Parking Notes: 4 Total Parking Spaces
  • Special View Info: Lake,Trees/Woods,Water
  • Lot Size: 0.24 Acres
  • Lot Dimensions: 0.24 Acre(S)
  • Heating: Heat Pump(s)
  • Fuel Type: Electric
  • Cooling: Ceiling Fan(s),Central A/C
  • Year Built: 2011
  • Fireplaces: 1
  • Water: Public
  • Sewer: Public Sewer
  • Stories: 3.0
  • Number of Rooms: 9
  • HOA Fee: $1848.79/Annually
  • Additional Structures: Above Grade,Below Grade
  • Fencing Description: Rear
  • Location Description: Lake
  • Structure Type: Detached
  • Total Garage/Parking Spaces: 4
  • Parking Features: Asphalt Driveway
  • Appliances: Built-In Microwave,Disposal,Dishwasher,Dryer,Refrigerator,Stove
  • Rooms: Bedroom 2,Bedroom 3,Bedroom 1,Bathroom 1,Bathroom 2
  • Basement: Connecting Stairway,Fully Finished,Improved,Heated,Interior Access,Outside Entrance,Walkout Level,Windows
  • Lake Name: LAKE LINGANORE
  • Community Amenities: Basketball Courts,Beach,Bike Trail,Boat Dock/Slip,Boat Ramp,Common Grounds,Jog/Walk Path,Lake,Pickleball Courts,Pier/Dock,Picnic Area,Pool - Outdoor,Tennis Courts,Tot Lots/Playground,Volleyball Courts,Water/Lake Privileges
  • SQFT Total Finished: 4812
  • SQFT Above Finished: 3222
  • SQFT Below Finished: 1590
  • Exterior: Bump-outs,Extensive Hardscape
  • Interior: Breakfast Area,Ceiling Fan(s),Dining Area,Entry Level Bedroom,Family Room Off Kitchen,Floor Plan - Open,Formal/Separate Dining Room,Kitchen - Gourmet,Kitchen - Island,Walk-in Closet(s),Wood Floors
  • Flooring: Hardwood,Solid Hardwood,Ceramic Tile
  • Water Access: Boat - Electric Motor Only,Canoe/Kayak,Fishing Allowed,Private Access,Swimming Allowed

School Information

  • School District: FREDERICK COUNTY PUBLIC SCHOOLS
Printed May 15, 2026

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 05/15/2026. The listing information on this page last changed on 05/15/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Fri 05/15/2026 12:00:00 AM EST) or Bright MLS (last updated Thu 05/14/2026 11:50:25 PM EST). Real estate listings held by brokerage firms other than Berkshire Hathaway HomeServices Homesale Realty may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility
Federal Housing Equal Opportunity Realtor
Corporate Office - 215 S Centerville Rd. Lancaster, PA 17603
James J Hafer - West Virginia Broker of Record

©2026 BHH Affiliates, LLC. An independently owned and operated franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  


Agent License Information: 
Licensed in Pennsylvania
Michael Thomas 

592 Shrewsbury Commons Avenue, Shrewsbury, PA 17361
717-235-9050