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

12859 S Scottsdale Drive
Haubstadt, IN 47639
John Czoer with FIRST CLASS REALTY, original listing - (812) 475-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,888
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 4375 Square Feet
Agency: FIRST CLASS REALTY
Agency Phone: (812) 475-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1983
Notes: This beautifully remodeled 4-bedroom, 4-bath brick ranch with a walkout basement and 1.85-acre lot sits on a beautiful 10-acre lake. You’ll love the flexibility of the main level, the front room with French doors and a walk-in closet, ideal for a home office, and a living room with a warm fireplace, built-in bookcases, and engineered hardwood flooring. The kitchen is perfect for cooking and gathering, featuring a large island, stainless steel appliances, tile backsplash, and plenty of cabinets, all connected to a spacious dining room. Off the kitchen, the sunroom is a cozy spot to relax and soak in the gorgeous views. The primary suite is a true retreat with beautiful lake views, a spa-like bath featuring a walk-in tile shower, double vanity, and walk-in closet. Two other bedrooms on the main level share a remodeled hall bath with a tub/shower combo, a tile surround, and a modern vanity. The walkout basement is designed for fun and entertaining! It features a stylish wet bar with granite countertops, LED display shelves, plus a spacious family room with a stone fireplace that opens to a covered patio by the lake. There’s even a recreation room (currently used as a home gym), a workshop, tons of storage, a full bath, 4th room (used as a bedroom) and a 3rd bay garage that fits all your toys. Outside, this 1.85-acre lot is set up for relaxation and fun. You’ll enjoy a sandy beach, a detachable dock, patios, beautiful landscaping, and a circular driveway. The sprinkler system keeps the yard looking great, too! Located on the Gibson/Vanderburgh County line, you’re just minutes from Toyota & Evansville’s amenities. Recent updates include a furnace and A/C (2019), roof (2017), hybrid 80-gallon water heater, fresh paint, newer appliances, engineered hardwood, and all updated bathrooms (3 with tile showers). If you’ve been dreaming of lake living, this is your chance.
MlsNumber: --
ListingId: 202445420


Listing Provided By: FIRST CLASS REALTY, original listing
Phone: (812) 457-1432
Office Phone: (812) 475-2000
Agent Name: John Czoer
Disclaimer: Copyright © 2024 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.


Local Real Estate Expert

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 = 727 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;
Brandon Hodgson
ASCIIDHI Realty Inc.
Call Today!: (618) 263-8622

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App