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

323 2nd Street
Rockport, In, IN 47635
JASON EDDY with FC TUCKER EMGE REALTORS, original listing - (812) 473-0123

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $498,500
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2943 Square Feet
Agency: FC TUCKER EMGE REALTORS
Agency Phone: (812) 473-0123

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1801
Notes: If Walls could Talk!! This 1801 built home is nestle high on a bluff overlooking the Ohio River with so much history inside these walls. 323 2nd street is anall brick home that offers charm and uniqueness throughout. As you step onto the front covered porch you can start your experience. Front door leads you insidethe formal living room with gorgeous hardwood flooring, arched cased doors leading to both the kitchen and formal dining room and a beautiful gas log fireplace.Step into the kitchen and from cooking will feel so good with views like no other. No view obstructed while cooking dinner or doing the dishes. Entertain your guestin the formal dining room that will easily seat 10 people and allow views of the river and the garden spaces. Just off the kitchen is a sunporch the has a gas logfireplace built into the kitchen peninsula. The owner's suite offers hardwood floors, double cedar lined closet and an en-suite with a jetted tub to relax those tiredmuscles. One more guest bedroom and full bathroom complete the main level of this one of kind home. Upstairs could be a kids paradise or a great in-law suite.There is a large bedroom with two closets and then a partition wall separate a large room that has plumbing with a vanity. Down in the walk out basement you havea large family room with the 3rd gas fireplace in the home. Just off this room is a large room that could be used as a great recreation room/office space. There is athird full bathroom and laundry room as well. Step outs back and just let all your worries melt away! Covered patio spaces, hot tub, wysteria, and views like noother. What more could you ask for?
MlsNumber: --
ListingId: 91975


Listing Provided By: FC TUCKER EMGE REALTORS, original listing
Phone: (812) 499-4519
Office Phone: (812) 473-0123
Agent Name: JASON EDDY
Disclaimer: Copyright © 2025 Greater Owensboro Realtor® 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