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

Lot 14 Cecilia Court
Kingsville, MD 21087

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $285,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: The Pinnacle Real Estate Co.

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other

Neighborhood/Schools

Elementary School/District: KINGSVILLE/BALTIMORE COUNTY PUBLIC SCHOOLS
Middle/Junior High School/District: /BALTIMORE COUNTY PUBLIC SCHOOLS
High School/District: PERRY HALL/BALTIMORE COUNTY PUBLIC SCHOOLS
Subvidision Name: Hahn's Meadow

Description/Comments


Lot Size: 1 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Take advantage of the Danleigh Design/Build format which provides for true customization and allows you to build a one-of-a-kind custom home ranging from two story traditional, rancher design, or a plan with first floor owner’s suite and 2nd floor living as well. Luxury Danleigh Home Features · Beautiful Architectural Elevations with Standard Stone to Water Table· Standard 2 Car Side Entry Garages (Optional 3+Car)· Luxury Kitchen w/ Standard Quartz Countertops & Standard Island· Upgraded Maple Cabinetry with Soft Close Doors and Drawers· Stainless Steel appliance package to include Chimney Style Hood, gas range, Side by Side Refrigerator and quiet stainless steel dishwasher· Hardwood Floors on the Entire Main Level· Standard Oak Tread Staircase · Standard Gas Fireplace in the Family Room just to name a few. Hahn’s Meadow offers Seven (7) estate size homesites for you to build your CUSTOM dream home! Price advertised is the lot with house starting price. Hahn's Meadow is "tucked away" off of Chapman Rd-yet convenient to major commuter routes. On-site sales center is open from 11am-4pm Thursday thru Monday, or by appointment. *Photos are of previously built Custom Danleigh Home. ASK ABOUT DANLEIGH DOLLARS!
MlsNumber: --


Listing Provided By: The Pinnacle Real Estate Co., original listing
Phone: (410) 560-3556
Office Phone: (410) 560-3556
Agent Name: Dara Lewis
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App