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;

4213 Tuckerman St
University Park, MD 20782
Jean Bourne-Pirovic with Greater Silver Spring, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $970,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: Greater Silver Spring
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1926
Notes: This charming, solid brick, 1926 built Colonial has just been beautifully rejuvenated for future generations to enjoy! Exceptional attention to every detail in this modern and thoughtful renovation make it the perfect choice for today's discerning buyers. Modern design and high quality materials, envisioned and built by a well known local builder, make this truly a turn-key property. Enjoy your morning coffee or afternoon tea on the open, but covered, front entryway which welcomes you into the first floor where walls were redesigned to create open living space for today's lifestyle. It features a living room w/luxury vinyl floors, a brick surround FP w/new 55"" flat screen TV, a new kitchen with soft close cabinets and stainless steel appliances, a center island with drawer-style microwave and add'l storage, motion activated kitchen faucet, air switch for garbage disposal and luxurious quartz countertops with a full backsplash. Its further enhanced by a motion-activated faucet and a French-style refrigerator with double ice maker. All windows have been replaced with double-hung Low-E ProVia's and those, together with recessed LED lights and new fixtures throughout, help illuminate the home. Access to a new partially covered deck with composite decking and railing allows coverage from inclement weather and extends the living space outdoors. Significant upgrades to the upper level include an en-suite bathroom with double vanity sink , porcelain floor and wall tiles, and walk-in closet in the main bedroom. The spacious hall bathroom features all new fixtures, flooring and exhaust fan and services the second and third bedroom on that level. Newly carpeted stairs and floors introduce the fully transformed attic featuring a bonus room (perfect for bedroom, office or den) and it features a seating bench. The lower level has been totally transformed and boasts a versatile bedroom/office, a sleek new bathroom, a functional laundry room w/Washer and Dryer, a recreational space and a storage room with utility sink and access to the rear yard. Other notable improvements include a one-car garage with new door & opener, brick steps & new concrete walkway, new dual zone HVAC, an upgraded electrical panel and an electric car charger. Old cast iron drain pipes and steel pipes were replaced with new PVC pipes and an extra gas line was installed in the mechanical room for future use. It's close proximity to Whole Foods, Trader Joes, Starbucks, Gold's Gym, choice restaurants, The University of Maryland College Park Campus, Two Metro Stations (Purple Line in progress), Marc Train, parks and recreational facilities, and so much more, provides a wonderful opportunity that can't be beat. Hurry!!
MlsNumber: --
ListingId: MDPG2121360


Listing Provided By: Greater Silver Spring, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Jean Bourne-Pirovic
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 = 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;
Real Estate Expert Photo for Emcee Arah
Emcee Arah
ASCIISamson Properties
Call Today!: (301) 691-2209

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App