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;

155 Shellfield Rd
Dunnsville, VA 22454
John K Thiel with Grove, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,275,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: Grove
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Welcome to this Luxurious Waterfront Retreat on the Rappahannock with breathtaking views sitting on an acre lot with a private beach. This home is already permitted at Essex county as a short term rental and has a successful rental history. Being sold fully furnished this is truly a turn key opportunity for your family retreat and/or short term rental investment. This beautiful home was built in 2022 and features 3,151 SF, 4 bedrooms and 3 full baths. The minute you step inside you'll see that no expense was spared. The first floor offers a huge family room open to the Gourmet kitchen with Quartz tops, two ovens, a full-size refrigerator & freezer, large island with breakfast bar and tons of cabinet & counter space. The main level owner's suite includes LVP floors, custom trim, walk in closet and an en-suite spa-like bath with double vanity, soaking tub and separate tiled shower. Bedrooms two and three are also on the main level at the other end of the home both with LVP flooring, large closets and a shared full hall bath. Head up to the second floor to find a spacious rec room with 4 built-in twin XL beds, two arcade machines and a comfortable spot to relax and watch TV. Also upstairs is the 3rd full bath and the 4th bedroom. There is over 1,800 square feet of concrete under the house that can be used for a break from the sun or a great place to hang out on a rainy day. It's the perfect place to pick crabs, shuck oysters or play games. This space could also be converted into an additional outdoor living space or garage. The dock is practically brand new with electricity, running water, remote control boat lift and additional mooring poles. The pilings are ready for a roof if desired. Other features include an amazing screened porch, outdoor shower, concrete basketball court with commercial basketball goal, concrete patio with fire pit and a gas grill both fed by a large propane tank with dedicated lines and timers. There are also 2 groins on either end of the beach to contain and catch sand. This is a must see!!
MlsNumber: --
ListingId: 2500512


Listing Provided By: Grove, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: John K Thiel
Disclaimer: Copyright © 2025 Long & Foster Real Estate. 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