Title Page Background
DEBUG FN args: Array ( [0] => 1824 [1] => [2] => [3] => agent ) BEFORE: Site: 1824 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1824 Igate: njhud LocID: 1824 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('nwhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1824 [1] => [2] => [3] => lender ) BEFORE: Site: 1824 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1824 Igate: njhud LocID: 1824 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('nwhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1824 [1] => [2] => [3] => other ) BEFORE: Site: 1824 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1824 Igate: njhud LocID: 1824 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('nwhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2556 Meservey Hill Road
Wellsville, NY 14895

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $224,000
Beds: 4
Baths: Full: 2
Status: Pending
SqFt: 1949 Square Feet
Agency: Homestar Realty

Map Details Show Map | Show StreetView




House Features

Appliances: Oven, Range, Refrigerator, Dryer
Architectural Style: New Traditional
Construction Materials: Vinyl Siding, Wood Siding, Frame
Flooring: Carpet, Tile, Vinyl, Hardwood, Tile - Ceramic
Heating: Hot Water
Interior Features: Ceiling Fans, Entrance Foyer, Other, See Remarks, Quartz Counters, Pull Down Attic Stairs, HOME OFFICE, DEN, Separate Formal Dining Room, Separate Formal Living Room
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Exterior Features: See Remarks, Private Yard, Blacktop Driveway
Parking Features: Garage
Other Features: See Remarks
Roof: Shingle, Asphalt

Neighborhood/Schools

Elementary School/District: Wellsville Elementary/Wellsville
Middle/Junior High School/District: /Wellsville
High School/District: Wellsville Senior High/Wellsville
Subvidision Name:

Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1930
Notes: Motivated Seller! Relocating! Truly one of a kind! This very welcoming and well maintained home is situated on a 10 acres parcel of nearly all wooded level land with an extensive network of walking or riding paths/trails through a canopy of trees. A park like clearing near the home provides a great family and friend entertainment area for cookouts, sleepouts, sporting, or relaxing next to the fire pit all located just outside the village line. In traditional farmhouse fashion this home is warm and inviting, beautiful hardwood flooring natural casing and moldings in most areas of the home. Fantastic rear entry with ceramic floors with laundry, a place for all your outerwear and storage a perfect room for an office, media, crafts children's playroom, or perhaps another bedroom. Recently remodeled kitchen captures the the farmhouse style with new cabinets and quartz counters and natural light through the garden window. The formal dining, and living room provide a very spacious area for family. 4 large bedrooms, the primary bedroom offers attached nursery/dressing/sitting room. Large bathroom with dual sinks, bathtub shower, storage, and a water closet.
MlsNumber: --


Listing Provided By: Homestar Realty, original listing
Phone: (585) 593-4444
Office Phone: (585) 593-4444
Agent Name: Lisa C Darling
Disclaimer: Copyright © 2024 Western New York Real Estate Information Services. 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