Page at line 943
3




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
345 Harrison Ave. Unit #PH71
Boston
MA
02118
Neighborhood/Town:
South End
Rent:
$6,996
Beds:
3
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



1 Parker Hill Ter. Unit #3
Boston
MA
02120
Neighborhood/Town:
Mission Hill
Rent:
$6,965
Beds:
7
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



The pictures don't do this place any justice, Coolidge Corner, 2500sqf
38 Babcock St. Unit #3
Brookline
MA
02446
Neighborhood/Town:
Brookline
Rent:
$6,900
Beds:
5
Baths:
3
Request Info
First Name:

Last Name:

Email:

Comments:



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

Last Name:

Email:

Comments:



531 Newbury St. Unit #1
Boston
MA
02215
Neighborhood/Town:
Back Bay
Rent:
$6,800
Beds:
4
Baths:
3
Request Info
First Name:

Last Name:

Email:

Comments:



84 The Fenway Unit #B1
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$6,800
Beds:
5
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



53 Lawn St. Unit #2
Boston
MA
02120
Neighborhood/Town:
Mission Hill
Rent:
$6,775
Beds:
7
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



30 Dalton Unit #2402
Boston
MA
02115
Neighborhood/Town:
Back Bay
Rent:
$6,758
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



23 Symphony Rd. Unit #1
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$6,750
Beds:
5
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



448 Park Dr. Unit #4
Boston
MA
02215
Neighborhood/Town:
The Fenway
Rent:
$6,750
Beds:
5
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



30 Dalton Unit #2203
Boston
MA
02115
Neighborhood/Town:
Back Bay
Rent:
$6,748
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



1 Nashua St. Unit #3605
Boston
MA
02114
Neighborhood/Town:
West End
Rent:
$6,645
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



30 Dalton Unit #1903
Boston
MA
02115
Neighborhood/Town:
Back Bay
Rent:
$6,628
Beds:
2
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



50 Malden St. Unit #301
Boston
MA
02118
Neighborhood/Town:
South End
Rent:
$6,600
Beds:
3
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



486 Massachusetts Ave. Unit #2
Boston
MA
02118
Neighborhood/Town:
South End
Rent:
$6,600
Beds:
4
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



480 Massachusetts Ave. Unit #2
Boston
MA
02118
Neighborhood/Town:
South End
Rent:
$6,600
Beds:
4
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



1616 Beacon St. Unit #3
Brookline
MA
02446
Neighborhood/Town:
Washington Square
Rent:
$6,600
Beds:
4
Baths:
3
Request Info
First Name:

Last Name:

Email:

Comments:



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

Last Name:

Email:

Comments:



56 Garrison St. Unit #204
Boston
MA
02116
Neighborhood/Town:
Back Bay
Rent:
$6,574
Beds:
3
Baths:
2
Request Info
First Name:

Last Name:

Email:

Comments:



22 Beacon St. Unit #2
Boston
MA
02116
Neighborhood/Town:
Beacon Hill
Rent:
$6,500
Beds:
3
Baths:
3
Request Info
First Name:

Last Name:

Email:

Comments:



»4
3
2 1
Page 3 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