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 = 3431 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 = 3431 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 = 3431 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;

8300 Concord Drive
Morton Grove, IL 60053
Randy Schulenburg with Schulenburg Realty, Inc, original listing - (224) 805-2616

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $319,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1215 Square Feet
Agency: Schulenburg Realty, Inc
Agency Phone: (224) 805-2616

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Such a GREAT opportunity to own this highly sought maintenance free condo at a great price with low interest rates, taxes and reasonable assessments. Contact your Real Estate Broker for a private showing and if financing, your lender for how easy it is to afford this best priced condo in Trafalgar Square. Sweet opportunity to own this desirable condo with 'million dollar views' that includes underground parking with storage closet, low taxes and reasonable assessments; Whereas the Seller is willing to credit 3 years of the 13th assessment with a solid offer. Large, deluxe eat in kitchen with plenty of cabinet space. In-unit spacious laundry room with side by side washer and dryer included. Brand new upgraded Kohler toilet in a roomy bathroom with a large linen closet and a brand new deluxe Moen shower head just installed. A new garbage disposal recently installed along with all new smoke detectors. Both bedrooms and the great room take in gorgeous unobstructed views. Step out onto the spacious balcony and enjoy the cool morning breeze off Lake Michigan as you enjoy a sip of your favorite beverage watching another perfect sunrise that will start your day off on a happy note! Special features abound in this community including a Party Room with kitchenette, bathroom, seating and TV, a secured two story entryway with elevator and underground parking with storage closet and a beautiful newly built outdoor covered pavilion to enjoy picnics and BBQ's. Get this! The floors in the ENTIRE unit are heated AND the property ALSO has HEATED SIDEWALKS and DRIVEWAYS. Morton Grove train station nearby. Just a few minute walk and a 30 minute commute to Union Station in downtown Chicago. A very convenient location near shopping, expressways, parks, libraries and wonderful restaurants. Just minutes away is Sawmill Station, a large 26-acres with 240,000 square ft of retail and entertainment space including a favorite; Cooper Hawks Restaurant. A well run building in top notch shape with solid reserves; the Management Company keeps the building in immaculate condition at all times. You know the building is solid when the architect of Neri Companies (the builder) actually lived in this building and at one point was on the board of directors. Amazing view of several fireworks displays throughout the year from your balcony including the big Fourth of July Fireworks show at Harrer Park. Lower taxes, low assessments and move in ready. Assessments Includes: Heat, water, gas, parking, insurance, exterior maintenance, lawn care, Scavenger and snow removal. You must schedule a tour to experience how nice this community is. Check out the YouTube Video Tour included as a link with the photos. This property may be utilized in the future as a rental property. The well run association maintains a 20 per cent rental cap. Owner occupied only at this time but, per the association, there is no one on the waiting list so if you purchase this condo, and want to rent it in the future, get your name on the list and you will currently be #1 for when a spot opens up.
MlsNumber: --
ListingId: 12200647


Listing Provided By: Schulenburg Realty, Inc, original listing
Phone: (224) 805-2616
Office Phone: (224) 805-2616
Agent Name: Randy Schulenburg
Disclaimer: Copyright © 2024 Midwest Real Estate Data, LLC. 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 = 3431 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;
Boris Lehtman
ASCIIFulton Grace Realty
Call Today!: (847) 644-7902

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App