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

25569 ARTHUR PL CHANTILLY VA 20152
ACTIVE
$1,399,999
4 bd   
4 ba  
1 half ba
   5,650 SQFT
25569 ARTHUR PL
CHANTILLY, VA 20152
25561 ARTHUR PL CHANTILLY VA 20152
ACTIVE
$1,349,900
4 bd   
4 ba  
1 half ba
   5,700 SQFT
25561 ARTHUR PL
CHANTILLY, VA 20152
42536 FLEMMING DR CHANTILLY VA 20152
COMING SOON
$1,324,900
4 bd   
3 ba  
1 half ba
   4,775 SQFT
42536 FLEMMING DR
CHANTILLY, VA 20152
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
43185 QUILTING LN CHANTILLY VA 20152
ACTIVE
$1,190,000
4 bd   
3 ba  
1 half ba
   3,640 SQFT
43185 QUILTING LN
CHANTILLY, VA 20152
25210 ULYSSES ST CHANTILLY VA 20152
ACTIVE
$1,012,000
5 bd   
3 ba  
1 half ba
   4,643 SQFT
25210 ULYSSES ST
CHANTILLY, VA 20152
25932 KIMBERLY ROSE DR CHANTILLY VA 20152
COMING SOON
$949,000
4 bd   
2 ba  
1 half ba
   3,338 SQFT
25932 KIMBERLY ROSE DR
CHANTILLY, VA 20152
42936 SPYDER PL CHANTILLY VA 20152
ACTIVE
$899,900
4 bd   
2 ba  
1 half ba
   3,958 SQFT
42936 SPYDER PL
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
26004 TALAMORE DR CHANTILLY VA 20152
ACTIVE
$785,000
3 bd   
2 ba  
1 half ba
   2,619 SQFT
26004 TALAMORE DR
CHANTILLY, VA 20152
26071 NIMBLETON SQ CHANTILLY VA 20152
COMING SOON
$700,000
3 bd   
2 ba  
1 half ba
   2,497 SQFT
26071 NIMBLETON SQ
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
42989 BEACHALL ST CHANTILLY VA 20152
ACTIVE
$670,000
3 bd   
2 ba  
2 half ba
   2,270 SQFT
42989 BEACHALL ST
CHANTILLY, VA 20152
42802 CEDAR HEDGE ST CHANTILLY VA 20152
ACTIVE
$670,000
3 bd   
2 ba  
1 half ba
   2,184 SQFT
42802 CEDAR HEDGE ST
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
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
43453 PARISH ST CHANTILLY VA 20152
ACTIVE
$629,900
3 bd   
2 ba  
2 half ba
   1,880 SQFT
43453 PARISH ST
CHANTILLY, VA 20152
25362 ASHBURY DR CHANTILLY VA 20152
COMING SOON
$600,000
3 bd   
3 ba  
2 half ba
   2,068 SQFT
25362 ASHBURY DR
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
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
42812 SMALLWOOD TER CHANTILLY VA 20152
ACTIVE
$515,000
3 bd   
3 ba  
1 half ba
   1,502 SQFT
42812 SMALLWOOD 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  04/27/2025 07:46 PM
 
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;