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 e.expertIdNum = 1841060 AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 e.expertIdNum = -1 AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 e.expertIdNum = -1 AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;

15550 Smithfield Pl
Centreville, VA 20120

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,195,000
Beds: 4
Baths: 5
Status: Active
SqFt: --
Agency: Long & Foster Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1989
Notes: Welcome to your dream home! This breathtaking former model home is nestled on almost an acre that backs to a peaceful common area and a tranquil pond. As you approach this home, you'll be captivated by its stately brick front creating an alluring façade that sets the tone for the elegance that awaits inside. This spacious home exudes sophistication and tranquility at every turn and offers ample living space for entertaining and everyday living. The grand two-story foyer will greet you with a graceful, curved refinished staircase that makes a stunning first impression. This home has a BRAND NEW ROOF for peace of mind for years to come. This home offers Pella windows and the main level boasts refinished hardwood floors and a dedicated study with built-ins providing the ideal space to work from home or indulge in your favorite hobby. The formal living and dining rooms are adorned with elegant moldings and flooded with natural light creating an inviting atmosphere for hosting dinner parties or intimate gatherings. Bathed in sunlight, the sunroom beckons with skylights and Palladian windows. Open up the patio doors and step onto the deck where you can sip your morning coffee, dine al fresco, or enjoy a summer barbecue. The gourmet kitchen is every chef's dream, featuring a breakfast bay, granite countertops, a central island with a gas cooktop, a planning desk, ample cabinet space, and quality stainless steel appliances, including a Bosch dishwasher, double wall oven, and top-of-the-line Samsung smart fridge which adds a touch of modern convenience to this already remarkable space. The adjacent family room has brand new carpet & seamlessly flows from the kitchen, offering warmth and ambiance with skylights, a cathedral ceiling, and a cozy fireplace. Ascend the staircase to find BRAND NEW CARPET THROUGHOUT THE UPPER LEVEL! Discover the expansive primary suite, where French doors lead to a serene sitting room loft overlooking the sunroom. Pamper yourself in the spa-like ensuite bathroom, complete with a jetted Jacuzzi tub, separate shower, and walk-in closet. A full upper hall bathroom serves the 3rd and 4th bedrooms, and the second bedroom has its own ensuite bath. The finished walk-out basement offers a generous rec room, ample storage, and a full bathroom. Additional amenities include a new roof, a second rear deck (both newly refinished), a central vacuum system, and four-zone heating and cooling. Virginia Run amenities include a community pool, tennis courts, pickleball, community center, tot lots, and miles of trails. Conveniently located near shopping, dining, parks, and commuter routes, this exceptional home offers a harmonious blend of elegance, comfort, and convenience!
MlsNumber: VAFX2173680


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Burke/Fairfax Station/Clifton
Office Phone: (888) 536-0216
Agent Name: Spencer R Marker
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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 e.expertIdNum = 1841060 AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;
David Johnston
ASCIICreegan Group
Call Today!: (407) 398-3295

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App