THE BILL DAVIS TEAM

Current Properties for Sale in South Riding

Located in Loudoun County, Virginia, South Riding is a census-designated place and planned community. The population as of the 2010 Census was over 24,000. Neighboring U.S. Route 50 and State Route 28 provide access to the Dulles/Reston/Tysons Corner technology corridor and other major employment centers in Northern Virginia and Washington, D.C.
The 2010 census contained the following statistics: Total population: 24,256. Demographics: White  74.1%,  Black 5.08%, Asian 13.53%, Hispanic  11.18%. 
Information about South Riding:

South Riding Homes for Sale

42756 GIDEON LN CHANTILLY VA 20152
ACTIVE
$1,299,980
4 bd   
4 ba  
1 half ba
   5,423 SQFT
42756 GIDEON LN
CHANTILLY, VA 20152
26124 TALAMORE DR CHANTILLY VA 20152
ACTIVE
$1,197,000
4 bd   
4 ba  
1 half ba
   5,163 SQFT
26124 TALAMORE DR
CHANTILLY, VA 20152
42710 OTIS LN CHANTILLY VA 20152
ACTIVE
$1,150,000
4 bd   
3 ba  
1 half ba
   3,703 SQFT
42710 OTIS LN
CHANTILLY, VA 20152
42651 HARRIS ST SOUTH%20RIDING VA 20152
ACTIVE
$879,900
4 bd   
4 ba  
1 half ba
   3,217 SQFT
42651 HARRIS ST
SOUTH RIDING, VA 20152
26251 RACHEL HILL DR CHANTILLY VA 20152
ACTIVE
$875,000
5 bd   
3 ba  
1 half ba
   2,709 SQFT
26251 RACHEL HILL DR
CHANTILLY, VA 20152
25260 LYON TER CHANTILLY VA 20152
ACTIVE
$735,000
3 bd   
2 ba  
1 half ba
   2,688 SQFT
25260 LYON TER
CHANTILLY, VA 20152
25505 BERESFORD DR CHANTILLY VA 20152
ACTIVE
$689,000
3 bd   
2 ba  
1 half ba
   2,400 SQFT
25505 BERESFORD DR
CHANTILLY, VA 20152
43003 GOLF VIEW DR CHANTILLY VA 20152
ACTIVE
$675,000
3 bd   
2 ba  
2 half ba
   2,478 SQFT
43003 GOLF VIEW DR
CHANTILLY, VA 20152
43003 GOLF VIEW DR CHANTILLY VA 20152
ACTIVE
$660,000
3 bd   
2 ba  
2 half ba
   2,478 SQFT
43003 GOLF VIEW DR
CHANTILLY, VA 20152
25348 WHIPPOORWILL TER SE CHANTILLY VA 20152
ACTIVE
$660,000
3 bd   
2 ba  
1 half ba
   2,283 SQFT
25348 WHIPPOORWILL TER SE
CHANTILLY, VA 20152
25567 GWYNNETH SQ CHANTILLY VA 20152
ACTIVE
$655,000
4 bd   
3 ba  
1 half ba
   2,308 SQFT
25567 GWYNNETH SQ
CHANTILLY, VA 20152
25952 PRIESTERS POND DR CHANTILLY VA 20152
ACTIVE
$650,000
3 bd   
2 ba  
1 half ba
   2,394 SQFT
25952 PRIESTERS POND DR
CHANTILLY, VA 20152
43534 LAIDLOW ST CHANTILLY VA 20152
ACTIVE
$639,000
2 bd   
2 ba  
1 half ba
   1,940 SQFT
43534 LAIDLOW ST
CHANTILLY, VA 20152
25451 CARBERRY DR CHANTILLY VA 20152
ACTIVE
$635,000
3 bd   
2 ba  
1 half ba
   2,250 SQFT
25451 CARBERRY DR
CHANTILLY, VA 20152
42999 EDGEWATER ST CHANTILLY VA 20152
ACTIVE
$629,900
3 bd   
2 ba  
2 half ba
   1,840 SQFT
42999 EDGEWATER ST
CHANTILLY, VA 20152
42999 EDGEWATER ST CHANTILLY VA 20152
ACTIVE
$625,000
3 bd   
2 ba  
2 half ba
   1,840 SQFT
42999 EDGEWATER ST
CHANTILLY, VA 20152
25544 HEYER SQ CHANTILLY VA 20152
COMING SOON
$620,000
3 bd   
2 ba  
1 half ba
   2,288 SQFT
25544 HEYER SQ
CHANTILLY, VA 20152
25109 OVERLORD TER CHANTILLY VA 20152
ACTIVE
$606,000
3 bd   
3 ba  
1 half ba
   1,741 SQFT
