Page at line 943
135




Recs pe page at line 944
10




Where Clause at line 945
 ( DCExp_SalesPropertyListings.SystemClientID = 235 OR DCExp_SalesPropertyListings.SystemClientID = 0 )  AND ( DCExp_SalesPropertyListings.CityID IN (1,12) OR DCExp_SalesPropertyListings.CommunityID IN (10,248,249,11,114,117,130,254,251,252) )  AND DCExp_SalesPropertyListings.PropertyStatusID NOT IN  (8,18,9,3,19,24,7,5,6,17,12,1,2)


Allston, Brighton, Brookline Homes for Sale | 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:
Beds:
Price:
Sort By
Kenney St
Boston
MA
Neighborhood/Town:
Jamaica Plain
Beds:
3
Baths:
1
Price:
$775,000
Request Info
First Name:

Last Name:

Email:

Comments:



Washington St
Boston
MA
Neighborhood/Town:
Jamaica Plain
Beds:
6
Baths:
2
Price:
$775,000
Request Info
First Name:

Last Name:

Email:

Comments:



Robey St
Boston
MA
Neighborhood/Town:
Roxbury
Beds:
3
Baths:
3
Price:
$775,000
Request Info
First Name:

Last Name:

Email:

Comments:



Station St.
Brookline
MA
Neighborhood/Town:
Brookline Village
Price:
$775,000
Request Info
First Name:

Last Name:

Email:

Comments:



W Eagle st.
Boston
MA
Neighborhood/Town:
East Boston
Beds:
6
Baths:
3
Price:
$775,000
Request Info
First Name:

Last Name:

Email:

Comments:



Cass St
Boston
MA
Neighborhood/Town:
West Roxbury
Beds:
7
Baths:
3
Price:
$774,999
Request Info
First Name:

Last Name:

Email:

Comments:



Rockland St
Boston
MA
Neighborhood/Town:
West Roxbury
Price:
$774,900
Request Info
First Name:

Last Name:

Email:

Comments:



Shawmut Ave
Boston
MA
Neighborhood/Town:
South End
Beds:
2
Baths:
1
Price:
$774,000
Request Info
First Name:

Last Name:

Email:

Comments:



Stanton Road
Brookline
MA
Neighborhood/Town:
Brookline Hills
Beds:
3
Baths:
1
Price:
$774,000
Request Info
First Name:

Last Name:

Email:

Comments:



Avery St
Boston
MA
Neighborhood/Town:
Midtown
Beds:
2
Baths:
2
Price:
$770,000
Request Info
First Name:

Last Name:

Email:

Comments:



»139 138 137 136
135
«
Page 135 of 263
2626 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