INSERT INTO Client_Page_Stats( PageID, ViewDate) VALUES ( 3, #CreateODBCDateTime(TodaysDate)#) SELECT Distinct(City) FROM RIUnitListings WHERE OrgID = 3 AND Active = 2 SELECT DISTINCT RIUnitListings.Bedrooms, RIBedrooms.BedroomText FROM (RIUnitListings INNER JOIN RIBedrooms ON RIBedrooms.BedroomID = RIUnitListings.Bedrooms) WHERE RIUnitListings.OrgID = 3 AND RIUnitListings.Active = 2 SELECT RIUnitListings.ListingID, RIUnitListings.City, RIUnitListings.UnitType, RIUnitListings.ComplexID, RIUnitListings.Available, RIUnitListings.RIActive, RIUnitListings.Bedrooms, RIUnitListings.Rent, RIUnitListings.SquareFt, RIBathrooms.BathroomText, RIBedrooms.BedroomText, RIBathrooms.BathroomText, RILeases.LeaseText, RIUnitTypes.UnitTypeText, RIUnitListings.Dog, RIUnitListings.Cat, RIUnitListings.Caged, RIComplexes.Dog AS CDog, RIComplexes.Cat AS CCat, RIComplexes.Caged AS CCaged, (SELECT Count(*) FROM Unit_Images WHERE Unit_Images.ListingID = RIUnitListings.ListingID) AS TotalImages, (SELECT Count(*) FROM Unit_VirtualTours WHERE Unit_VirtualTours.ListingID = RIUnitListings.ListingID) AS TotalVTs, (SELECT Count(*) FROM Unit_FloorPlans WHERE Unit_FloorPlans.ListingID = RIUnitListings.ListingID) AS TotalFPs FROM (RIUnitListings INNER JOIN RIBedrooms ON RIBedrooms.BedroomID = RIUnitListings.Bedrooms) INNER JOIN RILeases ON RILeases.LeaseID = RIUnitListings.Lease INNER JOIN RIBathrooms ON RIBathrooms.BathroomID = RIUnitListings.Bathrooms INNER JOIN RIUnitTypes ON RIUnitTypes.UnitTypeID = RIUnitListings.UnitType LEFT OUTER JOIN RIComplexes ON RIComplexes.ComplexID = RIUnitListings.ComplexID WHERE RIUnitListings.OrgID = 3 AND RIUnitListings.Active = 2 AND RIUnitListings.Bedrooms = #Form.BedroomStart# AND (RIUnitListings.Cat = 1 OR RIComplexes.Cat = 1) AND (RIUnitListings.Caged = 1 OR RIComplexes.Caged = 1) AND (RIUnitListings.Dog = 1 OR RIComplexes.Dog = 1) ORDER BY RIUnitListings.Rent asc, RIUnitListings.Available asc SELECT RIUnitListings.ListingID, RIUnitListings.City, RIUnitListings.UnitType, RIUnitListings.ComplexID, RIUnitListings.Available, RIUnitListings.RIActive, RIUnitListings.Bedrooms, RIUnitListings.Rent, RIBathrooms.BathroomText, RIUnitListings.SquareFt, RIBedrooms.BedroomText, RILeases.LeaseText, RIUnitTypes.UnitTypeText, RIUnitListings.Dog, RIUnitListings.Cat, RIUnitListings.Caged, RIComplexes.Dog AS CDog, RIComplexes.Cat AS CCat, RIComplexes.Caged AS CCaged, (SELECT Count(*) FROM Unit_Images WHERE Unit_Images.ListingID = RIUnitListings.ListingID) AS TotalImages, (SELECT Count(*) FROM Unit_VirtualTours WHERE Unit_VirtualTours.ListingID = RIUnitListings.ListingID) AS TotalVTs, (SELECT Count(*) FROM Unit_FloorPlans WHERE Unit_FloorPlans.ListingID = RIUnitListings.ListingID) AS TotalFPs FROM (RIUnitListings INNER JOIN RIBedrooms ON RIBedrooms.BedroomID = RIUnitListings.Bedrooms) INNER JOIN RILeases ON RILeases.LeaseID = RIUnitListings.Lease INNER JOIN RIBathrooms ON RIBathrooms.BathroomID = RIUnitListings.Bathrooms INNER JOIN RIUnitTypes ON RIUnitTypes.UnitTypeID = RIUnitListings.UnitType LEFT OUTER JOIN RIComplexes ON RIComplexes.ComplexID = RIUnitListings.ComplexID WHERE RIUnitListings.OrgID = 3 AND RIUnitListings.Active = 2 AND RIUnitListings.Bedrooms = #Form.Bedrooms# AND (RIUnitListings.Cat = 1 OR RIComplexes.Cat = 1) AND (RIUnitListings.Caged = 1 OR RIComplexes.Caged = 1) AND (RIUnitListings.Dog = 1 OR RIComplexes.Dog = 1) ORDER BY RIUnitListings.Rent asc, RIUnitListings.Available asc

			Any Cat Caged Dog
					view
#DollarFormat(Rent)#	#BedroomText#	#BathroomText#	Cats  Dogs  Caged	#DateFormat(Available, "mm/dd/yyyy")#