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

1327 W Jarrettsville Rd
Forest Hill, MD 21050
Tony (Mig) Migliaccio with Perry Hall, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: --
Agency: Perry Hall
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: 1949
Notes: Completely Updated Stone And Siding 3 Bedroom 2.5 Bath Cape Cod With Updated Architectural Roof, Side Deck, Detached Oversized Garage, New Luxury Vinyl Plank Floor, New Carpet, Refinished Hardwood Floors And Fresh Neutral Paint Throughout All Sited On Nearly 0.6 Acres Backing To Farmland In Forest Hill. Main Level Showcases Foyer Entry With Ceramic Tile Floor To The Expansive Family Room With Refinished Hardwood Floor, 2 Ceiling Fans, Crown Molding And Pellet Stove With Stone Accent Wall, Eat-In Kitchen With Ceramic Tile Floor, Hardwood Dining Floor, Breakfast Bar, Granite Countertops, Tile Backsplash, Pendant Lights, Table Space, Pantry, Updated Stainless Steel Appliances, Electric Stove / Oven, Built-In Microwave, Refrigerator, Ice Maker And Dishwasher, Bedroom 2 With Hardwood Floor And Ceiling Fan, Updated Full Hall Bath With Ceramic Tile Floor And Tub Shower And Bedroom 3 With Hardwood Floor And Ceiling Fan. Upper Level Offers Primary Bedroom With Ceiling Fan And New Carpet, Separate Spacious Primary Walk-In Closet And Primary Full Bathroom With Ceramic Tile Floor And Glass Door Walk-In Shower. Lower Level Features Recreation Room With New Luxury Vinyl Plank Floor And Recessed Lights, Updated Half Bath With Ceramic Tile Floor, Game Room With Luxury Vinyl Plank Floor And Recessed Lights, Laundry Room With Luxury Vinyl Plank Floor, Washer, Dryer And Utility Sink, Storage Room And Walk-Up To The Side Yard. The Exterior Of The Home Provides 2 Covered Porches, 16'x16' Wood Deck, Oversized 1 Car Detached Garage, Fenced Rear Yard With Views Of Farm Land Backing To The Property. A MUST SEE AND MOVE IN READY!!! *** PLEASE CLICK ON THE 'MOVIE' ICON WITHIN THE ONLINE LISTING TO VIEW THE 3D VIRTUAL TOUR AND WALK THRU VIDEO ***
MlsNumber: --
ListingId: MDHR2036594


Listing Provided By: Perry Hall, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Tony (Mig) Migliaccio
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 = 3259 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 Joanna Dieter
Joanna Dieter
ASCIIVybe Realty
Call Today!: (410) 949-6855

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App