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

105 Water Street
Cassville, PA 16623
Jeanie Sipes with Palmer Realty, original listing - (717) 485-5539

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $489,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3000 Square Feet
Agency: Palmer Realty
Agency Phone: (717) 485-5539

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: Step inside to see all this home has to offer. It doesn't get any better than this, the seller has thought of it all. Many upgrades to the property w/ various options and versatility type features for various uses! A spotless spacious open floor plan both upstairs and downstairs w/ finished walk in basement, Upstairs and lower back porch areas and pavilion in backyard to enjoy the beautiful landscaping views for entertaining guests, recreational games such as corn hole, yard Yahtzee, etc. Large attached double bay garage. Fully equipped kitchen, dining area , living room, 3 bedrooms and bath. Dimmer switches in main living areas w/ceiling fans in the bedrooms add to the cozy atmosphere of the home . Laundry on the main level. Lower level has it's own living space as well.. Kitchen with dining area and full bath. Day bed and sofa provide additional sleeping for guests. Property was used as a vacation home rental listed on both VRBO platforms. A MUST SEE BACKYARD PAVILION! It was a stone fireplace, sitting wall, covered area attached w/built in cabinets and countertop w/plenty of seating and storage with beautiful views of the landscaping and back yard area! Portable fire pit included w/seating area just for that, right by the pavilion can be set up or not and then it's just landscaping, very versatile! Stream runs through the backyard and there is an area for pond potential. Additional parking lot located diagonal the house used for extra parking for guests, boats, trailers, large work trucks, etc. This property can be kept as an established Airbnb or VRBO vacation home rental or live in it yourself and make it your home. Security cameras convey with the sale. This beautiful home and property is located near Trough Creek State Park and Lake Raystown Resort ,State Game lands nearby and a great central location w/many conveniences nearby! What's not to like? It's your move and we have just the home for you. All buyers must be pre approved for showings
MlsNumber: --
ListingId: PAHU2023386


Listing Provided By: Palmer Realty, original listing
Phone: (717) 485-5539
Office Phone: (717) 485-5539
Agent Name: Jeanie Sipes
Disclaimer: Copyright © 2025 Bright 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