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','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 = 2868 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 = 2868 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;

526 River Bluff Ln
King & Queen, VA 23085
Paige Adams with Innsbrook, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $579,950
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: Innsbrook
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Your Waterfront Paradise Awaits! Welcome to your dream home-a stunning newly built (2023) waterfront ranch nestled on 2.25 private acres in picturesque King & Queen County! This open-concept 3-bed, 2-bath beauty boasts breathtaking water views, modern finishes, and a seamless blend of indoor-outdoor living. Step inside to find vaulted ceilings, a kitchen with quartz countertops, stainless steel appliances, gas range, and a spacious island perfect for entertaining. Cozy up by the gas fireplace in the living room, creating a warm and inviting atmosphere. The primary suite is a true retreat with a walk in closet, spa-like en-suite bath, featuring a luxurious walk-in shower, dual vanities, and a built-in Bluetooth speaker so you can enjoy your favorite tunes while you unwind. Large windows flood the home with natural light, highlighting the stylish LVP flooring and details throughout. Enjoy mornings on your back deck and patio overlooking the tranquil water, afternoons fishing or kayaking, and evenings taking in the peace and privacy of your expansive property. With high-speed internet already wired, this is the perfect blend of luxury and nature, just waiting for you to call it home! For energy efficiency this home also offers a tankless hot water heater and a generac generator plug has been wired in for those who may want to invest in a generator. This property also includes the perks of a well-appointed HOA that offers exclusive private river access! Residents have access to a boat ramp, pier, and a charming common area beach, perfect for launching kayaks, fishing, or simply soaking in the serene waterfront views. Whether you're looking for adventure on the water or a peaceful retreat by the shore, this community provides the ideal balance of recreation and relaxation! Don't miss this rare gem, schedule your private showing today!
MlsNumber: --
ListingId: 2506531


Listing Provided By: Innsbrook, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Paige Adams
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