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

26531 W Melissa Drive
Channahon, IL 60410

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1800
Agency: RE/MAX Ultimate Professionals

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: NEW RANCH 3 BEDROOM~ 2 BATH~ 1800 SQ FT IN Mc KINLEY WOODS SUBDIVION. THIS QUAILITY BUILT HOME WILL MAKE YOU FEEL AT HOME AS SOON AS YOU WALK THRU THE FRONT DOOR. THE FOYER OPENS TO THE BEST OPEN COMCEPT FLOORPLAN. THE SPECTACULAR KITCHEN INCLUDES SOFT CLOSE CABINETRY DOORS & DRAWERS 36" UPPER CABINETS ~ GRANITE COUNTERTOPS ~ STAINLESS STEEL APPLIANCES ~ CAN LIGHTS~ WATER LINE FOR REFRIGERATOR. THE KITCHEN OPENS INTO THE FAMILY ROOM FOR THE TRUE OPEN CONCEPT LIVING. THE OFFICE DEN ALLOWS YOU TO WORK FROM HOME OR JUST A QUITE GET AWAY. 2 BEDROOMS & THE PRIMARY SUITE WITH VOLUME CEILING INCLUDES 2 CLOSETS AND LUXURY BATH WITH CERAMIC FLOORS ~ GLASS SHOWER DOOR ~ GRANITE COMFORT HEIGHT VANITY. HUGE LAUNDRY ROOM, AND FULL HALLWAY BATH. FULL UNFINISHED BASEMENT WHICH CAN ADD ANOTHER 1700 SQ FT OF LIVING SPACE WHEN FINISHED. THE EXTRA FEATURES THAT ARE STANDARD WITH THIS BUILDER ARE 9 FT FIRST FLOOR ~ LUXURY VINYL PLANK FLOORING ~ 2X6 EXTERIOR WALL CONSTRUCTION ~ ARCHITURAL SHINGLES ~ HIGH EFFICENCY FURNACE AND AIR CONDITIONING ~ POWER VENTED WATER HEATER ~ ALUMINUM FACIA & SOFFITS, VINYL SIDING AND BRICK FRONT PER PLAN MAKES THE EXTERIOR VIRTUALLY MAINTENANCE FREE ~ STEEL INSULATED GARAGE DOOR WITH WIRELESS MOTOR ~ RING DOORBELL & NEST THERMOSTAT~ 200 AMP SERVICE ~ 5 1/4" BASE BOARD. THIS IS NOT ALL OF THE QUAILITY STANDARDS THAT ARE INCLUDED IN THE PRICE OF THIS LUXURIOUS HOME !!!! LENDER INCENTIVES MAY BE AVAILABLE~. BUILD TIME IS APPROX 5-6 MONTHS UPGRADES ARE AVAILABLE ALL PHOTOS ARE OF PREVIOUSLY BUILT HOME SOME UPGRADES MAY BE IN PHOTOS.THIS IS A PROPOSED MODEL TO BE BUILT OTHER MODELS CAN BE BUILT ON THIS LOT SHOWN WITH 3 CAR GARAGE AS A UPGRADE FLOOR PLAN IN ADDITIONAL INFORMATION
MlsNumber: 12041582


Listing Provided By: RE/MAX Ultimate Professionals, original listing
Name: RE/MAX Ultimate Professionals
Phone: (815) 725-4545
Office Name: RE/MAX Ultimate Professionals
Office Phone: (815) 556-1077
Agent Name: Phillip Lawrence
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 = 3198 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;
Real Estate Expert Photo for Mike Moyzis
Mike Moyzis
ASCIIColdwell Banker Realty
Call Today!: (708) 205-9622

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App