Page at line 943
158




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
Gainsborough St
Boston
MA
Neighborhood/Town:
The Fenway
Beds:
2
Baths:
1
Price:
$699,000
Request Info
First Name:

Last Name:

Email:

Comments:



Norway Street
Boston
MA
Neighborhood/Town:
The Fenway
Beds:
1
Baths:
1
Price:
$699,000
Request Info
First Name:

Last Name:

Email:

Comments:



Gainsborough St
Boston
MA
Neighborhood/Town:
The Fenway
Beds:
1
Baths:
1
Price:
$699,000
Request Info
First Name:

Last Name:

Email:

Comments:



Columbus Avenue
Boston
MA
Neighborhood/Town:
South End
Beds:
1
Baths:
1
Price:
$699,000
Request Info
First Name:

Last Name:

Email:

Comments:



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

Last Name:

Email:

Comments:



E India Row
Boston
MA
Neighborhood/Town:
Waterfront
Beds:
1
Baths:
1
Price:
$699,000
Request Info
First Name:

Last Name:

Email:

Comments:



Broad Street
Boston
MA
Neighborhood/Town:
Waterfront
Beds:
1
Baths:
1
Price:
$699,000
Request Info
First Name:

Last Name:

Email:

Comments:



Saint Gregory St.
Boston
MA
Neighborhood/Town:
Dorchester
Beds:
4
Baths:
2
Price:
$699,000
Request Info
First Name:

Last Name:

Email:

Comments:



Cedar St
Boston
MA
Neighborhood/Town:
Roxbury's Fort Hill
Beds:
4
Baths:
2
Price:
$699,000
Request Info
First Name:

Last Name:

Email:

Comments:



8Th St
Boston
MA
Neighborhood/Town:
Charlestown's Navy Yard
Beds:
2
Baths:
2
Price:
$699,000
Request Info
First Name:

Last Name:

Email:

Comments:



»159
158
157 156 155 «
Page 158 of 264
2635 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