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

1334 Country Creek Circle
Shelbyville, IN 46176
Judy Lauziere with Carpenter, REALTORS®, original listing - (180) 063-0172 x7

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $260,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1600 Square Feet
Agency: Carpenter, REALTORS®
Agency Phone: (180) 063-0172 x7

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Condominium
Year Built: 2003
Notes: Welcome to your dream home! This beautifully remodeled 3-bedroom, 2-bath condominium is perfectly situated on a spacious corner lot, offering both privacy and abundant natural light. Step inside to discover a bright and airy open-concept design that seamlessly connects the living, dining, and newly renovated kitchen. The kitchen boasts modern finishes, skylights that flood the space with sunshine, making it the perfect gathering spot for family and friends. The generous primary suite features a luxurious en-suite bathroom with elegant tilework in walk-in shower and floor plus a skylight, while the second bath is equally stylish with new tiled bathtub/shower. With newer paint throughout and fresh floor coverings, including laminate in the kitchen breakfast area and laundry, this home is move-in ready. Enjoy the comfort of a new HVAC system, ensuring year-round climate control. The glass enclosed sunroom is an ideal retreat for relaxation or entertaining with an attached wood deck allowing you to enjoy the outdoors without the hassle of bugs and grilling outside. Additional perks include a 2-car garage, snow removal, and exterior maintenance, providing you with a low-maintenance lifestyle. Located near a lovely park, this condo is perfect for outdoor enthusiasts and families alike. Don't miss this opportunity to own a meticulously maintained property that blends modern convenience with cozy charm! Schedule your showing today!
MlsNumber: --
ListingId: 22009796


Listing Provided By: Carpenter, REALTORS®, original listing
Phone: (180) 063-0172 x7
Office Phone: (180) 063-0172 x7
Agent Name: Judy Lauziere
Disclaimer: Copyright © 2024 MIBOR Service Corporation. 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