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

3218 S County Rd 900 E
Velpen, IN 47590
Andrea White with RE/MAX REVOLUTION, original listing - (812) 664-0845

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,500
Beds: 3
Baths: Full: 2
Status: Pending
SqFt: 3225 Square Feet
Agency: RE/MAX REVOLUTION
Agency Phone: (812) 664-0845

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1982
Notes: Dreams Do Come TRUE: A BEUATIFUL MINI FARM surrounded by farm land in Velpen. Welcome HOME to your private retreat - a beautiful brick with 3 Levels, 3 Bedrooms 2 Bathrooms, a Bonus Room that could be used as a 4th Bedroom in the basement situated on 2.08 acres of perfect peaceful land. Upon entering the front door, you are greeted with a lovely open foyer and a stairway leading upstairs to 2 spacious bedrooms a hallway giant closet -perfect for an upstairs bathroom addition. On the main level you will LOVE that there is a OVERSIZED bedroom with a HUGE Beautiful bathroom including a double sink vanity with lots of drawers and cabinet space, updated flooring and shiplap creating a beautiful design and two pantry closets. The main level offers a living room that has a service window to the stunning recently remodeled kitchen with granite counter tops and backsplash with plenty of cabinets and modern light fixtures Including: Stainless steel appliance; Refrigerator, range-electric & Microwave. The kitchen has an area for the dining table with an amazing view out the patio doors to the deck overseeing the back yard. Off the kitchen is the laundry room that is conveniently located between the kitchen and two car garage. A FULLY FINISHED BASEMENT with a HUGE Rec Room or Family Room that is plumbed for a kitchenette, wood burning stove, full restroom, and another room that could be used as an additional 4th bedroom with closet. This home is perfect with a walk-out basement. OUTSIDE you will be impressed with a HUGE Beautiful DECK overlooking the 2.08 acres, the pool, chicken coop, barn for horses or animals. FIBER WIFI and a NEW AC Unit. 2 Parcels totaling to 2.08 acres
MlsNumber: --
ListingId: 202518703


Listing Provided By: RE/MAX REVOLUTION, original listing
Phone: (812) 664-0845
Office Phone: (812) 664-0845
Agent Name: Andrea White
Disclaimer: Copyright © 2025 Southwest Indiana Association of Realtors. 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