dbo.DCExp_Client_RentalPropertyListing_Search
@OrderBy, Price ASC, SQLVARCHAR
@Page, 29, SQLINT4
@RecsPerPage, 12, SQLINT4
@WhereClause, ( DCExp_RentalPropertyListings.SystemClientID = 235 OR DCExp_RentalPropertyListings.SystemClientID = 0 ) AND (DCExp_RentalPropertyListings.PropertyListingFeedID IN ( 2,0 )) AND ( DCExp_RentalPropertyListings.CityID IN (1,12) OR DCExp_RentalPropertyListings.CommunityID IN (10,248,288,249,1572,11,7,130,254,4,251,252) ) AND DCExp_RentalPropertyListings.Price >= 2400 AND DCExp_RentalPropertyListings.Price <= 8000 AND DCExp_RentalPropertyListings.PropertyStatusID NOT IN (8,18,9,20,4,19,22,7,26,5,6,17,12,1,2), SQLVARCHAR
Rentals
 

Neighborhood/Town:
Rent:
Min. Beds:
FANTASTIC BEACON HILL THREE BED, 1.5 BATH, STAINLESS STEEL APPLIANCES!
Anderson St. Unit #7
Boston
MA
02114
Rent:
$4,500
Beds:
4
Baths:
1.5






ALL NEW 3 Br in PRIME LOCATION! Cen Air, Laundry in Building, MUST-SEE
Belvidere Unit #2
Boston
MA
02115
Rent:
$4,600
Beds:
3
Baths:
1






Comfy XL 3BA Duplex | Free Laundry | Porch | Bay Windows
Atherton St. Unit #2
Boston
MA
02119
Rent:
$4,600
Beds:
5
Baths:
3






Higgins St
Boston
MA
02134
Rent:
$4,600
Beds:
4
Baths:
2






1 - February
Winthrop Rd. Unit #1
Brookline
MA
02445
Rent:
$4,600
Beds:
4
Baths:
2






Students Welcome!!Walk to BU. Heat, Hot Water Included. Laundry
Egmont St. Unit #5
Brookline
MA
02446
Rent:
$4,600
Beds:
4
Baths:
1.5






AWESOME 4 Br on SAINT PAUL ST *9/1* Dishwasher, Laundry, Ht/Hw Incl
Saint Paul St. Unit #5
Brookline
MA
02446
Rent:
$4,650
Beds:
4
Baths:
1






Gorgeous 4 bed, heat/hw incl, laundry, dishwashr, Sunny, big rooms 9/1
Egmont St. Unit #5
Brookline
MA
02446
Rent:
$4,700
Beds:
4
Baths:
1






St. Luke's Rd Unit #1
Boston
MA
02134
Rent:
$4,700
Beds:
4
Baths:
2






Chester St Unit #1
Boston
MA
02134
Rent:
$4,700
Beds:
4
Baths:
2






Chester St.
MA
Rent:
$4,700
Beds:
5
Baths:
2






4 Bd on Pratt St., 2 Bath, New/Renovated Bath, A/C, Laundry in Unit
Pratt St. Unit #2
Allston
MA
02134
Rent:
$4,700
Beds:
4
Baths:
2






»
29
28 27 26 25 «
Page 29 of 35
418 records found.