| 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-02-15 00:00:00.0 |
1900-01-01 00:00:00.0 |
[empty string] |
[empty string] |
[empty string] |
1602 |
1 |
Full-Time |
5 |
California - Northern |
459 |
459 |
Seaside, CA |
<h5>Looking to grow in your maintenance career? We are hiring several experienced Maintenance Technicians for temporary and temp-to-hire jobs at premier apartment communities.</h5>
<h5><em>If you are skilled, responsible, and customer service oriented, apply today for immediate consideration!</em></h5>
<h5><strong>Why JWilliams Staffing:</strong></h5>
<ul>
<li>Competitive pay DOE</li>
<li>Up to 40 hours a week</li>
<li>Weekly pay</li>
<li>Convenient commute and schedule</li>
<li>NO on-call, buying material from hardware stores, or roving</li>
<li>Progress your career with exposure to premier companies</li>
<li>We personally do the leg work for you when it comes to finding your next job opportunity</li>
</ul>
<h5><strong>Primary Responsibilities:</strong></h5>
<ul>
<li>Apartment turnover/make-ready.</li>
<li>General handyman/maintenance experience: basic plumbing, basic electric, light carpentry, painting, & patching drywall Exterior preventative maintenance</li>
<li>Complete turnovers and work-orders in an effective and timely manner</li>
<li>Work under direction of Property Manager or Maintenance Supervisor</li>
<li>Porter/Groundskeeping work during downtime or as needed</li>
</ul>
<h5><strong>Requirements:</strong></h5>
<ul>
<li>Two years of experience as an Apartment Maintenance/Service Tech strongly desired; hotel engineer, commercial and retail maintenance welcomed to apply!</li>
<li>Experience with residential plumbing, electrical, hardware installation, painting, troubleshooting & repairs, and other general maintenance</li>
<li>Basic tools required (All material will be provided; specialized equipment provided)</li>
<li>Not required but a plus: Experience in HVAC, carpentry, and appliance repair & troubleshooting</li>
</ul>
<h5><strong>We would love the opportunity to help you advance your career – submit your resume today for consideration!</strong></h5>
<p><em>---------------------------------------</em></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>
<p> </p>
<p>Job Types: Full-time, Part-time, Temporary</p>
<p>Salary: $23.00 - $25.00 per hour</p>
<p>Schedule:</p>
<p> </p>
<ul>
<li>8 hour shift</li>
</ul>
<p> </p>
<p>Application Question(s):</p>
<p> </p>
<ul>
<li>Do you understand that JWilliams Staffing works with apartment communities to fill temporary, temp-to-hire, and direct placement job opportunities? (reply yes to confirm)</li>
</ul>
<p> </p>
<p>Experience:</p>
<p> </p>
<ul>
<li>Maintenance: 1 year (Required)</li>
</ul>
<p> </p>
<p>Ability to Relocate:</p>
<p> </p>
<ul>
<li>Seaside, CA: Relocate before starting work (Required)</li>
</ul>
<p> </p>
<p>Work Location: In person</p> |
[empty string] |
[empty string] |
Maintenance Technician |
[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 = ? |
