Connection to the database successful Greenfields Rental Management






-- Branches --
BranchNoPhoneStreetCityZip
b14881110101100 Lafayette St.Santa Clara95050
b24882220202200 El CaminoSanta Clara95050
b34883330303300 Bascom Ave.Santa Clara95050
b44884440404400 Market St.Santa Clara95050
b54885550505500 Bellomy St.Santa Clara95050


-- Properties --
PropID Supervisor ID Branch Owner Street City Zip Rooms Rent Status Date Available
p1s51b5John Smith930 Race St.San Bruno954542900available01-JUL-16
p2s41b4Ali Peters550 Market St.Santa Clara950501925available01-JUL-16
p3s31b3Hannah Wright231 El CaminoSan Jose951252925available23-JUL-16
p5s21b2Hannah Williams775 Bellomy St.Santa Clara950501925available12-JUL-16
p6s11b1Sally Waters774 Bellomy St.Santa Clara950501725available01-JUL-16
p7s22b2Brooke Wiley112 Poplar St.Los Gatos950511925available01-JUL-16
p4s32b3Brooke Latham830 Lafayette St.Santa Clara950504850available21-JUL-16


-- Employees --
BranchNo EmpID Name Phone Number Role Date of Hire
b1m11Alex Hoff9252128829manager10-JAN-10
b1s11Halle Huff6129984108supervisor10-FEB-10
b1s12Elizabeth Smith4254493304supervisor11-FEB-11
b1e11Sam Smith6123491029employee11-MAR-12
b1e12Mike Munson9382039283employee07-APR-13
b1e13Mary Olson1229847283employee23-JAN-13
b2m22Greg Fay3039907191manager16-JAN-09
b2s21Bob Olson1029330222supervisor16-JAN-10
b2s22Sam Singer1203028883supervisor26-FEB-11
b2e21Shane Nelson2930028383employee26-MAR-11
b2e22Garrett Nelson2039992203employee07-MAY-12
b2e23Molly Callahan3840291102employee14-FEB-13
b3m33Aleisha Nelson6123608061manager10-APR-08
b3s31John Smith7281928345supervisor01-APR-09
b3s32Hope Wright2078413154supervisor14-FEB-10
b3e31Carrie Christensen8273992293employee14-FEB-11
b3e32Kevin Larpenteur9283732938employee10-JAN-11
b3e33Sean Griffin6120948392employee10-JAN-11
b4m44Jane Smith6510232883manager10-FEB-09
b4s41Sara Pollei6517658867supervisor11-MAR-10
b4s42Taylor Lamkin9283272837supervisor18-MAR-10
b4e41Jack Lundquist6510293888employee11-MAR-11
b4e42Cole Rued8172939228employee12-MAR-11
b4e43Sarah Haley8279482232employee30-MAR-12
b4e44Katie Keunster7162229182employee20-MAR-12
b5m55Aaron Madden8089274028manager16-JAN-10
b5s51Joe Neumeyer2088416087supervisor16-AUG-10
b5s52Cody Lee8082583645supervisor26-FEB-11
b5e51Mike Rudolf5187631166employee26-MAR-11
b5e52Christian Woodruff5037051023employee01-APR-12


--Owners --
Name Address Phone
Dessa BokidesAlameda Way, Gilroy 923524259930234
Geralyn Nelson5290 Lexington St. Los Altos 551266128680419
Jake Hendricks915 Harden Dr. San Jose, 951254259992122
Jennifer Olson915 Ford Pkwy, Los Altos 551266123928343
Elizabeth Stevens321 Alameda Way, Santa Clara, 950509872192332


-- Lease Agreements --
Lease ID Prop ID Renter Name Home Phone Work Phone Friend Friend's Phone Start Date End Date Deposit Rent/Mo.
1202p1Jason VanMeter91829912122391110292Ben Smith123923002901-MAR-1612-AUG-16325900
1303p2Aleisha Nelson61236006116517658826Halle Huff612039229330-MAY-1630-AUG-16350925
1404p4Greg Fay91822819289128229102Alex Hoff129111002025-MAY-1629-AUG-16325925
1505p5Aleisha Nelson61236006116517658826Halle Huff612039229330-JUN-1630-AUG-16325925
1205p1Bill James12322233332122222222Phil Rames333444555501-JAN-1601-SEP-1612005000
1222p3Ricardo2342352324234223Manuel234234201-JAN-1601-SEP-1612224545