Excel project
Listings Placer Hills Real Estate Agent Listings Listing IDListedAgent IDList PriceAddressCitySq FtBedsBathsGarageConstructionYear BuiltSale DateSale Price 100255/30/19160$255,0003420 Milburn StreetRocklin1900433 Car AttachedFrame20016/22/19$228,900 100276/4/19127$335,0002128 WedgewoodRoseville1184321 Car DetachedStone19997/10/19$345,000 100336/9/19103$334,5004336 Newland Heights DriveRocklin1840222 Car AttachedFrame199910/13/19$327,000 100426/22/19168$385,000131 Aeolia DriveAuburn1905322 Car DetachedBrick19659/15/19$385,000 100456/23/19168$274,50012355 Krista LaneAuburn2234332 Car AttachedBrick19848/17/19$260,000 100527/16/19103$227,0001096 Kinnerly LaneLincoln1948333 Car AttachedBrick199510/1/19$238,000 100547/16/19168$297,000272 Lariat LoopLincoln1571212 Car AttachedStone20029/16/19$265,900 100697/24/19151$239,6001255 CopperdaleAuburn1456322 Car DetachedFrame19958/30/19$237,000 101729/23/19160$329,000324 Center PointRoseville1480223 Car DetachedFrame199111/1/19$319,000 1017710/5/19160$326,500411 Marion StreetAuburn1950322 Car AttachedStone200112/5/19$315,000 1018010/8/19151$425,99917523 OleanderSacramento2100332 Car AttachedBrick200012/15/19$415,000 1018310/11/19168$525,0001044 Lake StreetElk Grove1755221 Car DetachedFrame201212/28/19$505,500 1018610/14/19103$345,00015802 CentennialDavis1950322 Car DetachedStone19981/4/20$340,000 1018910/17/19127$589,00014313 ClearviewSacramento2200333 Car AttachedBrick2000 1019210/20/19103$489,00012222 South Ann StreetElk Grove2100332 Car DetachedFrame20001/24/20$425,000 1019510/23/19168$319,0002330 West 120 StreetDavis1700221 Car AttachedStone19922/3/20$310,000 1019810/26/19127$439,0007240 Westbrook DriveSacramento1900322 Car AttachedBrick2001 1020110/29/19103$505,000419 Harlem AvenueElk Grove2000332 Car AttachedBrick20022/23/20$500,000 1020411/1/19151$312,0009023 Evergreen LaneDavis1850322 Car AttachedStone2003 1020711/4/19151$489,0004230 Madison StreetSacramento1900222 Car AttachedBrick20053/15/20$475,000 1021011/7/19160$499,0001330 Harrison StreetElk Grove2100333 Car AttachedFrame19903/25/20$465,000 1021311/10/19160$299,000401 Lombard AvenueDavis1650221 Car AttachedFrame1995 PivotTable Placer Hills Real Estate Sales by Agent Listing Sum of Sale PriceColumn Labels Row Labels103127151160168Grand Total Auburn2370003150006450001197000 Davis340000310000650000 Elk Grove9250004650005055001895500 Lincoln238000265900503900 Rocklin327000228900555900 Roseville345000319000664000 Sacramento890000890000 Grand Total18300003450001127000132790017264006356300 Table Placer Hills Real Estate Agent Listings Listing IDListedAgent IDList PriceAddressCitySq FtBedsBathsGarageConstructionYear BuiltSale DateSale Price 100255/30/19160$255,0003420 Milburn StreetRocklin1900433 Car AttachedFrame20016/22/19$228,900 100276/4/19127$335,0002128 WedgewoodRoseville1184321 Car DetachedStone19997/10/19$345,000 100336/9/19103$334,5004336 Newland Heights DriveRocklin1840222 Car AttachedFrame199910/13/19$327,000 100426/22/19168$385,000131 Aeolia DriveAuburn1905322 Car DetachedBrick19659/15/19$385,000 100456/23/19168$274,50012355 Krista LaneAuburn2234332 Car AttachedBrick19848/17/19$260,000 100527/16/19103$227,0001096 Kinnerly LaneLincoln1948333 Car AttachedBrick199510/1/19$238,000 100547/16/19168$297,000272 Lariat LoopLincoln1571212 Car AttachedStone20029/16/19$265,900 100697/24/19151$239,6001255 CopperdaleAuburn1456322 Car DetachedFrame19958/30/19$237,000 101729/23/19160$329,000324 Center PointRoseville1480223 Car DetachedFrame199111/1/19$319,000 1017710/5/19160$326,500411 Marion StreetAuburn1950322 Car AttachedStone200112/5/19$315,000 1018010/8/19151$425,99917523 OleanderSacramento2100332 Car AttachedBrick200012/15/19$415,000 1018310/11/19168$525,0001044 Lake StreetElk Grove1755221 Car DetachedFrame201212/28/19$505,500 1018610/14/19103$345,00015802 CentennialDavis1950322 Car DetachedStone19981/4/20$340,000 1018910/17/19127$589,00014313 ClearviewSacramento2200333 Car AttachedBrick2000 1019210/20/19103$489,00012222 South Ann StreetElk Grove2100332 Car DetachedFrame20001/24/20$425,000 1019510/23/19168$319,0002330 West 120 StreetDavis1700221 Car AttachedStone19922/3/20$310,000 1019810/26/19127$439,0007240 Westbrook DriveSacramento1900322 Car AttachedBrick2001 1020110/29/19103$505,000419 Harlem AvenueElk Grove2000332 Car AttachedBrick20022/23/20$500,000 1020411/1/19151$312,0009023 Evergreen LaneDavis1850322 Car AttachedStone2003 1020711/4/19151$489,0004230 Madison StreetSacramento1900222 Car AttachedBrick20053/15/20$475,000 1021011/7/19160$499,0001330 Harrison StreetElk Grove2100333 Car AttachedFrame19903/25/20$465,000 1021311/10/19160$299,000401 Lombard AvenueDavis1650221 Car AttachedFrame1995 1 2 3 4 5 6 A B C D Placer Hills Real Estate Agent Listings Listing ID Listed Agent ID List Price 10025 5/30/2019 160 $255,000 10027 6/4/2019 127 $335,000