25109 OVERLORD TER
CHANTILLY, VA 20152
42963 GOLF VIEW DR CHANTILLY VA 20152
ACTIVE
$589,900
3 bd   
2 ba  
1 half ba
   2,412 SQFT
42963 GOLF VIEW DR
CHANTILLY, VA 20152
43021 GOLF VIEW DR CHANTILLY VA 20152
ACTIVE
$545,000
3 bd   
2 ba  
1 half ba
   2,114 SQFT
43021 GOLF VIEW DR
CHANTILLY, VA 20152
25093 FRANCISCO TER CHANTILLY VA 20152
ACTIVE
$544,900
3 bd   
3 ba  
1 half ba
   1,574 SQFT
25093 FRANCISCO TER
CHANTILLY, VA 20152
25152 MONTEITH TER CHANTILLY VA 20152
ACTIVE
$540,000
3 bd   
3 ba  
1 half ba
   1,592 SQFT
25152 MONTEITH TER
CHANTILLY, VA 20152
42595 HOMEFRONT TER CHANTILLY VA 20152
ACTIVE
$539,000
3 bd   
3 ba  
1 half ba
   1,650 SQFT
42595 HOMEFRONT TER
CHANTILLY, VA 20152
42811 FLANNIGAN TER CHANTILLY VA 20152
ACTIVE
$525,000
4 bd   
2 ba  
1 half ba
   1,524 SQFT
42811 FLANNIGAN TER
CHANTILLY, VA 20152
25110 MCBRYDE TER CHANTILLY VA 20152
COMING SOON
$525,000
3 bd   
3 ba  
1 half ba
   1,854 SQFT
25110 MCBRYDE TER
CHANTILLY, VA 20152
42800 PILGRIM SQ CHANTILLY VA 20152
ACTIVE
$474,999
2 bd   
2 ba
   1,728 SQFT
42800 PILGRIM SQ
CHANTILLY, VA 20152
25260 LAKE SHORE SQ #101 CHANTILLY VA 20152
ACTIVE
$450,000
2 bd   
2 ba
   1,246 SQFT
25260 LAKE SHORE SQ #101
CHANTILLY, VA 20152
43134 WATERCREST SQ #205 CHANTILLY VA 20152
COMING SOON
$400,000
2 bd   
1 ba
   1,058 SQFT
43134 WATERCREST SQ #205
CHANTILLY, VA 20152
1
2
Database last updated  07/20/2024 05:11 AM
 
For Sale Listings
Rental Search
Find a Home
Minimum Sale Price
Maximum Sale Price
ADVANCED SEARCH OPTIONS
New Search
Search powered by
© Bright MLS. All rights reserved.
Listings provided by Bright MLS from various brokers who participate in IDX (Internet Data Exchange). Information deemed reliable but not guaranteed.

THE BILL DAVIS TEAM
CENTURY 21 New Millenium
4437 Brookfield Corporate Drive
Suite 110
Chantilly, VA 20151
Direct:
703-501-4471
Office:
703-818-0111
BillyC21@aol.com
Copyright © 2022. Bill Davis Team Real Estate
Copyright © 2022. Bill Davis Team Real Estate
 
