Title Page Background
DEBUG FN args: Array ( [0] => 2911 [1] => [2] => [3] => agent ) BEFORE: Site: 2911 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2911 Igate: njhud LocID: 2911 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2911 [1] => [2] => [3] => lender ) BEFORE: Site: 2911 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2911 Igate: njhud LocID: 2911 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2911 [1] => [2] => [3] => other ) BEFORE: Site: 2911 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2911 Igate: njhud LocID: 2911 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1111 Sophia Street
Fredericksburg, VA 22401
Alex Belcher with Belcher Real Estate, LLC., original listing - (540) 300-9669

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,850,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3320 Square Feet
Agency: Belcher Real Estate, LLC.
Agency Phone: (540) 300-9669

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: WATERFRONT LUXURY HOME W/ 3,300+ FINISHED SQFT OF BEAUTY FROM END TO END! SITUATED ON THE BANKS OF THE RAPPAHANNOCK ON SOPHIA ST, A SHORT WALKING DISTANCE TO HISTORIC DOWNTOWN FREDERICKSBURG'S PLETHORA OF SHOPPING & DINING AMENITIES! ENTER THE MASSIVE DRIVEWAY MULTI-CAR GARAGE & A HUGE COVERED PATIO W/ RECESSED LIGHTING/OPTIONAL ADDITIONAL OFF-STREET PARKING! THE EXTERIOR BOASTS TREMENDOUS CHARACTER W/ A BEAUTIFUL STANDING SEAM METAL ROOF, HARDIPLANK SIDING, & CUSTOM BRICKWORK ON THE FRONT & REAR! ENJOY AN UPGRADED OUTDOOR RELAXATION EXPERIENCE W/ A LARGE COVERED FRONT PORCH, A MASSIVE REAR DECK & PRIVATE BALCONY OFF THE UPPER-LEVEL OWNER'S SUITE, UNOBSTRUCTED VIEWS OF THE RIVER & HISTORIC CHATHAM MANOR PERCHED ON THE HILL! INSIDE THE GARAGE, YOU WILL HAVE ACCESS TO AN INTERIOR ELEVATOR THAT GOES TO THE UPPER LEVEL! THROUGH THE DOOR, YOU ARE GREETED WITH/ AN ABUNDANCE OF NATURAL LIGHTING FROM NEARLY 70 WINDOWS PROVIDING SPLENDID VIEWS VIRTUALLY ANYWHERE IN THE HOME! OFF THE FOYER THROUGH A SET OF FRENCH DOORS SITS A LARGE MAIN LEVEL BEDROOM/OPTIONAL STUDY W/ A TRAY CEILING, CEILING FAN & RECESSED LIGHTING, WALK-IN CLOSET & FULL BATH W/ A FRAMELESS SHOWER W/ CUSTOM TILING & QUARTZ VANITY! DOWN THE HALL TO THE MAIN LIVING AREA, ELEGANT CROWN MOULDING & TRIM ARE CARRIED THROUGHOUT, ARRIVING TO THE MAIN LEVEL ELEVATOR ACCESS AS WELL AS A CONVENIENT HALF BATH! ON THE REAR OF THE HOME, THE EXTRAORDINARY OPEN FLOOR PLAN OPENS UP TO THE BREATHTAKING RIVER VIEWS, MAKING INDOOR ENTERTAINING SOMETHING TO LOOK FORWARD TO YEAR-ROUND! MAGNIFICENT GOURMET KITCHEN IS A TRUE CHEF'S DELIGHT W/ EXQUISITE QUARTZ COUNTERTOPS & A LARGE CENTER ISLAND & BREAKFAST BAR, HIGH-END KITCHEN-AID APPLIANCES, DOUBLE BOWL FARMHOUSE SINK W/ GOURMET FAUCET, UPGRADED CABINETRY W/ BLACK MODERN PULLS, WHITE SUBWAY TILE BACKSPLASH, W/ A COMBINATION OF RECESSED & PENDANT LIGHTING! LARGE DINING RM W/ PLENTY OF SPACE FOR DINNER PARTIES TO COME! A FANTASTIC LIVING RM COMPLETES THE MAIN LIVING SPACE W/ A DELIGHTFUL COFFERED CEILING, RECESSED LIGHTING & AN OVERSIZED CEILING FAN, IN ADDITION TO THE SLIDING GLASS DOORS TO THE REAR DECK & MULTITUDE OF WINDOWS THROUGHOUT, LETTING THAT SPRING & FALL BREEZE FLOW THROUGH ON A SUNNY DAY! THE CROWN MOULDING & CUSTOM TRIM ARE CONTINUED FROM THE MAIN LEVEL ENTRY TO THE UPPER-LEVEL HALL, WHERE YOU WILL ALSO FIND THE UPPER-LEVEL ELEVATOR ACCESS & LAUNDRY ROOM! START YOUR DAY OFF W/ A VIEW FROM THE OWNER'S SUITE, STEPPING OUT OF BED & ONTO YOUR PRIVATE BALCONY LOOKING OUT OVER THE RAPPAHANNOCK OR FROM INSIDE W/ THE PANORAMIC WINDOW VIEWS, RECESSED LIGHTING, DUAL CEILING FANS & A HUGE WALK-IN CLOSET WITH CUSTOM BUILT-IN STORAGE! MOVING INTO THE LUXURY ENSUITE, QUARTZ DBL VANITIES, MASSIVE WALK-IN SHOWER W/ FRAMELESS GLASS DOOR, RAIN SHOWER & SEPARATE MODERN SOAKING TUB, RECESSED LIGHTING & CUSTOM TILING, PRIVATE WATER CLOSET & BEAUTIFUL CERAMIC TILE FLOORING! FINISHING OFF THE UPPER LEVEL, A SPACIOUS BONUS AREA & THE REMAINING BEDROOMS W/ WALK-IN CLOSETS & BOTH W/ ATTACHED FULL BATHS THAT BOAST CUSTOM TILING IN THE SHOWER & CERAMIC TILE FLOORING! DO NOT MISS THIS INCREDIBLY RARE OPPORTUNITY IN DOWNTOWN FREDERICKSBURG!
MlsNumber: --
ListingId: VAFB2008132


Listing Provided By: Belcher Real Estate, LLC., original listing
Phone: (540) 300-9669
Office Phone: (540) 300-9669
Agent Name: Alex Belcher
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => spotsylvania [3] => VA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: spotsylvania State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: spotsylvania State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Sheli Schneider
Sheli Schneider
ASCIISAMSON PROPERTIES - Locust Grove
Call Today!: (540) 760-6325

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App