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

774 Ryefield Road
Mattaponi, VA 23110
Teresa Marie Glidewell with Thrift Realty, LLC, original listing - (804) 843-3500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,950
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4620 Square Feet
Agency: Thrift Realty, LLC
Agency Phone: (804) 843-3500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Other-Single Family Residence
Year Built: 2009
Notes: What a gem nestled in the serene area of Shanghai in King & Queen County! This property is just down the lane of the Waterfence Boat Ramp where you can be on the pristine water of the Mattaponi River in just minutes. Enjoy the beauty and nature of this 6.43 acre property while sipping your coffee and gazing at the Ryefield Creek from the screened porch. This home offers 4 bedrooms with 3 full and 1 half bathroom, the open concept living includes the kitchen, dining and living rooms. There is a main floor primary bedroom with a walk in closet and a 4 piece bathroom which includes a jetted tub (also has a linen closet)! You'll find a Finished Room Over the Garage (FROG) that would be great as a game room or a colossal entertainment space. Let's not forget the second floor has 2 oversized bedrooms w/walk in closets and a full bathroom, and if that's not enough, the basement has 1,350 sqft to enjoy that includes a powder room, bedroom w/walk in closet and a space plumbed for a kitchen! There is a generator hook up with built in transfer switch. The home owners have done the following: hardwood floors, granite, tile backsplash, large single basin kitchen sink, pendent lights, trash/recycle cabinet, tiled floors, washer/dryer pedestal and bathroom pedestal sink! And listen to this- 2 sets of cable for the TVs: one for satellite and one for the antenna! There is a surround sound system and security with multiple cameras and all of it conveys! This home would be perfect for a large or extended family needing space to spread out!!!
MlsNumber: --
ListingId: 2506624


Listing Provided By: Thrift Realty, LLC, original listing
Phone: (804) 514-4296
Office Phone: (804) 843-3500
Agent Name: Teresa Marie Glidewell
Disclaimer: Copyright © 2025 Chesapeake Bay & Rivers 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