Title Page Background
DEBUG FN args: Array ( [0] => 3252 [1] => [2] => [3] => agent ) BEFORE: Site: 3252 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3252 Igate: njhud LocID: 3252 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 = 3252 AND i.igate IN ('mdhud','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 = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3252 [1] => [2] => [3] => lender ) BEFORE: Site: 3252 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3252 Igate: njhud LocID: 3252 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 = 3252 AND i.igate IN ('mdhud','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 = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3252 [1] => [2] => [3] => other ) BEFORE: Site: 3252 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3252 Igate: njhud LocID: 3252 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 = 3252 AND i.igate IN ('mdhud','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 = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

3738 Smiley Lane
Harwood, MD 20776

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $989,900
Beds: 6
Baths:
Status: Active
SqFt: 4300 Square Feet
Agency: RE/MAX Leading Edge

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Range, Refrigerator, Dryer, Freezer, Ice Maker, Washer/Dryer Combo, Range - Electric, Vacuum System
Architectural Style: Cape Cod
Construction Materials: Vinyl Siding
Cooling: Central A/C
Heating: Forced Air, Fireplace
Interior Features: Pantry, Attic, Central Vacuum, Walk-in Closet(s), Ceiling Fan(s), Recessed Lighting, Bar, Soaking Tub, Built-ins, Wood Floors, Crown Moldings, Wainscotting, Carpet, Dining Area, Butlers Pantry, Chair Railings, Breakfast Area, Family Room Off Kitchen, Formal/Separate Dining Room, Kitchen - Eat-in, Kitchen - Island, Primary Bath(s), Floor Plan - Open, Entry Level Bedroom, Kitchen - Table Space, Kitchen - Gourmet, Upgraded Countertops, Exposed Beams, Curved Staircase, Stove - Wood, Double/Dual Staircase, Stove - Pellet
Rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5

Window Features

Parking Features: Driveway

Neighborhood/Schools

Elementary School/District: CENTRAL
Middle/Junior High School/District:
High School/District: SOUTH RIVER/ANNE ARUNDEL COUNTY PUBLIC SCHOOLS
Subvidision Name: None available

Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Come sit on the huge front porch in this Remodeled Picturesque Custom Cape Cod. This is the PERFECT Family HOME! The minute you step inside this Magnolia Home-Farmhouse inspired Cape Cod, you feel at home! Amazing location minutes to Edgewater and 10 min Annapolis shopping, 40min to Baltimore and DC. This home features an amazing floor plan with a 1st floor primary suite w/ a gorgeous remodeled bathroom w/ double vanity, soaking tub and separate shower w/porcelain tile. So many amenities in this Custom Cape to include a "To Die For" newly remodeled Gourmet kitchen w/ Double islands, Stainless steel appliances, Quartz countertops, marble backsplash, a butler's pantry and new hardwood floors. Steps from kitchen is an New "One of a Kind" Bar Room with beverage & wine fridges and brick Herringbone floors, this is the perfect entertaining space! Beautiful covered porch off kitchen, leads to a maintenance free deck overlooking huge private wooded backyard. Oversized family room off kitchen w/hardwood floors, custom woodwork and a natural stone fireplace. Completing the downstairs is two story Foyer, Separate Dining room , Laundry Room and Mud Room . DUAL STAIRCASES lead upstairs to the 5 Bedrooms and a newly remodeled bath with double sinks ,separate shower and an newly built out office space-great for the work from home lifestyle. Upstairs has loads of storage to include custom shelving, window seat w/storage, walk-in closets an a storage area of almost 1k square feet which could easily be converted to more living space. This home has so much space to offer: to include 3 car garage, unfinished walk-out basement( to finish to your liking). All this on a 3.85 acre lot surrounding rolling Farmland. Bring your farm animals!! THIS HOME is a MUST SEE!!
MlsNumber: --


Listing Provided By: RE/MAX Leading Edge, original listing
Phone: (410) 956-3500
Office Phone: (410) 956-3500
Agent Name: Kathy Grimley
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => anne-arundel-south [3] => MD [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: anne-arundel-south State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: anne-arundel-south 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 = 3252 AND i.igate IN ('mdhud','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 = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Lindene Patton
ASCIICentury 21 New Millenium
Call Today!: (703) 447-6555

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => anne-arundel-south [3] => MD [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: anne-arundel-south State: MD Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: anne-arundel-south 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 = 3252 AND i.igate IN ('mdhud','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 = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Paul McCausland
Paul McCausland
ASCIIMeridian Bank
Office: (301) 605-9961

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App