query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 = ? | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQLPARAMETERS |
|
Job Title | Location | Job Type | Category |
---|---|---|---|
Real Estate Agent - New Home Sales (Licensed)
Antioch, California - Northern
|
Antioch, California - Northern | Part-Time, Temporary | New Home Sales |
Licensed Real Estate Agent - New Home Sales Assistant
Bakersfield, California - Northern
|
Bakersfield, California - Northern | Part-Time, Temporary | Corporate Staffing |
Real Estate Agent - New Home Sales (Licensed)
Bethel Island, California - Northern
|
Bethel Island, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Chico, California - Northern
|
Chico, California - Northern | Part-Time, Temporary | New Home Sales |
Licensed Real Estate Agent - New Home Sales Assistant
Clovis, California - Northern
|
Clovis, California - Northern | Part-Time, Temporary | Corporate Staffing |
Assistant Community Manager
Daly City, California - Northern
|
Daly City, California - Northern | Full-Time | Corporate Staffing |
Branch Sales Manager Real Estate
Danville, California - Northern
|
Danville, California - Northern | Full-Time | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Dublin, California - Northern
|
Dublin, California - Northern | Part-Time, Temporary | Corporate Staffing |
Real Estate Agent - New Home Sales (Licensed)
El Dorado Hills, California - Northern
|
El Dorado Hills, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Elk Grove, California - Northern
|
Elk Grove, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Fairfield, CA , California - Northern
|
Fairfield, CA , California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Folsom, California - Northern
|
Folsom, California - Northern | Part-Time, Temporary | New Home Sales |
Licensed Real Estate Agent - New Home Sales Assistant
Fowler, California - Northern
|
Fowler, California - Northern | Part-Time, Temporary | Corporate Staffing |
Community Manager-LIHTC-TEMP
Fremont, California - Northern
|
Fremont, California - Northern | Full-Time | Corporate Staffing |
Maintenance Technician
Fresno, California - Northern
|
Fresno, California - Northern | Full-Time | Corporate Staffing |
Real Estate Agent-New Home Sales (Licensed)
Fresno, California - Northern
|
Fresno, California - Northern | Part-Time, Temporary | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Friant, California - Northern
|
Friant, California - Northern | Part-Time, Temporary | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Gilroy, California - Northern
|
Gilroy, California - Northern | Full-Time | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Gold River, California - Northern
|
Gold River, California - Northern | Full-Time | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Hayward, California - Northern
|
Hayward, California - Northern | Part-Time, Temporary | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Hollister, California - Northern
|
Hollister, California - Northern | Part-Time, Temporary | Corporate Staffing |
Real Estate Agent - New Home Sales (Licensed)
Lathrop, California - Northern
|
Lathrop, California - Northern | Full-Time | New Home Sales |
New Home Sales Assistant
Lincoln, California - Northern
|
Lincoln, California - Northern | Part-Time, Temporary | New Home Sales |
Licensed Real Estate Agent - New Home Sales Assistant
Madera, California - Northern
|
Madera, California - Northern | Part-Time, Temporary | Corporate Staffing |
Real Estate Agent - New Home Sales (Licensed)
Manteca, California - Northern
|
Manteca, California - Northern | Part-Time, Temporary | New Home Sales |
New Home Sales Assistant
Merced, California - Northern
|
Merced, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Mountain House, California - Northern
|
Mountain House, California - Northern | Part-Time, Temporary | New Home Sales |
Leasing Consultant-Hospitality Professional
Mountain View, California - Northern
|
Mountain View, California - Northern | Full-Time | Corporate Staffing |
Maintenance Tech - Apartment Turns & Work Orders
Mountain View, California - Northern
|
Mountain View, California - Northern | Part-Time, Temporary | Maintenance |
Apartment Leasing Consultant
Napa, California - Northern
|
Napa, California - Northern | Full-Time, Temporary | Multi-Family |
Maintenance Tech/Handyman (Apartments)
Napa, California - Northern
|
Napa, California - Northern | Full-Time, Temporary | Multi-Family |
Apartment Tax Credit Assistant
Oakland , California - Northern
|
Oakland , California - Northern | Full-Time, Temporary | Multi-Family |
Real Estate Agent - New Home Sales (Licensed)
Oroville, California - Northern
|
Oroville, California - Northern | Part-Time, Temporary | New Home Sales |
Licensed Real Estate Agent - New Home Sales Assistant
Oxnard, California - Northern
|
Oxnard, California - Northern | Part-Time, Temporary | Corporate Staffing |
Assistant Community Manager
Palo Alto, CA, California - Northern
|
Palo Alto, CA, California - Northern | Full-Time | Corporate Staffing |
IT Support Technician-Property Management
Palo Alto, CA, California - Northern
|
Palo Alto, CA, California - Northern | Full-Time | Corporate Staffing |
Porter/Janitor-Apartments
Palo Alto, CA, California - Northern
|
Palo Alto, CA, California - Northern | Full-Time | Corporate Staffing |
Real Estate Agent - New Home Sales (Licensed)
Pleasanton, California - Northern
|
Pleasanton, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Plumas Lake, California - Northern
|
Plumas Lake, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Rancho Cordova, California - Northern
|
Rancho Cordova, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Redding, California - Northern
|
Redding, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Rocklin, California - Northern
|
Rocklin, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Rohnert Park, California - Northern
|
Rohnert Park, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Roseville, California - Northern
|
Roseville, California - Northern | Part-Time, Temporary | New Home Sales |
Administrative Assistant Residential
Sacramento, California - Northern
|
Sacramento, California - Northern | Full-Time | Corporate Staffing |
Front Desk Clerk
Sacramento, California - Northern
|
Sacramento, California - Northern | Full-Time | Corporate Staffing |
Leasing Consultant - Hospitality Professional
Sacramento, California - Northern
|
Sacramento, California - Northern | Part-Time, Temporary | Multi-Family |
Licensed Real Estate Agent - New Home Sales Assistant
Sacramento, California - Northern
|
Sacramento, California - Northern | Full-Time | Corporate Staffing |
Maintenance Tech - Apartment Turns & Work Orders
Sacramento, California - Northern
|
Sacramento, California - Northern | Full-Time, Temporary | Maintenance |
Apartment Tax Credit Assistant
San Francisco, California - Northern
|
San Francisco, California - Northern | Full-Time, Temporary | Multi-Family |
Administrative Assistant-Bilingual English & Spanish (Property Management)
San Jose, California - Northern
|
San Jose, California - Northern | Full-Time | Corporate Staffing |
Administrative Assistant-Bilingual English and Spanish (Property Management)
San Jose, California - Northern
|
San Jose, California - Northern | Full-Time | Corporate Staffing |
Apartment Porter/Janitor
San Jose, California - Northern
|
San Jose, California - Northern | Full-Time, Temporary | Multi-Family |
Assistant Community Manager- LIHTC (Affordable Housing)
San Jose, California - Northern
|
San Jose, California - Northern | Full-Time | Corporate Staffing |
Leasing Consultant
San Jose, California - Northern
|
San Jose, California - Northern | Full-Time | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
San Jose, California - Northern
|
San Jose, California - Northern | Part-Time, Temporary | Corporate Staffing |
Maintenance Tech/Handyman (Apartments)
San Jose, California - Northern
|
San Jose, California - Northern | Full-Time, Temporary | Maintenance |
Maintenance Tech/Handyman (Apartments)
Santa Clara, California - Northern
|
Santa Clara, California - Northern | Full-Time, Temporary | Maintenance |
Admin Assistant-Property Management
Santa Cruz, California - Northern
|
Santa Cruz, California - Northern | Full-Time | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Santa Cruz, California - Northern
|
Santa Cruz, California - Northern | Part-Time, Temporary | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Santa Rosa, California - Northern
|
Santa Rosa, California - Northern | Part-Time, Temporary | Corporate Staffing |
Maintenance Technician
Seaside, CA, California - Northern
|
Seaside, CA, California - Northern | Full-Time | Corporate Staffing |
Real Estate Agent - New Home Sales (Licensed)
Stockton, California - Northern
|
Stockton, California - Northern | Part-Time, Temporary | New Home Sales |
Leasing Consultant
Sunnyvale, California - Northern
|
Sunnyvale, California - Northern | Full-Time | Corporate Staffing |
Leasing Consultant
Sunnyvale, California - Northern
|
Sunnyvale, California - Northern | Full-Time | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Sunnyvale, California - Northern
|
Sunnyvale, California - Northern | Part-Time, Temporary | Corporate Staffing |
Maintenance Technician
Sunnyvale, California - Northern
|
Sunnyvale, California - Northern | Full-Time | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Tulare, California - Northern
|
Tulare, California - Northern | Part-Time, Temporary | Corporate Staffing |
Real Estate Agent - New Home Sales (Licensed)
Vacaville, California - Northern
|
Vacaville, California - Northern | Part-Time, Temporary | New Home Sales |
Real Estate Agent - New Home Sales (Licensed)
Vallejo, California - Northern
|
Vallejo, California - Northern | Part-Time, Temporary | New Home Sales |
Licensed Real Estate Agent - New Home Sales Assistant
Visalia, California - Northern
|
Visalia, California - Northern | Part-Time, Temporary | Corporate Staffing |
Licensed Real Estate Agent - New Home Sales Assistant
Woodland, California - Northern
|
Woodland, California - Northern | Part-Time, Temporary | Corporate Staffing |
Real Estate Agent - New Home Sales (Licensed)
Yuba City, California - Northern
|
Yuba City, California - Northern | Part-Time, Temporary | New Home Sales |
Apartment Custodian/Janitor – Day Porter
Anaheim, California - Southern
|
Anaheim, California - Southern | Part-Time, Temporary | Maintenance |
Apartment Leasing Consultant
Anaheim, California - Southern
|
Anaheim, California - Southern | Part-Time, Temporary | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
Anaheim, California - Southern
|
Anaheim, California - Southern | Part-Time, Temporary | Maintenance |
New Home Sales Assistant
Anaheim, California - Southern
|
Anaheim, California - Southern | Part-Time, Temporary | New Home Sales |
Senior Fund Accountant
Century City, California - Southern
|
Century City, California - Southern | Full-Time | Corporate Staffing |
Apartment Leasing Consultant (Experienced)
Corona, California - Southern
|
Corona, California - Southern | Full-Time, Temporary | Multi-Family |
Licensed Real Estate Agent - New Home Sales Assistant
Corona, California - Southern
|
Corona, California - Southern | Part-Time, Temporary | New Home Sales |
Maintenance Tech - Apartment Turns & Work Orders
Corona, California - Southern
|
Corona, California - Southern | Full-Time | Maintenance |
Apartment Leasing Consultant
Costa Mesa, California - Southern
|
Costa Mesa, California - Southern | Part-Time, Temporary | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
Costa Mesa, California - Southern
|
Costa Mesa, California - Southern | Full-Time | Maintenance |
Apartment Leasing Consultant (Experienced)
Downtown San Diego, California - Southern
|
Downtown San Diego, California - Southern | Part-Time, Temporary | Multi-Family |
Assistant Community Manager
El Monte, California - Southern
|
El Monte, California - Southern | Full-Time | Corporate Staffing |
Lead Maintenance Technician
Encinitas, California - Southern
|
Encinitas, California - Southern | Full-Time | Maintenance |
Apartment Leasing Consultant
Hollywood, California - Southern
|
Hollywood, California - Southern | Full-Time | Multi-Family |
Custodian/Day Porter - Apartments
Hollywood, California - Southern
|
Hollywood, California - Southern | Part-Time, Temporary | Maintenance |
Maintenance Tech - Apartment Turns & Work Orders
Hollywood, California - Southern
|
Hollywood, California - Southern | Part-Time, Temporary | Multi-Family |
Community Manager
Huntington Beach, California - Southern
|
Huntington Beach, California - Southern | Full-Time | Corporate Staffing |
Community Manager
Indio, California - Southern
|
Indio, California - Southern | Full-Time | Corporate Staffing |
Apartment Custodian/Janitor – Day Porter
Irvine, California - Southern
|
Irvine, California - Southern | Part-Time, Temporary | Maintenance |
Apartment Leasing Consultant
Irvine, California - Southern
|
Irvine, California - Southern | Full-Time | Multi-Family |
Jr. Marketing Coordinator
Irvine, California - Southern
|
Irvine, California - Southern | Full-Time | Corporate Staffing |
Maintenance Tech - Apartment Turns & Work Orders
Irvine, California - Southern
|
Irvine, California - Southern | Part-Time, Temporary | Maintenance |
New Home Sales Assistant
Irvine, California - Southern
|
Irvine, California - Southern | Part-Time, Temporary | New Home Sales |
Recruitment Assistant-Entry-Level
Irvine, California - Southern
|
Irvine, California - Southern | Full-Time | Corporate Staffing |
Staffing/Scheduling Coordinator
Irvine, California - Southern
|
Irvine, California - Southern | Full-Time | Corporate Staffing |
Commercial Property Manager
La Jolla, California - Southern
|
La Jolla, California - Southern | Full-Time | Other |
Maintenance Technician
La Jolla, California - Southern
|
La Jolla, California - Southern | Full-Time | Maintenance |
Apartment Leasing Consultant (Experienced)
Los Angeles, California - Southern
|
Los Angeles, California - Southern | Full-Time, Temporary | Multi-Family |
Entry Level Property Manager
Los Angeles, California - Southern
|
Los Angeles, California - Southern | Full-Time | Other |
Maintenance Tech - Apartment Turns & Work Orders
Los Angeles, California - Southern
|
Los Angeles, California - Southern | Full-Time, Temporary | Multi-Family |
Apartment Leasing Consultant
Los Angeles County, California - Southern
|
Los Angeles County, California - Southern | Part-Time, Temporary | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
Los Angeles County, California - Southern
|
Los Angeles County, California - Southern | Full-Time | Maintenance |
Apartment Leasing Consultant
Mission Viejo, California - Southern
|
Mission Viejo, California - Southern | Full-Time | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
Mission Viejo, California - Southern
|
Mission Viejo, California - Southern | Full-Time | Maintenance |
New Home Sales Assistant
Mission Viejo, California - Southern
|
Mission Viejo, California - Southern | Part-Time, Temporary | New Home Sales |
Apartment Custodian/Janitor – Day Porter
Ontario, California - Southern
|
Ontario, California - Southern | Part-Time, Temporary | Maintenance |
Apartment Leasing Consultant
Ontario, California - Southern
|
Ontario, California - Southern | Full-Time | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
Ontario, California - Southern
|
Ontario, California - Southern | Part-Time, Temporary | Maintenance |
Apartment Custodian/Janitor – Day Porter
Orange, California - Southern
|
Orange, California - Southern | Part-Time, Temporary | Maintenance |
Apartment Leasing Consultant
Orange, California - Southern
|
Orange, California - Southern | Part-Time, Temporary | Multi-Family |
Licensed Real Estate Agent - New Home Sales
Orange, California - Southern
|
Orange, California - Southern | Part-Time, Temporary | New Home Sales |
Maintenance Tech - Apartment Turns & Work Orders
Orange, California - Southern
|
Orange, California - Southern | Part-Time, Temporary | Maintenance |
Real Estate Listing Coordinator
Orange, California - Southern
|
Orange, California - Southern | Full-Time | Corporate Staffing |
Apartment Leasing Consultant
Orange County, California - Southern
|
Orange County, California - Southern | Part-Time, Temporary | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
Orange County, California - Southern
|
Orange County, California - Southern | Full-Time | Corporate Staffing |
Outside Sales Representative
Orange County, California - Southern
|
Orange County, California - Southern | Full-Time | Corporate Staffing |
Apartment Leasing Consultant (Experienced)
Pasadena, California - Southern
|
Pasadena, California - Southern | Part-Time, Temporary | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
Pasadena, California - Southern
|
Pasadena, California - Southern | Full-Time | Maintenance |
Apartment Leasing Consultant
Pomona, California - Southern
|
Pomona, California - Southern | Full-Time | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
Pomona, California - Southern
|
Pomona, California - Southern | Part-Time, Temporary | Maintenance |
Apartment Custodian/Janitor – Day Porter
Riverside, California - Southern
|
Riverside, California - Southern | Part-Time, Temporary | Maintenance |
Apartment Leasing Consultant
Riverside, California - Southern
|
Riverside, California - Southern | Part-Time, Temporary | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
Riverside, California - Southern
|
Riverside, California - Southern | Part-Time, Temporary | Maintenance |
New Home Sales - Licensed Real Estate Agent
Riverside, California - Southern
|
Riverside, California - Southern | Part-Time, Temporary | New Home Sales |
Apartment Leasing Consultant
San Bernardino, California - Southern
|
San Bernardino, California - Southern | Full-Time | Multi-Family |
Custodian/Day Porter - Apartments
San Bernardino, California - Southern
|
San Bernardino, California - Southern | Full-Time, Temporary | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
San Bernardino, California - Southern
|
San Bernardino, California - Southern | Full-Time, Temporary | Maintenance |
Apartment Custodian/Janitor – Day Porter
San Diego, California - Southern
|
San Diego, California - Southern | Full-Time, Temporary | Maintenance |
Apartment Leasing Consultant
San Diego, California - Southern
|
San Diego, California - Southern | Part-Time, Temporary | Multi-Family |
Maintenance Tech/Handyman – Apartment Turns & Work Orders
San Diego, California - Southern
|
San Diego, California - Southern | Full-Time, Temporary | Maintenance |
Commercial Property Manager
Santa Monica, California - Southern
|
Santa Monica, California - Southern | Full-Time | Corporate Staffing |
Assistant Community Manager
Santee, California - Southern
|
Santee, California - Southern | Full-Time | Corporate Staffing |
Apartment Leasing Consultant (Experienced)
West Hollywood, California - Southern
|
West Hollywood, California - Southern | Full-Time, Temporary | Multi-Family |
Maintenance Tech - Apartment Turns & Work Orders
West Hollywood, California - Southern
|
West Hollywood, California - Southern | Full-Time | Maintenance |