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 = 1884 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 1884 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 1884 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

454 East Lake Road
Milo, NY 14527
Josef Brodmann with Finger Lakes Realty, original listing - (315) 536-7285

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,349,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1784 Square Feet
Agency: Finger Lakes Realty
Agency Phone: (315) 536-7285

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Charming new build 3-Bedroom, 2.5-Bath House on Beautiful Keuka Lake<br /> <br /> Welcome to your dream lakefront retreat! This gorgeous 3-bedroom, 2.5-bathroom home on the shores of Keuka Lake offers fantastic water views, exceptional living spaces, and the perfect blend of modern amenities and lake lifecharm. Whether you're looking for a year-round residence or a seasonal getaway, this property provides a serene environment for relaxation and enjoyment.<br /> <br /> Key Features:<br /> 3 Spacious Bedrooms: Generously sized rooms with large windows offering stunning lake views. Master suite includes a private bathroom.<br /> Open Concept Living: Expansive open floor plan perfect for entertaining. Enjoy lake views through the many windows.<br /> Gourmet Kitchen: Fully equipped with stainless steel appliances, custom quartz countertops, custom cabinetry, and a center island.<br /> Cozy Family Room: Living area is perfect for movie nights or enjoying the cozy feel of the electric fireplace.<br /> Lakefront: Step right out into your backyard for direct access to 64' of frontage. Enjoy the pristine waters of Keuka Lake, ideal for boating, swimming, and fishing.<br /> Outdoor Living: Patio for entertaining, along with a lawn leading to the water’s edge. Enjoy stunning sunsets and lakefront dining in your own backyard. <br /> 40 ft Dock: Included for easy access to Keuka Lake, whether you’re boating, kayaking, or simply soaking in the serene surroundings. Water is deep enough for most boats at the end of the dock. <br /> Storage Garage: Ample storage space for your toys and outdoor equipment.<br /> Lot: Parking for 3 cars, walk down access, patio, alcove, with town water and sewer. <br /> Additional Features:<br /> Energy-efficient heating and cooling systems to keep the home comfortable year-round.<br /> Low-maintenance landscaping, giving you more time to enjoy the lake.<br /> Located near Penn Yan, wineries, and restaurants, providing endless opportunities for exploration and relaxation.
MlsNumber: --
ListingId: R1579977


Listing Provided By: Finger Lakes Realty, original listing
Phone: (315) 536-7285
Office Phone: (315) 536-7285
Agent Name: Josef Brodmann
Disclaimer: Copyright © 2024 New York State Alliance of MLSs, LLC. 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