House spotting, Memphis @ Zillow

Real estate agencies often have a portfolio of houses on sale. But it takes time and effort to build it, since identifying houses worth investing in can be a slow process with many variables that are constantly changing. Not only the properties, but also their neighborhoods are important and need to be carefully evaluated. Other investors active in the area can also influence the price and availability of the real estates. Properties which are considered good may leave the market sooner. At the same time, no real estate agency wants to keep houses for too long, being unable to sell them, as these incur maintenance costs. For instance, while looking at various datasets on energy-efficient buildings, I saw on at least two occasions a realtor appearing very high on the list. These companies have found creative ways to keep their operating costs low, while still having a good potential upside in the case of a sale.

But spotting new houses remains hard, especially when there is a lot of information and misinformation. There are websites like Zillow, which try to simplify the process by connecting buyers and sellers. For instance, if we select Boston, many thousands of offers will appear. It is overwhelming for a single person to make sense of all this information in a short time. But if we select a smaller city, the task becomes slightly easier to manage. We can further exclude some houses that don't have information about square footage, for instance. In other cases, the price of the house might seem too low, which may be due to foreclosure or an undisclosed amount of debt that needs to be paid off. There are lots of potential questions and it is always best to clarify the details directly with the seller.

Here we will take a look at the available houses in Memphis, Tennessee on the Zillow platform. According to Wikipedia, the city has ≈650000 citizens. The website provides information about the address, price, bedrooms, bathrooms and square footage of each house. This allows us to compute the price per square foot, which is also something that Zillow shows rounded to an integer. Then we could extract ten potentially interesting houses and use the links to show their pages on Zillow, without having to show house images here. Please, note that some of the houses may appear high in the results because of a foreclosure. There is no way to know that until we check each case individually. It is always a good idea to seek feedback from many different places, not just individual websites before making any decision. Given these caveats, we can proceed with our code:

# Source: Zillow.com, 04.11.2017 base_url = 'https://www.zillow.com/homedetails/' # address, price, beds, bathrooms, square footage, link_suffix homes_memphis = """ 2162 James Rd,65000,3,2,2231,2162-James-Rd-Memphis-TN-38127/42227236_zpid/ 2964 Meadows Ln,69000,4,2,None,2964-Meadows-Ln-Memphis-TN-38118/2092422340_zpid/ 6783 Stornaway Dr,179000,4,2,None,6783-Stornaway-Dr-Memphis-TN-38119/42267668_zpid/ 2295 Slocum Ave,15000,5,2,1410,2295-Slocum-Ave-Memphis-TN-38127/42227742_zpid/ 980 Fprrest Ave,52500,3,1,1330,980-Forrest-Ave-Memphis-TN-38105/42134436_zpid/ 2420 Blakemore Rd,20000,3,1,930,2420-Blakemore-Rd-Memphis-TN-38106/42198284_zpid/ 1319 Mary Jane Ave,65000,3,2,1160,1319-Mary-Jane-Ave-Memphis-TN-38116/42260918_zpid/ 7800 Chapel Ridge Dr.,487000,5,5,4773,7800-Chapel-Ridge-Dr-Cordova-TN-38016/62864478_zpid/ 584 Saint Nick Dr.,599900,5,6,4800,584-Saint-Nick-Dr-Memphis-TN-38117/42186460_zpid/ 391 Cambridge Ave,17000,2,1,708,391-Cambridge-Ave-Memphis-TN-38106/42126880_zpid/ 2886 Overton Crossing St.,62500,3,1,1632,2886-Overton-Crossing-St-Memphis-TN-38127/42226797_zpid/ 66 Wychewood Dr.,1095000,4,5,5499,66-Wychewood-Dr-Memphis-TN-38117/42187912_zpid/ 1366 Goodbar Ave,203000,2,1,1255,1366-Goodbar-Ave-Memphis-TN-38104/42127662_zpid/ 6305 Spey Cv.,164000,4,2,2062,6305-Spey-Cv-Memphis-TN-38119/42267362_zpid/ 1497 Vance Ave,549900,5,4,4039,1497-Vance-Ave-Memphis-TN-38104/42128492_zpid/ 944 E Homles Rd.,195000,3,2,2700,944-E-Holmes-Rd-Memphis-TN-38116/42255599_zpid/ 4665 Quince Rd,102900,3,2,1498,4665-Quince-Rd-Memphis-TN-38117/42211903_zpid/ 2952 Phyllis Ln,39500,3,2,1500,2952-Phyllis-Ln-Memphis-TN-38118/42233159_zpid/ 603 Denmark Dr,129900,1,1,None,603-Denmark-Dr-Memphis-TN-38103/2102808769_zpid/ 5830 Garden Oak Cv,650000,4,6,5249,5830-Garden-Oak-Cv-Memphis-TN-38120/42264387_zpid/ 9366 Ronald Rd, 2195000,4,7,None,6366-Ronald-Rd-Memphis-TN-38120/42264093_zpid/ 257 Whitewater Rd,157000,3,2,1604,1257-Whitewater-Rd-Memphis-TN-38117/42213234_zpid/ 144 Ascot Park Common Dr,1200000,5,8,None,144-Ascot-Park-Common-Dr-Memphis-TN-38120/42264566_zpid/ 649 Pawnee Ave,65000,3,1,894,649-Pawnee-Ave-Memphis-TN-38109/42245438_zpid/ 2929 Emerald St,112900,4,2,None,2929-Emerald-St-Memphis-TN-38115/42240230_zpid/ 1309 Timothy Dr,190000,3,2,2700,1309-Timothy-Dr-Memphis-TN-38116/42257075_zpid/ 165 Waring Rd,995000,6,8,None,165-Waring-Rd-Memphis-TN-38117/42184954_zpid/ 189 N Mendenhall Rd,375000,4,4,2400,189-N-Mendenhall-Rd-Memphis-TN-38117/42185695_zpid/ 884 Drake Manor Cv,700000,4,4,5000,884-Drake-Manor-Cv-Memphis-TN-38117/72093899_zpid/ 3437 Vernon Ave,12500,2,1,None,3437-Vernon-Ave-Memphis-TN-38122/42160556_zpid/ 1467 N Trezevant St,15000,3,1,None,1467-N-Trezevant-St-Memphis-TN-38108/42158041_zpid/ 3692 Firethorne Dr,64900,6,4,1268,3692-Firethorne-Dr-Memphis-TN-38115/42337222_zpid/ 4965 Shelter Cv,45000,3,2,None,4965-Shelter-Cv-Memphis-TN-38118/42346537_zpid/ 5122 Kingswood Cir,148000,5,3,2822,5122-Kingswood-Cir-Memphis-TN-38134/42279204_zpid/ 3424 Piney Woods Ave,20500,3,1,None,3424-Piney-Woods-Ave-Memphis-TN-38118/42234698_zpid/ 464 S Greer St,160000,2,2,1206,464-S-Greer-St-Memphis-TN-38111/42168573_zpid/ 36 W Emory Rd,29900,3,2,None,36-W-Emory-Rd-Memphis-TN-38109/42242970_zpid/ 1743 Peach Ave,275000,3,2,2073,1743-Peach-Ave-Memphis-TN-38112/42131708_zpid/ 4540 Cottonwood Rd,59900,3,2,1577,4540-Cottonwood-Rd-Memphis-TN-38118/42233507_zpid/ 3202 Manhattan Ave,16000,2,2,999,3202-Manhattan-Ave-Memphis-TN-38112/42152063_zpid/ 4130 Raintree Cv,69900,3,2,1403,4130-Raintree-Cv-Memphis-TN-38115/42336327_zpid/ 160 Picardy Pl,250000,3,2,1600,160-Picardy-Pl-Memphis-TN-38111/2136381726_zpid/ 4317 Judy Cv,64900,3,1,1129,4317-Judy-Cv-Memphis-TN-38111/42193938_zpid/ 4131 Leweir St.,49000,3,2,1128,4131-Leweir-St-Memphis-TN-38127/42223553_zpid/ 2363 Autumn Ave,365000,3,3,None,2363-Autumn-Ave-Memphis-TN-38112/2092215210_zpid/ 2373 Autumn Ave,350000,3,2,None,2373-Autumn-Ave-Memphis-TN-38112/2092216166_zpid/ 3247 Yale Ave,27500,3,1,1359,3247-Yale-Ave-Memphis-TN-38112/42162372_zpid/ 1976 Clovia Ln,50000,3,2,1400,1976-Clovia-Ln-Memphis-TN-38114/42143755_zpid/ 3367 E Rosita Cir,44900,2,1,None,3367-E-Rosita-Cir-Memphis-TN-38116/42253348_zpid/ 4896 Peace St,34900,4,1,None,4896-Peace-St-Memphis-TN-38109/42248071_zpid/ 2054 Kirby Pkwy,272000,4,3,None,2054-Kirby-Pkwy-Memphis-TN-38119/42265606_zpid/ 435 S Front St APT307,299900,2,3,1527,435-S-Front-St-APT-307-Memphis-TN-38103/89133255_zpid/ 1382 Abernathy Rd,159000,3,2,None,1382-Abernathy-Rd-Memphis-TN-38116/42261088_zpid/ 7371 Abercrombie Ln,219000,5,4,2800,7371-Abercrombie-Ln-Memphis-TN-38119/42269039_zpid/ 2277 Union Ave APT 310,55750,1,1,None,2277-Union-Ave-APT-310-Memphis-TN-38104/42138871_zpid/ 1092 E Montebello Cir,149900,3,3,1400,1092-E-Montebello-Cir-Cordova-TN-38018/64547782_zpid/ 4618 Saint Elmo Ave,159900,3,3,None,4618-Saint-Elmo-Ave-Memphis-TN-38128/42275099_zpid/ 4754 Oakbrook Ct #1,114900,2,2,None,4754-Oakbrook-Ct-1-Memphis-TN-38117/42208938_zpid/ 323 Damone Ave,29000,3,1,None,323-Damone-Ave-Memphis-TN-38109/42244782_zpid/ 4133 Sequoia Rd,235000,3,2,None,4133-Sequoia-Rd-Memphis-TN-38117/42184745_zpid/ 4008 Grantham Rd,55000,3,2,1520,4008-Grantham-Rd-Memphis-TN-38109/42248704_zpid/ 390 Fountain Lake Dr,274900,3,3,1959,390-Fountain-Lake-Dr-Memphis-TN-38120/52599780_zpid/ 1538 Beaver Trail Dr,95000,2,3,1232,1538-Beaver-Trail-Dr-Cordova-TN-38016/62863814_zpid/ 841 S Perkins Rd,499900,3,4,3200,841-S-Perkins-Rd-Memphis-TN-38117/42188418_zpid/ 28 N Cooper St,499900,4,3,2800,28-N-Cooper-St-Memphis-TN-38104/42138361_zpid/ 5246 Suggs Cv,529000,4,4,3753,5246-Suggs-Cv-Memphis-TN-38120/42187259_zpid/ 5100 Verosa Ave,229000,3,2,1654,5100-Verosa-Ave-Memphis-TN-38117/42208177_zpid/ 1842 S Sutton Dr,55000,3,1,962,1842-S-Sutton-Dr-Memphis-TN-38127/42225718_zpid/ 412 Malboro Rd,120000,2,1,1025,412-Malboro-Rd-Memphis-TN-38120/42217314_zpid/ 706 Belvedere Blvd,350000,3,2,1800,706-S-Belvedere-Blvd-Memphis-TN-38104/42141387_zpid/ 348 Fountain Crest Dr,198500,3,2,1344,348-Fountain-Crest-Dr-Memphis-TN-38120/52599807_zpid/ 4164 Arrowood Ave,92900,3,2,1064,4164-Arrowood-Ave-Memphis-TN-38118/42232950_zpid/ 5731 Maple Tree Dr,25500,3,2,1152,5731-Maple-Tree-Dr-Memphis-TN-38115/42337304_zpid/ 1188 Canary Ln,21000,3,1,1068,1188-Canary-Ln-Memphis-TN-38109/42270006_zpid/ 1375 Snowden Ave,44900,3,2,1442,1375-Snowden-Ave-Memphis-TN-38107/42133969_zpid/ 91 Clark Pl,170000,4,2,2246,91-Clark-Pl-Memphis-TN-38104/42129739_zpid/ 4635 Addington Dr,54000,3,3,1467,4635-Addington-Dr-Memphis-TN-38128/64627517_zpid/ 378 Mulberry St,129000,1,1,771,378-Mulberry-St-Memphis-TN-38103/72468819_zpid/ 7204 Germanshire Oaks Cv,98000,4,3,2544,7204-Germanshire-Oaks-Cv-Memphis-TN-38125/55304144_zpid/ 2791 Sonora Dr,24000,2,2,960,2791-Sonora-Dr-Memphis-TN-38115/42240787_zpid/ 4373 Misty Morning Dr,67900,2,3,1408,4373-Misty-Morning-Dr-Memphis-TN-38141/109170322_zpid/ 4686 Addington Dr,52000,3,3,1490,4686-Addington-Dr-Memphis-TN-38128/60331021_zpid/ 3706 Macon Rd,29995,2,1,1222,3706-Macon-Rd-Memphis-TN-38122/42161867_zpid/ 3599 Beechollow Dr,30000,3,3,2000,3599-Beechollow-Dr-3599-Memphis-TN-38128/2116181476_zpid/ 958 Forrest Ave,29000,3,1,1000,958-Forrest-Ave-Memphis-TN-38105/42134440_zpid/ 3230 Edgeware Rd,32500,3,1,950,3230-Edgeware-Rd-S-Memphis-TN-38118/42202386_zpid/ 3045 Canyon Rd,91000,4,2.5,2874,3045-Canyon-Rd-Memphis-TN-38134/42277341_zpid/ 3675 Royal Wood Dr,13000,4,1,1189,3675-Royal-Wood-Dr-Memphis-TN-38128/42282501_zpid/ 8615 Cedar Farms,189000,4,3,2698,8615-Cedar-Farms-Dr-Cordova-TN-38016/62863462_zpid/ 3024 Whitney Ave,120000,4,3,2306,3024-Whitney-Ave-Memphis-TN-38128/42272668_zpid/ 5655 Ashley Sq S,559500,8,6,7002,5655-Ashley-Sq-S-Memphis-TN-38120/42187806_zpid/ 1088 Kney St,12900,3,1,1298,1088-Kney-St-Memphis-TN-38107/42133091_zpid/ 5299 Longacre Ave,76000,3,2,1598,5299-Longacre-Ave-Memphis-TN-38134/42276977_zpid/ 449 Garland St,287000,4,2,2204,449-Garland-St-Memphis-TN-38104/42130867_zpid/ 757 Rain Dance Way,120000,3,3,1508,757-Rain-Dance-Way-Cordova-TN-38018/42287932_zpid/ 2659 Country Downs Ln,164900,4,2,2153,2659-Country-Downs-Ln-Cordova-TN-38016/42330231_zpid/ 1962 Manila Ave,189900,3,2,1200,1962-Manila-Ave-Memphis-TN-38114/42144374_zpid/ 262 Wagner PI APT 201,230000,2,2,1549,262-Wagner-Pl-APT-201-Memphis-TN-38103/42126011_zpid/ 2277 Union Ave APT 308,55750,1,1,730,2277-Union-Ave-APT-308-Memphis-TN-38104/42138869_zpid/ 2358 Zanone Ave,30000,3,1,900,2358-Zanone-Ave-Memphis-TN-38114/42140344_zpid/ 1585 Court Ave,139900,3,1,1091,1585-Court-Ave-Memphis-TN-38104/42129709_zpid/ 6360 Thrushcross Dr,95000,3,2,1162,6360-Thrushcross-Dr-Memphis-TN-38134/42281191_zpid/ 6350 Limewood Ave,77000,3,2,1505,6350-Limewood-Ave-Memphis-TN-38134/42280671_zpid/ 817 Hilton St,20995,3,1,905,817-Hilton-St-Memphis-TN-38114/42203993_zpid/ 1098 Clyde Ave,25440,3,1,856,1098-Clyde-Ave-Memphis-TN-38107/42154859_zpid/ 123 S Fenwick Rd,334499,4,3,2293,123-S-Fenwick-Rd-Memphis-TN-38111/42166768_zpid/ 379 N Holmes St,45000,2,1,816,379-N-Holmes-St-Memphis-TN-38112/42162378_zpid/ 3231 University St,35000,4,1,1600,3231-University-St-Memphis-TN-38127/42227555_zpid/ 14N Larchmont Dr,149900,2,1,1277,14-N-Larchmont-Dr-Memphis-TN-38111/42165687_zpid/ 1171 Sledge Ave,279950,3,2,1799,1171-Sledge-Ave-Memphis-TN-38104/42145039_zpid/ 336 Bendigo Dr,157900,3,2,1751,336-Bendigo-Dr-Cordova-TN-38018/42334575_zpid/ 891 E Dempster Ave,47500,3,2,1743,891-E-Dempster-Ave-Memphis-TN-38106/42175449_zpid/ 4052 Rhodes Ave,33350,3,1,962,4052-Rhodes-Ave-Memphis-TN-38111/42193051_zpid/ 3731 Alma Dr,35000,3,1,1832,3731-Alma-Dr-Memphis-TN-38127/42223232_zpid/ 1700 Port Oak Pl,105000,3,2,1194,1700-Port-Oak-Pl-Memphis-TN-38120/42263490_zpid/ 433 N Highland St APT4,129900,3,3,None,433-N-Highland-St-APT-4-Memphis-TN-38122/42162821_zpid/ 8937 Bridlewood Ln,234900,4,2,2500,8937-Bridlewood-Ln-Cordova-TN-38016/42327869_zpid/ 4943 Robindale Ln,359000,3,3,1400,4943-Robindale-Ln-Memphis-TN-38117/42207615_zpid/ 4101 Langston Cv,625000,4,5,None,4101-Langston-Cv-Memphis-TN-38117/42188239_zpid/ 3973 Philwood Ave,134900,3,1,1000,3973-Philwood-Ave-Memphis-TN-38122/42165535_zpid/ 4597 Plato Ave,120000,4,2,1829,4597-Plato-Ave-Memphis-TN-38128/42274090_zpid/ 1374 Island Pl,275000,3,3,1652,1374-Island-Pl-E-Memphis-TN-38103/70589726_zpid/ 4220 Belle Meade Cv,1395000,6,6,None,4220-Belle-Meade-Cv-Memphis-TN-38117/42188094_zpid/ 1083 Marcia Rd,169900,3,2,1445,1083-Marcia-Rd-Memphis-TN-38117/42209084_zpid/ 5049 Millbranch Rd,69000,3,1,1044,5049-Millbranch-Rd-Memphis-TN-38116/42260385_zpid/ 5040 Gull Rd,55000,3,2,1096,5040-Gull-Rd-Memphis-TN-38109/42271295_zpid/ 255 Windover Rd,434900,4,3,3200,255-Windover-Rd-Memphis-TN-38111/42169360_zpid/ 2669 Trangbourne Dr,210000,5,3,3000,2669-Tangbourne-Dr-Memphis-TN-38119/42267773_zpid/ 6768 Paper Birch Cv,509000,5,8,5620,6768-Paper-Birch-Cv-Memphis-TN-38119/42266046_zpid/ 2942 Getwell Rd,79900,3,2,1379,2942-Getwell-Rd-Memphis-TN-38118/42231778_zpid/ 4179 Leweir St,64900,3,2,1200,4179-Leweir-St-Memphis-TN-38127/42223549_zpid/ 1888 Court Ave,220000,2,3,1714,1888-Court-Ave-Memphis-TN-38104/42130265_zpid/ 4726 Stage Rd,139900,4,2,2162,4726-Stage-Rd-Memphis-TN-38128/42277775_zpid/ 3256 Denver St,65000,3,2,1284,3256-Denver-St-Memphis-TN-38127/42226189_zpid/ 1911 E Shelby Dr,64000,3,1,1009,1911-E-Shelby-Dr-Memphis-TN-38116/42259485_zpid/ 125 E Goodways St,529000,4,3,3000,125-E-Goodwyn-St-Memphis-TN-38111/42167120_zpid/ 1125 Island Pl,274000,3,3,1840,1125-Island-Pl-E-Memphis-TN-38103/54052758_zpid/ 4164 Hedge Hills Ave,259900,3,2,1636,4164-Hedge-Hills-Ave-Memphis-TN-38117/42184712_zpid/ 4160 Tuckahoe Rd,699000,4,4,4000,4160-Tuckahoe-Rd-Memphis-TN-38117/42187984_zpid/ 1329 Rolling Oaks Dr,200000,3,2,1711,1329-Rolling-Oaks-Dr-E-Memphis-TN-38119/42215227_zpid/ 7580 Dexter Grove Dr,198000,4,3,2379,7580-Dexter-Grove-Dr-Cordova-TN-38016/62864103_zpid/ 5280 Sycamore Grove Ln,325000,3,3,2545,5280-Sycamore-Grove-Ln-Memphis-TN-38120/42216480_zpid/ 6548 Margaux Sv,115000,3,2,1623,6548-Margaux-Cv-E-Memphis-TN-38141/42352546_zpid/ 3991 Cheryl Dr,72000,3,1,1150,3991-Cheryl-Dr-Memphis-TN-38116/42254046_zpid/ 4644 Quintell Ave,79900,3,2,1281,4644-Quintell-Ave-Memphis-TN-38128/42277829_zpid/ 1211 Casetino St,219000,3,3,2800,1211-Casentino-St-Cordova-TN-38018/72466203_zpid/ 336 Grove Hill Pl,869000,3,5,None,336-Grove-Hill-Pl-Memphis-TN-38120/42264454_zpid/ 1218 Wilmore Rd,149900,2,2,1031,1218-Wilmore-Rd-Memphis-TN-38117/42214213_zpid/ 6744 Amersham Dr,145000,3,2,None,6744-Amersham-Dr-Memphis-TN-38119/42268039_zpid/ 1116 Poplar Ave APT 4,185999,2,1,1200,1116-Poplar-Ave-APT-4-Memphis-TN-38105/82699268_zpid/ 3166 Central Ave,189000,2,1,None,3166-Central-Ave-Memphis-TN-38111/42167872_zpid/ 2069 Iroquous Rd,500000,3,3,2599,2969-Iroquois-Rd-Memphis-TN-38111/42166928_zpid/ 320 Eastland Dr,379000,3,2,2531,320-Eastland-Dr-Memphis-TN-38111/42165464_zpid/ 200 N Waldran Blvd APT 17,339999,3,2,2200,200-N-Waldran-Blvd-APT-17-Memphis-TN-38105/82697579_zpid/ 1605 Vinton Ave,455000,4,3,2700,1605-Vinton-Ave-Memphis-TN-38104/42128592_zpid/ 773 Spring St,40000,3,2,1238,773-Spring-St-Memphis-TN-38112/42177821_zpid/ 8425 Brownstone Ln,94500,3,4,2222,8425-Brownstone-Ln-50-Cordova-TN-38016/2108440577_zpid/ 258 Paisade St,289000,3,2,1381,258-Palisade-St-Memphis-TN-38111/42168275_zpid/ 4653 Laurel Oaks,205000,3,3,None,4653-Laurel-Oaks-4653-Memphis-TN-38117/2092344807_zpid/ 2694 Mcgregor Ave,50000,4,2,1300,2694-Mcgregor-Ave-Memphis-TN-38127/42229945_zpid/ 3735 California Terrace Dr,20000,2,3,None,3735-California-Terrace-Dr-10-Memphis-TN-38122/2092344595_zpid/ 3981 Chippewa Rd,59900,3,2,1499,3981-Chippewa-Rd-Memphis-TN-38118/42231743_zpid/ 805 N Mcneil St,49900,3,1,None,805-N-Mcneil-St-Memphis-TN-38107/42149170_zpid/ 6425 Kirby Trees,18500,4,3,1854,6425-Kirby-Trees-Dr-Memphis-TN-38115/55304398_zpid/ 4682 Chip Rd,154900,3,2,None,4682-Chip-Rd-Memphis-TN-38117/42209039_zpid/ 947 Par Ave,19500,3,1,875,947-Par-Ave-Memphis-TN-38127/42218122_zpid/ 5254 Dee Rd,160000,3,2,None,5254-Dee-Rd-Memphis-TN-38117/42214369_zpid/ 2938 Kenneth St,64900,4,2,None,2938-Kenneth-St-Memphis-TN-38128/42278478_zpid/ 2795 Sage Meadow Dr,155000,4,2.5,1899,2795-Sage-Meadow-Dr-Memphis-TN-38133/62861124_zpid/ 7001 Juanta Cir S.,119900,3,2,None,7001-Juanita-Cir-S-Memphis-TN-38133/62849514_zpid/ 3775 Oakley Ave,545000,4,4,3500,3775-Oakley-Ave-Memphis-TN-38111/42164907_zpid/ 395 Laclede Ave,35900,3,1,None,395-Laclede-Ave-Memphis-TN-38126/42126677_zpid/ 1757 Fox Hunt Ln,39000,3,3,None,1757-Fox-Hunt-Ln-1757-Memphis-TN-38134/2092376373_zpid/ 5352 Boswell Ave,115000,3,2,1818,5352-Boswell-Ave-Memphis-TN-38120/42215718_zpid/ 1326 Salem St,34000,2,1,870,1326-Salem-St-Memphis-TN-38122/42179544_zpid/ 3215 Winslow Rd,19900,2,1,968,3215-Winslow-Rd-Memphis-TN-38109/42242547_zpid/ 5278 Buckport Ln,89900,3,3,1490,5278-Bucksport-Ln-Memphis-TN-38118/72471832_zpid/ 3593 Kensett Dr,39500,3,2,1200,3593-Kensett-Dr-Memphis-TN-38127/42225709_zpid/ 8835 Raspberry Ln,240000,6,4,3343,8835-Raspberry-Ln-Cordova-TN-38016/42327943_zpid/ 1479 Old Hickory Rd,59900,3,2,None,1479-Old-Hickory-Rd-Memphis-TN-38116/42256462_zpid/ 4439 Janssen Dr,37000,3,2,1150,4439-Janssen-Dr-Memphis-TN-38128/42283667_zpid/ 3595 England St,29500,3,2,1673,3595-England-St-Memphis-TN-38127/42229880_zpid/ 3412 Kirby Ave,21500,2,1,1114,3412-Kirby-Ave-Memphis-TN-38111/42189380_zpid/ 918 S Greer St,35000,2,1,1042,918-S-Greer-St-Memphis-TN-38111/42196930_zpid/ 7000 Crestridge Rd,119900,3,2,1564,7000-Crestridge-Rd-Memphis-TN-38119/42268534_zpid/ 6748 Stone Garden Dr,150000,3,3,1455,6748-Stone-Garden-Dr-Memphis-TN-38134/71001791_zpid/ 1283 Dogwood Dr,46000,3,2,1077,1283-Dogwood-Dr-Memphis-TN-38111/42192831_zpid/ 1591 Hamilton St,20000,3,1,None,1591-Hamilton-St-Memphis-TN-38114/42172209_zpid/ 1899 Marjorie St,19900,3,1,1140,1899-Marjorie-St-Memphis-TN-38106/62859413_zpid/ 8571 Woodland Rose Cir S.,239900,3,2,None,8571-Woodland-Rose-Cir-S-Cordova-TN-38016/2092391255_zpid/ 840 Chelsea Ave, 50000,3,2,2492,840-Chelsea-Ave-Memphis-TN-38107/42138240_zpid/ 716 Brownlee Rd,108900,4,3,2660,716-Brownlee-Rd-Memphis-TN-38116/42254303_zpid/ 290 N Claybrooks St,139900,3,2,None,290-N-Claybrook-St-Memphis-TN-38104/2092365334_zpid/ 3377 Seaforth Dr,45000,3,2,1000,3377-Seaforth-Dr-Memphis-TN-38127/42230232_zpid/ 6929 Snyder Rd,50000,2,2,1218,6929-Snyder-Rd-Memphis-TN-38141/118958447_zpid/ 2174 Burlingate Dr,116000,5,3.5,2585,2174-Burlingate-Dr-Cordova-TN-38016/62865633_zpid/ 3223 Markley St,35000,3,2,1120,3223-Markley-St-Memphis-TN-38127/42219842_zpid/ 3703 Royal Wood Dr,30000,3,1,924,3703-Royal-Wood-Dr-Memphis-TN-38128/42282506_zpid/ 1180 Whitten Rd,125000,3,2.5,1615,1180-Whitten-Rd-Memphis-TN-38134/72483196_zpid/ 2853 Fulham Pl,129500,5,3,2787,2853-Fulham-Pl-Memphis-TN-38128/42272190_zpid/ 3096 Dumbarton Rd,89900,4,2,1747,3096-Dumbarton-Rd-Memphis-TN-38128/42271736_zpid/ 3054 Coleman Ave,49000,3,2,1312,3054-Coleman-Ave-Memphis-TN-38112/42179058_zpid/ 857 Pope St,19995,2,1,1000,857-Pope-St-Memphis-TN-38112/42178965_zpid/ 1691 S Goodlett St,32500,2,1,825,1691-S-Goodlett-St-Memphis-TN-38111/42194054_zpid/ 883 Univeristy St,249000,4,3,2200,883-University-St-Memphis-TN-38107/42150764_zpid/ 7128 Butterfly Dr,112000,3,2,1230,7128-Butterfly-Dr-Memphis-TN-38133/62861612_zpid/ 2512 Castleman St,99000,3,2,None,3512-Castleman-St-Memphis-TN-38118/42237369_zpid/ 745 Homer St,47000,3,1,1116,745-Homer-St-Memphis-TN-38122/42153454_zpid/ 1554 Ellsworth St,36000,3,1,975,1554-Ellsworth-St-Memphis-TN-38111/42189893_zpid/ 1745 Mcnair St,44000,2,1,None,1745-Mcnair-St-Memphis-TN-38108/42180390_zpid/ 3822 Tessland Rd,34000,3,1,898,3822-Tessland-Rd-Memphis-TN-38128/42284593_zpid/ 547 Delta Rd,47500,3,1,None,547-Delta-Rd-Memphis-TN-38109/42247391_zpid/ 3987 Shinault Ln,119900,3,2,1200,3987-Shinault-Ln-Memphis-TN-38125/55303701_zpid/ 3576 W Big Bend Dr,49000,3,2,1000,3576-W-Big-Bend-Dr-Memphis-TN-38116/42255686_zpid/ 3449 Hardin Ave,39900,2,1,994,3449-Hardin-Ave-Memphis-TN-38122/42153089_zpid/ 2199 Purple Leaf Ln,142000,3,2,1426,2199-Purple-Leaf-Ln-Cordova-TN-38016/55308080_zpid/ 3142 Aden St,33900,3,2,1400,3142-Aden-St-Memphis-TN-38127/42226149_zpid/ 4215 Boyce Ave,46000,3,1,896,4215-Boyce-Ave-Memphis-TN-38111/42193900_zpid/ 1375 Canfield Ave,34900,2,1,925,1375-Canfield-Ave-Memphis-TN-38127/42220671_zpid/ 835 N McNeil St,54900,3,1,1286,835-N-Mcneil-St-Memphis-TN-38107/42149164_zpid/ 689 Hillcrest St,45000,3,2,1280,689-Hillcrest-St-Memphis-TN-38112/42152079_zpid/ 2483 Dana Dr,31500,4,2,1404,2483-Dana-Dr-Memphis-TN-38108/42178096_zpid/ 1105 Hester Rd,144900,5,3,2348,1105-Hester-Rd-Memphis-TN-38116/42255521_zpid/ 3775 Windcrest Rd,79000,4,2,1400,3775-Windcrest-Rd-Memphis-TN-38116/42255996_zpid/ 403 Lipford St,27000,2,2,1176,403-Lipford-St-Memphis-TN-38112/42151543_zpid/ 1657 Duke St,58900,3,1,None,1657-Duke-St-Memphis-TN-38108/42180188_zpid/ 2436 Chattering Ln,28500,3,1,1076,2436-Chattering-Ln-Memphis-TN-38127/42224599_zpid/ 4228 Bow St,45000,2,1,995,4228-Bow-St-Memphis-TN-38109/42245561_zpid/ 2205 Purple Leaf Ln,162000,3,3,1901,2205-Purple-Leaf-Ln-Cordova-TN-38016/55308081_zpid/ 2067 Kings Cross Ln,199500,5,3,3169,2067-Kings-Cross-Ln-Cordova-TN-38016/62864811_zpid/ 6533 Swarthmore Dr,179000,4,3,2376,6533-Swarthmore-Dr-Memphis-TN-38119/42266309_zpid/ 5216 Normandy Ln,249900,3,2,None,5216-Normandy-Ln-Memphis-TN-38117/42207823_zpid/ 774 Rain Dance Way,160000,4,3,2386,774-Rain-Dance-Way-Cordova-TN-38018/42287916_zpid/ 4473 Lansford Dr,139000,4,3,3298,4473-Lansford-Dr-Memphis-TN-38128/42275171_zpid/ 5179 Shady Grove Rd,590000,4,4,3000,5179-Shady-Grove-Rd-Memphis-TN-38117/42186899_zpid/ 4136 Garden Birch Cv,75000,3,2,1489,4136-Garden-Birch-Cv-Memphis-TN-38115/121723911_zpid/ 5110 Barry Rd,824900,4,6,None,5110-Barry-Rd-Memphis-TN-38117/42186822_zpid/ 3698 Park Ave,69000,2,1,999,3698-Park-Ave-Memphis-TN-38111/42169794_zpid/ 1960 N Parkway APT 1004,129900,3,2,1394,1960-N-Parkway-APT-1004-Memphis-TN-38112/42150494_zpid/ 1290 Elkwood St,36500,3,1,1049,1290-Elkwood-St-Memphis-TN-38111/42190197_zpid/ 3064 Claudine Cv,31900,3,1,889,3064-Claudine-Cv-Memphis-TN-38127/42226489_zpid/ 4117 Chippewa Rd,49000,3,1,1040,4117-Chippewa-Rd-Memphis-TN-38118/42232754_zpid/ 4029 Saint Elmo Ave,52000,3,2,1675,4029-Saint-Elmo-Ave-Memphis-TN-38128/42285519_zpid/ 2595 Copperfield Dr,159000,3,2,1945,2595-Copperfield-Dr-Memphis-TN-38119/42267502_zpid/ 357 Fountain Crest Dr,179900,2,2,1200,357-Fountain-Crest-Dr-Memphis-TN-38120/42217696_zpid/ 8062 Port Douglas Cv,122500,3,2,None,8062-Port-Douglas-Cv-Memphis-TN-38018/2092464406_zpid/ 8744 Grandbury Pl,210000,5,3,None,8744-Grandbury-Pl-Cordova-TN-38016/62865426_zpid/ 8528 Trinity Rd,177500,5,3,None,8528-Trinity-Rd-Cordova-TN-38018/42287533_zpid/ 720 Lotty Ct APT 201,149500,1,2,1161,720-Litty-Ct-APT-201-Memphis-TN-38103/72455395_zpid/ 5357 Murff Ave,199900,4,2,2303,5357-Murff-Ave-Memphis-TN-38119/42215121_zpid/ 511 Meade Cir,185000,3,2,1281,511-Meade-Cir-Memphis-TN-38122/42165598_zpid/ 4424 Ferndale Rd,65900,3,1,1258,4424-Ferndale-Rd-Memphis-TN-38122/42183747_zpid/ 2301 Celeste Dr,52000,3,1,1053,2301-Celeste-Dr-Memphis-TN-38127/42229052_zpid/ 4366 Falcon Dr,35000,3,1,None,4366-Falcon-Dr-Memphis-TN-38109/42246363_zpid/ 1604 Autumn Tree Cv,234900,4,3,2882,1604-Autumn-Tree-Cv-Cordova-TN-38016/62863498_zpid/ 5479 S Angeia Rd,399900,4,3,3000,5479-S-Angela-Rd-Memphis-TN-38120/42216796_zpid/ 2525 Shillingford Dr,315000,4,3,3601,2525-Shillingford-Dr-Memphis-TN-38119/72466261_zpid/ 1788 Cheshunt Ln,217500,3,3,None,1788-Cheshunt-Ln-Cordova-TN-38016/42327747_zpid/ 5122 SanderlinAve,175000,2,3,None,5122-Sanderlin-Ave-5122-Memphis-TN-38117/2092370781_zpid/ 3620 Kenwood Ave,224900,3,1,1600,3620-Kenwood-Ave-Memphis-TN-38122/42164292_zpid/ 6820 Rockbrook Dr,119900,3,2,1514,6820-Rockbrook-Dr-Memphis-TN-38141/42342482_zpid/ 1960 N Parkway APT1109,85000,2,2,None,1960-N-Parkway-APT-1109-Memphis-TN-38112/42150510_zpid/ 2785 Skylake Cv,67000,4,2,2296,2785-Skylake-Cv-Memphis-TN-38127/42230637_zpid/ 2178 Burnham Cv,69500,3,1,1064,2178-Burnham-Cv-Memphis-TN-38127/42229014_zpid/ 3605 Vernon Ave,62500,3,1,1256,3605-Vernon-Ave-Memphis-TN-38122/42161023_zpid/ 2920 Spottswood Ave,31900,2,1,1200,2920-Spottswood-Ave-Memphis-TN-38111/42166329_zpid/ 1278 Dogwood Dr,38000,3,1.5,1110,1278-Dogwood-Dr-Memphis-TN-38111/42192866_zpid/ 2530 Rozelle St,64000,3,1,None,2530-Rozelle-St-Memphis-TN-38114/42200853_zpid/ 5827 Grassy valley Dr,52000,5,2,1416,5827-Grassy-Valley-Dr-Memphis-TN-38141/116407350_zpid/ 730 Lipford St,31900,3,1,None,730-Lipford-St-Memphis-TN-38112/42178876_zpid/ 211 Alexander St,299000,5,3,2600,211-Alexander-St-Memphis-TN-38111/42168253_zpid/ 2464 Madison Ave,210000,3,2,None,2464-Madison-Ave-Memphis-TN-38112/42139066_zpid/ 532 S Belvedere Blvd,700000,3,3,3210,532-S-Belvedere-Blvd-Memphis-TN-38104/42128858_zpid/ 2475 Hawkhurst St,204000,4,3,2814,2475-Hawkhurst-St-Memphis-TN-38119/42266630_zpid/ 137 E Ge Patterson Ave APT 504,299000,2,2,1799,137-E-Ge-Patterson-Ave-APT-504-Memphis-TN-38103/64588296_zpid/ 4631 Leatherwood Ave,139900,4,2,None,4631-Leatherwood-Ave-Memphis-TN-38117/42211371_zpid/ 7822 Brady Hollow Cv,84900,2,3,1200,7822-Brady-Hollow-Cv-Cordova-TN-38016/102984484_zpid/ 3133 Knightway Rd,56000,3,1,1033,3133-Knightway-Rd-Memphis-TN-38118/42233408_zpid/ 3840 Newton Rd,39500,2,1,None,3840-Newton-Rd-Memphis-TN-38128/42204467_zpid/ 2452 Pecan Cir,50000,2,1,968,2452-Pecan-Cir-Memphis-TN-38114/42200431_zpid/ 4704 Normandy Ave,399000,4,3,3104,4704-Normandy-Ave-Memphis-TN-38117/42185600_zpid/ 1527 Tutwiler Ave,149000,3,1,1381,1527-Tutwiler-Ave-Memphis-TN-38107/42149403_zpid/ 2770 Park Crest Cv,125000,3,2,1670,2770-Park-Crest-Cv-Cordova-TN-38016/62863231_zpid/ 185 S Edgewood St APT 4,120000,2,3,1199,185-S-Edgewood-St-APT-4-Memphis-TN-38104/42138612_zpid/ 8912 Alana Cv,260000,4,4,None,8912-Alana-Cv-Cordova-TN-38016/42327302_zpid/ 4943 Sagewood Sr,84900,4,2,1944,4943-Sagewood-Dr-Memphis-TN-38116/42259002_zpid/ 4884 Farmwood Dr,69500,3,2,1744,4884-Farmwood-Dr-Memphis-TN-38116/42259050_zpid/ 4563 Violet Ave,76000,3,1,972,4563-Violet-Ave-Memphis-TN-38122/42205660_zpid/ 4745 Audubon View Cir,118500,2,2,None,4745-Audubon-View-Cir-1507-Memphis-TN-38117/2118061408_zpid/ 6676 Whispering Oak Pl APT 3,75000,2,2,None,6676-Whispering-Oak-Pl-APT-3-Memphis-TN-38120/42263622_zpid/ 2187 Leyton Ave,69900,3,2,1047,2187-Leyton-Ave-Memphis-TN-38127/42223873_zpid/ 4630 Spring Valley,60000,3,1,1162,4630-Spring-Valley-Dr-Memphis-TN-38128/42282916_zpid/ 1460 Titus Rd,42000,3,1,1349,1460-Titus-Rd-Memphis-TN-38111/42192501_zpid/ 358 Angelus St,469900,4,3,2375,358-Angelus-St-Memphis-TN-38112/42131366_zpid/ 9149 Karen Mill Ln,167500,4,3,1900,9149-Karen-Mill-Ln-Cordova-TN-38016/64449248_zpid/ 1420 Island Town Dr,269900,3,3,2000,1420-Island-Town-Dr-Memphis-TN-38103/72290144_zpid/ 6649 Ross Cv,153000,3,3,2430,6649-Ross-Cv-Memphis-TN-38141/42350490_zpid/ 4565 Amboy Rd,89900,2,1,942,4565-Amboy-Rd-Memphis-TN-38117/42211130_zpid/ """ from heapq import heappush, nsmallest houses = [] lines = homes_memphis.split('\n') for line in lines[1:-1]: address, price, beds, bathrooms, square_footage, link_suffix = line.split(',') if square_footage != 'None': price = float(price) square_footage = float(square_footage) beds = int(beds) bathrooms = float(bathrooms) price_m2 = price / square_footage heappush(houses, (price_m2, beds, bathrooms, address, link_suffix)) html = "<ul>{0}</ul>".format(''.join(["<li><h3><a href='%s'>%s</a></h3><span>%.2f$/m2, %dbeds, %.1fbathrooms</span></li>" % (base_url + link, address, price_m2, beds, bathrooms) for price_m2, beds, bathrooms, address, link in nsmallest(10, houses)])) print(html)

Once we embed the result into this web page, we see the following:

Click on any link to see further details. If we imported and used the nlargest function instead, we could have found the homes with the highest price/m2, which for some people may be of interest too. Feel free to use this example as a motivation to run your own analysis on your own data. In case you seek further help, you could always ask to see whether working together would be an option.