File /var/www/html/realestate.dreamingcode.com/plugins/content-inline/plugin_propertylistings.class.php
Line 1582



whereclause
 ( DCExp_RentalPropertyListings.SystemClientID = 243 OR DCExp_RentalPropertyListings.SystemClientID = 0 )  AND (DCExp_RentalPropertyListings.PropertyListingFeedID IN ( 2,5,0 )) AND (DCExp_RentalPropertyListings.CommunityID IN (7)) AND DCExp_RentalPropertyListings.PropertyStatusID NOT IN  (25,8,18,9,19,22,7,6,17)



dbo.DCExp_Client_RentalPropertyListing_Search
@OrderBy, Price DESC, SQLVARCHAR
@Page, 1, SQLINT4
@RecsPerPage, 9, SQLINT4
@WhereClause, ( DCExp_RentalPropertyListings.SystemClientID = 243 OR DCExp_RentalPropertyListings.SystemClientID = 0 ) AND (DCExp_RentalPropertyListings.PropertyListingFeedID IN ( 2,5,0 )) AND (DCExp_RentalPropertyListings.CommunityID IN (7)) AND DCExp_RentalPropertyListings.PropertyStatusID NOT IN (25,8,18,9,19,22,7,6,17) AND DCExp_RentalPropertyListings.PropertyStatusID NOT IN (25,8,18,9,19,22,7,6,17), SQLVARCHAR
Rental Listings
 
image map example

Neighborhood/Town:
Rent:
Beds:
Min. Baths:
Available Date:
77 South St
Boston
MA
02130
Rent:
$3,650
Beds:
3
Baths:
2
Square Footage:
1,250
Send Us a Message






3155 Washington Street
Boston
MA
02130
Rent:
$3,625
Beds:
3
Baths:
1
Square Footage:
1,170
Send Us a Message






27 Eliot
Boston
MA
02090
Rent:
$4,500
Beds:
2
Baths:
1
Square Footage:
1,912
Send Us a Message






58 Mozart St
Boston
MA
02130
Rent:
$4,500
Beds:
5
Baths:
2
Square Footage:
1,400
Send Us a Message






139 Perkins Street
Boston
MA
02130
Rent:
$4,250
Beds:
3
Baths:
2
Square Footage:
1,550
Send Us a Message






197 Green St
Boston
MA
02130
Rent:
$4,000
Beds:
2
Baths:
2
Square Footage:
435
Send Us a Message






419 South Huntington Ave
Boston
MA
02130
Rent:
$3,800
Beds:
3
Baths:
1
Square Footage:
1,200
Send Us a Message






21 Malcolm Rd
Boston
MA
02130
Rent:
$3,750
Beds:
3
Baths:
1
Square Footage:
2,273
Send Us a Message






138 Chestnut Ave
Boston
MA
02130
Rent:
$3,700
Beds:
2
Baths:
2
Square Footage:
1,750
Send Us a Message






4 3 2
1
Page 1 of 5
39 records found.