Title Page Background
DEBUG FN args: Array ( [0] => 1194 [1] => [2] => [3] => agent ) BEFORE: Site: 1194 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1194 Igate: njhud LocID: 1194 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1194 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1194 [1] => [2] => [3] => lender ) BEFORE: Site: 1194 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1194 Igate: njhud LocID: 1194 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1194 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1194 [1] => [2] => [3] => other ) BEFORE: Site: 1194 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1194 Igate: njhud LocID: 1194 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1194 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

202 Terrace View Court
Churchville, MD 21028
Denise Diana with Weichert, Realtors - Diana Realty, original listing - (410) 893-1200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,595,000
Beds: 7
Baths: Full: 5, ½: 1
Status: Active
SqFt: 8121 Square Feet
Agency: Weichert, Realtors - Diana Realty
Agency Phone: (410) 893-1200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: THIS ONE WILL KNOCK YOUR SOCKS OFF!!! <br /> <br /> Welcome to 202 Terrace View Ct, a Trinity custom built home! Look at the 3 new gorgeous garage doors! Walk up to the meticulously well maintained extensive landscaped front yard to the brick circular covered front porch, Open the brand new Pro Vista double front doors to a beautiful 2 story foyer leading to the grand curved staircase with beautiful moldings , high ceilings , recessed lighting and all hardwood floors throughout the entire 1st floor. <br /> <br /> Features of the 1st floor are as follows: formal living and dining rooms with tray ceilings and wainscoting, very spacious office with double glass doors and large closet , 1st floor powder room. TWO story open family room with travertine stone gas FP , LOTS of windows, leads you to the rear sunroom with all new french doors , leading you to the MASSIVE rear deck with steps! Awesome open kitchen with tons of cabinet space, some with glass fronts, a butlers pantry, a huge center island, all with granite counter tops, stainless steel appliances. Find here another set of steps that takes you to the upper level. <br /> Dont miss the 1st floor laundry area with lots of closets and leads to the HUGE 3 car garage access .<br /> NOW enter the breezeway to this RARE FIND! THIS PROPERTY OFFERS AN ATTACHED 2ND DWELLING WITH 2 HUGE BEDROOMS, ONE VERY LARGE FULL BATH WITH SOAKING TUB AND WALK IN SHOWER, LOTS OF CLOSETS, A SEPARATE LAUNDRY ROOM EQUPPIED WITH ITS OWN FULL SIZE WASHER AND DRYER, A FULL KITCHEN WITH NEW STAINLESS STEEL APPLIANCES, GRANITE COUNTERTOPS, CENTER ISLAND , AN EAT IN AREA THAT LEADS TO THE REAR NEVERENDING DECK, A LARGE LIVING ROOM AREA WITH ITS OWN SEPARATE ENTRANCE INTO THE MAIN HOUSE THROUGH THE BREEZEWAY AND FROM THE BRAND NEW FRONT DOOR LEADING TO THE FRONT DRIVEWAY. <br /> <br /> The 2nd floor of this amazing property offers, a view into the foyer and the family room, 4 very nicely sized bedrooms, ALL with attached full bathrooms and ceiling fans. Bedroom 3 and 4 connects to a Jack and Jill bathroom with new vanity, granite counter tops, ceramic tile shower / tub combo . Bedroom 2 offers its own private full bath with ceramic tile shower tub / combo and extra large vanity.<br /> Enter the double doors to the AMAZING primary suite with a separate sitting room, a gas fireplace, a walk in closet that goes on forever and has a built in vanity, tray ceilings, a ceiling fan, lots of windows for beautiful sunlight. Check out the HUGE primary bathroom with new 2 sink vanity with new quartz counter tops, new vanity light fixtures, separate walk in shower and soaking tub with jets. All recessed lighting through out the entire 2nd level <br /> <br /> Dont forget the finished lower lever offering: an unbelievably large rec room, with brand new luxury vinyl plank flooring, another HUGE bedroom with brand new carpet and a walk in closet, a very spacious gym / workout room with new LVP flooring, another full bathroom with tub shower combo. Party time at the built in wood bar with tons of shelving, another set of kitchen cabinets, a new dishwasher, and new Refrigerator. This area leads you to French doors to the walk out basement to a fun exterior stoned private fire pit area. Need storage space??? walk into the endless unfinished basement storage area that also has a walk out to the back yard. <br /> <br /> SELLER IS LOOKING FOR AN END OF JUNE CLOSE DATE WITH A 45 to possibly 60 DAY RENT BACK UNTIL MID AUGUST!
MlsNumber: --
ListingId: MDHR2037886


Listing Provided By: Weichert, Realtors - Diana Realty, original listing
Phone: (410) 893-1200
Office Phone: (410) 893-1200
Agent Name: Denise Diana
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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => harford-southeast [3] => MD [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: harford-southeast State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: harford-southeast State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1194 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
The Ritchie Group
ASCIIBerkshire Hathaway HomeServices Homesale Realty
Call Today!: (410) 215-1123

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => harford-southeast [3] => MD [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: harford-southeast State: MD Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: harford-southeast State: MD Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1194 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Gary Becker NMLS#160607
Gary Becker NMLS#160607
ASCIINexa Mortgage
Call Today!: (410) 375-2216

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App