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

348 Indiana Avenue
English, IN 47118

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $185,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1500
Agency: Paulin Advantage, LLC dba REMAX Advantage

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: Welcome to 348 Indiana Ave, where your dream home awaits! Situated on a spacious half-acre corner lot, this stunning NEW CONSTRUCTION residence offers everything you desire and more. Step inside to discover a thoughtfully designed layout, with all amenities conveniently located on one level spanning an impressive 1,500 square feet. Enjoy the outdoors from the sturdy front and back decks, perfect for relaxing or entertaining. The home boasts a high-end three-tab shingle roof for durability and style. Inside, the kitchen is a chef's delight, featuring a central island, abundant cabinetry, and brand-new appliances. The open-concept eat-in kitchen flows seamlessly into the living room, bathed in natural light throughout. Retreat to the substantial master bedroom, complete with a luxurious master bathroom featuring a garden tub and an enormous walk-in closet an added bonus for your storage needs. The spacious laundry room includes a new washer and dryer, with convenient access to the backyard. This charming home also offers the practicality of being connected to sewer services. With three large bedrooms and two full bathrooms, there's ample space for the whole family. Plus, you'll love the convenience of being just a quarter-mile away from essential amenities such as a grocery store, bank, restaurants, library, and post office. Don't miss out on this incredible opportunity! Call today to schedule your private showing and make this your new home sweet home.
MlsNumber: 202407172


Listing Provided By: Paulin Advantage, LLC dba REMAX Advantage, original listing
Name: Paulin Advantage, LLC dba REMAX Advantage
Phone: (812) 923-7050
Office Name: RE/MAX Advantage
Office Phone: (812) 923-7050
Agent Name: Becky Higgins
Disclaimer: Copyright © 2024 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