| 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] |
Fresno |
2024-03-04 00:00:00.0 |
1900-01-01 00:00:00.0 |
[empty string] |
[empty string] |
[empty string] |
1611 |
1 |
Full-Time |
5 |
California - Northern |
11 |
11 |
Fresno |
<h5>Looking for your next Maintenance Tech position? We have multiple opportunities readily available!</h5>
<p>We’re hiring Maintenance Techs with basic experience in plumbing, electrical, and general maintenance that can complete apartment turnovers/make-readies and work orders.</p>
<p>Full-time, temp-to-hire, and temporary opportunities with Property Management Companies looking for skilled, responsible, customer-service oriented, and dependable Maintenance Technicians like you!</p>
<h5><strong>Why JWilliams Staffing:</strong></h5>
<ul>
<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 (driving to multiple apartments in a day)</li>
<li>We personally do the leg work for you when it comes to finding your next job opportunity</li>
</ul>
<p><em>Experience as Handy-man, Independent Contractor, Hotel Engineer, in Construction and other similar Service Technician roles encouraged to apply!</em></p>
<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/Grounds keeping work during downtime or as needed.</li>
</ul>
<h5><strong>Requirements:</strong></h5>
<ul>
<li>Preferred 3 years residential maintenance experience</li>
<li>HVAC experience required</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. Advanced or specialized equipment provided.)</li>
</ul>
<h5><strong>Schedule</strong>: Tuesday - Saturday</h5>
<h5><em><strong>Apply TODAY for consideration!</strong></em></h5>
<p><em>---------------------------------------</em><br />
<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.</em></p>
<p> </p> |
[empty string] |
California |
Maintenance Technician |
93650 |
93650 |
|
| 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 = ? |
