Page at line 943
4




Recs pe page at line 944
20




Where Clause at line 945
 ( 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,249,11,7,130,254,252) )  AND DCExp_RentalPropertyListings.Price >= 1799 AND DCExp_RentalPropertyListings.PropertyStatusID NOT IN  (8,18,9,20,4,19,22,7,26,5,6,17,12,1,2)


Allston, Brighton, Brookline Apartments for Rent | Gateway Real Estate Group
 
Contact Us139 Brighton Ave Allston, MA 02134617.254.8080
http://cdn-ecomm.dreamingcode.com/public/235/images/icn-fb-over-235-15949-1.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-yelp-over-235-15953-1.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-tw-over-235-15952-1.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-google-over-235-15950-1.png

Neighborhood/Town:
Rent:
Beds:
Min. Baths:
Sort By
30 Dalton Unit #0803
Boston
MA
02115
Neighborhood/Town:
Back Bay
Rent:
$6,248
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



1789 Commonwealth Ave. Unit #2
Boston
MA
02135
Neighborhood/Town:
Brighton
Rent:
$6,200
Beds:
7
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



1017 Tremont St. Unit #2
Boston
MA
02120
Neighborhood/Town:
South End
Rent:
$6,500
Beds:
5
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



50 Gloucester St. Unit #2
Boston
MA
02116
Neighborhood/Town:
Back Bay
Rent:
$6,400
Beds:
3
Baths:
2.5
Request Info
First Name:

Last Name:

Email:

Comments:



184 St. Paul Unit #3 copy
Brookline
MA
02446
Neighborhood/Town:
Brookline
Rent:
$6,350
Beds:
5
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



115 Franklin
Boston
MA
02135
Neighborhood/Town:
Allston
Rent:
$6,300
Beds:
7
Baths:
3
Request Info
First Name:

Last Name:

Email:

Comments:



101 Canal St. Unit #0201
Boston
MA
02114
Neighborhood/Town:
North End
Rent:
$6,295
Beds:
3
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



Huge 5 Bed/2 Bath in Prime BU location
81 Gibbs St. Unit #3 copy
Brookline
MA
02446
Neighborhood/Town:
Brookline
Rent:
$6,250
Beds:
5
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



81 Gibbs St. Unit #2 copy
Brookline
MA
02446
Neighborhood/Town:
Brookline
Rent:
$6,250
Beds:
5
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



11 Euston St. Unit #2 copy
Brookline
MA
02446
Neighborhood/Town:
Brookline
Rent:
$6,200
Beds:
5
Baths:
1.5
Request Info
First Name:

Last Name:

Email:

Comments:



11 Babcock Unit #1 copy
Brookline
MA
02446
Neighborhood/Town:
Brookline
Rent:
$6,200
Beds:
5
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



345 Harrison Ave. Unit #PH17
Boston
MA
02118
Neighborhood/Town:
South End
Rent:
$6,197
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



180 Brookline Ave. Unit #206
Boston
MA
02215
Neighborhood/Town:
The Fenway
Rent:
$6,147
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



66-68 Hooker St. Unit #66
Boston
MA
02134
Neighborhood/Town:
Allston
Rent:
$6,125
Beds:
4
Baths:
3
Request Info
First Name:

Last Name:

Email:

Comments:



1350 Boylston St. Unit #T0501
Boston
MA
02215
Neighborhood/Town:
The Fenway
Rent:
$6,113
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



44 Pratt
Boston
MA
02134
Neighborhood/Town:
Allston
Rent:
$6,100
Beds:
6
Baths:
3
Request Info
First Name:

Last Name:

Email:

Comments:



148 Thorndike St. Unit #Single
Brookline
MA
02446
Neighborhood/Town:
Brookline
Rent:
$6,100
Beds:
5
Baths:
3.5
Request Info
First Name:

Last Name:

Email:

Comments:



1443 Beacon Unit #616
Brookline
MA
02446
Neighborhood/Town:
Coolidge Corner
Rent:
$6,095
Beds:
2
Baths:
2.5
Request Info
First Name:

Last Name:

Email:

Comments:



32 Garrison St. Unit #107
Boston
MA
02116
Neighborhood/Town:
Back Bay
Rent:
$6,094
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



200 Brookline Ave. Unit #1515
Boston
MA
02215
Neighborhood/Town:
The Fenway
Rent:
$6,075
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



»
4
3 2 1
Page 4 of 150
2995 records found.
The Gateway Real Estate Group Inc.
139 Brighton Ave, Allston MA
MA 02134


617.254.8080

617.254.8877
Follow Us:

http://cdn-ecomm.dreamingcode.com/public/235/images/icn-fb-over-235-15949-1.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-yelp-over-235-15953-1.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-tw-over-235-15952-1.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-google-over-235-15950-1.png