Java assignment
Property ID,Vendor ID,Contract Date,Status,Marketing Fee,Commission 1,29,2020-11-21,Sold,4957,0.02 2,44,2020-11-30,Sold,2051,0.04 3,32,2020-10-26,Sold,4532,0.08 4,6,2020-11-07,Sold,2460,0.05 5,18,2020-10-12,Sold,3805,0.04 6,24,2020-11-16,Sold,4090,0.06 7,17,2020-11-07,Sold,4709,0.08 8,34,2020-12-02,Sold,3319,0.02 9,49,2020-11-09,Sold,1601,0.03 10,47,2020-11-28,Sold,4864,0.06 11,25,2020-10-20,Sold,4658,0.03 12,45,2020-10-16,Withdrawn,3368,0.06 13,50,2020-11-12,Sold,2524,0.08 14,27,2020-11-06,Sold,4737,0.07 15,58,2020-10-31,Sold,1535,0.08 16,21,2020-10-20,Sold,1840,0.08 17,2,2020-09-30,For Sale,3071,0.07 18,40,2020-10-23,Sold,912,0.03 19,41,2020-10-11,Sold,4817,0.05 20,42,2020-11-16,Sold,2854,0.02 21,56,2020-10-13,Sold,863,0.08 22,43,2020-11-06,Sold,4172,0.02 23,35,2020-10-21,Sold,3127,0.06 24,38,2020-11-13,Sold,2505,0.03 25,1,2020-10-25,Sold,4711,0.07 26,16,2020-10-20,Sold,2441,0.02 27,37,2020-12-16,Sold,3942,0.02 28,52,2020-09-30,Sold,4252,0.08 29,36,2020-10-05,Sold,855,0.04 30,19,2020-12-09,Sold,2069,0.02 30,50,2020-01-05,Sold,1745,0.07 31,12,2020-11-06,Sold,4912,0.02 32,30,2020-11-04,Sold,4293,0.06 33,11,2020-11-20,Withdrawn,3944,0.04 34,14,2020-11-11,Sold,3115,0.02 35,3,2020-10-26,Sold,4574,0.02 36,13,2020-10-16,Sold,1542,0.05 37,51,2020-10-14,Sold,1082,0.03 38,5,2020-10-13,Sold,4128,0.02 39,26,2020-10-29,Sold,3033,0.07 40,8,2020-12-02,For Sale,3663,0.05 41,39,2020-11-22,Sold,1529,0.04 42,7,2020-10-30,Sold,2695,0.08 42,22,2019-05-02,Sold,3594,0.04 43,46,2020-11-03,Withdrawn,3038,0.07 44,22,2020-10-25,Sold,4597,0.02 45,48,2020-11-02,Sold,3742,0.07 46,31,2020-11-05,Sold,2790,0.02 47,59,2020-11-10,For Sale,1747,0.03 48,33,2020-10-17,Sold,1184,0.08 49,23,2020-11-23,Sold,3169,0.07 50,54,2020-11-06,Sold,1041,0.06 51,28,2020-10-20,Sold,2563,0.08 52,4,2020-11-09,Sold,952,0.05 53,55,2020-10-28,Withdrawn,4361,0.03 53,55,2019-03-03,Withdrawn,4035,0.02 54,9,2020-11-22,For Sale,2888,0.05 55,20,2020-09-30,Withdrawn,3850,0.04 56,60,2020-10-16,Sold,1998,0.02 57,15,2020-11-14,Sold,1832,0.04 58,53,2020-10-10,For Sale,4686,0.03 59,57,2020-11-07,Sold,2166,0.07 60,10,2020-10-25,Sold,1756,0.02 61,1,2020-11-19,Sold,2842,0.04 61,8,2019-10-08,Sold,2234,0.04 62,4,2020-11-10,Sold,4705,0.05 63,23,2020-09-08,Sold,4999,0.06 64,9,2020-10-25,Sold,4802,0.06 65,54,2020-09-21,Sold,1010,0.06 66,33,2020-10-17,Sold,1051,0.07 67,59,2020-10-05,Sold,2378,0.08 68,8,2020-11-25,Withdrawn,1472,0.05 69,60,2020-10-10,Sold,2207,0.05 70,16,2020-11-07,Sold,4879,0.03 71,17,2020-09-08,Sold,4313,0.08 72,9,2020-08-29,Sold,4495,0.02 Property ID,Street Num,Street,Suburb,Bedrooms,Bathrooms,Car spaces,Property Type,Floorspace,Landsize 12,55/92-120,Cleveland St,Chippendale,1,1,0,Apartment,40,200 23,2/27-31,Regent St,Chippendale,1,1,0,Apartment,42,449 49,90,Lord St,Newtown,1,1,0,House,43,89 13,5/13-21,Abercrombie St,Chippendale,1,1,0,Apartment,44,577 2,B611/89,Bay St,Glebe,1,1,0,Apartment,45,778 64,21,Lambert St,Erskineville,1,1,0,House,50,115 3,B110/5,Hadfields St,Erskineville,1,1,0,Apartment,52,84 24,2/124,Redfern St,Redfern,1,1,0,Apartment,60,915 25,19/1a,Gowie St,Newtown,1,1,0,Apartment,72,1500 66,13,Devine St,Erskineville,1,1,0,House,87,164 28,11/48-52,Darley St,Newtown,1,1,1,Apartment,36,1250 27,12/20-24,Sheehy St,Glebe,1,1,1,Apartment,37,607 34,Unit 16/10,Avona Avenue,Glebe,1,1,1,Apartment,38,710 32,10/252,Abercrombie St,Redfern,1,1,1,Apartment,51,300 14,49/60-68,City Rd,Chippendale,1,1,1,Apartment,51,1851 18,321-323,Abercrombie St,Darlington,1,1,3,House,80,320 26,17/60-68,City Rd,Chippendale,1,2,1,Apartment,72,1851 59,42,Egan St,Newtown,2,1,0,House,60,96 54,67,Caroline St,Redfern,2,1,0,House,60,57 48,91,Ross St,Forest Lodge,2,1,0,House,60,193 22,3/164,Glebe Pt Rd,Glebe,2,1,0,Apartment,60,467 68,6,Douglas St,Redfern,2,1,0,House,62,76 62,32,Union St,Erskineville,2,1,0,House,69,120 65,18,Thomas St,Darlington,2,1,0,House,75,82 46,127,Rochford St,Erskineville,2,1,0,House,80,127 6,75a,Rochford St,Erskineville,2,1,0,House,80,120 51,84,Lord St,Newtown,2,1,0,House,84,111 42,170,Lord St,Newtown,2,1,0,House,94,125 11,6/81-83,St Johns Road,Glebe,2,1,1,Apartment,50,1342 35,Unit 5/5,Munni St,Newtown,2,1,1,Apartment,73,988 53,77,Burren St,Newtown,2,1,1,House,88,177 29,11/2a,Forsyth St,Glebe,2,1,1,Apartment,94,2087 47,92,Lennox St,Newtown,2,1,1,House,100,127 45,129,Rochford St,Erskineville,2,1,1,House,110,129 41,179,Denison St,Newtown,2,1,1,House,120,127 71,3,Turner St,Redfern,2,2,0,House,97,67 17,328/14,Griffin Pl,Glebe,2,2,1,Apartment,60,1000 8,6709/177-219,Mitchell Rd,Erskineville,2,2,1,Apartment,74,3026 21,30/21,Coulson St,Erskineville,2,2,1,Apartment,78,127 52,82,Darling St,Glebe,2,2,1,House,80,101 38,Unit 4/64,Lawson Sq,Redfern,2,2,1,Apartment,80,501 19,3212/2,Nassau Lane,Erskineville,2,2,1,Apartment,83,127 20,314/70,Macdonald St,Erskineville,2,2,1,Apartment,96,1500 15,413/221,Sydney Park Rd,Erskineville,2,2,1,Apartment,117,4000 4,812/70,Macdonald St,Erskineville,2,2,1,Apartment,118,1500 37,Unit 6/84,Wentworth Park Road,Glebe,2,2,1,Apartment,118,120 1,G1505/780,Bourke St,Redfern,2,2,1,Apartment,128,4421 16,355/221-229,Sydney Park Rd,Erskineville,2,2,1,Apartment,155,4000 9,610/1,Pearl St,Erskineville,2,2,2,Apartment,86,136 10,606/33,Bridge St,Erskineville,2,2,2,Apartment,137,2000 72,1,Turner St,Redfern,3,1,0,House,98,78 56,55,Baptist St,Redfern,3,1,0,House,108,102 60,42,Sheperd St,Chippendale,3,1,0,House,138,114 58,45,Rose St,Chippendale,3,1,1,House,107,108 63,26,Watkin St,Newtown,3,1,1,House,136,133 67,7,John St,Erskineville,3,1,1,House,143,171 69,5,Lord St,Newtown,3,2,0,House,80,221 33,1/134,Lennox St,Newtown,3,2,0,Apartment,97,97 39,681,South Dowling St,Redfern,3,2,0,House,119,171 30,101/32,Alice St,Newtown,3,2,1,Apartment,106,132 43,150,Abercrombie St,Redfern,3,2,1,House,176,136 31,100/249,Chalmers St,Redfern,3,2,2,Apartment,149,1500 7,707/5,Hadfields St,Erskineville,3,3,2,Apartment,96,84 40,500,Wilson St,Darlington,4,1,1,House,120,133 5,7a,Glebe St,Glebe,4,2,1,House,128,112 70,3,Leamington Ave,Newtown,4,2,1,House,138,133 55,58,Vine St,Darlington,4,2,1,House,207,112 36,Unit 1/1,Maddison St,Redfern,4,2,2,Apartment,292,6119 44,139,Wells St,Newtown,4,2,4,House,186,544 57,54,Pearl St,Newtown,4,3,1,House,110,120 61,36,Bellevue St,Glebe,4,3,1,House,147,139 50,86,City Rd,Chippendale,7,2,1,House,220,215 Property ID,Vendor ID,Sale Price,Sale Type,Sale Date 1,29,1425000,Private Treaty,2021-01-15 2,44,610000,Private Treaty,2020-12-29 3,32,712000,Private Treaty,2020-12-17 4,6,1232500,Prior to Auction,2020-12-12 5,18,1802000,Private Treaty,2020-12-11 6,24,1330000,Private Treaty,2020-12-15 8,34,915000,Private Treaty,2020-12-10 9,49,1370000,Private Treaty,2021-01-06 10,47,1331500,Private Treaty,2020-12-09 11,25,775000,Private Treaty,2021-01-13 13,50,605000,Auction,2020-11-28 14,27,580000,Prior to Auction,2020-11-27 15,58,880000,Private Treaty,2020-12-11 16,21,1030000,Private Treaty,2020-12-09 18,40,2650000,Auction,2020-12-19 19,41,1180000,Private Treaty,2020-12-07 20,42,1120000,Auction,2020-11-28 21,56,835000,Auction,2020-12-05 22,43,770000,Prior to Auction,2020-12-10 23,35,525000,Private Treaty,2020-12-23 24,38,710000,Auction,2020-12-12 25,1,785000,Auction,2020-12-12 26,16,901000,Private Treaty,2020-11-28 27,37,640000,Private Treaty,2020-12-15 28,52,552000,Private Treaty,2020-12-23 29,36,1100000,Private Treaty,2020-12-03 30,19,1300000,Private Treaty,2021-01-15 30,50,1350000,Auction,2020-02-08 31,12,2755000,Auction,2020-11-28 32,30,692000,Prior to Auction,2020-12-03 34,14,630000,Private Treaty,2021-01-14 35,3,851000,Auction,2020-12-05 36,13,1200000,Prior to Auction,2020-12-18 37,51,1170000,Private Treaty,2021-01-15 38,5,801000,Auction,2020-12-12 39,26,1430000,Auction,2020-12-03 41,39,1300000,Auction,2020-12-05 42,7,1240000,Private Treaty,2020-12-09 42,22,1100000,Private Treaty,2019-05-28 44,22,3100000,Auction,2020-12-05 45,48,1490000,Auction,2020-12-12 46,31,1390000,Private Treaty,2021-01-11 48,33,1390000,Private Treaty,2021-01-14 49,23,880000,Prior to Auction,2020-12-09 50,54,2015000,Auction,2020-12-05 51,28,1180000,Private Treaty,2020-12-16 52,4,1527000,Auction,2020-12-12 56,60,1875000,Private Treaty,2020-12-15 57,15,1885000,Auction,2020-12-12 59,57,1230000,Auction,2020-12-09 60,10,1610000,Private Treaty,2021-01-06 61,1,2300000,Private Treaty,2020-12-04 61,8,2000000,Private Treaty,2019-11-08 62,4,1210000,Auction,2020-12-05 63,23,2180000,Auction,2020-12-12 64,9,1200000,Auction,2020-12-05 65,54,1360000,Private Treaty,2021-01-07 66,33,1465000,Auction,2020-11-28 67,59,1750000,Auction,2020-12-07 69,60,1600000,Auction,2020-12-12 70,16,2085000,Private Treaty,2020-12-08 71,17,1450000,Private Treaty,2020-12-15 72,9,1600000,Private Treaty,2020-12-23 ID,First Name,Surname,Phone Number,Email Address 29,Catherin,Aguele,07-6476-1399,
[email protected] 44,Trina,Bakey,07-5922-1983,
[email protected] 32,Maybelle,Bewley,07-9387-7293,
[email protected] 6,Leandro,Bolka,03-8157-4609,
[email protected] 18,Kathryn,Bonalumi,08-3071-2258,
[email protected] 24,Noelia,Brackett,08-3773-3770,
[email protected] 17,Eveline,Brickhouse,03-9517-9800,
[email protected] 34,Veronika,Buchauer,02-4202-5191,
[email protected] 49,Jean,Cecchinato,08-5263-2786,
[email protected] 47,Amira,Chudej,07-8135-3271,
[email protected] 25,Christene,Cisney,03-3630-2467,
[email protected] 45,Royal,Costeira,07-5338-6357,
[email protected] 50,Jospeh,Couzens,03-8451-7537,
[email protected] 27,Fidelia,Dampier,02-8035-9997,
[email protected] 58,Lenora,Delacruz,02-7862-5151,
[email protected] 21,Ling,Dibello,07-1330-6750,
[email protected] 2,Rebbecca,Didio,03-8174-9123,
[email protected] 40,Miles,Feldner,07-8561-5894,
[email protected] 41,Katlyn,Flitcroft,07-1778-9968,
[email protected] 42,Catrice,Fowlkes,07-9032-5149,
[email protected] 56,Lacey,Francis,07-4119-3981,
[email protected] 43,Linsey,Gedman,07-4785-3781,
[email protected] 35,Tommy,Gennusa,02-5444-1961,
[email protected] 38,Aide,Ghera,02-3738-7508,
[email protected] 1,Ronald,Grube,08-3305-5436,
[email protected] 16,Ngoc,Guglielmina,08-2264-5559,
[email protected] 37,Stevie,Hallo,07-9997-3366,
[email protected] 52,Na,Hodges,08-8215-1588,
[email protected] 36,Kent,Ivans,07-8661-4016,
[email protected] 19,Theron,Jarding,08-6890-4661,
[email protected] 12,Rosendo,Jelsma,08-7712-4785,
[email protected] 30,Jeniffer,Jezek,03-3268-5102,
[email protected] 11,Gwen,Julye,03-7063-6734,
[email protected] 14,Sherill,Klar,08-6522-8931,
[email protected] 3,Barb,Latina,08-8506-7259,
[email protected] 13,Lynda,Lazzaro,03-4933-4205,
[email protected] 51,Kirby,Litherland,07-5284-3845,
[email protected] 5,Paulina,Maker,08-8344-8929,
[email protected]