Powered by ListingsToGo™
select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ahlea' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Akerly' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Alderman' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Alumni' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'America' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Anabell' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Anderby' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Anthem' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ariakian' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Arthur' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ashbury' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Astell' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Atchison' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Aythorne' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Bald Eagle' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Barons' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Beachall' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Bennett' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Beresford' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Bessemer' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Biddle' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Bradshaw' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Brass' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Brickell' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Bridgehampton' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Brodie' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Bryson' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Burke Dale' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Buser' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Camden' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Capital' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Carberry' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Carne' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Carrington' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Caversham' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Cedar Hedge' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Center' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Chambers' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Chase' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Chicama' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Chilmark' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Chiswick' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Chorley Wood' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Cilantro' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Coach' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Cocoa' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Colonists' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Conrad' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Corcoran' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Cowher' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Creek Run' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Creekmoore' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Cricket' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Crossfield' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Cunard' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Dabner' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Daniel Shane' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Dapper' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Darkwoods' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Daventry' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Demerrit' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Dempsey' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Donegal' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Donovan' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Doolittle' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Dream' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Dressmaker' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Drillfield' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Dunvegan' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Easterwood' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Edenfield' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Edgartown' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Edgewater' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Eggleston' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Eisenhower' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Eldridge' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Elk Lick Road' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Equality' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Esther' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Eustis' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Euthchus' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Evans' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Evian' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Exart' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Fair Ponds' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Fairbanks' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Farm Neck' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Femoyer' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Fieldsman' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Finders' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Firefly' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Firelight' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'First Frost' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Flannigan' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Flemming' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Flintonbridge' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Flyaway' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Flynn' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Fortitude' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Francis' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Francisco' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Freda' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Freedom' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Fretton' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Friars' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Friendship' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Gabriel' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Gallitzin' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Gaslight Aley' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Gelding' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Gideon' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Gimbel' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Glasgow' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Golf View' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Gover' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Graham' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Green Ginger' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Gunnery' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Gwynneth' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hagen' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hallmark' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Harris' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hartwood' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Heathfield' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Herring Creek' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hetrick' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Heyer' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hobbit' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hogan' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hollingsworth' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Holly Tree' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Holtby' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Homefront' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Howerton' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hubbard' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Huddleston' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hussar' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Hyland Hills' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Indian Hill' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Interval' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Intrepid' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ironworker' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Iverson' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ivory' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Jebson' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Jenny' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Jeweller' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Jolly' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Jones' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Jonquil' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Jordan' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Jubilee' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Justice' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kaiser' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kanefield' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Katama' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Katling' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kearney' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kelly' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kenai' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kenmore' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kennebec' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kennywood' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kettle' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kimberly Rose' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kinship' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kiplington' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kirby' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Kirkwood' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Krebs' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Laidlow' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lake Mist' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lake Shore' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lambert' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lands End' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Langdon' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lantern' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Larks' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Latrobe' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Latter' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Leaflet' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Legion' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lemon Tree' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lennox' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Leonard' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lewiston' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Leyland' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lighthouse' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lilypad' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lochdon' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Locket' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Locklear' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Loganshire' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lomax' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Londontown' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Longacre' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Longleaf' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Longmere' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Longworth' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Lyon' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Magistrate' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Maise' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Malt' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Mandeville' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Mandoa' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Mandolin' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Maple Cross' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Marshmellow' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Maverick' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'McBryde' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'McComas' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'McDeeds' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'McIntyre' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'McKinzie' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Menemsha' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Middlecoff' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Miltec' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Mimosa Tree' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Mink Meadows' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Mongoose' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Monteith' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Moonlight' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Morse' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Moshupe' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Murrey' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Mustard' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Nations' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Natures' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Neighborly' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Neptune' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Nesbit' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Nesting' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Nestle' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Newcastle' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Newcomer' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Nicklaus' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Nimbleton' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Norrington' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Norton' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Oberon' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Obrien' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ocala' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Oceantide' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Olander' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Oleary' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Olive Tree' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Omaha' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Opra' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Oregano' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Oriole' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Orson' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Oscar' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Otis' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Overlord' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Overly' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Owen Park' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Oxen' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Oyster' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Pampering' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Pamplin' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Parish' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Peachstone' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Pelican' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Pemberton' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Pembrooke' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Peppercorn' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Pilgrim' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Pinebluff' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Pineforest' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Planting Field' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Plum' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Pond View' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Priesters Pond' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Primanti' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Privilege' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Quentin' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Quigley' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Quilting' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Quinlan' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Quits Pond' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Rachel Hill' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Radke' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Raflo' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Randfield' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Rickmansworth' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Riding Center' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Riffleford' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ripleys Field' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ritter' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Robinson' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Rolling Rock' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Rooney' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Roper' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Rose' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Royal Burkedale' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'San Sebastian' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Sandman' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Sarazan' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Scarlet' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Schultz' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Sealock' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Sedgmire' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Shaler' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Shannon' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Shelbourne' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Shimmering Lake' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Shipley' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Singleton' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Skiff' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Smallwood' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Smithers' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Snead' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Sorbonne' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Springdale' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Spurling' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Spyder' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'St. Andrews' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Stadler' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Stinger' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Stires' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Stires' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Stonewall Pond' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Strawbridge' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Sykes' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Sylvia' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tabor House' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tadman' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Talamore' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Talent' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tall Cedars' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Talmont' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tarkington' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tarragon' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tashmoo' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Thoroughgood' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tinsel' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tippman' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tisbury' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tremaine' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tudling' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Turnbull' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Tuthill' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ulster' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Ulysses' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Unicorn' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Upper Clubhouse' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Utah' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Valiant' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Vanilla Bean' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Warbuckle' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Watercrest' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Webb' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Wembley' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Wendell' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Whippoorwill' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Winter' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Wray' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Wytton' UNION select * from searchAll where ForSale='Y' and (ListingStatus='Active' or ListingStatus='Coming Soon') and City IN ('Chantilly','South Riding') and State='VA' and PropertyType = 'Residential' and `StreetName` = 'Zap' order by ListPrice desc;