dbo.DCExp_Client_RentalPropertyListing_Search
@OrderBy, Price ASC, SQLVARCHAR
@Page, 4, 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:
Large Living Space!!
Easton St. Unit #3
Allston
MA
02134
Rent:
$2,625
Beds:
3
Baths:
1






*** Available NOW! Great Value 1-Bed w/ Heat Inc - Large Bedroom! ***
VFW
Boston
MA
02132
Rent:
$2,650
Beds:
1
Baths:
1






*NICE CAMBRIDGE 1BD ON CHAUNCY, AVAIL NOW, HT/HTW, PARKING*
Sherman Rd.
Boston
MA
02132
Rent:
$2,650
Beds:
1
Baths:
1






Must See 3 Bed on Babcock St., 2 Full Bathroom
Saratoga St. Unit #1
Boston
MA
02128
Rent:
$2,675
Beds:
3
Baths:
1






*** Available NOW! Great Value 1-Bed w/ Heat Inc - Large Bedroom! ***
Sherman
Brookline
MA
02146
Rent:
$2,690
Beds:
1
Baths:
1






3 Bd on Melvin Ave., Hardwood Floors, Heat & Hot Water Included
Melvin Ave. Unit #9
Brighton
MA
02135
Rent:
$2,695
Beds:
3
Baths:
1






Living & Dining Room, Parking Incl. Spacious 3 Bed in Brighton Center
Lyne Rd. Unit #2
Brighton
MA
02135
Rent:
$2,700
Beds:
3
Baths:
1






3 Bd on Washington St., Laundry in Building
Washington St. Unit #3
Brighton
MA
02135
Rent:
$2,700
Beds:
3
Baths:
1






4 BR Available NOW Porch Fireplace MODERN Kitchen
South Hobart St. Unit #2
Brighton
MA
02135
Rent:
$2,700
Beds:
3
Baths:
2






Mapleton St
Boston
MA
02135
Rent:
$2,700
Beds:
3
Baths:
1






3 Bd on Washington St., 2 Bath, Avail 09/01, Concierge
Washington St. Unit #1
Brighton
MA
02135
Rent:
$2,700
Beds:
3
Baths:
2






Kelton St Unit #B
Boston
MA
02134
Rent:
$2,700
Beds:
3
Baths:
2






»
4
3 2 1
Page 4 of 21
250 records found.