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

9515 Loma Drive
Bristow, VA 20136
Leslie Hoban with EXP Realty, LLC, original listing - (866) 825-7169

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $769,900
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2998 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (866) 825-7169

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: This is an incredible opportunity to own this traditional, elegant & immaculate home in the coveted New Castle Village neighborhood in Bristow. This 5 Br, 3.5 Ba home is the essence of luxury living in this community. With over $200,000 in recent updates and a generous floor plan at 3100 sq ft, this spacious home offers wonderful living space inside and out. A large porch at the front of the house and another deck at the back of the home add livable square footage to this home. The owner is an incredible gardener, and the beautiful landscape around the home adds to its beauty and ambiance. Step into the spacious gourmet kitchen with a butler's pantry feeding into the formal dining room. The kitchen has a huge pantry and another smaller pantry. Stainless steel appliances and beautiful quartz countertops make the kitchen look modern and functional. A huge island, a cozy eat-in breakfast nook, and a walk-out to the deck add to the kitchen's charm. The kitchen opens to a wonderful family room with high ceilings and a lovely mantled fireplace. A newly updated powder room is sure to please you, and a spacious home office with built-ins allows easy access for work from home. A bright and cheerful formal dining room with crown moldings and wainscotting greets you upon entering the home, and beautiful hardwood floors are found throughout the main level. Travel upstairs to a primary bedroom fit for a king or queen. You will find a generous walk-in closet with organizers, allowing plenty of room for all your clothes! A gorgeous renovation gives you the bathroom of your dreams - you just have to see it in person to appreciate all of the special details! Three more generous bedrooms can be found on the upper level. A modern and renovated hall bathroom is also located on the upper level. Traveling to the lower level is an experience of its own! The sky is the limit with this useful space. An activity room is perfect for children to play and for entertaining guests. Behind the recreation room is a special space. An oversized room with a private outdoor entrance, an updated attached bath, and a closet the size of a bedroom (8X10), is conveniently located here. Perfect for in-laws, friends or renters. Access to the side yard and driveway is available from this suite. Finally, we cannot forget the storage space and utilities room. Large enough for everything you want to store, with room to spare, and a private area for the washer and dryer. The 2-car detached garage is located behind the home. <br /> Some of the many updates include: the AC -2023, Furnace - 2022, New architectural shingle roof with lifetime warranty -2025, Kitchen countertops and backsplash, and all Bathroom and Powder room renovations -2022, New carpet on stairs, upper level, and the basement -2020. New Washer, Range, Dishwasher, and Refrigerator, 2021, Fireplace rebuilt inside and chimney cleaned -2021, New wide gutters and downspouts - 2023, Interior painted -2023, Deck construction, exterior painting of the house, foundation, porch, and railings, and powder washing, landscaping, adding mulch and soil and more flowers - 2024, and so much more! This home is so close to the pool, playgrounds, tennis, basketball courts, schools, and shopping. A perfect place to live in Bristow!<br /> OPEN HOUSES: Friday, March 28th 4-6 PM , Saturday, March 29th 12-2 PM, Sunday March 30th 1-3 PM A"Must See!"
MlsNumber: --
ListingId: VAPW2090260


Listing Provided By: EXP Realty, LLC, original listing
Phone: (866) 825-7169
Office Phone: (866) 825-7169
Agent Name: Leslie Hoban
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 = 2899 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 Dee Thomasson
Dee Thomasson
ASCIILong & Foster Real Estate, Inc.
Call Today!: (229) 563-8330

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 = 2899 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 Ellsworth 'Brownie' Brown NMLS#1686479
Ellsworth 'Brownie' Brown NMLS#1686479
ASCIISuccess Mortgage
Call Today!: (757) 870-4943

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App