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

212 W Water Street
Paoli, IN 47454
Arla Frazier with F.C. Tucker Company, original listing - (317) 888-3311

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1371 Square Feet
Agency: F.C. Tucker Company
Agency Phone: (317) 888-3311

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: STUNNING NEW CONSTRUCTION IN THE HEART OF PAOLI * HONEY STOP THE CAR CURB APPEAL WHITE & BLACK FARMHOUSE STYLE FEATURING BOARD & BATTEN SIDING, BLACK JELD-WEN WINDOWS, EXPANSIVE FRONT PORCH & WOOD GABLE ACCENT * 3-BED SPLIT FLOOR PLAN + 2 FULL BA * 1371 SF * QUALITY CONSTRUCTION & FINISHES THROUGHOUT * WALKING DISTANCE TO HISTORIC PAOLI TOWN SQ, LIBRARY, SENIOR CENTER & RESTAURANTS * WELCOME IN TO THE CHARM & APPEAL OF LVP FLOORING & NEUTRAL WARM WALL COLOR + CATHEDRAL CEILING THAT ELEVATE THE FEEL OF THE L/R & KITCHEN * CHEF'S DREAM KITCHEN IS ABSOLUTE PERFECTION FEATURING WHITE CABINETS, CENTER ISLAND W/BREAKFAST BAR, S/S FARM SINK, BUTCHER BLOCK COUNTERS & S/S APPLIANCES * 14X13 OWNER'S ENSUITE W/I CLOSET & ATTACHED FULL BATH DOUBLE VANITY & W/I SHOWER * ALL BEDROOM CEILING LIGHTS ARE FAN READY * SEPARATE LAUNDRY/MECHANICAL ROOM * SEPARATE MUDROOM W/HUGE PANTRY CLOSET * EXPAND YOUR LIVING SPACE ON THE 24X12 COVERED BACK PATIO * FINAL PUNCH LIST ITEMS UNDER WAY * GRAVEL DRIVEWAY TO BE ADDED & YARD TO BE GRADED & SEEDED * READY FOR IMMEDIATE POSSESSION * SELLER TO TRANSFER ALL MANUFACTURER WARRANTIES TO BUYER @ CLOSING * BUYER INSPECTIONS WELCOME * ONE LOOK AND YOU WILL WANT TO CALL THIS HOME!
MlsNumber: --
ListingId: 202505537


Listing Provided By: F.C. Tucker Company, original listing
Phone: (317) 908-4050
Office Phone: (317) 888-3311
Agent Name: Arla Frazier
Disclaimer: Copyright © 2025 Southern Indiana REALTORS Association. 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