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

392 E Burdick Road
Chesterton, IN 46304

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,000
Beds: 3
Baths:
Status: Active
SqFt: 3669 Square Feet
Agency: Stray Dog Properties, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1970
Notes: Gorgeous brick ranch on 2.38 acres! Beautiful trees and landscaping welcome you up the drive and into the foyer, where you'll immediately notice the reclaimed hardwood floors and natural light that flow throughout the home; from the large family room to your left, to the formal dining room overlooking the backyard and down the hall to the bedrooms! The charming eat-in kitchen opens up to the living room with gas fireplace & brick accent all; the perfect spot to get lost in a good book! Beyond that is the laundry room (washer & dryer stay), guest bathroom and den with built-in shelving that walks out to the enclosed porch where you can enjoy your morning coffee year-round thanks to dual ceiling fans AND a heater! Another full guest bathroom and three spacious bedrooms (including the sprawling master with bath en suite, walk-in closet with vanity & access to the back deck) round out your main level, while the basement offers tons of additional living space, boasting an office, sleeping room with en suite bath & rec room with wet bar for entertaining, plus copious unfinished areas for storage! You'll LOVE hosting friends for cookouts this summer in your parklike, picturesque backyard retreat; 18x18 deck immersed in wooded, natural privacy with three peach trees & seven apple trees -- your own mini orchard! There's an attached 2-car garage + detached 2-car, affording more than ample space to house all your toys! Although the property is seemingly secluded, you're just minutes from downtown Chesterton's shops, restaurants & European Market, Coffee Creek Nature Preserve, the Indiana Dunes Lakeshore & Dune Park South Shore station & toll road, making your commute to Chicago a breeze!
MlsNumber: --


Listing Provided By: Stray Dog Properties, LLC, original listing
Phone: (219) 246-5200
Office Phone: (219) 246-5200
Agent Name: Shawn Spaw
Disclaimer: Copyright © 2024 Greater Northwest Indiana Association of REALTORS. 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