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

496 Lacomb Road
Norfolk, NY 13667

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,000
Beds: 4
Baths: 5
Status: Active
SqFt: 2800
Agency: Dufrane Real Estate, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1993
Notes: WOW WOW WOW!!! That is all I can say after seeing this great property! And I know you will too! The updates to this home are endless! Every square inch of this home has been updated. The open layout of the kitchen (plus newer appliances) into a massive dining room is where you'll want to have guests come and hang out! It's also open to the living room which is a great size! Down the hall, there are 3 bedrooms and 2 full bathrooms which have just recently been completely remodeled with new showers and vanities. One of the bedrooms is an en-suite with your bathroom and 3 large closets for all your clothes. The second bedroom has a custom "tree house" which I know littles would LOVE to play with! This room also has a walk-in closet! This home has a full basement that is partially finished. There is a second living room with an electric fireplace, a large bedroom en-suite (with an Egress window) that has a full new bathroom, and a small den/room. There is a huge storage area and utility area as well. There is a dry basement with two sub pumps and a new, extra drainage system, a new furnace, new central air, new water heater, new roof, and all new interior doors, did I mention they redid everything??! I have not even started yet! There is an attached garage right off your mudroom/laundry area, a massive newer garage that can fit a large RV with a plug-in, and two more outbuildings for every single toy you could need! But wait! I saved the best for last! This home also has a large section completely fenced in and also has an INDOOR SWIMMING POOL! The pool area has extra safety measures in place which include a code lock on the door and, a safety cover that can be walked on but has a lock on it as well. All inside a great room that also has a lot of updates. The floor is freshly painted, and a new sitting sunroom off the back overlooks a new deck and firepit. There is also a covered space for your grill in the backyard! With 38 acres with this property, I can't even begin to tell you the possibilities this listing has for a buyer. The land has tons of maple trees that are currently hooked up to a sugar shack that is located on an attached property that is also for sale! Call today for this unbelievable find before you lose out on your dream of living in the country and having everything you could ever dream of!
MlsNumber: 49648


Listing Provided By: Dufrane Real Estate, LLC, original listing
Name: Dufrane Real Estate, LLC
Phone: (315) 769-2446
Office Name: Dufrane Real Estate, LLC
Office Phone: (315) 769-2446
Agent Name: Angela Frost
Disclaimer: Copyright © 2024 St. Lawrence Board 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