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

253 Indian Banks Road
Farnham, VA 22460

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,000
Beds: 3
Baths: 1
Status: Active
SqFt: 1676
Agency: Shaheen, Ruth, Martin & Fonville

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1977
Notes: Charming waterfront cottage on Morattico Creek just off the Rappahannock River located in Farnham on the border of Richmond and Lancaster Counties. This three-bedroom, one bathroom cottage is ideal for full or part-time families. Completely renovated in 2014 featuring spacious Creek Room with fireplace overlooking wide water views with sliding door access to patio and waterfront. Decorative barn door entry to lovely kitchen featuring new cabinetry, granite counter tops, glass tile backsplash & stainless-steel appliances. Plus, a waterfront dining area for entertaining family with wide water views. Located on 1.49 ample acres on protected Morattico Creek with close proximity to nearby Marina with fuel. Morattico & Lancaster Creeks surround the Simonson Peninsula, where the Public Boat launch is located just minutes from your dock. HVAC 2019, Painted 2023, Rinnai Tankless Water Heater located in laundry closet, & Broadband Internet. Venture waterside to Dock w/ L-Head, 10,000lb Boat Lift & Mooring Slip w/ 4' MLW. Great for all boating enthusiasts! Anglers will enjoy some of the best fishing on the Rappahannock River & Chesapeake Bay, plus Oysters & Blue Crabs for some of the best seafood in Virginia. Quick motorboat ride to the Rappahannock River & approximately 45 minutes to the Chesapeake Bay. Only 20 minutes to Warsaw & 25 minutes to Tappahannock. And, only 30 minutes to Kilmarnock for shopping, restaurants & Main St charm. Relax on the patio, swing in the hammock & play games in the spacious yard. No HOA, so STR potential. Come, Relax & Make Cherished Family Memories!
MlsNumber: 115894


Listing Provided By: Shaheen, Ruth, Martin & Fonville, original listing
Name: Shaheen, Ruth, Martin & Fonville
Phone: (804) 288-2100
Office Name: Shaheen,Ruth, Martin & Fonville Real Estate
Office Phone: (804) 288-2100
Agent Name: Travis Powell
Disclaimer: Copyright © 2024 Northern Neck Association 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