Page at line 943
79




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
Call Street
Boston
MA
Neighborhood/Town:
Jamaica Plain
Beds:
3
Baths:
2
Price:
$1,149,000
Request Info
First Name:

Last Name:

Email:

Comments:



Symphony
Boston
MA
Neighborhood/Town:
The Fenway
Beds:
3
Baths:
1
Price:
$1,149,000
Request Info
First Name:

Last Name:

Email:

Comments:



South St
Boston
MA
Neighborhood/Town:
Roslindale
Beds:
5
Baths:
1
Price:
$1,145,000
Request Info
First Name:

Last Name:

Email:

Comments:



South St
Boston
MA
Neighborhood/Town:
Roslindale
Price:
$1,145,000
Request Info
First Name:

Last Name:

Email:

Comments:



Munroe Street
Boston
MA
Neighborhood/Town:
Roxbury
Beds:
6
Baths:
4
Price:
$1,145,000
Request Info
First Name:

Last Name:

Email:

Comments:



Seaport Boulevard
Boston
MA
Neighborhood/Town:
Seaport District
Beds:
1
Baths:
1
Price:
$1,140,000
Request Info
First Name:

Last Name:

Email:

Comments:



Chestnut
Boston
MA
Neighborhood/Town:
Charlestown
Beds:
3
Baths:
2
Price:
$1,139,000
Request Info
First Name:

Last Name:

Email:

Comments:



Seaport Boulevard
Boston
MA
Neighborhood/Town:
Seaport District
Beds:
1
Baths:
1
Price:
$1,135,800
Request Info
First Name:

Last Name:

Email:

Comments:



Seaport Boulevard
Boston
MA
Neighborhood/Town:
Seaport District
Beds:
1
Baths:
1
Price:
$1,131,000
Request Info
First Name:

Last Name:

Email:

Comments:



Seaport Boulevard
Boston
MA
Neighborhood/Town:
Seaport District
Beds:
1
Baths:
1
Price:
$1,130,700
Request Info
First Name:

Last Name:

Email:

Comments:



»
79
78 77 76 75 «
Page 79 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