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

120 Blaisdell Lane
Fredericksburg, VA 22405
Michelle Wilson with CENTURY 21 New Millennium, original listing - (540) 373-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,175,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5411 Square Feet
Agency: CENTURY 21 New Millennium
Agency Phone: (540) 373-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Discover unparalleled luxury at this extraordinary Rappahannock River estate, nestled within nearly 4 acres of private sanctuary. Crafted by award-winning architect William Poole, this stunning residence offers over 7,000 square feet of opulent living space, highlighted by exceptionally large rooms and custom features at every turn.<br /> <br /> Step inside to find 10-foot ceilings on the main floor, creating an airy and inviting atmosphere, complemented by two cozy gas fireplaces. Two first-floor master suites provide breathtaking river views and unparalleled convenience. The interior is adorned with built-in bookcases in the study, family room, and living room, showcasing extensive millwork, including triple crown molding, chair rail, and oversized casing.<br /> <br /> The estate features a spacious two-car garage, a full basement, and a separate workshop, providing ample room for storage, expansion, or hobbies. Upstairs, you'll find a third master suite along with two additional bedrooms—one with an en-suite bath—each designed with spectacular water views.<br /> <br /> The open kitchen floor plan is perfect for entertaining, featuring a large eat-in area, a walk-in pantry, and a peninsula island equipped with a separate sink. Black stainless appliances accent the abundant custom granite counters, while tile floors, solid oak staircases, and hardwood complement the home’s comfortable interior.<br /> <br /> Crafted for low maintenance, the all-brick exterior, lifetime roof, and flip-clean gutters allow you to relish in a serene waterfront lifestyle. Architectural details such as bullnose tread on the exterior brick steps, bonded jack arches over the windows, and brick quoins on the facade enhance the home's timeless appeal.<br /> <br /> Designed with energy efficiency in mind, the estate includes Anderson windows and doors, four separate HVAC systems, and four distinct zones, ensuring comfort throughout the year. Enjoy the conveniences of town living with amenities like high-speed internet and cable TV while basking in the privacy of this enchanting homesite.<br /> <br /> Entertainment options abound on the brick terrace overlooking the historic Rappahannock River and the scenic John Warner Rapids, with opportunities for fishing, canoeing, and kayaking on the longest free-flowing river on the East Coast.
MlsNumber: --
ListingId: VAST2037582


Listing Provided By: CENTURY 21 New Millennium, original listing
Phone: (703) 753-7910
Office Phone: (540) 373-2000
Agent Name: Michelle Wilson
Disclaimer: Copyright © 2025 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 2912 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;
Real Estate Expert Photo for Jennifer Leinberger, Realtor, PSA, ABR, SRS, MRP, VA Lic#0225244071
Jennifer Leinberger, Realtor, PSA, ABR, SRS, MRP, VA Lic#0225244071
ASCIIColdwell Banker Elite
Call Today!: (301) 643-3323

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App