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

2420 Cr-15a
Canaseraga, NY 14822

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $435,000
Beds: 4
Baths: 2
Status: Active
SqFt: 4244
Agency: Empire Realty Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential
Year Built: 1890
Notes: Breathtaking scenery surrounds you at this of a kind compound! 4000 sq. ft. farmhouse completely updated & overbuilt! Gorgeous maple floors, coal & wood stoves w/detailed stonework, knotty pine ceilings, chefs' kitchen w/high-end stainless-steel appliances, custom hickory cabinets, & slate countertops & flooring! Spectacular 2nd floor living room w/unique custom windows & deck w/staircase to ground level, cathedral pine ceilings, washer & dryer closet, master suite w/rustic exposed beams, spacious closet, & private deck, master bathroom w/jacuzzi tub & shower, hallway office, stairs leading to 3rd floor exposed open loft, two staircases to 1st level, & another bedroom! Massive fenced in yard w/storage building & covered lean to, covered deck for entertaining, 2 car garage w/concrete floors, 46X32 shop w/5000lb lift & Kalamazoo wood stove, huge barn w/tons of inside/outside covered storage, solar panel & windmill system, & diesel-powered generator with 200-gallon tank. This property would be a dream wedding venue, AIRBNB, or family trip destination with tons of space to build another structure or park RV's & Campers! Additional property available see listings R1531593 & R153192.
MlsNumber: R1531591


Listing Provided By: Empire Realty Group, original listing
Name: Empire Realty Group
Phone: (585) 746-9196
Office Name: Empire Realty Group
Office Phone: (585) 204-2440
Agent Name: Bridgett C. Hoag
Disclaimer: Copyright © 2024 Upstate New York Real Estate Information Services LLC (Rochester). 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