dbo.DCExp_Client_SalesPropertyListing_Search
@OrderBy, Price DESC, SQLVARCHAR
@Page, 947, SQLINT4
@RecsPerPage, 21, SQLINT4
@WhereClause, ( 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), SQLVARCHAR
Sales Listings
 

LISTINGS


Neighborhood/Town:
Beds:
Min. Baths:
Price:
Property Type:
19 Gorham St
Waltham
MA
02453
Beds:
2
Baths:
1




Schedule s Showing:


250 Whitwell St
Quincy
MA
02169
Beds:
2
Baths:
1




Schedule s Showing:


319 Allston Street
Boston
MA
02135
Beds:
1
Baths:
1




Schedule s Showing:


319 Allston Street
Boston
MA
02135
Beds:
1
Baths:
1




Schedule s Showing:


2 Fernboro St
Boston
MA
02121
Beds:
3
Baths:
1




Schedule s Showing:


132 Rockland St
Quincy
MA
02169
Beds:
3
Baths:
1




Schedule s Showing:


132 Rockland St
Quincy
MA
02169
Beds:
3
Baths:
1




Schedule s Showing:


195 bunker hill
Boston
MA
02129
Beds:
1
Baths:
1




Schedule s Showing:


195 bunker hill
Boston
MA
02129
Beds:
1
Baths:
1




Schedule s Showing:


31 Greenock St
Boston
MA
02124
Beds:
3
Baths:
1




Schedule s Showing:


31 Greenock St
Boston
MA
02124
Beds:
3
Baths:
1




Schedule s Showing:


549 Centre St
Newton
MA
02458
Beds:
1
Baths:
1




Schedule s Showing:


549 Centre St
Newton
MA
02458
Beds:
1
Baths:
1




Schedule s Showing:


549 Centre St
Newton
MA
02458
Baths:
1




Schedule s Showing:


549 Centre St
Newton
MA
02458
Baths:
1




Schedule s Showing:


63 Ash St
Waltham
MA
02453
Beds:
1
Baths:
1




Schedule s Showing:


63 Ash St
Waltham
MA
02453
Beds:
1
Baths:
1




Schedule s Showing:


5 Nira Street
Malden
MA
02148
Beds:
3
Baths:
1




Schedule s Showing:


31 Cushing Avenue
Boston
MA
02125
Beds:
1
Baths:
1




Schedule s Showing:


31 Cushing Avenue
Boston
MA
02125
Beds:
1
Baths:
1




Schedule s Showing:


20 Ripley Rd
Boston
MA
02121
Beds:
3
Baths:
1




Schedule s Showing:


»949 948
947
946 945 «
Page 947 of 985
20684 records found.
© Fitkova. All Rights Reserved
Powered by DreamingCode