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;

6305 Departed Sunset Lane
Columbia, MD 21044

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $935,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 3760
Agency: RE/MAX Realty Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1994
Notes: Beautifully updated colonial home with unique designer touches in the highly sought-after Village of River Hill. Well-appointed traditional floor plan starts with a covered front porch and a grand two-story foyer, where new charming chandeliers and a beautiful hardwood staircase set the stage for the warmth and luxury that characterize this colonial home. The main level flows with Brazilian Cherry floors, from the spacious & bright living room, through stained glass French doors into the formal dining room, and through arched doorways into the centrally located chef's kitchen and into the family room. The chef's kitchen shines with new quartz countertops, new subway tiled backsplashes, a large center island under stylish new pendant lights, white cabinetry, updated appliances, and a delightful breakfast nook, which opens to the expansive family room with gas fireplace and a large bay window overlooking the tranquil backyard. Step outside to a large deck to enjoy a serene view of the fully fenced-in yard with mature trees in the back. Also on the main level is an updated powder room and a sizable laundry room equipped with a laundry chute and upgraded washer and dryer (in 2022). Beautiful Brazilian Cherry floors continue throughout the entire upper level. The primary suite features double door entry, vaulted ceiling, lighted ceiling fan, and a walk-in closet. Newly renovated primary bathroom boasts new double sink vanity, new designer fixtures, new tiled floor and walls, and a new shower with frameless glass enclosure. Upstairs hallway bathroom is also updated with new floors, new double sink vanity, and new fixtures. Fully finished walk-up basement has brand new carpet, a large recreation room, a full bathroom, and a media room that’s hardwired for sound… ready to host your next movie night. Additional upgrades include: entire home freshly painted with designer colors (2024), new roof and siding (2018), new water heater (2024), new windows (2023), new dishwasher (2022), and new deck boards and railing (2019). Ideally located within top-ranked school districts (Clarksville ES, Clarksville MS, and River Hill HS), 5 minute walk to the 1,021-acre Middle Patuxent Environmental Area and its 5.5 miles of hiking trails, and 4 minute ride to River Hill Village center. Easy commute to Baltimore, Washington, and BWI Airport from Routes 32 and 29, and I95. This home is a family's dream come true, combining timeless elegance and modern convenience in one extraordinary package.
MlsNumber: MDHW2037418


Listing Provided By: RE/MAX Realty Group, original listing
Name: RE/MAX Realty Group
Phone: (301) 258-7757
Office Name: RE/MAX Realty Group
Office Phone: (301) 921-4500
Agent Name: KATHY XU
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 = 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