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

4100 Underwood
University Park, MD 20782
Bryan Bartlett with Compass, original listing - (410) 220-5745

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3887 Square Feet
Agency: Compass
Agency Phone: (410) 220-5745

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1948
Notes: Welcome to your dream home! 4100 Underwood offers the very best of both worlds; a practically brand-new build and located in the established, much-desired neighborhood of University Park. This stunning, completely renovated residence offers an impressive 5 bedrooms and 4.5 baths, sprawling across nearly 4,000 square feet of fabulous living space. Every detail has been thoughtfully curated, from the high-end finishes to the stylish fixtures, this home was meticulously and lovingly planned for both luxury and functionality. The heart of the home is the expansive living area, highlighted by a beautiful brick fireplace for those cold winter nights, perfect for entertaining or relaxing with family. The modern kitchen boasts top-of-the-line stainless steel appliances, sleek quartz countertops, gorgeous tile backsplash and custom cabinetry, seamlessly flowing into the dining and living areas. Convenient to the kitchen, you'll find a massive walk-in pantry, providing ample storage for all your culinary needs. This exceptional property also features not one, but two primary suites, providing ultimate comfort and privacy. As you step through the front door, you'll be greeted by gleaming hardwood floors that carry throughout the main level, enhancing the open-concept layout that seamlessly connects the living, dining, and kitchen areas. The abundance of natural light highlights the beauty of these floors, creating a warm and inviting atmosphere. The main-level primary suite is a true retreat, ideal for guests or multi-generational living, offering convenience and privacy, boasting a large walk-in closet and spa-like bathroom that is an absolute showstopper. This luxurious bath features a unique water room, combining a soaking tub and a walk-in shower in a beautifully designed space that promises relaxation and rejuvenation. Completing the main level is a stunning four-season sunroom that seamlessly blends indoor and outdoor living. With direct access to the backyard, this sunroom is the perfect space to enjoy the beauty of every season. Whether you're looking to create a cozy family room or a serene retreat to bring the outdoors in, this sunroom offers endless possibilities. The upper level of the home presents its own primary suite with multiple closets and beautifully appointed bath, 3 more sizable rooms and an additional full bath. A thoughtful design element of this home is the communal space strategically placed between the bedrooms, enhancing the home's functionality. The lower level offers an enormous area of finished space, perfect for a variety of entertaining options, game room, home gym, or even additional living quarters with the 4th full bath. This level also includes a laundry room, utility room and bonus storage space. To ensure comfort on every level, the home is equipped with a dual-zone HVAC system, allowing for precise temperature control and energy efficiency throughout the year. Come visit prestigious University Park and envision your new beginning in this exceptional property!
MlsNumber: --
ListingId: MDPG2136688


Listing Provided By: Compass, original listing
Phone: (202) 491-1275
Office Phone: (410) 220-5745
Agent Name: Bryan Bartlett
Disclaimer: Copyright © 2025 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