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

4700 Devereaux Court
Centreville, VA 20120
Maureen Sheridan with Century 21 Redwood Realty, original listing - (703) 790-1850

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4858 Square Feet
Agency: Century 21 Redwood Realty
Agency Phone: (703) 790-1850

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Open Saturday April 5th from 1 - 3pm and Open Sunday April 6th from 1 - 3pm. Stunning home with over 4800 finished sqft on 3 levels. Absolutely gorgeous lot is on almost 1/2 acre. So many updates to include: 2024 = Driveway resealed. 2023 = Remodeled Primary bathroom, remodeled upstairs hall bathroom and new carpet on upper level. 2022 = New Roof. 2021 = New Furnace/AC in basement. 2020 = Walk-out basement fully finished to include 5th bedroom, 3rd full bath, Theater room, Bar area, Recreation area and LVP flooring. 2020 = New composite deck with outdoor lighting on deck posts and stairs. 2019 = New Furnace/AC in Attic. 2019 = Kitchen updated with quartz counters, stainless steel appliances (except DW), new range hood. 2019 = Updated powder room on main level . 2018 = Wood floors in family room. 2016 = New stone patio, built-in bar and built-in grill area. Whole interior painted within the last 5 years. In-ground sprinkler system.<br /> Main level has 2-story foyer, dual staircase, hardwood floors, separate formal dining room, separate formal living room, office with french doors, 2-story family room off kitchen with gas fireplace, updated powder room (2019). Open Kitchen with quartz counters, stainless steel appliances (except DW), nice size island, breakfast area, double wall ovens, walk-in pantry. Laundry room on main level.<br /> Upper level has walkway with family room overlook, very spacious primary bedroom with large walk-in closet, completely updated primary bathroom (2023), 3 generous sized bedrooms, upstairs hallway bathroom completely updated (2023) and new carpet (2023).<br /> Amazing walk-out basement was fully finished in 2020 to include nice size 5th bedroom with door to back-yard, beautiful 3rd full bath, awesome theater room and wonderful bar area with beautiful custom cabinets, granite counters, dishwasher, sink, wine fridge and TV that conveys. <br /> Gorgeous back-yard on almost 1/2 acre with beautiful stone patio, built-in bar & grill area, large covered gazebo conveys along with the table and chairs under it. Composite deck (new in 2020) off the kitchen has outdoor lighting on posts and stairs, which leads down to stone patio area.<br /> Fantastic location - minutes from Rte 50, Rte 66, Rte 29, Fairfax Connector Metrobus, Stringfellow Park and Ride Lot, Fair Lakes Shopping, Fair Oaks Mall, Restaurants, Library & Schools.
MlsNumber: --
ListingId: VAFX2229576


Listing Provided By: Century 21 Redwood Realty, original listing
Phone: (703) 858-5676
Office Phone: (703) 790-1850
Agent Name: Maureen Sheridan
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 = 3481 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 Harry Hasbun
Harry Hasbun
ASCIIAlready Home Real Estate Group
Call Today!: (703) 898-5507

Local Mortgage Pro

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 = 3481 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;
Heritage Financial, Inc.
Call Today!: (410) 224-7250

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App