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 = 1841635 AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 'vahud', 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 = 'vahud', 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;

13535 Knotty Log Ct
Chantilly, VA 20151

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,999
Beds: 4
Baths: 4
Status: Pending
SqFt: --
Agency: Long & Foster Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1986
Notes: WELCOME TO THIS LOVELY 4 BEDROOM, 3.5 BATH HOME, CUL DE SAC LOCATION IN THE HIGHLY DESIRED POPLAR TREE ESTATES COMMUNITY! AT FIRST SIGHT, THIS HOME HAS EXCELLENT CURB APPEAL, BRICK WALKWAY, PROFESSIONALLY LANDSCAPED, SPACIOUS TREX DECK. GLEAMING HARDWOOD FLOORS GREET YOU AS YOU ENTER INTO THE TWO STORY FOYER AND FLOW THROUGHOUT THE MAIN LEVEL AND NATURAL LIGHT BEAMING FROM ONE ROOM TO THE NEXT. CHEERFUL LIVING ROOM OFF OF FOYER HAS EXTENSIVE DETAILED TRIM IN THE DINING ROOM, FOYER AND STAIR CASE. OPEN KITCHEN OFFERS STAINLESS STEEL APPLIANCES, BACKSPLASH, GRANITE COUNTER TOPS, KITCHEN ISLAND WITH ELECTRIC COOKTOP, DOUBLE OVENS, KITCHEN TABLE AREA NEXT TO THE SLIDING GLASS DOOR WHICH OVERLOOKS THE BACKYARD THE SUN FILLED FAMILY ROOM FEATURES SKYLIGHTS AND WOOD BURNING FIREPLACE. THE MAIN LEVEL OFFICE FEATURES A LARGE PICTURE WINDOW WELCOMING PLENTY OF SUNLIGHT. THE UPPER-LEVEL FEATURES A REMODELED PRIMARY BATHROOM WITH DUAL SINKS, WALK-IN SHOWER AND SOAKING TUB. FINISHED BASEMENT FEATURES, LARGE RECREATION ROOM, FULL BATH, OFFICE/WORKOUT SPACE, WORKSHOP/UTILITIES AREA. NEWER FURNACE WITH PROGRAMABLE THERMOSTAT, WHOLE HOUSE SURGE PROTECTOR, NEW WATER HEATER, SUMP PUMP, ROOF 2022, HVAC 2012. THIS HOME HAS BEEN FILLED WITH AN ENORMOUS AMOUNT OF LOVE AND NOW AWAITS YOU!! EASY ACCESS TO DULLES INTERNATIONAL AIRPORT, I-66, VA-28, US-50 AND MINUTES TO PARK AND RIDE ON STRINGFELLOW RD. SHOPPING, RESTAURANTS, TOP-RATED SCHOOLS, PLAYGROUND, WALKING/JOGGING PATHS THAT CONNECT TO BIG ROCKY RUN TRAIL AND ELLANOR C. LAWRENCE PARK, COMMUNITY POOL, AND TENNIS COURTS. NEIGHBORHOOD INCLUDES A SWIM TEAM, PLANNED SOCIAL EVENTS, SCHEDULED FOOD TRUCKS AND SO MUCH MORE. IT'S A GREAT WAY TO MEET YOUR NEIGHBORS. SCHEDULE SHOWING ONLINE WITH SHOWING TIME. DEADLINE FOR ALL OFFERS, SUNDAY MAY 4TH AT NOON. RENT BACK TILL END OF JULY.
MlsNumber: VAFX2165336


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Fairfax Centre
Office Phone: (888) 536-0216
Agent Name: Elizabeth McGuiness
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 = 1841635 AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 Joey Frankel & Sandra Carl
Joey Frankel & Sandra Carl
ASCIIDouglas Elliman The Frankel/ Carl Team
Call Today!: (516) 342-0056

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App