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

307 Amelia Street
Fredericksburg, VA 22401
Evan Sullivan with Coldwell Banker Elite, original listing - (540) 373-0100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,695,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: 9320 Square Feet
Agency: Coldwell Banker Elite
Agency Phone: (540) 373-0100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1834
Notes: CONSTRUCTION ON BRAND NEW 2ND KITCHEN ON MAIN LEVEL HAS BEEN COMPLETED! <br /> Welcome to Smithsonia! This stunning four columned historic landmark located right in the heart of Downtown Fredericksburg is back on the market, and this time with some extremely exciting upgrades! The existing kitchen in the lower level with an exposed wood beam ceiling remains, giving the large home two luxurious kitchens. The existing kitchen is complete with custom cabinetry, a marble topped island and countertops, gas log fireplace, walk-in pantry, an off-kitchen sitting/dining area, a commercial Viking range, Sub Zero refrigerator, wine cooler, dishwasher, microwave, and more! Upstairs, when you are standing in the grand entry way of the home, there is an enormous ballroom perfect for entertaining to the left, and to the right is a formal dining area with a fireplace. Throughout the rest of this 9,000+ SF mansion, you will find six large bedrooms all with their own full bathrooms. The Master suite has an entire extra room as a closet/dressing area with an island, and is also complete with a soaking tub, two more built in closets, his and her sinks, and a glassed-in shower. A 3-car garage with a full gym above it connects to the home through a stunning two-story glass atrium. Downstairs there is a large recreation area perfect for hanging out with the family or entertaining. The home is climate controlled thru a geothermal system which drastically reduces monthly bills. Moving to the exterior, you'll notice a gorgeous fountain on the side of the house, a solarium opposite the fountain, a long pergola separating the driveway and yard, a gazebo in the back, a brick patio and walkways, a brick wall surrounding the whole home, and stunning landscaping! Other features include an elevator that services three levels, five fireplaces, the original staircase, custom trim, wood floors, tall ceilings, window shutters, a soon-to-be installed electric gate to the driveway, and much more. Only a few blocks from all of Fredericksburg's plethora of dining and shopping amenities. Come see everything this house has to offer today!
MlsNumber: --
ListingId: VAFB2006412


Listing Provided By: Coldwell Banker Elite, original listing
Phone: (540) 373-0100
Office Phone: (540) 373-0100
Agent Name: Evan Sullivan
Disclaimer: Copyright © 2024 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 = 2911 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 Linda Toppin
Linda Toppin
ASCIICTI Real Estate 415 Wolfe st. Fredericksburg VA, 22401 Dowtin Realty 1995 North ParkPlace SE, Atlanta. 30339
Call Today!: (540) 226-2045

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App