dbo.DCExp_Client_SalesPropertyListing_Search
@OrderBy, Price ASC, SQLVARCHAR
@Page, 1653, SQLINT4
@RecsPerPage, 10, SQLINT4
@WhereClause, ( DCExp_SalesPropertyListings.SystemClientID = 235 OR DCExp_SalesPropertyListings.SystemClientID = 0 ) AND (DCExp_SalesPropertyListings.PropertyListingFeedID IN ( 1,0 )) AND ( DCExp_SalesPropertyListings.CityID IN (1,12) OR DCExp_SalesPropertyListings.CommunityID IN (10,248,288,249,1572,11,7,130,254,4,251,252,1568) ) AND DCExp_SalesPropertyListings.PropertyStatusID NOT IN (8,18,9,3,19,7,5,6,17,12,1,2), SQLVARCHAR
Sales
 

Neighborhood/Town:
Beds:
Price:
Emerson Street
Boston
MA
Beds:
3
Baths:
2
Price:
$1,949,000






Constellation Wharf
Boston
MA
Beds:
3
Baths:
3
Price:
$1,949,000






Avery St
Boston
MA
Beds:
2
Baths:
2
Price:
$1,949,000






Shawmut Ave
Boston
MA
Beds:
3
Baths:
2
Price:
$1,949,000






Tremont St
Boston
MA
Beds:
2
Baths:
2
Price:
$1,949,000






Avery Street
Boston
MA
Beds:
2
Baths:
2
Price:
$1,949,000






Seaport Boulevard
Boston
MA
Beds:
2
Baths:
2
Price:
$1,949,900






Harrison Ave.
Boston
MA
Beds:
2
Baths:
2
Price:
$1,949,900






G
Boston
MA
Beds:
4
Baths:
3
Price:
$1,949,975






Beacon
Boston
MA
Beds:
2
Baths:
2
Price:
$1,950,000






»1654
1653
1652 1651 1650 «
Page 1653 of 1879
18788 records found.