Title Page Background
DEBUG FN args: Array ( [0] => 2873 [1] => [2] => [3] => agent ) BEFORE: Site: 2873 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2873 Igate: njhud LocID: 2873 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 = 2873 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2873 [1] => [2] => [3] => lender ) BEFORE: Site: 2873 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2873 Igate: njhud LocID: 2873 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 = 2873 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2873 [1] => [2] => [3] => other ) BEFORE: Site: 2873 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2873 Igate: njhud LocID: 2873 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 = 2873 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

45932 Pullman Court
Sterling, VA 20164
Rheema Ziadeh with Redfin Corporation, original listing - (703) 665-6665

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Pending
SqFt: 4911 Square Feet
Agency: Redfin Corporation
Agency Phone: (703) 665-6665

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Welcome Home! This remarkable nearly 5000 square feet brick front single family estate situated on desirable lot in charming Lochewood Manor community. This home has had over $200,000 of Upgrades and Updates in recent years. Including: Fully renovated and remodeled Lower Level; Backyard full renovation to include new Patio, Pergola, Staircase storage and more; Professional landscaping; Three HVAC units replaced in 2024 and 1 in 2023 (cost of $34,000); New Kitchen Appliances; Entire lighting, fixtures and switches replaced; Customized Closet and Kitchen Pantry systems; Nearly All New Windows (40 windows- almost $60,000 cost); Electric car charger and so much more! *Full list of Upgrades will be found in Documents Tab*<br /> As you approach, you are welcomed by the lovely curb appeal and landcaping. As you enter, you feel the grandeur with gleaming floors and soaring 2-story foyer. Main level boasts desirable office with french doors and formal living and dining rooms. The enormous kitchen is a Chef's dream: complete with Stainless Steel appliances, large center Island, Upgraded Coffee/Bar, Custom Pantry and sunlit Breakfast room. Located off the kitchen you will find the open, spacious Family Room with 2-story ceilings, fireplace and picturesque windows. Stunning lighting found throughout. Step out into the backyard to your own little oasis: Homeowner has created a lovely retreat with the large paver Patio and private Pergola with tree privacy. Wonderful location to relax outdoors or entertain! Upper level features 4 large bedroom to include the deluxe Primary Suite with large sitting room, walk in closet, tray ceiling and en-suite spa like bath. Three additional upper level bedrooms include a private Jr. Suite with bath and Two additional bedrooms and full bath. The Fully Renovated Lower Level is a true treat: All new LVP flooring throughout. The Lower level boasts a huge Rec Room with extra dining and sitting space, Theatre Room with upgraded Projector Screen, Stunning Kitchenette with dishwasher, microwave and fridge. Bonus room with second installed Washer/Dryer combo. Must see in person! Private walkout lower level leads to the backyard. Great location close to major commuter routes and tons of nearby shopping, dining and entertainment. Just minutes to Dulles Town Center, Dulles Airport and Claude Moore Recreation Center. Don't miss this one!
MlsNumber: --
ListingId: VALO2096070


Listing Provided By: Redfin Corporation, original listing
Phone: (703) 665-6665
Office Phone: (703) 665-6665
Agent Name: Rheema Ziadeh
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] => loudoun [3] => VA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: loudoun State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: loudoun 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 = 2873 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Troy Property Group
Troy Property Group
ASCIISampson Properties - Chantilly
Call Today!: (703) 408-5560

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => loudoun [3] => VA [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: loudoun State: VA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: loudoun State: VA 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 = 2873 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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