Page at line 943
1




Recs pe page at line 944
21




Where Clause at line 945
 ( DCExp_SalesPropertyListings.SystemClientID = 244 OR DCExp_SalesPropertyListings.SystemClientID = 0 )  AND (DCExp_SalesPropertyListings.PropertyListingFeedID IN ( 1,3,0 )) AND ( DCExp_SalesPropertyListings.CityID IN (43,12,13,24,63,15,16,28,54,39,195,17,40,41,56,57,32) OR DCExp_SalesPropertyListings.CommunityID IN (108,10,248,288,249,11,114,117,113,12,1391,143,283,2,13,1570,284,6,7,126,1569,130,285,254,250,1609,286,5,251,252,287,253,256,164,165,166,167,168,169,170,1571) )  AND ( DCExp_SalesPropertyListings.MainLuxuryBuildingListing <> 'Y' OR DCExp_SalesPropertyListings.MainLuxuryBuildingListing = NULL )  AND ( DCExp_SalesPropertyListings.InLuxuryBuilding <> 'Y' OR DCExp_SalesPropertyListings.InLuxuryBuilding = NULL )  AND DCExp_SalesPropertyListings.PropertyStatusID NOT IN  (8,9,19,22,7,26,5,6,17,12)


Sales Listings
 

LISTINGS


Neighborhood/Town:
Beds:
Min. Baths:
Price:
Property Type:
150 Woodland
Brookline
MA
02467




Schedule s Showing:


150 Woodland
Brookline
MA
02467




Schedule s Showing:


112 Woodland Road
Brookline
MA
02467
Beds:
5
Baths:
5




Schedule s Showing:


112 Woodland Road
Brookline
MA
02467
Beds:
5
Baths:
5




Schedule s Showing:


150 Woodland Rd
Brookline
MA
02467
Beds:
8
Baths:
7




Schedule s Showing:


150 Woodland Rd
Brookline
MA
02467
Beds:
8
Baths:
7




Schedule s Showing:


77-81 Park Drive
Boston
MA
02215
Beds:
99
Baths:
55




Schedule s Showing:


776 Boylston Street
Boston
MA
02116
Beds:
4
Baths:
4




Schedule s Showing:


776 Boylston Street
Boston
MA
02116
Beds:
4
Baths:
4




Schedule s Showing:


8 Mt Vernon Pl
Boston
MA
02108
Beds:
5
Baths:
7




Schedule s Showing:


8 Mt Vernon Pl
Boston
MA
02108
Beds:
5
Baths:
7




Schedule s Showing:


17 Louisburg Square
Boston
MA
02108
Beds:
5
Baths:
3




Schedule s Showing:


17 Louisburg Square
Boston
MA
02108
Beds:
5
Baths:
3




Schedule s Showing:


40-44 Parker Hill Avenue
Boston
MA
02120
Beds:
78
Baths:
44




Schedule s Showing:


40-44 Parker Hill Avenue
Boston
MA
02120
Beds:
78
Baths:
44




Schedule s Showing:


17 Louisburg Square
Boston
MA
02108
Beds:
5
Baths:
3




Schedule s Showing:


17 Louisburg Square
Boston
MA
02108
Beds:
5
Baths:
3




Schedule s Showing:


17 Story Street
Cambridge
MA
02138




Schedule s Showing:


17 Story Street
Cambridge
MA
02138




Schedule s Showing:


219 Commonwealth Avenue
Newton
MA
02467
Beds:
37
Baths:
28




Schedule s Showing:


219 Commonwealth Avenue
Newton
MA
02467
Beds:
37
Baths:
28




Schedule s Showing:


»4 3 2
1
Page 1 of 1009
21178 records found.
© Fitkova. All Rights Reserved
Powered by DreamingCode