dbo.DCExp_Client_SalesPropertyListing_Search
@OrderBy, Price DESC, SQLVARCHAR
@Page, 1020, 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:
133 Commander Shea Blvd
Quincy
MA
02171
Beds:
2
Baths:
1




Schedule s Showing:


35 Desmoines
Quincy
MA
02169
Beds:
2
Baths:
2




Schedule s Showing:


35 Desmoines
Quincy
MA
02169
Beds:
2
Baths:
2




Schedule s Showing:


135 Neponset Ave
Boston
MA
02122
Beds:
2
Baths:
1




Schedule s Showing:


159 Cottage St
Boston
MA
02128
Beds:
1
Baths:
1




Schedule s Showing:


55 Colborne Rd
Boston
MA
02135
Beds:
1
Baths:
1




Schedule s Showing:


111 Perkins Street
Boston
MA
02130
Beds:
1
Baths:
1




Schedule s Showing:


111 Perkins Street
Boston
MA
02130
Beds:
1
Baths:
1




Schedule s Showing:


221 Minot St
Boston
MA
02124
Beds:
2
Baths:
1




Schedule s Showing:


735 Harrison Ave
Boston
MA
02118
Beds:
1
Baths:
1




Schedule s Showing:


25 Alpine St
Boston
MA
02136
Beds:
2
Baths:
1




Schedule s Showing:


115 Navarre St
Boston
MA
02136
Beds:
2
Baths:
1




Schedule s Showing:


111 Perkins
Boston
MA
02130
Beds:
1
Baths:
1




Schedule s Showing:


111 Perkins
Boston
MA
02130
Beds:
1
Baths:
1




Schedule s Showing:


79 Florida St.
Boston
MA
02124
Beds:
2
Baths:
1




Schedule s Showing:


77-79 Willowwood Street
Boston
MA
02124
Beds:
2
Baths:
1




Schedule s Showing:


372 Washington
Quincy
MA
02169
Beds:
2
Baths:
1




Schedule s Showing:


533 CAMBRIDGE ST
Boston
MA
02134
Beds:
1
Baths:
1




Schedule s Showing:


110 Lanark Road
Boston
MA
02135
Beds:
1
Baths:
1




Schedule s Showing:


301 Adams
Boston
MA
02122




Schedule s Showing:


301 Adams
Boston
MA
02122




Schedule s Showing:


»1024 1023 1022 1021
1020
«
Page 1020 of 1039
21818 records found.
© Fitkova. All Rights Reserved
Powered by DreamingCode