| 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-03-06 00:00:00.0 |
1900-01-01 00:00:00.0 |
[empty string] |
[empty string] |
[empty string] |
1643 |
1 |
Full-Time |
8 |
Nevada |
330 |
330 |
Carson City |
<h5><strong>Builders’ choice for new home sales staffing? JWilliams Staffing!</strong></h5>
<p>Temporary sales assistant assignments are your stepping stone into an exciting and lucrative career with a new home builder. This role is the perfect way to gain both experience and exposure, working with several new home builders to find your ideal match.</p>
<p><strong>Start the New Year with a new career in New Home Sales!</strong></p>
<h5><strong>Responsibilities:</strong></h5>
<ul>
<li>Assist the on-site sales team in coordinating all aspects of presenting homes to prospective buyers.</li>
<li>Establish rapport with prospective buyers to determine their immediate housing needs</li>
<li>Obtain contact/follow-up information from prospective buyers visiting the community.</li>
<li>Provide excellent customer service to real estate sales agents and prospective buyers.</li>
</ul>
<h5><strong>Requirements:</strong></h5>
<ul>
<li><strong>Must have a valid California Real Estate License and be willing to it move to JWS</strong></li>
<li>Strong verbal and written communication skills</li>
<li>Professional dress and demeanor</li>
<li>Desire to excel in team oriented environment</li>
<li>Reliable transportation</li>
</ul>
<h5><strong>With JWS, you’ll receive…</strong></h5>
<ul>
<li>Opportunity & Exposure in the Homebuilding Industry</li>
<li>Flexible Scheduling</li>
<li>Recruiter Representation</li>
<li>Free Online Education</li>
<li>Mentoring & Ongoing Guidance</li>
</ul>
<p><em>**Candidates must be willing to transfer their license to the JWilliams Staffing brokerage. Please note that these are temporary and temp-to-hire positions**</em></p>
<h5><strong>Apply today for immediate consideration!</strong></h5>
<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. </em>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.</p> |
[empty string] |
[empty string] |
Licensed Real Estate Agent - New Home Sales Assistant |
[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 = ? |
