Page at line 943
265




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 (188,58,851,526,363,463,462,520,445,101,59,867,33,43,172,402,509,319,374,438,834,451,102,361,194,103,869,185,12,519,61,2018,13,23,212,517,430,104,376,559,833,201,62,521,532,320,157,24,522,105,371,209,106,539,184,126,580,14,155,161,107,455,25,46,34,354,326,443,459,527,324,108,352,200,413,47,858,2027,196,329,210,453,364,63,64,380,372,312,15,26,318,405,208,111,27,16,306,365,180,321,441,28,516,112,2030,50,54,156,577,342,39,37,362,68,303,530,406,435,507,170,203,125,431,315,528,213,2003,114,195,566,152,327,414,316,345,115,202,409,502,17,839,305,66,51,434,317,173,373,307,40,117,41,56,379,57,160,193,551,302,44,21,301,38,119) OR DCExp_SalesPropertyListings.CommunityID IN (1583,1559,37,38,39,108,10,248,288,249,11,114,117,113,12,1391,143,283,2,284,6,7,250,5,251,252,287,253,256,1150,1156,1188) )  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:
145 Hart Street
Beverly
MA
01915
Beds:
4
Baths:
2




Schedule s Showing:


145 Hart Street
Beverly
MA
01915
Beds:
4
Baths:
2




Schedule s Showing:


104 Garfield Ave
Boston
MA
02136
Beds:
6
Baths:
2




Schedule s Showing:


246 Boston St
Boston
MA
02125
Beds:
2
Baths:
2




Schedule s Showing:


246 Boston St
Boston
MA
02125
Beds:
2
Baths:
2




Schedule s Showing:


99 Vernon Street
Waltham
MA
02453
Beds:
3
Baths:
2




Schedule s Showing:


99 Vernon Street
Waltham
MA
02453
Beds:
3
Baths:
2




Schedule s Showing:


6 Corinne Road
Medford
MA
02155
Beds:
3
Baths:
1




Schedule s Showing:


65 East India Row
Boston
MA
02110
Beds:
1
Baths:
1




Schedule s Showing:


154 Savin St
Malden
MA
02148
Beds:
4
Baths:
2




Schedule s Showing:


614 Columbus Ave
Boston
MA
02118
Beds:
2
Baths:
1




Schedule s Showing:


614 Columbus Ave
Boston
MA
02118
Beds:
2
Baths:
1




Schedule s Showing:


40 Fay St
Boston
MA
02118
Beds:
1
Baths:
1




Schedule s Showing:


652 Massachusetts Ave.
Boston
MA
02118
Beds:
2
Baths:
2




Schedule s Showing:


40 Fay St
Boston
MA
02118
Beds:
1
Baths:
1




Schedule s Showing:


257 Northampton St
Boston
MA
02118
Beds:
1
Baths:
1




Schedule s Showing:


15 Craig Avenue
Quincy
MA
02169
Beds:
4
Baths:
2




Schedule s Showing:


6 Highland Ave
Somerville
MA
02143
Beds:
3
Baths:
2




Schedule s Showing:


6 Highland Ave
Somerville
MA
02143
Beds:
3
Baths:
2




Schedule s Showing:


694 Highland Ave
Malden
MA
02148
Beds:
4
Baths:
2




Schedule s Showing:


694 Highland Ave
Malden
MA
02148
Beds:
4
Baths:
2




Schedule s Showing:


»269 268 267 266
265
«
Page 265 of 483
10125 records found.
© Fitkova. All Rights Reserved
Powered by DreamingCode