dbo.DCExp_Client_RentalPropertyListing_Search
@OrderBy, Price DESC, SQLVARCHAR
@Page, 1, SQLINT4
@RecsPerPage, 12, SQLINT4
@WhereClause, ( DCExp_RentalPropertyListings.SystemClientID = 235 OR DCExp_RentalPropertyListings.SystemClientID = 0 ) AND (DCExp_RentalPropertyListings.PropertyListingFeedID IN ( 2,0 )) AND DCExp_RentalPropertyListings.Price >= 2000 AND DCExp_RentalPropertyListings.Price <= 8000 AND (DCExp_RentalPropertyListings.CommunityID IN (10,11) OR DCExp_RentalPropertyListings.CityID IN (12)) AND DCExp_RentalPropertyListings.PropertyStatusID NOT IN (8,18,9,20,4,19,22,7,26,5,6,17,12,1,2) AND DCExp_RentalPropertyListings.PropertyStatusID NOT IN (8,18,9,20,4,19,22,7,26,5,6,17,12,1,2), SQLVARCHAR
Rentals
 
Rent remotely! Offering video/3D tours along with virtual signing and payments options.

Neighborhood/Town:
Rent:
Min. Beds:
Griggs Pl. Unit #copy
Allston
MA
02134
Rent:
$7,000
Beds:
6
Baths:
3






Browne St Unit #1
Brookline
MA
02446
Rent:
$7,000
Beds:
6
Baths:
3






St. Paul St Unit #2
Brookline
MA
02446
Rent:
$6,500
Beds:
5
Baths:
2






Babcock Unit #2
Brookline
MA
02446
Rent:
$6,250
Beds:
5
Baths:
2






Babcock Unit #3
Brookline
MA
02446
Rent:
$6,250
Beds:
5
Baths:
2






Babcock St Unit #1
Brookline
MA
02446
Rent:
$5,500
Beds:
4
Baths:
3






Glenville
Allston
MA
02134
Rent:
$5,500
Beds:
4
Baths:
3






Long Ave. Unit #2
Allston
MA
02134
Rent:
$5,500
Beds:
5
Baths:
3






Large Renovated Unit. Pats Friendly, In-Unit Laundry, Parking
Long Ave. Unit #2
Allston
MA
02134
Rent:
$5,500
Beds:
5
Baths:
3






5 Bd on Holman St., 3 Bath, Living Room, Laundry in Unit, Open Layout
Holman St. Unit #1
Allston
MA
02134
Rent:
$5,300
Beds:
5
Baths:
3






Euston St Unit #3
Brookline
MA
02446
Rent:
$5,300
Beds:
5
Baths:
1.5






l
Beacon Unit #5 copy
Brookline
MA
02446
Rent:
$5,300
Beds:
4
Baths:
2






»4 3 2
1
Page 1 of 41
483 records found.