Page at line 943
136




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
River Street
Boston
MA
Neighborhood/Town:
Hyde Park
Beds:
5
Baths:
2
Price:
$770,000
Request Info
First Name:

Last Name:

Email:

Comments:



Floyd St.
Boston
MA
Neighborhood/Town:
Dorchester
Beds:
8
Baths:
2
Price:
$769,900
Request Info
First Name:

Last Name:

Email:

Comments:



B St
Boston
MA
Neighborhood/Town:
South Boston
Beds:
1
Baths:
1
Price:
$769,000
Request Info
First Name:

Last Name:

Email:

Comments:



W 8Th St
Boston
MA
Neighborhood/Town:
South Boston
Beds:
2
Baths:
2
Price:
$769,000
Request Info
First Name:

Last Name:

Email:

Comments:



N Street
Boston
MA
Neighborhood/Town:
South Boston
Beds:
2
Baths:
1
Price:
$769,000
Request Info
First Name:

Last Name:

Email:

Comments:



Sullivan Street
Boston
MA
Neighborhood/Town:
Charlestown
Beds:
2
Baths:
1
Price:
$769,000
Request Info
First Name:

Last Name:

Email:

Comments:



Holton Street
Boston
MA
Neighborhood/Town:
Brighton
Beds:
4
Baths:
3
Price:
$769,000
Request Info
First Name:

Last Name:

Email:

Comments:



Holyoke Street
Boston
MA
Neighborhood/Town:
South End
Beds:
1
Baths:
1
Price:
$769,000
Request Info
First Name:

Last Name:

Email:

Comments:



Bowman Street
Boston
MA
Neighborhood/Town:
Dorchester's Neponset
Beds:
2
Baths:
2
Price:
$769,000
Request Info
First Name:

Last Name:

Email:

Comments:



S Russell St
Boston
MA
Neighborhood/Town:
Beacon Hill
Beds:
2
Baths:
1
Price:
$769,000
Request Info
First Name:

Last Name:

Email:

Comments:



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