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


RENTALS
 
Contact Us617.787.4350
http://cdn-ecomm.dreamingcode.com/public/235/images/icn-fb-over20150331071131.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-tw-over20150331071130.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-yelp-over20150331071129.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-pin-over20150331071129.png

Neighborhood/Town:
Rent:
Beds:
Sort By
Garrison St.
Boston
MA
02116
Neighborhood/Town:
Back Bay
Rent:
$4,317
Beds:
2
Baths:
2
First Name:

Last Name:

Email Address:

Phone:

Message:



Boylston St.
Boston
MA
02215
Neighborhood/Town:
The Fenway
Rent:
$4,320
Beds:
1
Baths:
1
First Name:

Last Name:

Email Address:

Phone:

Message:



Emerson Pl.
Boston
MA
02114
Neighborhood/Town:
West End
Rent:
$4,320
Beds:
2
Baths:
2
First Name:

Last Name:

Email Address:

Phone:

Message:



Brookline Ave.
Boston
MA
02215
Neighborhood/Town:
The Fenway
Rent:
$4,322
Beds:
1
Baths:
1
First Name:

Last Name:

Email Address:

Phone:

Message:



Boylston St.
Boston
MA
02215
Neighborhood/Town:
The Fenway
Rent:
$4,337
Beds:
1
Baths:
1
First Name:

Last Name:

Email Address:

Phone:

Message:



The Fenway
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$4,350
Beds:
3
Baths:
1
First Name:

Last Name:

Email Address:

Phone:

Message:



Hillside
Boston
MA
02120
Neighborhood/Town:
Mission Hill
Rent:
$4,350
Beds:
4
Baths:
1.5
First Name:

Last Name:

Email Address:

Phone:

Message:



Hemenway St.
Boston
MA
02115
Neighborhood/Town:
The Fenway
Rent:
$4,350
Beds:
3
Baths:
1
First Name:

Last Name:

Email Address:

Phone:

Message:



Phillips St.
Boston
MA
02114
Neighborhood/Town:
Beacon Hill
Rent:
$4,350
Beds:
3
Baths:
1.5
First Name:

Last Name:

Email Address:

Phone:

Message:



Phillips St.
Boston
MA
02114
Neighborhood/Town:
Beacon Hill
Rent:
$4,350
Beds:
3
Baths:
1
First Name:

Last Name:

Email Address:

Phone:

Message:



Phillips St.
Boston
MA
02114
Neighborhood/Town:
Beacon Hill
Rent:
$4,350
Beds:
3
Baths:
1.5
First Name:

Last Name:

Email Address:

Phone:

Message:



Evergreen St.
Boston
MA
02130
Neighborhood/Town:
Jamaica Plain
Rent:
$4,350
Beds:
4
Baths:
2
First Name:

Last Name:

Email Address:

Phone:

Message:



Boylston St.
Boston
MA
02199
Neighborhood/Town:
Back Bay
Rent:
$4,365
Beds:
2
Baths:
2
First Name:

Last Name:

Email Address:

Phone:

Message:



Washington St.
Boston
MA
02111
Neighborhood/Town:
Chinatown
Rent:
$4,365
Beds:
2
Baths:
2
First Name:

Last Name:

Email Address:

Phone:

Message:



Dalton
Boston
MA
02115
Neighborhood/Town:
Back Bay
Rent:
$4,366
Beds:
1
Baths:
1
First Name:

Last Name:

Email Address:

Phone:

Message:



Garrison St.
Boston
MA
02116
Neighborhood/Town:
Back Bay
Rent:
$4,367
Beds:
2
Baths:
2
First Name:

Last Name:

Email Address:

Phone:

Message:



Garrison St.
Boston
MA
02116
Neighborhood/Town:
Back Bay
Rent:
$4,367
Beds:
2
Baths:
2
First Name:

Last Name:

Email Address:

Phone:

Message:



Clarendon St.
Boston
MA
02116
Neighborhood/Town:
Back Bay
Rent:
$4,370
Beds:
1
Baths:
1
First Name:

Last Name:

Email Address:

Phone:

Message:



Devonshire Pl.
Boston
MA
02109
Neighborhood/Town:
Financial District
Rent:
$4,372
Beds:
2
Baths:
2
First Name:

Last Name:

Email Address:

Phone:

Message:



Columbus Ave.
Boston
MA
02118
Neighborhood/Town:
South End
Rent:
$4,375
Beds:
3
Baths:
1
First Name:

Last Name:

Email Address:

Phone:

Message:



»129 128 127
126
125 «
Page 126 of 152
3031 records found.
Venture Real Estate LLC
141C Brighton Ave,
Allston MA 02134


617.787.4350

617.787.6407
Follow Us:

http://cdn-ecomm.dreamingcode.com/public/235/images/icn-fb-over20150331071131.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-tw-over20150331071130.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-yelp-over20150331071129.pnghttp://cdn-ecomm.dreamingcode.com/public/235/images/icn-pin-over20150331071129.png