query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQL | SELECT A.ID, A.MetroAreaID, A.Title, A.Duties, A.Requirements, A.ExternalLink, A.ShortDescription, A.DateAdded, A.DateEnding, A.DutiesIntro, B.ID AS LocationID, B.Name AS LocationName, C.Name AS MetroAreaName, C.ID AS MetroAreaID, C.Zip, C.City, C.State, A.JobsTypeID, JobsType.Name AS JobsTypeName, c.address, c.zip FROM Jobs AS A INNER JOIN JobsType ON A.JobsTypeID = JobsType.ID LEFT OUTER JOIN MetroArea AS C ON A.MetroAreaID = C.ID LEFT OUTER JOIN Locations AS B ON C.LocationID = B.ID Where a.id = ? | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQLPARAMETERS |
|
Our client, a well-established residential property management company, is seeking an energetic multi-family Property Manager to join their team. This is an excellent opportunity to grow your career within a successful company who is willing to train the right candidate!
We are looking for someone who is eager to learn, has excellent time management ability, and will work well under pressure in this exciting, fast-paced environment. Apply today for immediate consideration!
Salary: From $45,000.00 per year
-------------------------------------------------------------
JWilliams Staffing, Inc. An Equal Opportunity Employer M/F/Disability/Veterans.
Qualified applicants with criminal histories will be considered for employment in a manner consistent with Federal, state and local laws, including but not limited to local Fair Chance Ordinances.