Page at line 943
945




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:
142-146 Chelsea Street
Boston
MA
02128




Schedule s Showing:


142-146 Chelsea Street
Boston
MA
02128




Schedule s Showing:


0 Bow St.
Cambridge
MA
02138




Schedule s Showing:


000 Bow St
Cambridge
MA
02138




Schedule s Showing:


260 Bear Hill Road
Waltham
MA
02451




Schedule s Showing:


65 Watertown
Watertown
MA
02472




Schedule s Showing:


66 Summer Street
Malden
MA
02148




Schedule s Showing:


42-42A Eastern Ave
Malden
MA
02148




Schedule s Showing:


384 Trapelo Rd
Belmont
MA
02478




Schedule s Showing:


108 Water St
Watertown
MA
02472




Schedule s Showing:


1 Cityview Ln
Quincy
MA
02169
Beds:
2
Baths:
2




Schedule s Showing:


525 Main Street
Malden
MA
02148




Schedule s Showing:


167 Atlantic St, Apt 2
Quincy
MA
02171
Beds:
6
Baths:
2




Schedule s Showing:


33 Bedford Street
Lexington
MA
02420




Schedule s Showing:


214 Milton Street
Dedham
MA
02026




Schedule s Showing:


657 Adams Street
Quincy
MA
02169




Schedule s Showing:


360 Watertown Street
Newton
MA
02458




Schedule s Showing:


1458 Hancock Street
Quincy
MA
02169




Schedule s Showing:


7 Brook Street
Quincy
MA
02171




Schedule s Showing:


60 Kendrick St
Needham
MA
02494




Schedule s Showing:


101 Commercial St
Malden
MA
02148




Schedule s Showing:


947 946
945
«
Page 945 of 947
19885 records found.
© Fitkova. All Rights Reserved
Powered by DreamingCode