Page at line 943
126




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
50 Charlesgate E Unit #193
Boston
MA
02215
Neighborhood/Town:
The Fenway
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



115 Saint Stephen St. Unit #B-3
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



463 Park Dr. Unit #8
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$2,500
Beds:
2
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



226 Parker Hill Ave. Unit #15
Boston
MA
02120
Neighborhood/Town:
Mission Hill
Rent:
$2,500
Beds:
2
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



463 Park Dr. Unit #4
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



57 Westland Ave. Unit #5
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



null
65 Burbank St. Unit #15
Boston
MA
02116
Neighborhood/Town:
The Fenway
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



211 Park Dr. Unit #1
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



105 Queensberry St. Unit #1
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



57 Westland Ave. Unit #3
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



423 Shawmut Ave. Unit #23
Boston
MA
02118
Neighborhood/Town:
South End
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



161 Endicott St. Unit #1R
Boston
MA
02113
Neighborhood/Town:
North End
Rent:
$2,500
Beds:
2
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



220 Hanover St. Unit #24
Boston
MA
02113
Neighborhood/Town:
North End
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



24 Mount Vernon St. Unit #500
Boston
MA
02108
Neighborhood/Town:
Beacon Hill
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



24 Phillips St. Unit #1
Boston
MA
02114
Neighborhood/Town:
Beacon Hill
Rent:
$2,500
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



409 Marlborough St. Unit #21
Boston
MA
02116
Neighborhood/Town:
Back Bay
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



384 Commonwealth Ave. Unit #41
Boston
MA
02215
Neighborhood/Town:
Back Bay
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



429 Marlborough St. Unit #1
Boston
MA
02115
Neighborhood/Town:
Back Bay
Rent:
$2,500
Beds:
1
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



171 Beacon St. Unit #1F
Boston
MA
02116
Neighborhood/Town:
Back Bay
Rent:
$2,500
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



160 Cemtre St. Unit #3
Boston
MA
02119
Neighborhood/Town:
Fort Hill
Rent:
$2,500
Beds:
3
Baths:
1
Request Info
First Name:

Last Name:

Email:

Comments:



»129 128 127
126
125 «
Page 126 of 150
2997 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