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

5708 Fountain View Drive
Wheatfield, IN 46392
Lisa Herma with RE/MAX Executives, original listing - (219) 987-2230

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $829,900
Beds: 3
Baths: Full: 2, ¾: 1
Status: Active
SqFt: 3808 Square Feet
Agency: RE/MAX Executives
Agency Phone: (219) 987-2230

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 2015
Notes: Discover a rare opportunity to own this STUNNING high-end condominium, ideally situated on the 18th Hole on Sandy Pines Golf Course! Golfers' Choice Ranked #12 for the Top 50 Best Public Golf Courses! Designed for those who appreciate the finer things in life, this residence offers panoramic views of lush greens and fairways, providing an unparalleled sense of tranquility. Step inside to find expansive, open-concept living spaces, expertly crafted with premium finishes and CUSTOM UPGRADES throughout, soaring ceilings, and an abundance of windows that provide a generous amount of natural light. The gourmet kitchen is a chef's dream, featuring top of the line appliances, custom cabinetry, quartz counter tops, breakfast bar, and pantry. It will surely be a favorite spot for entertaining guests! No expense was spared in all 3 spa-inspired bathrooms. The main bedroom is expansive, has a large walk-in closet, and exquisite adjoining bath with oversized jetted tub, beautiful custom shower, and custom cabinets. The 2nd spacious main floor bedroom also offers a walk-in closet. The fully finished basement is an ideal space for entertainment, relaxation, or recreation. It offers a handsome wet bar with custom cabinetry, leathered granite counter tops, microwave, and 2 beverage refrigerators. The home gym provides rubber flooring and a ballet bar. To round out the living space in the lower level is a 3rd bedroom, stunning bathroom, office with drafting table, and a small library that includes wine storage. With spacious living areas, luxurious bedrooms, spa-inspired bathrooms, this home offers the ultimate in comfort and style! Enjoy seamless indoor-outdoor living with the 3 Seasons Room, expansive patio area that provide sweeping views of the golf course, perfect for unwinding after a day on the greens! Just a short golf cart ride to the clubhouse and driving range and for those traveling from Chicago, it's just over an hour drive from the Loop.
MlsNumber: --
ListingId: 816600


Listing Provided By: RE/MAX Executives, original listing
Phone: (219) 987-2230
Office Phone: (219) 987-2230
Agent Name: Lisa Herma
Disclaimer: Copyright © 2025 Greater Northwest 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