Exp19_Access_Ch08_HOEAssessment - Real 1.0

profilethomast2093
Thomas_Exp19_Access_Ch8_HOEAssessment_Real.accdb
Home>Computer Science homework help>Exp19_Access_Ch08_HOEAssessment - Real 1.0
AgentID FirstName LastName HomePhone Title CellPhone PerformanceReview
1 Juan Rosario-Galarce 228-9999 President 224-0000 NA
2 Kia Hart 222-9999 Senior Age 224-0001 Excellent
3 Student_Name Student_Name 226-9999 Agent 224-0002 Good
4 Ko-Yun Yang 221-9999 Agent 224-0003 Good
5 Steven Lookabil 222-0000 Agent Trai 224-0004 Satisfactory
6 Angela Scott 228-0000 Agent Trai 223-0005 Good
ID mSysRowId
1 X03CnOhiChgUkSukPcbydjuUF886NokYSbcBRhxYa28=-~B7lSwd4vb2YxyL7D+W5R5w==
Listing DateListed DateSold ListPrice SalePrice SqFeet Beds Baths Address SubDivisionID City Sold SellingAgent ListingAgent Style Construction Garage Year Built Roof mSysRowId
10010.0 6/23/20 9/14/20 72500.0 68000 1030.0 3.0 1.0   214 Merrydale 3 Dale City true 2 3 Ranch Brick 2 Car Detached 2000.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10011.0 6/24/20 9/15/20 85000.0 84500 500.0 2.0 1.0   209 Avondale 3 Dale City true 3 2 2 Story Frame 1 Car Detached 1979.0 Slate BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10020.0 7/23/20 8/15/20 108000.0 99000 1080.0 3.0 2.0   4514 Merrydale 3 Dale City true 4 2 Ranch Brick 2 Car Detached 2000.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10025.0 7/25/20 9/16/20 112900.0 107500 864.0 3.0 1.0   2037 Hillendale 3 Dale City true 1 2 Ranch Brick 1 Car Attached 2000.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10027.0 8/25/20 10/17/20 115000.0 114000 1102.0 3.0 1.0   2035 Wedgewood 14 Wood Town true 1 4 2 Story Frame 1 Car Detached 1979.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10035.0 8/13/20 10/18/20 125990.0 124350 1280.0 4.0 2.0   39238 Wedgewood 14 Wood Town true 2 3 Split Level Stone 2 Car Attached 1977.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10043.0 9/2/20 10/19/20 129500.0 125000 1305.0 2.0 1.0   537 Copperwood 14 Wood Town true 3 2 Ranch Brick 1 Car Attached 1987.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10044.0 9/3/20 10/20/20 129900.0 126000 938.0 3.0 1.0   3903 Wedgewood 14 Wood Town true 6 2 Split Level Frame 2 Car Detached 2011.0 Slate BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10046.0 9/4/20 10/21/20 130000.0 128950 1184.0 3.0 2.0   2128 Wedgewood 14 Wood Town true 5 2 Ranch Stone 1 Car Detached 2012.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10047.0 9/5/20 10/22/20 131000.0 125000 1482.0 2.0 2.0   423 Welterwood 14 Wood Town true 4 5 2 Story Brick Carport 2007.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10059.0 9/5/20 10/23/20 135500.0 126000 1688.0 4.0 2.0   2039 Redwood 14 Wood Town true 5 1 Split Foyer Frame 3 Car Attached 1992.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10064.0 9/5/20 10/24/20 138773.0 128950 1709.0 4.0 2.0   39236 Edgewood 14 Wood Town true 4 4 Ranch Stone 1 Car Detached 2000.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10067.0 9/5/20 10/25/20 139900.0 135000 1562.0 3.0 2.0   361 Pinewood 14 Wood Town true 3 2 Split Level Brick 2 Car Attached 2012.0 Slate BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10082.0 9/18/20 10/26/20 146500.0 146400 970.0 2.0 1.0   240 Copperwood 14 Wood Town true 2 5 Ranch Frame 1 Car Attached 2000.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10095.0 9/22/20 10/27/20 151000.0 149000 1008.0 3.0 2.0   604 Ridgewood 14 Wood Town true 1 6 2 Story Stone 2 Car Detached 1979.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10114.0 9/24/20 10/28/20 155000.0 155000 1552.0 3.0 2.0   145 Cove Point 1 Northern Heights true 1 6 Split Foyer Brick 1 Car Detached 1977.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10837.0 10/3/20 10/30/20 299000.0 275000 2397.0 3.0 3.0   5828 Laurel Brook 1 Brookville true 2 6 Ranch Frame Carport 1987.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10865.0 10/12/20 10/31/20 317400.0 309000 3174.0 2.0 2.0   1516 Creek Brook 1 Brookville true 3 6 Split Level Stone 3 Car Attached 2011.0 Slate BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10868.0 10/13/20 11/1/20 317400.0 314900 3174.0 2.0 2.0   1521 River Brook 1 Brookville true 5 6 Ranch Brick 1 Car Detached 2012.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10873.0 10/14/20 11/2/20 319900.0 319000 2735.0 3.0 3.0   1527 Pricklypear 2 Hightown true 6 1 2 Story Frame 2 Car Attached 2007.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10875.0 10/15/20 11/3/20 319900.0 317000 3877.0 5.0 4.0   364 Peachtree 2 Hightown true 4 1 Split Foyer Stone 1 Car Attached 1992.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10888.0 10/19/20 11/30/20 326000.0 322000 4468.0 3.0 3.0   1919 Grapevine 2 Hightown true 3 2 Split Level Frame 1 Car Detached 2012.0 Slate BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10895.0 10/19/20 10/30/20 331000.0 330000 3566.0 3.0 3.0   5390 Grapevine 2 Hightown true 4 3 Ranch Stone Carport 2000.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10899.0 6/23/20 12/15/20 336400.0 335000 4054.0 3.0 3.0   1160 Nicklaus 9 Northern Heights true 3 1 Ranch Brick 3 Car Attached 1979.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10909.0 7/17/20 11/1/20 339900.0 338000 4236.0 4.0 3.0   3270 Stewart Drive 9 Northern Heights true 5 5 2 Story Frame 1 Car Detached 1977.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10922.0 7/17/20 11/2/20 345900.0 339000 3327.0 2.0 3.0   1502 Waterfront 13 Water Valley true 6 3 2 Story Frame 2 Car Attached 2005.0 Slate BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10928.0 10/3/20 11/3/20 348000.0 335000 4951.0 3.0 3.0   8217 Streamside 13 Water Valley true 5 2 2 Story Stone 2 Car Attached 1987.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10935.0 9/2/20 10/30/20 349900.0 338000 4256.0 4.0 4.0   615 Mountain 13 Water Valley true 3 5 Split Level Brick 1 Car Attached 2006.0 Slate BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10966.0 9/22/20 10/31/20 372300.0 339000 3252.0 3.0 4.0   1214 Golden Eagle 4 Eagle true 2 6 Ranch Frame 2 Car Detached 2012.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10968.0 9/23/20 11/1/20 374900.0 375000 4302.0 4.0 3.0   1419 Eagle Lane 4 Eagle true 3 3 2 Story Stone 1 Car Detached 2007.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10980.0 9/24/20 11/2/20 389000.0 385000 4316.0 3.0 3.0   7502 Mallard 4 Eagle true 4 2 Split Foyer Brick Carport 2007.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10984.0 9/25/20 11/3/20 389900.0 389000 3192.0 3.0 3.0   2587 Pintail 4 Eagle true 5 2 Ranch Frame 3 Car Attached 2000.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
10990.0 9/26/20 11/4/20 399000.0 390000 1812.0 3.0 2.0   8152 Soaring 4 Eagle true 1 2 Split Level Stone 1 Car Detached 2012.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11001.0 9/27/20 11/5/20 407500.0 400000 2820.0 3.0 3.0   545 Windsong 4 Eagle true 2 4 Ranch Brick 2 Car Attached 2000.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11012.0 9/28/20 11/6/20 430000.0 425000 4632.0 3.0 3.0   36790 Pintail 4 Eagle true 4 3 2 Story Frame 1 Car Attached 1979.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11025.0 9/29/20 11/7/20 449000.0 429000 2184.0 4.0 2.0   1501 Pintail 4 Eagle true 5 2 Split Foyer Stone 2 Car Detached 1977.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11028.0 9/30/20 11/8/20 449900.0 440000 1170.0 2.0 1.0   1002 Windsong 4 Eagle true 3 2 Ranch Brick 1 Car Detached 1987.0 Slate BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11029.0 10/1/20 11/9/20 450000.0 440000 4562.0 3.0 4.0   2210 Bald Top 4 Eagle true 6 2 Split Level Frame Carport 2011.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11042.0 10/26/20 11/10/20 460000.0 450000 4078.0 3.0 3.0   1300 Red Bark 7 Northern Heights true 3 5 Ranch Stone 3 Car Attached 2012.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11054.0 7/17/20 11/11/20 478000.0 465000 3596.0 3.0 3.0   2138 Redstone 7 Northern Heights true 2 1 2 Story Brick 1 Car Detached 2007.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11077.0 10/3/20 11/12/20 494000.0 475000 3276.0 3.0 3.0   11900 Rouge 7 Northern Heights true 1 4 Split Foyer Frame 2 Car Attached 1992.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11079.0 10/4/20 11/13/20 495000.0 450000 2000.0 3.0 3.0   3816 Redstone 7 Northern Heights true 1 2 Ranch Stone 1 Car Attached 2000.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11080.0 10/5/20 11/14/20 495000.0 465000 4176.0 3.0 4.0   1926 Red Rock 7 Northern Heights true 1 5 Split Level Brick 2 Car Detached 2012.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11082.0 10/6/20 11/15/20 497000.0 475000 4448.0 3.0 4.0   1976 Red Bark 7 Northern Heights true 4 6 Ranch Frame 1 Car Detached 2000.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11097.0 7/9/20 9/9/20 525000.0 500000 3384.0 4.0 3.0   3420 Redmond 7 Northern Heights true 5 6 2 Story Stone Carport 2006.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11098.0 7/10/20 10/10/20 525000.0 510000 4320.0 4.0 4.0   918 Rouge 7 Northern Heights true 6 6 Ranch Brick 3 Car Attached 1977.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11118.0 7/23/20 9/11/20 575000.0 550000 4518.0 4.0 4.0   249 Cottonwood 12 Pineville true 3 6 Split Foyer Frame 1 Car Detached 1987.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11126.0 8/13/20 10/15/20 595000.0 580000 5028.0 4.0 3.0   4044 Shortleaf 12 Pineville true 2 6 Split Level Stone 2 Car Attached 2011.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11141.0 7/27/20 10/16/20 652000.0 650000 4481.0 4.0 3.0   938 Longleaf 12 Pineville true 3 1 Ranch Brick 1 Car Attached 2006.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11158.0 5/29/20 11/15/20 725000.0 650000 5046.0 5.0 5.0   7101 Silver Oak 8 Seeley true 5 1 2 Story Frame 2 Car Detached 2007.0 Slate BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11159.0 5/30/20 8/15/20 740000.0 740000 5461.0 3.0 4.0   5028 Pine Point 8 Seeley true 2 2 Split Foyer Stone 1 Car Detached 1992.0 Shingle BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11171.0 10/3/20 11/30/20 825000.0 800000 5955.0 5.0 7.0   7415 Valley Oak 8 Seeley true 3 3 Split Foyer Brick Carport 2000.0 Shaker BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11188.0 7/27/20 10/12/20 1100000.0 999999 7126.0 5.0 6.0 7900 Valley Oak 8 Seeley true 4 1 Split Level Frame 3 Car Attached 2012.0 Composition BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
11199.0 7/27/20 11/15/20 1475000.0 1350000 4378.0 3.0 3.0   580 French Court 10 Countryside true 5 5 Ranch Stone 1 Car Detached 2000.0 Tile BxtghS9FYlQCBUtXsr/Em7BEUUwYDgAKwmzxrBFet/0=-~ceb03zULNhr7BCLGGIgKGA==
SubDivisionID SubDivisionName Pool RecreationCenter BikeTrail mSysRowId
1 Fair Brook true false false
2 The Orchards false true true
3 Dale true true true
4 Eagle Valley false false false
SELECT Agents.LastName, Properties.DateListed, Properties.DateSold, Properties.SalePrice, [DateSold]-[DateListed] AS DaysOnMarket, [SalePrice]*0.035 AS SaleComm FROM Agents INNER JOIN Properties ON Agents.[AgentID] = Properties.SellingAgent;