dbo.DCExp_Client_RentalPropertyListing_Search
@OrderBy, Price ASC, SQLVARCHAR
@Page, 3, 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:
NO BROKER FEE - Great Location 3 Bed 1 Bath- Available 9/1!!
Etna St. Unit #2
Brighton
MA
02134
Rent:
$2,500
Beds:
3
Baths:
1






Must See 3 Bed on Babcock St., 2 Full Bathroom
Commonwealth Ave. Unit #18
Brighton
MA
02135
Rent:
$2,550
Beds:
3
Baths:
1






*HALF FEE* 4 Bed 1 Bath in Oak Square - Available September 1st
Faneuil St. Unit #3
Brighton
MA
02135
Rent:
$2,600
Beds:
4
Baths:
1






Beautiful 2 Bed; HALF FEE; Free Laundry, Free Off-Street Parking, 4/1
Union St. Unit #2
Brighton
MA
02135
Rent:
$2,600
Beds:
2
Baths:
1






Quint Ave Unit #2
Boston
MA
02134
Rent:
$2,600
Beds:
3
Baths:
1






*AWESOME AREA***1 Bd on BEACON, Avail 09/01, HT/HW, Concierge
Gerry Rd.
Brookline
MA
02135
Rent:
$2,600
Beds:
1
Baths:
1






Furnished Short Term Rental. Amazing space in Back Bay!
Commonweath Ave. Unit #4
Boston
MA
02115
Rent:
$2,600
Beds:
1
Baths:
1






Nest in North Brookline Brownstone, block from BU with granite/stainls
Riverdale St. Unit #2
Allston
MA
02134
Rent:
$2,600
Beds:
3
Baths:
1






Best Two bed for the money, heat and hot water included
Edgerly Rd. Unit #B
Boston
MA
02115
Rent:
$2,600
Beds:
2
Baths:
1






2.5 Bd on Richmond St., Hardwood Floors, Laundry in Building, A/C
School St. Unit #3
Boston
MA
02119
Rent:
$2,600
Beds:
2
Baths:
1






4 Bd, 2 Bath, Pet Ok, Eat-in Kitchen, Laundry in Building
Cottage St. Unit #3
Boston
MA
02128
Rent:
$2,600
Beds:
4
Baths:
1






*** Available NOW! Great Value 1-Bed w/ Heat Inc - Large Bedroom! ***
Thornton
Brookline
MA
02115
Rent:
$2,620
Beds:
1
Baths:
1.5






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