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

13390 County Highway 23
Unadilla, NY 13849
Edward Heflin with EAST COAST NEW YORK INC, original listing - (718) 428-2900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $550,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1904 Square Feet
Agency: EAST COAST NEW YORK INC
Agency Phone: (917) 974-0992

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 82 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1880
Notes: Welcome to a world where charm and modern amenities unite, a timeless 4-bedroom, 2-bathroom farmhouse nestled on a vast 82 acres of organic farmland and cattle ranch. This remarkable property offers an unparalleled blend of rustic charm, modern amenities, and the potential for a thriving agricultural lifestyle. Home Features: Country Kitchen: Embrace the heart of the home with solid surface countertops and a spacious walk-in pantry. Elegant Flooring: Enjoy the beauty and durability of hardwood and laminate flooring throughout. Cozy Fireplace: Warm up on chilly evenings by the inviting fireplace. Handicap-Accessible Bathroom: Thoughtfully designed for accessibility. Luxurious Hot Tub: Relax and unwind in the hot tub on the large back deck. Versatile Heating Systems: Stay comfortable with forced air, stove, oil, and wood/pellet heating options. Recent Renovations: Updated Electrical System: Modernized for convenience and safety. New Well Pump & Fiberglass Pressure Tank: Ensuring a reliable and efficient water supply. Whole Farm Backup Generator: Hard-wired to provide seamless power to the entire property. Remodeled Kitchen & Dining Room: Beautifully upgraded spaces ideal for family gatherings. Outdoor Paradise: 82 Acres of Organic Land: Perfect for growing crops, grazing cattle, or simply enjoying the expansive green space. Cattle Ranching Facilities: Includes infrastructure for raising and managing cattle. Scenic Views: Immerse yourself in the breathtaking beauty of the surrounding landscape. Partial Basement: Offers additional space for storage or a cozy retreat. Lifestyle & Location: Located in the picturesque town of Unadilla, NY, this farmhouse offers a serene escape from city life while still providing modern conveniences. Whether you're looking to embark on an organic farming venture, raise cattle, or simply enjoy a peaceful rural retreat, this property is your dream come true.
MlsNumber: --
ListingId: 11428770


Listing Provided By: EAST COAST NEW YORK INC, original listing
Phone: (646) 625-9565
Office Phone: (718) 428-2900
Agent Name: Edward Heflin
Disclaimer: Copyright © 2025 My State MLS. 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