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

408 S 4th Street
Lake City, PA 16423
David Nguyen with Cavalry Realty, LLC, original listing - (717) 574-4012

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $85,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1056 Square Feet
Agency: Cavalry Realty, LLC
Agency Phone: (717) 574-4012

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Manufactured Home
Year Built: 2023
Notes: !!!Seller Finance/Installment Sale/Lease Purchase/Rent-to-Own is available for a qualified buyer!!! Mobile home is located at Country Gardens Mobile Home Park, Lake City, PA. Single-wide home 16' x 66', 3 bedrooms, 2 bath, 1056 sq. ft. for Owner Occupied Buyer. Brand new mobile home features with stainless steel appliances such as refrigerator, dishwasher, range/oven, kitchen hood exhaust to exterior, double kitchen sinks with window for more daylight, recessed lights in kitchen, wood look laminated flooring through out, window treatments, bath1 with window, bath2 with sidelight window above bathtub, gas furnace, wash/dryer hookup ready. Home cannot be moved out of the community. Lot rent $385/month, tenant pays water/sewer which is $45/month, tenant to pay for trash directly with township, buyer is responsible for property taxes and homeowner insurance. Buyer must be approved by community before purchasing!! Please text 717-203-seven six seven six for any showing. No sign on property. Move-in requirements: Each resident 18 year of age or older must fill out an application and be approved by the community. Application at gomobilerealty dot com. Be sure to look at Country Gardens Mobile Home Park Disclosure of Rent, Fees and Rules and Regulations. Content is reliable but not guaranteed and should be independently verified. Listing agent has a financial interest. Call or Text listing agent for all showing. Note: Home is also available for rent $1,350/month.
MlsNumber: --
ListingId: PAER2000098


Listing Provided By: Cavalry Realty, LLC, original listing
Phone: (717) 574-4012
Office Phone: (717) 574-4012
Agent Name: David Nguyen
Disclaimer: Copyright © 2024 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