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

7426 Weather Worn Way
Columbia, MD 21046

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $700,000
Beds: 4
Baths: 3
Status: Pending
SqFt: --
Agency: Long & Foster Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1984
Notes: COLUMBIA LIVING AT ITS VERY FINEST! Absolutely STUNNING, Renovated home in the sought after Dickinson area of Kings Contrivance. This Spacious home (FOUR Finished Levels!) checks all the boxes! Everything has been done for you, including a Fabulous, Expanded Gourmet Kitchen, Top-Of-The-Line Bathrooms, and the list goes on and on. Gleaming Hardwood Floors, Energy Efficient Windows, Recessed Lighting, Crown and Chair Molding, Built-Ins, and a Recently Customized Majestic Gas Fireplace with an Impressive Floor-to-Ceiling Stone Surround, to name just a few. Let's begin in the Kitchen and Breakfast area! Completely Customized and High End, you'll love preparing meals here (and showing off your Kitchen)! Lots of Gorgeous Cabinetry, Elegant Countertops and Backsplash, and Custom Lighting. Hi-End 5-Burner Gas Stove with a Double Oven, Instant Hot Water, a Peninsula Island, Pantry, and More! And there's plenty of room for a large table next to a big Bay Window. You'll want to have lots of guests over, and the Super-Sized Dining Room can accommodate them. Also on this level in a Light-Filled Living Room, with Sliders to the Large Deck, Paver Patio, and Rear Yard. Just three steps down, and you're in a Spacious Family Room, with Lots of Natural Light, that Amazing Fireplace mentioned earlier, and Beautiful Built-Ins. Also on this level is a 4th Bedroom, another Bathroom, and the Laundry area. Let's head Upstairs, where you're met with Three good-sized Bedrooms. The Owner's Suite is Special, with Two Walk-In Closets, Remote Controlled Shades, its own Balcony, and one of those three Custom Bathrooms! You'll Love it! The other two Bedrooms share another Impressive Bathroom. The lowest level is Fully Finished too! There's a Bar and Fridge, and lots of space for a pool table or whatever you desire. Parking won't be an issue. There's an Extended 2-Car Garage with Storage Area, and two additional Driveway Spaces. You may never want to leave your new home, but when you do, Columbia awaits! You're close to Shopping and Restaurants, and, you're directly across the street from the Kings Contrivance Dickinson Beach-entry Swimming Pool and Sand Volleyball Courts WOW! You won't want to miss this opportunity to see what may be your new home -- Welcome!
MlsNumber: MDHW2039268


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Columbia
Office Phone: (888) 536-0216
Agent Name: Steve Lenet
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 = 1195 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;
Erica Washington
ASCIIKeller Williams
Call Today!: (443) 956-2660

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App