| RESULTSET |
| query |
| |
ADDRESS |
CITY |
DATEADDED |
DATEENDING |
DUTIES |
DUTIESINTRO |
EXTERNALLINK |
ID |
JOBSTYPEID |
JOBSTYPENAME |
LOCATIONID |
LOCATIONNAME |
METROAREAID |
METROAREAID |
METROAREANAME |
REQUIREMENTS |
SHORTDESCRIPTION |
STATE |
TITLE |
ZIP |
ZIP |
| 1 |
[empty string] |
[empty string] |
2024-09-11 00:00:00.0 |
1900-01-01 00:00:00.0 |
[empty string] |
[empty string] |
[empty string] |
1660 |
4 |
Part-Time, Temporary |
2 |
Arizona |
325 |
325 |
North Scottsdale |
<p>Have you ever considered working with a Temporary Staffing Agency to launch your career? Many people do! In fact, nine out of ten people said that temporary staffing work made them more employable according to a study done by the American Staffing Association.</p>
<h5><strong>So, how can JWilliams Staffing help you? By providing you with Temporary Leasing Consultant Assignments!</strong></h5>
<p>Joining JWilliams as a Leasing Consultant means you’ll gain valuable experience to add to your resume and get your foot in the door with several communities until you find a direct-hire position with a company you love. We offer our leasing candidates placement assistance, coaching, resume advice, access to our online training platform, and personalized ongoing guidance so they excel on site. Many of our talented candidates land full-time positions by working temporary assignments. Apply today for immediate consideration!</p>
<p><strong>Pay Rate:</strong> $18.00/hr</p>
<h5><strong>Responsibilities of the Temporary Leasing Consultant:</strong></h5>
<ul>
<li>Greet prospective & current residents, providing excellent customer service</li>
<li>Answer calls and inquiries in the leasing office</li>
<li>Set appointments for prospects to visit the community and apartments</li>
<li>Present the apartment community, ultimately assisting in sales</li>
<li>Qualify leads to help generate prospects for the community</li>
<li>Assist residents with service requests and general questions about the community and home</li>
</ul>
<h5> </h5>
<h5><strong>The Ideal Temporary Leasing Consultant Will Have:</strong></h5>
<ul>
<li>1+ years’ experience as a Leasing Consultant</li>
<li>Professional demeanor</li>
<li>Strong written & verbal communication</li>
<li>Outgoing personality matched with great enthusiasm</li>
<li>Organized and resourceful nature</li>
<li>A passion to serve</li>
<li>Proficiency with computers and property management software</li>
</ul>
<p>**THESE ARE TEMPORARY AND TEMP-TO-HIRE POSITIONS**</p>
<h5><em>Send in your resume TODAY for consideration!</em> <em>We would love the opportunity to help you succeed in your new career!</em></h5>
<p>-------------------------------------------------------</p>
<p><em>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. JWilliams Staffing participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the US. JWilliams Staffing complies with all federal E-Verify rules and responsibilities, and provides required federal postings in an electronic format to all candidates and employees via the JWS online portal.</em></p> |
[empty string] |
[empty string] |
Apartment Leasing Consultant (Experienced) |
[empty string] |
[empty string] |
|
| 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 = ? |
