Save to Favorites
Print
Share
PRICE $797,000 dsIDX morgage calculator
BEDS 5
BATHS 4
HOME SIZE 5,367 sqft
LOT SIZE 37,462 sqft

MULTIPLE OFFERS RECEIVED. PLEASE SUBMIT HIGHEST/BEST OFFERS BY 10am, Friday, May 1, with expiration no sooner than 2pm. THANK YOU. Get into refined waterfront living with this beautiful Waterford Green executive home in the coveted PHM school district. Offering 5 (potentially 6) bedrooms, 4 full baths, and 4 inviting fireplaces, this custom-built residence blends traditional luxury with everyday comfort. Thoughtfully updated throughout, this stately home showcases 9-foot ceilings, intricate architectural detail, and panoramic windows that fill the home with natural light. A spacious, well-appointed kitchen further enhances its functionality and style. The vast walk-out lower level with patio is ideal for a complete entertainment or recreation space, or it can serve as a comfortable guest area featuring a bedroom and full bath. Start your mornings in the four-season sunroom overlooking Greystone Lake or unwind on the full-length deck"”perfect for entertaining or unwinding. The professionally designed landscaping creates a picturesque outdoor setting while adding to the home's elevated curb appeal. The large master suite offers a true retreat with vaulted ceilings, a private balcony overlooking the lake, and a cozy reading nook with its own fireplace, along with ample flex space for a home office or fitness area. Designed for year-round comfort, the home is equipped with dual furnaces, air conditioning units, and water heaters. This is more than a home"”it's a lifestyle, best experienced in person. Review the attached improvements list and schedule your private tour today, because this exquisite listing is all about YOU!

DAYS ON MARKET 0 LAST UPDATED 5/1/2026
TRACT Waterford Green YEAR BUILT 1994
GARAGE SPACES 3.0 COUNTY St. Joseph
STATUS Pending PROPERTY TYPE(S) Single Family

SCHOOLS
School District Penn-Harris-Madison School Corp.
Elementary School Prairie Vista
Jr. High School Schmucker
High School Penn


ADDITIONAL DETAILS
AIR Ceiling Fan(s), Central Air, ENERGY STAR Qualified Equipment
AIR CONDITIONING Yes
APPLIANCES Dishwasher, Disposal, Dryer, Electric Oven, Electric Range, Exhaust Fan, Gas Water Heater, Humidifier, Ice Maker, Microwave, Refrigerator, Washer, Water Heater, Water Softener Owned
BASEMENT Finished, Full, Sump Pump, Walk-Out Access, Yes
CONSTRUCTION Brick, Vinyl Siding
FIREPLACE Yes
GARAGE Attached Garage, Yes
HEAT ENERGY STAR Qualified Equipment, Fireplace Insert, Forced Air, Natural Gas
HOA DUES 400
INTERIOR Built-in Features, Crown Molding, Eat-In Kitchen, Entrance Foyer, Kitchen Island, Natural Woodwork, Stone Counters, Vaulted Ceiling(s), Walk-In Closet(s)
LOT 0.86 acre(s)
LOT DESCRIPTION Landscaped, Level, Waterfront
LOT DIMENSIONS 118x180
PARKING Garage Door Opener, Concrete, Garage, Attached
SEWER Septic Tank
STORIES 2
STYLE Traditional
SUBDIVISION Waterford Green
TAXES 5036
UTILITIES Cable Connected
WATER Private, Well
WATER ACCESS Other
WATERFRONT Yes
WATERFRONT DESCRIPTION Lake
MORTGAGE CALCULATOR
   

TOTAL MONTHLY PAYMENT

0
P
I
*Estimate only
Listed with Diane Bennett, Inspired Homes Indiana, [email protected]
The data relating to real estate for sale on this web site comes in part from the Internet Data exchange (“IDX”) program of the Indiana Regional MLS®. IDX information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.
Copyright© 2026 IRMLS. All rights reserved.
Last Updated On: 5/1/26 10:42 PM PDT
Walk Score provided by walkscore.com

This IDX solution is (c) Diverse Solutions 2026.




 
CONTACT US ABOUT 15246 LONGFORD DRIVE
 / 
We respect your online privacy and will never spam you. By submitting this form with your telephone number you are consenting for Gary Gerardot to contact you even if your name is on a Federal or State "Do not call List".