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 = 618 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 = 618 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 = 618 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;

632 Zagreb Avenue
Sycamore, IL 60178
Rorry Skora with RE/MAX Experience, original listing - (815) 895-8900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $594,500
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2100 Square Feet
Agency: RE/MAX Experience
Agency Phone: (815) 895-8900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: CUSTOM BUILT HOME-OPEN FLOOR PLAN WITH SPLIT BEDROOM LAYOUT! VERSLUYS CONSTRUCTION Really Shines With Unique Features At Every Turn In This 2,100+/- SF Sycamore Ranch Home...Ready For Immediate Occupancy! Entry Foyer Has Custom Wood Arch Opening - Open To The Stunning Living Room With Triple Windows Over Looking The Back - Floor To Ceiling Shiplap Fireplace & Detailed Ceiling Design With Accent Lighting. Open Sight Lines To THE KITCHEN...White Soft Close Cabinets - Quartz Countertops & DESIGNER TEXTURED BACKSPLASH That Add A Subtle Elegance To The Space. STAINLESS Range Hood - Stove - Built-In Microwave. LARGE CENTER ISLAND WOOD ACCENT WITH STAINLESS STEEL FARM SINK & Accessories! CUSTOM BUILT IN BOOKSHELF STORAGE ON EACH END PLUS....SURPRISE DOUBLE CABINET OPENS TO REVEAL WALK-IN PANTRY WITH ADDITIONAL WOOD SHELVING STORAGE!! OPEN TO THE Dining Room With Chandelier - Triple Windows & Glass French Door To Back ENCLOSED Porch Area! Master Suite Has Tray Ceiling With Accent Rope Lighting - (2) Walk In Closet & STUNNING Private Full Bath - Double Sinks With Back Lit Mirror- WOOD Soft Close Cabinets - Quartz Countertops - OVERSIZED DESIGNER Shower With extra ceiling rain Shower feature. Across The House Are The Additional 2 Spacious Bedrooms one with walk in closet and the other with double closet...And Full Bath With Hallway Linen Closet & In Bathroom Linen Closet Storage - double sinks - pocket door to toilet and tiled tub/shower. Mud/Laundry Room Has Built IN Bench Seating and Cubby Storage - Washer & Dryer Hook Up and Laundry Sink With Vanity Cabinet Storage. PLUS....1/2 bath off the back door area. Full Basement Has Rough In For Future Bathroom & SEVERAL LOOK-OUT Windows That Give You Natural Light! Attached 3 car Garage With Floor Drain....ATTENTION TO DETAIL IS AT EVERY TURN!! QUALITY CONSTRUCTION - READY FOR OCCUPANCY NOW!
MlsNumber: --
ListingId: 12215844


Listing Provided By: RE/MAX Experience, original listing
Phone: (815) 751-4171
Office Phone: (815) 895-8900
Agent Name: Rorry Skora
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App