dbo.DCExp_Client_RentalPropertyListing_Search
@OrderBy, Price ASC, SQLVARCHAR
@Page, 1, SQLINT4
@RecsPerPage, 12, SQLINT4
@WhereClause, ( DCExp_RentalPropertyListings.SystemClientID = 235 OR DCExp_RentalPropertyListings.SystemClientID = 0 ) AND (DCExp_RentalPropertyListings.PropertyListingFeedID IN ( 2,0 )) AND DCExp_RentalPropertyListings.Price >= 2000 AND DCExp_RentalPropertyListings.Price <= 8000 AND (DCExp_RentalPropertyListings.CommunityID IN (10,11) OR DCExp_RentalPropertyListings.CityID IN (12)) AND DCExp_RentalPropertyListings.PropertyStatusID NOT IN (8,18,9,20,4,19,22,7,26,5,6,17,12,1,2) AND DCExp_RentalPropertyListings.PropertyStatusID NOT IN (8,18,9,20,4,19,22,7,26,5,6,17,12,1,2), SQLVARCHAR
Allston, Brighton, Brookline Apartments for Rent | Gateway Real Estate Group
 

Zip Code:
Neighborhood/Town:
Rent:
Beds:
1 Bed w/ Sun Room - Surrounded by the Best Coolidge has to Offer *7/1*
Beacon St. Unit #35
Brookline
MA
02446
Rent:
$2,000
Beds:
1
Baths:
1
Request Information






RARE FIND - Way Underpriced 1 Bed in the Heart of Coolidge Corner!!
Beacon St. Unit #53
Brookline
MA
02446
Rent:
$2,000
Beds:
1
Baths:
1
Request Information






1 Bd on Quint Ave.
Beacon St. Unit #65
Brookline
MA
02446
Rent:
$2,000
Beds:
1
Baths:
1
Request Information






1 Bd on Winthrop Rd., Hardwood Floors, Hardwood Floors, Modern Bath
Winthrop Rd. Unit #22
Brookline
MA
02445
Rent:
$2,000
Beds:
1
Baths:
1
Request Information






Gordon St Unit #301
Boston
MA
02135
Rent:
$2,000
Beds:
1
Baths:
1
Request Information






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






Highgate St Unit #4
Boston
MA
02134
Rent:
$2,100
Beds:
2
Baths:
1
Request Information






1 Bd, Hardwood Floors, Professionally Managed, Natural Light / Sunny
Beacon St. Unit #36
Brookline
MA
02446
Rent:
$2,100
Beds:
1
Baths:
1
Request Information






*Nice and Bright* Ideal C Line Location, High Quality Space! July 1
Beacon St. Unit #45
Brookline
MA
02446
Rent:
$2,100
Beds:
1
Baths:
1
Request Information






1 Bd on Babcock St.
Babcock St. Unit #7
Brookline
MA
02446
Rent:
$2,100
Beds:
1
Baths:
1
Request Information






2 Bed on Dean RD., 2 Bath, Parking Included.
Dean Rd. Unit #GA
Brookline
MA
02445
Rent:
$2,100
Beds:
2
Baths:
2
Request Information






Studio on Beacon St.
Beacon St. Unit #410
Brookline
MA
02446
Rent:
$2,175
Baths:
1
Request Information






»4 3 2
1
Page 1 of 20
229 records found.