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

221 Lands End Rd
Tappahannock, VA 22560
Rachel Douglas with Hometown Realty, original listing - (804) 443-0067

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $989,900
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3170 Square Feet
Agency: Hometown Realty
Agency Phone: (804) 443-0067

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: Discover your dream escape at Island Farm, nestled on the Rappahannock River at the Mouth of Piscataway Creek. This charming 4-bedroom, 3-bath cottage offers the ultimate in relaxation and riverfront living. The main level boasts an open floor plan with a kitchen, dining, and great room perfect for gatherings, complete with stunning river views. A first-floor bedroom and full bath make it accessible for all. Upstairs, the oversized master suite opens to a spacious balcony with panoramic riverfront views, accompanied by two additional bedrooms and a full bath. The third-floor bonus room is ideal for a game room, quiet retreat, or guest accommodations. Step outside to enjoy your private pier, perfect for fishing or boating. Recent upgrades include new lighting, a open porch, updated flooring throughout the first floor, a modern kitchen with LVP, tile backsplash, granite countertops, and more. The property also features a private pier, jet ski lift, fenced yard, two sheds, and a garage for watercraft and storage. Conveniently located minutes from town amenities, shops, restaurants, a marina, golf course, and healthcare facilities. Just 1 hour from Richmond and Fredericksburg, and 1.5 hours from NOVA/DC. This property has also excelled as a short-term rental, earning a 5-star rating and $45,000+ annual revenue with 2025 bookings already in place. Don't miss this opportunity—schedule your showing today! Professional photos coming soon!
MlsNumber: --
ListingId: 118127


Listing Provided By: Hometown Realty, original listing
Phone: (804) 313-5540
Office Phone: (804) 443-0067
Agent Name: Rachel Douglas
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