| 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] |
2019-04-05 00:00:00.0 |
1900-01-01 00:00:00.0 |
[empty string] |
[empty string] |
[empty string] |
630 |
4 |
Part-Time, Temporary |
6 |
California - Southern |
199 |
199 |
Costa Mesa |
<h5><strong>We’re looking for experienced leasing consultants to fill temporary, temp-to-hire, and direct-placement positions in the apartment industry – apply today!</strong></h5>
<p>JWilliams Staffing is the temporary staffing agency of choice for those seeking career opportunities in residential property management. We partner with some of the most prominent apartment communities in the industry to help them find leasing superstars for their high-end leasing offices; you could be one of them!</p>
<p> </p>
<p><strong>Pay rate: </strong>$18-$22/hr</p>
<p> </p>
<h5><strong>Why JWilliams Staffing?</strong></h5>
<p>Joining JWilliams Staffing is an ideal way to progress your career in the apartment industry. We have a strong reputation with the industry’s leading property management companies and will provide you with:</p>
<ul>
<li>Career coaching and resume advice</li>
<li>Access to our online training platform for leasing, tax credit, and fair housing</li>
<li>Placement assistance</li>
<li>Personalized ongoing guidance and feedback so you excel on site</li>
<li>The opportunity to get your foot in the door with several communities until you find a full-time, direct hire position with a company you love!</li>
</ul>
<p> </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>
<p> </p>
<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> </p>
<h5><strong><em>Send in your resume TODAY for consideration!</em></strong> <em>We would love the opportunity to help you succeed in your new career!</em></h5>
<p> </p>
<p>-------------------------------------------------------</p>
<p><em>JWilliams Staffing, Inc. An Equal Opportunity Employer M/F/Disability/Veterans.</em></p>
<p><em>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 |
[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 = ? |
