import pandas as pd
import matplotlib.cm as cm
import matplotlib.pyplot as plt
import seaborn as sns
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88 return f(*args, **kwds) /Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88 return f(*args, **kwds)
%matplotlib inline
df = pd.read_csv('apartments_train.csv')
len(df)
31932
df.info()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 31932 entries, 0 to 31931 Data columns (total 24 columns): address 26863 non-null object area 0 non-null float64 balcony 31932 non-null bool cellar 0 non-null float64 city 31932 non-null object contact_name 25134 non-null object district 31932 non-null object extra_costs 31932 non-null float64 garden 31932 non-null bool immo_id 31932 non-null int64 kitchen 31932 non-null bool lat 26740 non-null float64 lng 26740 non-null float64 media_count 31932 non-null int64 private 31932 non-null bool rent 31932 non-null float64 rooms 31932 non-null float64 sqm 31932 non-null float64 time_dest 0 non-null float64 time_dest2 0 non-null float64 time_dest3 0 non-null float64 title 31932 non-null object url 31932 non-null object zip_code 31932 non-null int64 dtypes: bool(4), float64(11), int64(3), object(6) memory usage: 5.0+ MB
df.head()
address | area | balcony | cellar | city | contact_name | district | extra_costs | garden | immo_id | ... | private | rent | rooms | sqm | time_dest | time_dest2 | time_dest3 | title | url | zip_code | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Holteistraße 17 | NaN | True | NaN | Berlin | Felix Henne | Friedrichshain (Friedrichshain) | 360.0 | False | 104509324 | ... | False | 1095.00 | 3.0 | 82.52 | NaN | NaN | NaN | Wohnen am Stadtpark | https://www.immobilienscout24.de/expose/104509324 | 10245 |
1 | Kremmener Straße 11 | NaN | True | NaN | Berlin | Ihr Makler in Berlin! | Mitte (Mitte) | 282.0 | False | 102537923 | ... | False | 1824.00 | 3.0 | 102.48 | NaN | NaN | NaN | Außergewöhnliches Industrieloft mit 2 edlen Bä... | https://www.immobilienscout24.de/expose/102537923 | 10435 |
2 | Rudolf-Schwarz-Str. 26 | NaN | False | NaN | Berlin | NaN | Prenzlauer Berg (Prenzlauer Berg) | 137.0 | False | 106461482 | ... | False | 655.00 | 2.0 | 54.56 | NaN | NaN | NaN | Gemütliche 2 Zimmer Wohnung in Prenzlauer Berg... | https://www.immobilienscout24.de/expose/106461482 | 10407 |
3 | NaN | NaN | True | NaN | Berlin | Michael Latteck | Wilmersdorf (Wilmersdorf) | 122.0 | False | 106325874 | ... | False | 899.85 | 2.0 | 59.99 | NaN | NaN | NaN | attraktive Pärchen-Wohnung am Güntzel-Kiez! Pa... | https://www.immobilienscout24.de/expose/106325874 | 10717 |
4 | Bredowstr. 5 | NaN | False | NaN | Berlin | Vermietungsteam Stadthaus Verwaltungsgesellschaft | Tiergarten (Tiergarten) | 97.0 | False | 106316967 | ... | False | 482.00 | 1.0 | 37.59 | NaN | NaN | NaN | Moabit! - Westfälisches Viertel! - 1 Zimmer - ... | https://www.immobilienscout24.de/expose/106316967 | 10551 |
5 rows × 24 columns
df.immo_id = df.immo_id.astype(str)
df.zip_code = df.zip_code.astype(str)
df2=df.drop(columns=["time_dest", "time_dest2", "time_dest3", "area", "cellar"])
df2.describe()
area | cellar | extra_costs | lat | lng | media_count | rent | rooms | sqm | |
---|---|---|---|---|---|---|---|---|---|
count | 0.0 | 0.0 | 31932.000000 | 26740.000000 | 26740.000000 | 31932.000000 | 31932.000000 | 31932.000000 | 31932.000000 |
mean | NaN | NaN | 221.975585 | 52.508081 | 13.396624 | 10.970468 | 979.486026 | 2.490923 | 78.363778 |
std | NaN | NaN | 1396.253013 | 0.045758 | 0.098108 | 6.313705 | 6761.499857 | 1.220792 | 44.324234 |
min | NaN | NaN | 0.000000 | 52.373770 | 13.116530 | 0.000000 | 0.000000 | 1.000000 | 0.000000 |
25% | NaN | NaN | 130.000000 | 52.479450 | 13.330520 | 7.000000 | 520.000000 | 2.000000 | 53.760000 |
50% | NaN | NaN | 180.000000 | 52.510890 | 13.395005 | 10.000000 | 719.000000 | 2.000000 | 68.900000 |
75% | NaN | NaN | 250.000000 | 52.537560 | 13.452780 | 14.000000 | 1098.000000 | 3.000000 | 92.142500 |
max | NaN | NaN | 208597.090000 | 52.656390 | 13.726850 | 77.000000 | 1000000.000000 | 100.000000 | 2489.660000 |
df2.groupby("contact_name").size().sort_values(ascending=False)
contact_name Vermietungsteam Stadthaus Verwaltungsgesellschaft 948 Britta C. Gruttmann 417 Ingo Pries 393 Petra Hubertus 348 Manuel Lan 298 Melanie Schröder 283 Sandra Smarslik 281 Thomas Voss 267 Schönlife Immobilien 265 Kathrin Aschurow 253 Ihr Makler in Berlin! 252 Alexandra Nepomnyashcha 223 Sandra Linke 213 Beate Akitoye 198 Hans-Jürgen Kloss 194 Pia Unterlauf 186 Diana Wilhelm 183 BIDDEX IMMOBILIEN 172 Petra Hubertus reco immobilienbüro 171 Andrej Schafranek 165 Sonja Stanisch 160 Vermietungsteam Wiesenpark Quartier 158 Ulrich Keiling 155 Vermietungsabteilung - Engel & Völkers Berlin Mitte GmbH 154 Konstanze Mühlbach 151 Frau Schulze Vermietung 150 Corinne Adolph 144 Giulia Valentino 139 Dana Marsig 136 Michael Chibac 135 ... Dirk Friebe 1 Dirk Elsner 1 Vanessa Murri 1 Maik Wehner 1 Dipl.-Ing. Ulrike Stübner 1 Ehrhard Hawelka 1 MaklerBüro Wille Frau Schardt- lenbach@optikalusion.com 1 Manfred Klinkert 1 Manuel Hennings 1 Sven Tillmanns 1 Dieter Huber 1 Manuel Martinez 1 Maciej Auda 1 MICHAEL DIETRICH 1 Dirk Wippermann 1 M. Solms 1 M. Kleinschmidt Immobilien 1 Vanessa Mummert 1 Dominique McRae 1 Doreen Smolarek 1 Doreen Kärgel 1 M. Karge 1 M. Jens 1 Luise Schirmer 1 Dorothea Friedrich 1 Lucia Demmel 1 Liebermann Vernen 1 Liane Polzin 1 Leipzig Engel & Völkers 1 Simone Burgold 1 Length: 1656, dtype: int64
df2.groupby("district").size().sort_values(ascending=False)
district Mitte (Mitte) 2535 Charlottenburg (Charlottenburg) 2401 Prenzlauer Berg (Prenzlauer Berg) 1982 Friedrichshain (Friedrichshain) 1825 Neukölln (Neukölln) 1615 Wedding (Wedding) 1543 Tiergarten (Tiergarten) 1524 Wilmersdorf (Wilmersdorf) 1425 Kreuzberg (Kreuzberg) 1133 Spandau (Spandau) 1088 Schöneberg (Schöneberg) 998 Köpenick (Köpenick) 764 Lichterfelde (Steglitz) 679 Weißensee (Weißensee) 658 Reinickendorf (Reinickendorf) 626 Steglitz (Steglitz) 590 Pankow (Pankow) 589 Adlershof (Treptow) 518 Marzahn (Marzahn) 450 Niederschönhausen (Pankow) 409 Hellersdorf (Hellersdorf) 399 Zehlendorf (Zehlendorf) 385 Lichtenberg (Lichtenberg) 379 Karlshorst (Lichtenberg) 343 Tempelhof (Tempelhof) 342 Niederschöneweide (Treptow) 323 Dahlem (Zehlendorf) 319 Kaulsdorf (Hellersdorf) 293 Mariendorf (Tempelhof) 292 Staaken (Spandau) 277 ... Neu-Hohenschönhausen (Hohenschönhausen) 110 Baumschulenweg (Treptow) 104 Treptow (Treptow) 94 Mahlsdorf (Hellersdorf) 92 Wittenau (Reinickendorf) 92 Französisch Buchholz (Pankow) 84 Grünau (Köpenick) 75 Kladow (Spandau) 74 Nikolassee (Zehlendorf) 73 Wannsee (Zehlendorf) 64 Siemensstadt (Spandau) 63 Biesdorf (Marzahn) 55 Plänterwald (Treptow) 52 Frohnau (Reinickendorf) 51 Hermsdorf (Reinickendorf) 40 Buch (Pankow) 35 Lübars (Reinickendorf) 28 Haselhorst (Spandau) 28 Konradshöhe (Reinickendorf) 27 Rahnsdorf (Köpenick) 26 Heinersdorf (Weißensee) 23 Heiligensee (Reinickendorf) 22 Gatow (Spandau) 19 Müggelheim (Köpenick) 13 Bohnsdorf (Treptow) 12 Blankenburg (Weißensee) 9 Schmöckwitz (Köpenick) 6 Rummelsburg (Lichtenberg) 4 Malchow (Hohenschönhausen) 2 Wartenberg (Hohenschönhausen) 1 Length: 79, dtype: int64
df3=df2[(df2.rent<2000) & (df2.sqm<200) & (df2.rooms < 10) & (df2.extra_costs < 2000)]
len(df3)
30011
df3.plot(x="sqm", y="rent", c="rooms", kind="scatter", colormap=cm.Set1, figsize=(15,10))
<matplotlib.axes._subplots.AxesSubplot at 0x11de9cc18>
df3.plot(x="lng", y="lat", c="rent", kind="scatter", figsize=(15,10), colormap=cm.Blues)
<matplotlib.axes._subplots.AxesSubplot at 0x120c73438>
df3.hist(bins=20,figsize=(15,10), column=["extra_costs","lat","lng","media_count","rent","rooms","sqm"])
array([[<matplotlib.axes._subplots.AxesSubplot object at 0x121451f98>, <matplotlib.axes._subplots.AxesSubplot object at 0x121489048>, <matplotlib.axes._subplots.AxesSubplot object at 0x1217216d8>], [<matplotlib.axes._subplots.AxesSubplot object at 0x121748d68>, <matplotlib.axes._subplots.AxesSubplot object at 0x12177a3c8>, <matplotlib.axes._subplots.AxesSubplot object at 0x12177a400>], [<matplotlib.axes._subplots.AxesSubplot object at 0x1217d50f0>, <matplotlib.axes._subplots.AxesSubplot object at 0x1217fb780>, <matplotlib.axes._subplots.AxesSubplot object at 0x121824e10>]], dtype=object)
corr=df3.corr()
fig, ax = plt.subplots(figsize=(15,10))
sns.heatmap(corr,
xticklabels=corr.columns,
yticklabels=corr.columns, center=0.0,
cmap=sns.diverging_palette(5, 250, as_cmap=True), annot=True, fmt=".2f", ax=ax)
<matplotlib.axes._subplots.AxesSubplot at 0x1218e7470>
# df4=df3.dropna()
sns.pairplot(df3, vars=["sqm","rooms","rent","media_count", "extra_costs"], kind="reg")
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/scipy/stats/stats.py:1713: FutureWarning: Using a non-tuple sequence for multidimensional indexing is deprecated; use `arr[tuple(seq)]` instead of `arr[seq]`. In the future this will be interpreted as an array index, `arr[np.array(seq)]`, which will result either in an error or a different result. return np.add.reduce(sorted[indexer] * weights, axis=axis) / sumval
<seaborn.axisgrid.PairGrid at 0x11b9952e8>
import numpy as np
from sklearn import linear_model
from sklearn.metrics import r2_score
# One-hot encoding of zip_codes
hot_zip = pd.get_dummies(df3.zip_code)
df3.balcony = df3.balcony.astype(int)
df3.garden = df3.garden.astype(int)
df3.kitchen = df3.kitchen.astype(int)
df3.private = df3.private.astype(int)
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/pandas/core/generic.py:4405: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy self[name] = value
X = pd.concat((df3[["sqm","rooms","balcony","garden","kitchen","private"]], hot_zip), axis=1)
y = df3[["rent"]]
X.head()
sqm | rooms | balcony | garden | kitchen | private | 10059 | 10115 | 10117 | 10119 | ... | 14167 | 14169 | 14179 | 14193 | 14195 | 14197 | 14199 | 14974 | 19719 | 20147 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 82.52 | 3.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1 | 102.48 | 3.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2 | 54.56 | 2.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
3 | 59.99 | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
4 | 37.59 | 1.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
5 rows × 241 columns
# a simple linear model doesn't perform too well
simple = linear_model.LinearRegression()
simple.fit(X,y)
y_pred = simple.predict(X)
r2_score(y, y_pred)
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/sklearn/linear_model/base.py:509: RuntimeWarning: internal gelsd driver lwork query error, required iwork dimension not returned. This is likely the result of LAPACK bug 0038, fixed in LAPACK 3.2.2 (released July 21, 2010). Falling back to 'gelss' driver. linalg.lstsq(X, y)
0.805445021495854
# Robustly fit linear model with RANSAC (RANdom SAmple Consensus) algorithm
regressor = linear_model.RANSACRegressor(linear_model.LinearRegression())
regressor.fit(X,y)
RANSACRegressor(base_estimator=LinearRegression(copy_X=True, fit_intercept=True, n_jobs=1, normalize=False), is_data_valid=None, is_model_valid=None, loss='absolute_loss', max_skips=inf, max_trials=100, min_samples=None, random_state=None, residual_metric=None, residual_threshold=None, stop_n_inliers=inf, stop_probability=0.99, stop_score=inf)
inlier_mask = regressor.inlier_mask_
outlier_mask = np.logical_not(inlier_mask)
print(u'%.1f%% der Wohnungen als Ausreißer identifiziert' % (sum(outlier_mask)*100.0/(sum(outlier_mask)+sum(inlier_mask))))
24.0% der Wohnungen als Ausreißer identifiziert
y_pred = regressor.predict(X)
df3["rent_predicted"] = y_pred
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
r2_ransac = r2_score(y[inlier_mask], y_pred[inlier_mask])
fig, ax = plt.subplots(figsize=(15,10))
sns.regplot(df3['rent'][inlier_mask],
df3['rent_predicted'][inlier_mask])
plt.scatter(df3['rent'][outlier_mask],
df3['rent_predicted'][outlier_mask],
alpha=0.4,
c='r')
plt.title('Prediction of rent for apartments in Berlin')
plt.text(250, 2000, r'$R^2=%.2f$' % r2_ransac)
plt.tight_layout()
# plt.savefig('LinReg-rent-apartment.png', dpi=150)
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/scipy/stats/stats.py:1713: FutureWarning: Using a non-tuple sequence for multidimensional indexing is deprecated; use `arr[tuple(seq)]` instead of `arr[seq]`. In the future this will be interpreted as an array index, `arr[np.array(seq)]`, which will result either in an error or a different result. return np.add.reduce(sorted[indexer] * weights, axis=axis) / sumval
df_test = pd.read_csv('apartments_test.csv')
len(df_test)
3309
df2_test=df_test.drop(columns=["time_dest", "time_dest2", "time_dest3"])
df2_test.describe()
area | cellar | extra_costs | immo_id | lat | lng | media_count | rent | rooms | sqm | zip_code | |
---|---|---|---|---|---|---|---|---|---|---|---|
count | 0.0 | 0.0 | 3309.000000 | 3.309000e+03 | 2721.000000 | 2721.000000 | 3309.000000 | 3309.000000 | 3309.000000 | 3309.000000 | 3309.000000 |
mean | NaN | NaN | 229.113629 | 1.026711e+08 | 52.508286 | 13.393502 | 11.624962 | 1139.576745 | 2.577999 | 82.808250 | 11876.211242 |
std | NaN | NaN | 145.021002 | 9.777422e+06 | 0.045547 | 0.104382 | 7.639504 | 888.289082 | 1.153846 | 46.044379 | 1426.281945 |
min | NaN | NaN | 0.000000 | 3.018110e+07 | 52.376040 | 13.127430 | 0.000000 | 176.520000 | 1.000000 | 6.000000 | 10115.000000 |
25% | NaN | NaN | 140.390000 | 1.047457e+08 | 52.478960 | 13.326820 | 7.000000 | 602.620000 | 2.000000 | 55.000000 | 10553.000000 |
50% | NaN | NaN | 200.000000 | 1.060304e+08 | 52.510380 | 13.390170 | 10.000000 | 900.000000 | 2.000000 | 72.550000 | 12159.000000 |
75% | NaN | NaN | 280.000000 | 1.064149e+08 | 52.537790 | 13.452820 | 15.000000 | 1400.000000 | 3.000000 | 99.810000 | 13125.000000 |
max | NaN | NaN | 1750.000000 | 1.066237e+08 | 52.645320 | 13.667430 | 88.000000 | 15000.000000 | 11.000000 | 482.000000 | 37127.000000 |
df3_test=df2_test[(df2_test.rent<2000) & (df2_test.sqm<200) & (df2_test.rooms < 10) & (df2_test.extra_costs < 2000)]
len(df3_test)
2993
hot_zip_test = pd.get_dummies(df3_test.zip_code)
df3_test.balcony = df3_test.balcony.astype(int)
df3_test.garden = df3_test.garden.astype(int)
df3_test.kitchen = df3_test.kitchen.astype(int)
df3_test.private = df3_test.private.astype(int)
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/pandas/core/generic.py:4405: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy self[name] = value
X_test = pd.concat((df3_test[["sqm","rooms","balcony","garden","kitchen","private"]], hot_zip_test), axis=1)
y_test = df3_test[["rent"]]
X_test.head()
sqm | rooms | balcony | garden | kitchen | private | 10115 | 10117 | 10119 | 10178 | ... | 14129 | 14163 | 14165 | 14167 | 14169 | 14193 | 14195 | 14197 | 14199 | 37127 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 83.00 | 2.5 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1 | 107.00 | 4.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2 | 69.00 | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
3 | 53.68 | 2.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
4 | 103.05 | 3.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
5 rows × 199 columns
# https://stackoverflow.com/questions/41335718/keep-same-dummy-variable-in-training-and-testing-data
# Get missing columns in the training test
missing_cols = set( X.columns ) - set( X_test.columns )
# Add a missing column in test set with default value equal to 0
for c in missing_cols:
X_test[c] = 0
# Ensure the order of column in the test set is in the same order than in train set
X_test = X_test[X.columns]
y_pred = regressor.predict(X_test)
df3_test["rent_predicted"] = y_pred
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
r2_score(y_test, y_pred)
0.3845097842000519
df3_test["rent_error"] = df3_test["rent"] - df3_test["rent_predicted"]
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy """Entry point for launching an IPython kernel.
top = df3_test.sort_values("rent_error")
top[top["district"].str.contains("Zehlendorf")]
address | area | balcony | cellar | city | contact_name | district | extra_costs | garden | immo_id | ... | media_count | private | rent | rooms | sqm | title | url | zip_code | rent_predicted | rent_error | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3169 | Von-der-Trenck-Straße 5 A | NaN | 1 | NaN | Berlin | Wohnbau Service Bonn GmbH Service Team | Nikolassee (Zehlendorf) | 195.98 | 1 | 89168579 | ... | 3 | 0 | 535.02 | 2.0 | 67.04 | WBS erforderlich!!! ruhige Wohnung mit Garten | https://www.immobilienscout24.de/expose/89168579 | 14129 | 774.322687 | -239.302687 |
3151 | Von-der-Trenck-Straße 3 | NaN | 1 | NaN | Berlin | Wohnbau Service Bonn GmbH Service Team | Nikolassee (Zehlendorf) | 182.17 | 0 | 90729049 | ... | 6 | 0 | 451.83 | 1.5 | 56.62 | Wohnen in der Natur! WBS erforderlich! Einbauk... | https://www.immobilienscout24.de/expose/90729049 | 14129 | 629.757535 | -177.927535 |
3090 | Alsterweg 53 | NaN | 1 | NaN | Berlin | Dave Felgenhauer | Zehlendorf (Zehlendorf) | 164.00 | 1 | 95781013 | ... | 8 | 0 | 408.18 | 1.5 | 52.68 | Bereits modernisierte Wohnung, mit großem Balk... | https://www.immobilienscout24.de/expose/95781013 | 14167 | 574.065009 | -165.885009 |
1933 | NaN | NaN | 0 | NaN | Berlin | Philipp Vormeier | Zehlendorf (Zehlendorf) | 240.00 | 1 | 106200307 | ... | 13 | 1 | 950.00 | 4.0 | 105.00 | Ruhige Wohnung in Berlin, Zehlendorf | https://www.immobilienscout24.de/expose/106200307 | 14167 | 1065.147978 | -115.147978 |
1790 | Am Sandwerder 24 | NaN | 1 | NaN | Berlin | Jörg-M. Meier | Wannsee (Zehlendorf) | 215.00 | 0 | 106291069 | ... | 7 | 0 | 530.00 | 2.0 | 61.01 | Helle 2-Zimmerwohnung im Grünen, nahe Wannsee. | https://www.immobilienscout24.de/expose/106291069 | 14109 | 614.251279 | -84.251279 |
1071 | Marshallstr. 9 | NaN | 1 | NaN | Berlin | GmbH PRINTS | Dahlem (Zehlendorf) | 298.00 | 0 | 106595282 | ... | 7 | 0 | 1048.23 | 3.0 | 110.00 | +NAHE GRUNEWALD+SONNENBALKON+PARKETT+WOHNKÜCHE | https://www.immobilienscout24.de/expose/106595282 | 14169 | 1131.169515 | -82.939515 |
1064 | Pritchardstraße 13 | NaN | 1 | NaN | Berlin | Axel Pfeiffer | Dahlem (Zehlendorf) | 241.00 | 0 | 106596584 | ... | 7 | 0 | 868.05 | 3.0 | 89.49 | 3 Zimmer mit Balkon Nähe Grunewald ab September | https://www.immobilienscout24.de/expose/106596584 | 14169 | 905.880449 | -37.830449 |
2604 | Düppelstr. 19 | NaN | 0 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 115.00 | 0 | 105189965 | ... | 8 | 0 | 570.00 | 2.0 | 55.64 | Tolle Wohnung in ruhiger Zehlendorf-Lage | https://www.immobilienscout24.de/expose/105189965 | 14163 | 602.302764 | -32.302764 |
1385 | NaN | NaN | 1 | NaN | Berlin | Ralph Wodrich | Wannsee (Zehlendorf) | 756.00 | 1 | 106495039 | ... | 12 | 0 | 1628.00 | 3.0 | 148.00 | WANNSEE : EG-Maisonetten-Wohnung direkt am Kle... | https://www.immobilienscout24.de/expose/106495039 | 14109 | 1642.410666 | -14.410666 |
2181 | Starkenburger Str. 3 | NaN | 0 | NaN | Berlin | Yvonne Fuchs | Zehlendorf (Zehlendorf) | 348.00 | 0 | 105996967 | ... | 2 | 0 | 1005.30 | 3.5 | 100.53 | ++Wir renovieren für Sie: Ansprechende 3,5-Zim... | https://www.immobilienscout24.de/expose/105996967 | 14163 | 1010.457592 | -5.157592 |
3083 | Albertinenstr. 12 | NaN | 1 | NaN | Berlin | BITTE NUR PER EMAIL WGW Hausverwaltung GmbH | Zehlendorf (Zehlendorf) | 350.00 | 1 | 96253253 | ... | 12 | 0 | 950.00 | 3.0 | 85.00 | SCHÖNE, HELLE 3-ZIMMERWOHNUNG MIT BALKON IN ZE... | https://www.immobilienscout24.de/expose/96253253 | 14169 | 950.396470 | -0.396470 |
1752 | Sangebuchtweg 11 | NaN | 1 | NaN | Berlin | NaN | Wannsee (Zehlendorf) | 320.00 | 0 | 106315694 | ... | 17 | 0 | 1099.00 | 3.0 | 107.00 | Erstbezug nach Modernisierung! 3-Zimmer-Wohnun... | https://www.immobilienscout24.de/expose/106315694 | 14109 | 1098.216458 | 0.783542 |
713 | Potsdamer Chaussee 26 | NaN | 0 | NaN | Berlin | Mirko Neumann | Nikolassee (Zehlendorf) | 340.00 | 1 | 57300477 | ... | 15 | 1 | 1400.00 | 4.0 | 140.00 | Schöne, geräumige 4Zimmerwohnung im Dachgescho... | https://www.immobilienscout24.de/expose/57300477 | 14129 | 1396.475338 | 3.524662 |
1980 | Breisgauer Str. 4 | NaN | 0 | NaN | Berlin | NaN | Nikolassee (Zehlendorf) | 117.00 | 0 | 106174394 | ... | 7 | 0 | 495.00 | 1.0 | 42.05 | 1-Zi-Apartment nahe Schlachtensee | https://www.immobilienscout24.de/expose/106174394 | 14129 | 474.230600 | 20.769400 |
2492 | Hugo Vogel Straße 6 | NaN | 1 | NaN | Berlin | Achim Emde | Wannsee (Zehlendorf) | 257.00 | 0 | 105518230 | ... | 13 | 1 | 1270.00 | 4.0 | 124.80 | Ansprechende 4-Zimmer-Wohnung zur Miete in Wan... | https://www.immobilienscout24.de/expose/105518230 | 14109 | 1248.014875 | 21.985125 |
1451 | Breitensteinweg 10 | NaN | 1 | NaN | Berlin | Julia Ziglowski | Zehlendorf (Zehlendorf) | 120.00 | 0 | 106460055 | ... | 5 | 0 | 521.54 | 2.0 | 49.67 | Sonnenbalkon + Wohnküche, das passt! | https://www.immobilienscout24.de/expose/106460055 | 14165 | 489.688724 | 31.851276 |
252 | Spilstraße 10 | NaN | 0 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 212.42 | 1 | 106296522 | ... | 8 | 0 | 900.96 | 2.0 | 75.08 | Helle und sanierte 2 Zimmer-Altbauwohnung in S... | https://www.immobilienscout24.de/expose/106296522 | 14195 | 856.549366 | 44.410634 |
3147 | Mörchinger Str. 25 | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 120.00 | 0 | 91171284 | ... | 8 | 0 | 450.00 | 1.0 | 35.00 | Einzimmerwohnung im Grünen von Zehlendorf - ho... | https://www.immobilienscout24.de/expose/91171284 | 14169 | 402.878430 | 47.121570 |
3055 | Ramsteinweg 23 | NaN | 0 | NaN | Berlin | Dennis Hirschberg | Zehlendorf (Zehlendorf) | 147.03 | 1 | 98023697 | ... | 10 | 0 | 606.05 | 2.0 | 52.70 | +++ ACHTUNG +++ NEUBAU RAMSTEINWEG 23 SUCHT NA... | https://www.immobilienscout24.de/expose/98023697 | 14165 | 557.594590 | 48.455410 |
2274 | Podbielskiallee 68 | NaN | 0 | NaN | Berlin | Markus Krause | Dahlem (Zehlendorf) | 204.00 | 1 | 105901612 | ... | 12 | 0 | 795.00 | 2.0 | 65.00 | schöne teilmöblierte 2 Zi. in Dahlemlage | https://www.immobilienscout24.de/expose/105901612 | 14195 | 745.827094 | 49.172906 |
623 | NaN | NaN | 1 | NaN | Berlin | Ralph Wodrich | Wannsee (Zehlendorf) | 550.00 | 1 | 106245902 | ... | 11 | 0 | 1180.00 | 2.0 | 98.79 | WANNSEE in Bestlage. : Attr. BALKON-Wohnung di... | https://www.immobilienscout24.de/expose/106245902 | 14109 | 1123.075873 | 56.924127 |
3261 | NaN | NaN | 1 | NaN | Berlin | G. Schmidt | Zehlendorf (Zehlendorf) | 315.00 | 1 | 68925463 | ... | 15 | 1 | 910.00 | 3.0 | 83.00 | 3-Zi.-Wohnung mit Terrasse u. Garten in sehr g... | https://www.immobilienscout24.de/expose/68925463 | 14169 | 850.784925 | 59.215075 |
2336 | Hocksteinweg 17 | NaN | 0 | NaN | Berlin | Alexandra Nepomnyashcha | Zehlendorf (Zehlendorf) | 156.00 | 0 | 105796491 | ... | 11 | 0 | 590.00 | 2.5 | 53.55 | Kleines gemütliches Heim in einer angenehmen S... | https://www.immobilienscout24.de/expose/105796491 | 14165 | 515.617905 | 74.382095 |
2232 | Taylorstr. 9 | NaN | 1 | NaN | Berlin | Stephanie Schulze | Dahlem (Zehlendorf) | 320.94 | 0 | 105941148 | ... | 3 | 0 | 1125.81 | 5.0 | 106.50 | Familienfreundlich wohnen in ruhiger Lage | https://www.immobilienscout24.de/expose/105941148 | 14195 | 1050.313913 | 75.496087 |
2510 | Taylorstr. 15 | NaN | 0 | NaN | Berlin | Stephanie Schulze | Dahlem (Zehlendorf) | 291.39 | 0 | 105476421 | ... | 8 | 0 | 961.92 | 3.0 | 88.10 | Erstbezug nach Sanierung in Dahlem! | https://www.immobilienscout24.de/expose/105476421 | 14195 | 884.524685 | 77.395315 |
1412 | Dahlemer Weg 223 | NaN | 1 | NaN | Berlin | Möller Nadine | Zehlendorf (Zehlendorf) | 245.00 | 0 | 106484356 | ... | 9 | 0 | 780.00 | 3.0 | 70.96 | 3-Zi-Whg. am Heinrich-Laehr-Park - Besichtigun... | https://www.immobilienscout24.de/expose/106484356 | 14167 | 702.340400 | 77.659600 |
2037 | Hammerstraße, 42 | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 220.00 | 1 | 106129364 | ... | 28 | 1 | 925.43 | 2.0 | 79.82 | Helle 2-Zimmer-Luxus-Wohnung in ruhiger Lage | https://www.immobilienscout24.de/expose/106129364 | 14167 | 837.059869 | 88.370131 |
2200 | Beerenstr. 11 | NaN | 1 | NaN | Berlin | Pamela Wunsch | Zehlendorf (Zehlendorf) | 131.47 | 0 | 105949718 | ... | 4 | 0 | 444.82 | 1.0 | 35.38 | Ruhige Seniorenwohnung im schönen Zehlendorf | https://www.immobilienscout24.de/expose/105949718 | 14163 | 353.927513 | 90.892487 |
825 | Riemeisterstraße 4 | NaN | 1 | NaN | Berlin | Nils Bock | Zehlendorf (Zehlendorf) | 0.00 | 1 | 89388312 | ... | 8 | 1 | 350.00 | 1.0 | 25.00 | Studenten wohnen wie Gott in Frankreich | https://www.immobilienscout24.de/expose/89388312 | 14169 | 256.102859 | 93.897141 |
375 | Saargemünder Straße 27 b | NaN | 1 | NaN | Berlin | Sybille Löffelbein | Dahlem (Zehlendorf) | 179.00 | 1 | 106570653 | ... | 14 | 0 | 799.00 | 2.0 | 60.00 | "The Metropolitan Gardens" - Wohnen im Park: K... | https://www.immobilienscout24.de/expose/106570653 | 14195 | 696.992847 | 102.007153 |
2036 | Habelschwerdter Allee 1 | NaN | 1 | NaN | Berlin | Dennis Altinok | Dahlem (Zehlendorf) | 50.00 | 0 | 106129651 | ... | 12 | 0 | 499.00 | 1.0 | 37.65 | Helle 1-Zimmer Wohnung nahe der FU in super La... | https://www.immobilienscout24.de/expose/106129651 | 14195 | 378.861993 | 120.138007 |
1613 | Eschershauser Weg 29f | NaN | 1 | NaN | Berlin | Sabine Rösel | Zehlendorf (Zehlendorf) | 169.00 | 0 | 106365380 | ... | 10 | 0 | 650.00 | 2.0 | 53.00 | Spektakulärer Waldblick an der Krummen Lanke -... | https://www.immobilienscout24.de/expose/106365380 | 14163 | 526.266617 | 123.733383 |
1742 | Mörchinger Str. 63 | NaN | 0 | NaN | Berlin | Rayk Welke | Zehlendorf (Zehlendorf) | 111.10 | 0 | 106317810 | ... | 2 | 0 | 526.03 | 1.5 | 39.93 | Wir modernisieren für Sie! | https://www.immobilienscout24.de/expose/106317810 | 14169 | 387.216210 | 138.813790 |
611 | Schorlemer Allee 3 | NaN | 1 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 150.67 | 0 | 106296679 | ... | 7 | 0 | 860.40 | 2.5 | 71.70 | Schöne, helle und sanierte 2,5 Zimmer-Altbauwo... | https://www.immobilienscout24.de/expose/106296679 | 14195 | 721.071413 | 139.328587 |
1743 | Mörchinger Str. 59 | NaN | 0 | NaN | Berlin | Rayk Welke | Zehlendorf (Zehlendorf) | 88.25 | 0 | 106317805 | ... | 2 | 0 | 448.87 | 1.0 | 31.48 | ***Aus alt mach neu!!*** | https://www.immobilienscout24.de/expose/106317805 | 14169 | 305.001025 | 143.868975 |
3166 | Clayallee 311 | NaN | 1 | NaN | Berlin | Anne Gärtner | Zehlendorf (Zehlendorf) | 280.00 | 0 | 89349917 | ... | 6 | 1 | 1209.60 | 4.0 | 108.00 | Zehlendorf, Stadtvilla, DG Maisonette | https://www.immobilienscout24.de/expose/89349917 | 14169 | 1063.477757 | 146.122243 |
1904 | Lange Stüclen 7 | NaN | 1 | NaN | Berlin | NaN | Wannsee (Zehlendorf) | 600.00 | 1 | 106216844 | ... | 25 | 0 | 1775.00 | 5.0 | 149.44 | HOMESK - 5-Zimmer-Maisonette mit Terrasse in i... | https://www.immobilienscout24.de/expose/106216844 | 14109 | 1615.817765 | 159.182235 |
2773 | Podbielskiallee 40 | NaN | 1 | NaN | Berlin | Claudia von Zitzewitz | Dahlem (Zehlendorf) | 450.00 | 1 | 104558120 | ... | 12 | 0 | 1475.37 | 3.0 | 118.30 | 3 - Zimmer Wohnung mit Südterrasse in bester L... | https://www.immobilienscout24.de/expose/104558120 | 14195 | 1316.175402 | 159.194598 |
3186 | Königin-Luise-Str. 5 | NaN | 1 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 95.00 | 0 | 87475137 | ... | 16 | 0 | 395.00 | 1.0 | 19.37 | Möbliertes, modernes 1-Zi-Appartement ab 01.10... | https://www.immobilienscout24.de/expose/87475137 | 14195 | 231.193004 | 163.806996 |
719 | Königin-Luise-Straße 5 | NaN | 1 | NaN | Berlin | Karl-Heinz Jettinger | Dahlem (Zehlendorf) | 109.00 | 0 | 85047209 | ... | 16 | 0 | 520.00 | 1.0 | 30.50 | Großes Möbliertes Apartment für Studenten und ... | https://www.immobilienscout24.de/expose/85047209 | 14195 | 353.448845 | 166.551155 |
1153 | NaN | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 200.00 | 0 | 106574939 | ... | 5 | 1 | 600.00 | 2.0 | 51.00 | Schöne zwei Zimmer Wohnung in Berlin, Zehlendorf | https://www.immobilienscout24.de/expose/106574939 | 14167 | 426.655072 | 173.344928 |
2658 | Potsdamer Straße 38 | NaN | 0 | NaN | Berlin | Sascha Lobeck | Zehlendorf (Zehlendorf) | 97.00 | 0 | 105030507 | ... | 30 | 0 | 800.00 | 3.0 | 58.00 | Dachgeschoss-Wohnung in Berlin-Zehlendorf fris... | https://www.immobilienscout24.de/expose/105030507 | 14163 | 607.020651 | 192.979349 |
3196 | Glockenstraße 2 | NaN | 1 | NaN | Berlin | Gerd Plensky | Zehlendorf (Zehlendorf) | 267.90 | 1 | 85787616 | ... | 3 | 0 | 1320.04 | 3.0 | 105.64 | 3 Zimmer im EG und Souterrain in begehrter Wes... | https://www.immobilienscout24.de/expose/85787616 | 14163 | 1123.988531 | 196.051469 |
2494 | Königsstr. 67a | NaN | 0 | NaN | Berlin | Dr. Christian Schölzel | Wannsee (Zehlendorf) | 180.00 | 1 | 105511918 | ... | 10 | 1 | 350.00 | 1.0 | 20.00 | 1 Zimmer-Wohnung, ca. 20 qm mit Badesteg zum K... | https://www.immobilienscout24.de/expose/105511918 | 14109 | 141.968613 | 208.031387 |
854 | NaN | NaN | 1 | NaN | Berlin | Leon Karsten | Dahlem (Zehlendorf) | 177.00 | 1 | 106385218 | ... | 6 | 1 | 820.00 | 2.0 | 56.00 | Neubau-Wohnung in Dahlem (inkl. EBK & Balkon) | https://www.immobilienscout24.de/expose/106385218 | 14195 | 575.412597 | 244.587403 |
357 | Brettnacher Straße 21 | NaN | 1 | NaN | Berlin | Marc Zellner | Zehlendorf (Zehlendorf) | 190.00 | 0 | 105849682 | ... | 17 | 0 | 1110.00 | 2.5 | 79.30 | Umfassend modernisierte Wohnung mit Einbauküch... | https://www.immobilienscout24.de/expose/105849682 | 14167 | 857.677462 | 252.322538 |
739 | Flanaganstrasse 20 | NaN | 1 | NaN | Berlin | Stefan Hainzl | Dahlem (Zehlendorf) | 232.00 | 0 | 106596591 | ... | 0 | 1 | 1206.63 | 4.0 | 96.53 | Schöne vier Zimmer Wohnung direkt am Grunewald... | https://www.immobilienscout24.de/expose/106596591 | 14195 | 937.487235 | 269.142765 |
156 | Berliner Straße 12 | NaN | 0 | NaN | Berlin | Michael Röder | Zehlendorf (Zehlendorf) | 141.00 | 0 | 106368136 | ... | 9 | 1 | 1128.00 | 3.0 | 85.00 | TRAUMHAFT helle Wohnung, Stuck, Einbauküche, W... | https://www.immobilienscout24.de/expose/106368136 | 14169 | 825.955324 | 302.044676 |
1526 | Hampsteadstraße 33 | NaN | 1 | NaN | Berlin | Thomas Nölle | Zehlendorf (Zehlendorf) | 390.00 | 1 | 106418297 | ... | 18 | 1 | 1456.00 | 4.0 | 112.00 | Neuwertige 4-Zimmer-Erdgeschosswohnung mit Sou... | https://www.immobilienscout24.de/expose/106418297 | 14167 | 1148.125958 | 307.874042 |
1262 | NaN | NaN | 1 | NaN | Berlin | Franz Du Chesne | Dahlem (Zehlendorf) | 345.00 | 0 | 106533126 | ... | 15 | 0 | 1499.00 | 4.0 | 116.60 | Sanierte 4Zi Wohnung am Dreipfuhlpark mit Balk... | https://www.immobilienscout24.de/expose/106533126 | 14195 | 1182.461056 | 316.538944 |
139 | Berliner Straße 12 | NaN | 0 | NaN | Berlin | Thierry Dubois | Zehlendorf (Zehlendorf) | 132.00 | 0 | 104927243 | ... | 30 | 1 | 1065.00 | 3.0 | 77.00 | TRAUMHAFT helle Wohnung, Stuck, Einbauküche, W... | https://www.immobilienscout24.de/expose/104927243 | 14169 | 738.080505 | 326.919495 |
1560 | NaN | NaN | 1 | NaN | Berlin | Felicitas Rennert | Nikolassee (Zehlendorf) | 400.00 | 1 | 106384388 | ... | 20 | 0 | 1596.00 | 4.0 | 114.00 | Chices Wohnen mit netten Nachbarn, 151 m² auf ... | https://www.immobilienscout24.de/expose/106384388 | 14129 | 1247.737503 | 348.262497 |
906 | Teltower Damm 203 B | NaN | 0 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 265.00 | 0 | 66633796 | ... | 12 | 0 | 1141.80 | 2.0 | 74.53 | Barrierefreie 2-Zimmer-Wohnung | https://www.immobilienscout24.de/expose/66633796 | 14167 | 756.672208 | 385.127792 |
804 | Lutterbacher Str. 22 | NaN | 1 | NaN | Berlin | Bernhard Reiter | Zehlendorf (Zehlendorf) | 320.00 | 1 | 85123148 | ... | 6 | 1 | 1395.00 | 3.0 | 96.50 | Gehobenes Wohnen im Rhytmus der Jahreszeiten | https://www.immobilienscout24.de/expose/85123148 | 14167 | 999.073682 | 395.926318 |
3276 | NaN | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 350.00 | 0 | 62407818 | ... | 14 | 1 | 1800.00 | 6.0 | 147.00 | Exklusives Wohnen im Baudenkmal | https://www.immobilienscout24.de/expose/62407818 | 14163 | 1396.332157 | 403.667843 |
569 | Sundgauer Straße . | NaN | 1 | NaN | Berlin | Sandra Smarslik | Dahlem (Zehlendorf) | 240.00 | 0 | 106489995 | ... | 13 | 0 | 1170.00 | 2.0 | 69.00 | Einziehen und Wohlfühlen! Moderne, vollmöblier... | https://www.immobilienscout24.de/expose/106489995 | 14169 | 755.141225 | 414.858775 |
1656 | Charlottenburger Straße 6 | NaN | 1 | NaN | Berlin | Lars Thieme | Zehlendorf (Zehlendorf) | 200.00 | 1 | 106350242 | ... | 4 | 1 | 1500.00 | 3.0 | 100.00 | Sehr helle und ruhige 3 Zimmer Wohnung (Neubau) | https://www.immobilienscout24.de/expose/106350242 | 14169 | 1037.518915 | 462.481085 |
1508 | Am Hirschsprung 59 C | NaN | 0 | NaN | Berlin | Reinhard Timm e. K. | Dahlem (Zehlendorf) | 400.00 | 0 | 106434786 | ... | 29 | 0 | 1900.00 | 3.0 | 130.00 | Top-Dahlem-Lage: Schönes Reihenmittelhaus mit ... | https://www.immobilienscout24.de/expose/106434786 | 14195 | 1397.894018 | 502.105982 |
2533 | Goßlerstraße 15 | NaN | 0 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 150.00 | 1 | 105408183 | ... | 14 | 1 | 1250.00 | 3.0 | 71.00 | 71qm in Dahlem Altbauvilla (möbliert) | https://www.immobilienscout24.de/expose/105408183 | 14195 | 712.885184 | 537.114816 |
141 | Kleiststraße 30 | NaN | 1 | NaN | Berlin | Uwe Peschel | Zehlendorf (Zehlendorf) | 200.00 | 0 | 69450128 | ... | 14 | 0 | 1590.00 | 3.0 | 86.00 | Toplage!Attraktives Penthouse in einer Stadtvi... | https://www.immobilienscout24.de/expose/69450128 | 14163 | 920.670030 | 669.329970 |
60 rows × 23 columns
from tpot import TPOTRegressor
from sklearn.model_selection import train_test_split
# reduce the training set for tpot to 10%, otherwise tpot will take a lot of time
X_train, _ , y_train, _ = train_test_split(X, y,train_size=0.10, test_size=0.90)
tpot = TPOTRegressor(generations=5, population_size=20, verbosity=2, scoring="r2")
tpot.fit(X_train, y_train)
print(tpot.score(X_test, y_test))
Warning: xgboost.XGBRegressor is not available and will not be used by TPOT.
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/sklearn/utils/validation.py:578: DataConversionWarning: A column-vector y was passed when a 1d array was expected. Please change the shape of y to (n_samples, ), for example using ravel(). y = column_or_1d(y, warn=True) Optimization Progress: 33%|███▎ | 40/120 [04:38<08:21, 6.27s/pipeline]
Generation 1 - Current best internal CV score: 0.798568751396417
Optimization Progress: 50%|█████ | 60/120 [07:09<13:03, 13.06s/pipeline]
Generation 2 - Current best internal CV score: 0.798568751396417
Optimization Progress: 67%|██████▋ | 80/120 [09:18<02:04, 3.12s/pipeline]
Generation 3 - Current best internal CV score: 0.8209218944357476
Optimization Progress: 83%|████████▎ | 100/120 [10:49<01:33, 4.69s/pipeline]
Generation 4 - Current best internal CV score: 0.8215888652967465
Generation 5 - Current best internal CV score: 0.8215888652967465 Best pipeline: KNeighborsRegressor(RidgeCV(input_matrix), n_neighbors=40, p=2, weights=distance) 0.46449375770157664
y_pred = tpot.predict(X_test)
r2_score(y_test, y_pred)
0.46449375770157664
df3_test["rent_predicted2"] = y_pred
df3_test["rent_error2"] = df3_test["rent"] - df3_test["rent_predicted2"]
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy """Entry point for launching an IPython kernel. /Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
top = df3_test.sort_values("rent_error2")
top[top["district"].str.contains("Zehlendorf")]
address | area | balcony | cellar | city | contact_name | district | extra_costs | garden | immo_id | ... | rent | rooms | sqm | title | url | zip_code | rent_predicted | rent_error | rent_predicted2 | rent_error2 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1933 | NaN | NaN | 0 | NaN | Berlin | Philipp Vormeier | Zehlendorf (Zehlendorf) | 240.00 | 1 | 106200307 | ... | 950.00 | 4.0 | 105.00 | Ruhige Wohnung in Berlin, Zehlendorf | https://www.immobilienscout24.de/expose/106200307 | 14167 | 1065.147978 | -115.147978 | 1260.052699 | -310.052699 |
3169 | Von-der-Trenck-Straße 5 A | NaN | 1 | NaN | Berlin | Wohnbau Service Bonn GmbH Service Team | Nikolassee (Zehlendorf) | 195.98 | 1 | 89168579 | ... | 535.02 | 2.0 | 67.04 | WBS erforderlich!!! ruhige Wohnung mit Garten | https://www.immobilienscout24.de/expose/89168579 | 14129 | 774.322687 | -239.302687 | 802.642642 | -267.622642 |
3090 | Alsterweg 53 | NaN | 1 | NaN | Berlin | Dave Felgenhauer | Zehlendorf (Zehlendorf) | 164.00 | 1 | 95781013 | ... | 408.18 | 1.5 | 52.68 | Bereits modernisierte Wohnung, mit großem Balk... | https://www.immobilienscout24.de/expose/95781013 | 14167 | 574.065009 | -165.885009 | 591.347406 | -183.167406 |
3151 | Von-der-Trenck-Straße 3 | NaN | 1 | NaN | Berlin | Wohnbau Service Bonn GmbH Service Team | Nikolassee (Zehlendorf) | 182.17 | 0 | 90729049 | ... | 451.83 | 1.5 | 56.62 | Wohnen in der Natur! WBS erforderlich! Einbauk... | https://www.immobilienscout24.de/expose/90729049 | 14129 | 629.757535 | -177.927535 | 634.260168 | -182.430168 |
1071 | Marshallstr. 9 | NaN | 1 | NaN | Berlin | GmbH PRINTS | Dahlem (Zehlendorf) | 298.00 | 0 | 106595282 | ... | 1048.23 | 3.0 | 110.00 | +NAHE GRUNEWALD+SONNENBALKON+PARKETT+WOHNKÜCHE | https://www.immobilienscout24.de/expose/106595282 | 14169 | 1131.169515 | -82.939515 | 1215.975747 | -167.745747 |
2492 | Hugo Vogel Straße 6 | NaN | 1 | NaN | Berlin | Achim Emde | Wannsee (Zehlendorf) | 257.00 | 0 | 105518230 | ... | 1270.00 | 4.0 | 124.80 | Ansprechende 4-Zimmer-Wohnung zur Miete in Wan... | https://www.immobilienscout24.de/expose/105518230 | 14109 | 1248.014875 | 21.985125 | 1424.893534 | -154.893534 |
1385 | NaN | NaN | 1 | NaN | Berlin | Ralph Wodrich | Wannsee (Zehlendorf) | 756.00 | 1 | 106495039 | ... | 1628.00 | 3.0 | 148.00 | WANNSEE : EG-Maisonetten-Wohnung direkt am Kle... | https://www.immobilienscout24.de/expose/106495039 | 14109 | 1642.410666 | -14.410666 | 1734.694538 | -106.694538 |
1790 | Am Sandwerder 24 | NaN | 1 | NaN | Berlin | Jörg-M. Meier | Wannsee (Zehlendorf) | 215.00 | 0 | 106291069 | ... | 530.00 | 2.0 | 61.01 | Helle 2-Zimmerwohnung im Grünen, nahe Wannsee. | https://www.immobilienscout24.de/expose/106291069 | 14109 | 614.251279 | -84.251279 | 629.856273 | -99.856273 |
3261 | NaN | NaN | 1 | NaN | Berlin | G. Schmidt | Zehlendorf (Zehlendorf) | 315.00 | 1 | 68925463 | ... | 910.00 | 3.0 | 83.00 | 3-Zi.-Wohnung mit Terrasse u. Garten in sehr g... | https://www.immobilienscout24.de/expose/68925463 | 14169 | 850.784925 | 59.215075 | 1005.441058 | -95.441058 |
2181 | Starkenburger Str. 3 | NaN | 0 | NaN | Berlin | Yvonne Fuchs | Zehlendorf (Zehlendorf) | 348.00 | 0 | 105996967 | ... | 1005.30 | 3.5 | 100.53 | ++Wir renovieren für Sie: Ansprechende 3,5-Zim... | https://www.immobilienscout24.de/expose/105996967 | 14163 | 1010.457592 | -5.157592 | 1096.988452 | -91.688452 |
825 | Riemeisterstraße 4 | NaN | 1 | NaN | Berlin | Nils Bock | Zehlendorf (Zehlendorf) | 0.00 | 1 | 89388312 | ... | 350.00 | 1.0 | 25.00 | Studenten wohnen wie Gott in Frankreich | https://www.immobilienscout24.de/expose/89388312 | 14169 | 256.102859 | 93.897141 | 433.109380 | -83.109380 |
713 | Potsdamer Chaussee 26 | NaN | 0 | NaN | Berlin | Mirko Neumann | Nikolassee (Zehlendorf) | 340.00 | 1 | 57300477 | ... | 1400.00 | 4.0 | 140.00 | Schöne, geräumige 4Zimmerwohnung im Dachgescho... | https://www.immobilienscout24.de/expose/57300477 | 14129 | 1396.475338 | 3.524662 | 1459.929540 | -59.929540 |
2604 | Düppelstr. 19 | NaN | 0 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 115.00 | 0 | 105189965 | ... | 570.00 | 2.0 | 55.64 | Tolle Wohnung in ruhiger Zehlendorf-Lage | https://www.immobilienscout24.de/expose/105189965 | 14163 | 602.302764 | -32.302764 | 629.408644 | -59.408644 |
3166 | Clayallee 311 | NaN | 1 | NaN | Berlin | Anne Gärtner | Zehlendorf (Zehlendorf) | 280.00 | 0 | 89349917 | ... | 1209.60 | 4.0 | 108.00 | Zehlendorf, Stadtvilla, DG Maisonette | https://www.immobilienscout24.de/expose/89349917 | 14169 | 1063.477757 | 146.122243 | 1265.753563 | -56.153563 |
2037 | Hammerstraße, 42 | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 220.00 | 1 | 106129364 | ... | 925.43 | 2.0 | 79.82 | Helle 2-Zimmer-Luxus-Wohnung in ruhiger Lage | https://www.immobilienscout24.de/expose/106129364 | 14167 | 837.059869 | 88.370131 | 955.697621 | -30.267621 |
1064 | Pritchardstraße 13 | NaN | 1 | NaN | Berlin | Axel Pfeiffer | Dahlem (Zehlendorf) | 241.00 | 0 | 106596584 | ... | 868.05 | 3.0 | 89.49 | 3 Zimmer mit Balkon Nähe Grunewald ab September | https://www.immobilienscout24.de/expose/106596584 | 14169 | 905.880449 | -37.830449 | 885.648723 | -17.598723 |
623 | NaN | NaN | 1 | NaN | Berlin | Ralph Wodrich | Wannsee (Zehlendorf) | 550.00 | 1 | 106245902 | ... | 1180.00 | 2.0 | 98.79 | WANNSEE in Bestlage. : Attr. BALKON-Wohnung di... | https://www.immobilienscout24.de/expose/106245902 | 14109 | 1123.075873 | 56.924127 | 1197.245279 | -17.245279 |
3147 | Mörchinger Str. 25 | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 120.00 | 0 | 91171284 | ... | 450.00 | 1.0 | 35.00 | Einzimmerwohnung im Grünen von Zehlendorf - ho... | https://www.immobilienscout24.de/expose/91171284 | 14169 | 402.878430 | 47.121570 | 454.560786 | -4.560786 |
1451 | Breitensteinweg 10 | NaN | 1 | NaN | Berlin | Julia Ziglowski | Zehlendorf (Zehlendorf) | 120.00 | 0 | 106460055 | ... | 521.54 | 2.0 | 49.67 | Sonnenbalkon + Wohnküche, das passt! | https://www.immobilienscout24.de/expose/106460055 | 14165 | 489.688724 | 31.851276 | 518.242532 | 3.297468 |
3083 | Albertinenstr. 12 | NaN | 1 | NaN | Berlin | BITTE NUR PER EMAIL WGW Hausverwaltung GmbH | Zehlendorf (Zehlendorf) | 350.00 | 1 | 96253253 | ... | 950.00 | 3.0 | 85.00 | SCHÖNE, HELLE 3-ZIMMERWOHNUNG MIT BALKON IN ZE... | https://www.immobilienscout24.de/expose/96253253 | 14169 | 950.396470 | -0.396470 | 936.127064 | 13.872936 |
2494 | Königsstr. 67a | NaN | 0 | NaN | Berlin | Dr. Christian Schölzel | Wannsee (Zehlendorf) | 180.00 | 1 | 105511918 | ... | 350.00 | 1.0 | 20.00 | 1 Zimmer-Wohnung, ca. 20 qm mit Badesteg zum K... | https://www.immobilienscout24.de/expose/105511918 | 14109 | 141.968613 | 208.031387 | 335.170410 | 14.829590 |
2200 | Beerenstr. 11 | NaN | 1 | NaN | Berlin | Pamela Wunsch | Zehlendorf (Zehlendorf) | 131.47 | 0 | 105949718 | ... | 444.82 | 1.0 | 35.38 | Ruhige Seniorenwohnung im schönen Zehlendorf | https://www.immobilienscout24.de/expose/105949718 | 14163 | 353.927513 | 90.892487 | 420.942562 | 23.877438 |
3055 | Ramsteinweg 23 | NaN | 0 | NaN | Berlin | Dennis Hirschberg | Zehlendorf (Zehlendorf) | 147.03 | 1 | 98023697 | ... | 606.05 | 2.0 | 52.70 | +++ ACHTUNG +++ NEUBAU RAMSTEINWEG 23 SUCHT NA... | https://www.immobilienscout24.de/expose/98023697 | 14165 | 557.594590 | 48.455410 | 574.921206 | 31.128794 |
1752 | Sangebuchtweg 11 | NaN | 1 | NaN | Berlin | NaN | Wannsee (Zehlendorf) | 320.00 | 0 | 106315694 | ... | 1099.00 | 3.0 | 107.00 | Erstbezug nach Modernisierung! 3-Zimmer-Wohnun... | https://www.immobilienscout24.de/expose/106315694 | 14109 | 1098.216458 | 0.783542 | 1061.379450 | 37.620550 |
1980 | Breisgauer Str. 4 | NaN | 0 | NaN | Berlin | NaN | Nikolassee (Zehlendorf) | 117.00 | 0 | 106174394 | ... | 495.00 | 1.0 | 42.05 | 1-Zi-Apartment nahe Schlachtensee | https://www.immobilienscout24.de/expose/106174394 | 14129 | 474.230600 | 20.769400 | 454.515762 | 40.484238 |
1412 | Dahlemer Weg 223 | NaN | 1 | NaN | Berlin | Möller Nadine | Zehlendorf (Zehlendorf) | 245.00 | 0 | 106484356 | ... | 780.00 | 3.0 | 70.96 | 3-Zi-Whg. am Heinrich-Laehr-Park - Besichtigun... | https://www.immobilienscout24.de/expose/106484356 | 14167 | 702.340400 | 77.659600 | 739.295399 | 40.704601 |
2773 | Podbielskiallee 40 | NaN | 1 | NaN | Berlin | Claudia von Zitzewitz | Dahlem (Zehlendorf) | 450.00 | 1 | 104558120 | ... | 1475.37 | 3.0 | 118.30 | 3 - Zimmer Wohnung mit Südterrasse in bester L... | https://www.immobilienscout24.de/expose/104558120 | 14195 | 1316.175402 | 159.194598 | 1433.912052 | 41.457948 |
3186 | Königin-Luise-Str. 5 | NaN | 1 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 95.00 | 0 | 87475137 | ... | 395.00 | 1.0 | 19.37 | Möbliertes, modernes 1-Zi-Appartement ab 01.10... | https://www.immobilienscout24.de/expose/87475137 | 14195 | 231.193004 | 163.806996 | 353.431037 | 41.568963 |
252 | Spilstraße 10 | NaN | 0 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 212.42 | 1 | 106296522 | ... | 900.96 | 2.0 | 75.08 | Helle und sanierte 2 Zimmer-Altbauwohnung in S... | https://www.immobilienscout24.de/expose/106296522 | 14195 | 856.549366 | 44.410634 | 858.729302 | 42.230698 |
375 | Saargemünder Straße 27 b | NaN | 1 | NaN | Berlin | Sybille Löffelbein | Dahlem (Zehlendorf) | 179.00 | 1 | 106570653 | ... | 799.00 | 2.0 | 60.00 | "The Metropolitan Gardens" - Wohnen im Park: K... | https://www.immobilienscout24.de/expose/106570653 | 14195 | 696.992847 | 102.007153 | 749.583324 | 49.416676 |
1904 | Lange Stüclen 7 | NaN | 1 | NaN | Berlin | NaN | Wannsee (Zehlendorf) | 600.00 | 1 | 106216844 | ... | 1775.00 | 5.0 | 149.44 | HOMESK - 5-Zimmer-Maisonette mit Terrasse in i... | https://www.immobilienscout24.de/expose/106216844 | 14109 | 1615.817765 | 159.182235 | 1722.101715 | 52.898285 |
2336 | Hocksteinweg 17 | NaN | 0 | NaN | Berlin | Alexandra Nepomnyashcha | Zehlendorf (Zehlendorf) | 156.00 | 0 | 105796491 | ... | 590.00 | 2.5 | 53.55 | Kleines gemütliches Heim in einer angenehmen S... | https://www.immobilienscout24.de/expose/105796491 | 14165 | 515.617905 | 74.382095 | 520.540860 | 69.459140 |
2232 | Taylorstr. 9 | NaN | 1 | NaN | Berlin | Stephanie Schulze | Dahlem (Zehlendorf) | 320.94 | 0 | 105941148 | ... | 1125.81 | 5.0 | 106.50 | Familienfreundlich wohnen in ruhiger Lage | https://www.immobilienscout24.de/expose/105941148 | 14195 | 1050.313913 | 75.496087 | 1056.003654 | 69.806346 |
1153 | NaN | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 200.00 | 0 | 106574939 | ... | 600.00 | 2.0 | 51.00 | Schöne zwei Zimmer Wohnung in Berlin, Zehlendorf | https://www.immobilienscout24.de/expose/106574939 | 14167 | 426.655072 | 173.344928 | 518.510297 | 81.489703 |
2036 | Habelschwerdter Allee 1 | NaN | 1 | NaN | Berlin | Dennis Altinok | Dahlem (Zehlendorf) | 50.00 | 0 | 106129651 | ... | 499.00 | 1.0 | 37.65 | Helle 1-Zimmer Wohnung nahe der FU in super La... | https://www.immobilienscout24.de/expose/106129651 | 14195 | 378.861993 | 120.138007 | 416.737225 | 82.262775 |
1743 | Mörchinger Str. 59 | NaN | 0 | NaN | Berlin | Rayk Welke | Zehlendorf (Zehlendorf) | 88.25 | 0 | 106317805 | ... | 448.87 | 1.0 | 31.48 | ***Aus alt mach neu!!*** | https://www.immobilienscout24.de/expose/106317805 | 14169 | 305.001025 | 143.868975 | 366.270552 | 82.599448 |
2274 | Podbielskiallee 68 | NaN | 0 | NaN | Berlin | Markus Krause | Dahlem (Zehlendorf) | 204.00 | 1 | 105901612 | ... | 795.00 | 2.0 | 65.00 | schöne teilmöblierte 2 Zi. in Dahlemlage | https://www.immobilienscout24.de/expose/105901612 | 14195 | 745.827094 | 49.172906 | 706.101033 | 88.898967 |
719 | Königin-Luise-Straße 5 | NaN | 1 | NaN | Berlin | Karl-Heinz Jettinger | Dahlem (Zehlendorf) | 109.00 | 0 | 85047209 | ... | 520.00 | 1.0 | 30.50 | Großes Möbliertes Apartment für Studenten und ... | https://www.immobilienscout24.de/expose/85047209 | 14195 | 353.448845 | 166.551155 | 419.178517 | 100.821483 |
3196 | Glockenstraße 2 | NaN | 1 | NaN | Berlin | Gerd Plensky | Zehlendorf (Zehlendorf) | 267.90 | 1 | 85787616 | ... | 1320.04 | 3.0 | 105.64 | 3 Zimmer im EG und Souterrain in begehrter Wes... | https://www.immobilienscout24.de/expose/85787616 | 14163 | 1123.988531 | 196.051469 | 1217.931447 | 102.108553 |
1742 | Mörchinger Str. 63 | NaN | 0 | NaN | Berlin | Rayk Welke | Zehlendorf (Zehlendorf) | 111.10 | 0 | 106317810 | ... | 526.03 | 1.5 | 39.93 | Wir modernisieren für Sie! | https://www.immobilienscout24.de/expose/106317810 | 14169 | 387.216210 | 138.813790 | 407.045002 | 118.984998 |
1526 | Hampsteadstraße 33 | NaN | 1 | NaN | Berlin | Thomas Nölle | Zehlendorf (Zehlendorf) | 390.00 | 1 | 106418297 | ... | 1456.00 | 4.0 | 112.00 | Neuwertige 4-Zimmer-Erdgeschosswohnung mit Sou... | https://www.immobilienscout24.de/expose/106418297 | 14167 | 1148.125958 | 307.874042 | 1331.687891 | 124.312109 |
2510 | Taylorstr. 15 | NaN | 0 | NaN | Berlin | Stephanie Schulze | Dahlem (Zehlendorf) | 291.39 | 0 | 105476421 | ... | 961.92 | 3.0 | 88.10 | Erstbezug nach Sanierung in Dahlem! | https://www.immobilienscout24.de/expose/105476421 | 14195 | 884.524685 | 77.395315 | 835.823806 | 126.096194 |
1613 | Eschershauser Weg 29f | NaN | 1 | NaN | Berlin | Sabine Rösel | Zehlendorf (Zehlendorf) | 169.00 | 0 | 106365380 | ... | 650.00 | 2.0 | 53.00 | Spektakulärer Waldblick an der Krummen Lanke -... | https://www.immobilienscout24.de/expose/106365380 | 14163 | 526.266617 | 123.733383 | 517.658254 | 132.341746 |
611 | Schorlemer Allee 3 | NaN | 1 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 150.67 | 0 | 106296679 | ... | 860.40 | 2.5 | 71.70 | Schöne, helle und sanierte 2,5 Zimmer-Altbauwo... | https://www.immobilienscout24.de/expose/106296679 | 14195 | 721.071413 | 139.328587 | 725.105191 | 135.294809 |
739 | Flanaganstrasse 20 | NaN | 1 | NaN | Berlin | Stefan Hainzl | Dahlem (Zehlendorf) | 232.00 | 0 | 106596591 | ... | 1206.63 | 4.0 | 96.53 | Schöne vier Zimmer Wohnung direkt am Grunewald... | https://www.immobilienscout24.de/expose/106596591 | 14195 | 937.487235 | 269.142765 | 1070.342618 | 136.287382 |
854 | NaN | NaN | 1 | NaN | Berlin | Leon Karsten | Dahlem (Zehlendorf) | 177.00 | 1 | 106385218 | ... | 820.00 | 2.0 | 56.00 | Neubau-Wohnung in Dahlem (inkl. EBK & Balkon) | https://www.immobilienscout24.de/expose/106385218 | 14195 | 575.412597 | 244.587403 | 673.233478 | 146.766522 |
2658 | Potsdamer Straße 38 | NaN | 0 | NaN | Berlin | Sascha Lobeck | Zehlendorf (Zehlendorf) | 97.00 | 0 | 105030507 | ... | 800.00 | 3.0 | 58.00 | Dachgeschoss-Wohnung in Berlin-Zehlendorf fris... | https://www.immobilienscout24.de/expose/105030507 | 14163 | 607.020651 | 192.979349 | 628.095894 | 171.904106 |
1262 | NaN | NaN | 1 | NaN | Berlin | Franz Du Chesne | Dahlem (Zehlendorf) | 345.00 | 0 | 106533126 | ... | 1499.00 | 4.0 | 116.60 | Sanierte 4Zi Wohnung am Dreipfuhlpark mit Balk... | https://www.immobilienscout24.de/expose/106533126 | 14195 | 1182.461056 | 316.538944 | 1280.065191 | 218.934809 |
156 | Berliner Straße 12 | NaN | 0 | NaN | Berlin | Michael Röder | Zehlendorf (Zehlendorf) | 141.00 | 0 | 106368136 | ... | 1128.00 | 3.0 | 85.00 | TRAUMHAFT helle Wohnung, Stuck, Einbauküche, W... | https://www.immobilienscout24.de/expose/106368136 | 14169 | 825.955324 | 302.044676 | 901.894797 | 226.105203 |
1560 | NaN | NaN | 1 | NaN | Berlin | Felicitas Rennert | Nikolassee (Zehlendorf) | 400.00 | 1 | 106384388 | ... | 1596.00 | 4.0 | 114.00 | Chices Wohnen mit netten Nachbarn, 151 m² auf ... | https://www.immobilienscout24.de/expose/106384388 | 14129 | 1247.737503 | 348.262497 | 1356.174413 | 239.825587 |
357 | Brettnacher Straße 21 | NaN | 1 | NaN | Berlin | Marc Zellner | Zehlendorf (Zehlendorf) | 190.00 | 0 | 105849682 | ... | 1110.00 | 2.5 | 79.30 | Umfassend modernisierte Wohnung mit Einbauküch... | https://www.immobilienscout24.de/expose/105849682 | 14167 | 857.677462 | 252.322538 | 849.797722 | 260.202278 |
3276 | NaN | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 350.00 | 0 | 62407818 | ... | 1800.00 | 6.0 | 147.00 | Exklusives Wohnen im Baudenkmal | https://www.immobilienscout24.de/expose/62407818 | 14163 | 1396.332157 | 403.667843 | 1531.081185 | 268.918815 |
804 | Lutterbacher Str. 22 | NaN | 1 | NaN | Berlin | Bernhard Reiter | Zehlendorf (Zehlendorf) | 320.00 | 1 | 85123148 | ... | 1395.00 | 3.0 | 96.50 | Gehobenes Wohnen im Rhytmus der Jahreszeiten | https://www.immobilienscout24.de/expose/85123148 | 14167 | 999.073682 | 395.926318 | 1121.535427 | 273.464573 |
139 | Berliner Straße 12 | NaN | 0 | NaN | Berlin | Thierry Dubois | Zehlendorf (Zehlendorf) | 132.00 | 0 | 104927243 | ... | 1065.00 | 3.0 | 77.00 | TRAUMHAFT helle Wohnung, Stuck, Einbauküche, W... | https://www.immobilienscout24.de/expose/104927243 | 14169 | 738.080505 | 326.919495 | 772.676235 | 292.323765 |
1656 | Charlottenburger Straße 6 | NaN | 1 | NaN | Berlin | Lars Thieme | Zehlendorf (Zehlendorf) | 200.00 | 1 | 106350242 | ... | 1500.00 | 3.0 | 100.00 | Sehr helle und ruhige 3 Zimmer Wohnung (Neubau) | https://www.immobilienscout24.de/expose/106350242 | 14169 | 1037.518915 | 462.481085 | 1202.181512 | 297.818488 |
906 | Teltower Damm 203 B | NaN | 0 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 265.00 | 0 | 66633796 | ... | 1141.80 | 2.0 | 74.53 | Barrierefreie 2-Zimmer-Wohnung | https://www.immobilienscout24.de/expose/66633796 | 14167 | 756.672208 | 385.127792 | 708.356545 | 433.443455 |
2533 | Goßlerstraße 15 | NaN | 0 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 150.00 | 1 | 105408183 | ... | 1250.00 | 3.0 | 71.00 | 71qm in Dahlem Altbauvilla (möbliert) | https://www.immobilienscout24.de/expose/105408183 | 14195 | 712.885184 | 537.114816 | 802.250537 | 447.749463 |
569 | Sundgauer Straße . | NaN | 1 | NaN | Berlin | Sandra Smarslik | Dahlem (Zehlendorf) | 240.00 | 0 | 106489995 | ... | 1170.00 | 2.0 | 69.00 | Einziehen und Wohlfühlen! Moderne, vollmöblier... | https://www.immobilienscout24.de/expose/106489995 | 14169 | 755.141225 | 414.858775 | 708.755624 | 461.244376 |
1508 | Am Hirschsprung 59 C | NaN | 0 | NaN | Berlin | Reinhard Timm e. K. | Dahlem (Zehlendorf) | 400.00 | 0 | 106434786 | ... | 1900.00 | 3.0 | 130.00 | Top-Dahlem-Lage: Schönes Reihenmittelhaus mit ... | https://www.immobilienscout24.de/expose/106434786 | 14195 | 1397.894018 | 502.105982 | 1402.905561 | 497.094439 |
141 | Kleiststraße 30 | NaN | 1 | NaN | Berlin | Uwe Peschel | Zehlendorf (Zehlendorf) | 200.00 | 0 | 69450128 | ... | 1590.00 | 3.0 | 86.00 | Toplage!Attraktives Penthouse in einer Stadtvi... | https://www.immobilienscout24.de/expose/69450128 | 14163 | 920.670030 | 669.329970 | 965.793145 | 624.206855 |
60 rows × 25 columns
top.sort_values("rent_error2")
address | area | balcony | cellar | city | contact_name | district | extra_costs | garden | immo_id | ... | rent | rooms | sqm | title | url | zip_code | rent_predicted | rent_error | rent_predicted2 | rent_error2 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
936 | Wattstrasse 11 | NaN | 0 | NaN | Berlin | Sarah Bauer | Oberschöneweide (Köpenick) | 150.00 | 1 | 106621033 | ... | 828.00 | 4.0 | 120.00 | Charismatisches Dachgeschoss mit viel Platz in... | https://www.immobilienscout24.de/expose/106621033 | 12459 | 1229.913263 | -401.913263 | 1419.280170 | -591.280170 |
3245 | Luckenwalder Straße 70 | NaN | 1 | NaN | Berlin | Vermietungsbüro "Grüne Mitte" | Hellersdorf (Hellersdorf) | 454.68 | 0 | 74225906 | ... | 1182.16 | 4.0 | 181.87 | Toller Ausblick auf 2 Etagen mit 2 Balkonen | https://www.immobilienscout24.de/expose/74225906 | 12629 | 1899.409731 | -717.249731 | 1769.416972 | -587.256972 |
1334 | Sakrower Landstraße 23 | NaN | 1 | NaN | Berlin | Carola Dumont | Kladow (Spandau) | 300.00 | 1 | 106510836 | ... | 1018.64 | 5.0 | 133.68 | Maisonette Wohnung im Kladower Ortskern ! | https://www.immobilienscout24.de/expose/106510836 | 14089 | 1442.704373 | -424.064373 | 1529.608336 | -510.968336 |
916 | NaN | NaN | 1 | NaN | Berlin | Vanessa Laribi | Charlottenburg (Charlottenburg) | 100.00 | 0 | 104559726 | ... | 1250.00 | 4.0 | 155.00 | Stilvolle, geräumige und gepflegte 4-Zimmer-Wo... | https://www.immobilienscout24.de/expose/104559726 | 14059 | 1579.742315 | -329.742315 | 1711.121614 | -461.121614 |
902 | Königsseestr. 10 | NaN | 1 | NaN | Berlin | Christian Dabelstein | Grünau (Köpenick) | 241.00 | 1 | 98142202 | ... | 953.00 | 2.0 | 112.08 | Grünau: helle, ruhige 2 Zi. mit Garten am Wass... | https://www.immobilienscout24.de/expose/98142202 | 12527 | 1269.057915 | -316.057915 | 1406.127224 | -453.127224 |
335 | Cunostr. 8 | NaN | 1 | NaN | Berlin | Carolin Vonderau | Schmargendorf (Wilmersdorf) | 454.60 | 0 | 106434812 | ... | 1006.12 | 4.0 | 133.71 | Helles Wohnen in großzügiger Wohnung in Schmar... | https://www.immobilienscout24.de/expose/106434812 | 14199 | 1423.528295 | -417.408295 | 1455.525524 | -449.405524 |
3234 | Zwieseler Str. 40-40d | NaN | 1 | NaN | Berlin | NaN | Karlshorst (Lichtenberg) | 370.88 | 0 | 77198368 | ... | 799.71 | 2.0 | 115.90 | Wohnen über den Dächern von Karlshorst | https://www.immobilienscout24.de/expose/77198368 | 10318 | 1217.182377 | -417.472377 | 1248.638370 | -448.928370 |
3300 | Stresowstr. 4 | NaN | 1 | NaN | Berlin | Marcel Reiche | Spandau (Spandau) | 301.00 | 0 | 42788681 | ... | 629.45 | 3.0 | 91.49 | 3- Zi-Wohnung mit Balkon in Berlin Spandau, au... | https://www.immobilienscout24.de/expose/42788681 | 13597 | 980.974124 | -351.524124 | 1062.876268 | -433.426268 |
997 | Hohenzollerndamm 89 | NaN | 1 | NaN | Berlin | NaN | Schmargendorf (Wilmersdorf) | 320.00 | 0 | 106614079 | ... | 1300.00 | 5.5 | 153.00 | geräumige 5-Zimmerwohnung am Roseneck | https://www.immobilienscout24.de/expose/106614079 | 14199 | 1603.608675 | -303.608675 | 1720.608705 | -420.608705 |
3257 | NaN | NaN | 0 | NaN | Berlin | Felix Thurmann | Charlottenburg (Charlottenburg) | 235.00 | 1 | 70405282 | ... | 812.00 | 4.5 | 116.00 | ruhige 116 qm Souterrainwohnung im Villenviert... | https://www.immobilienscout24.de/expose/70405282 | 14055 | 1122.248291 | -310.248291 | 1228.330025 | -416.330025 |
2605 | Lynarstr. 25 | NaN | 1 | NaN | Berlin | Vermietungsteam Stadthaus Verwaltungsgesellschaft | Spandau (Spandau) | 246.00 | 0 | 105189880 | ... | 953.00 | 4.0 | 118.20 | Spandau Lutherplatz! 4 Zimmer - Wassernähe - B... | https://www.immobilienscout24.de/expose/105189880 | 13585 | 1253.160991 | -300.160991 | 1368.183716 | -415.183716 |
1123 | NaN | NaN | 0 | NaN | Berlin | Marina Schulze | Rudow (Neukölln) | 160.31 | 1 | 106588396 | ... | 605.00 | 2.0 | 86.00 | Kuschliges 2-Zimmer Dachgeschoss in Berlin-Rud... | https://www.immobilienscout24.de/expose/106588396 | 12357 | 976.498493 | -371.498493 | 1015.999039 | -410.999039 |
2969 | NaN | NaN | 1 | NaN | Berlin | Sylvie Winckel | Niederschöneweide (Treptow) | 350.00 | 0 | 102237882 | ... | 1299.00 | 4.0 | 162.33 | Sehr repräsentativ – Eckwohnung am Bahnhof Sch... | https://www.immobilienscout24.de/expose/102237882 | 12439 | 1684.775487 | -385.775487 | 1702.100317 | -403.100317 |
2390 | Schildhornstrasse 77 | NaN | 1 | NaN | Berlin | Hardy Ney | Steglitz (Steglitz) | 304.00 | 0 | 105725420 | ... | 658.66 | 4.0 | 98.75 | 4-Zi. Loggia-Balkonwohnung nahe Schloßstr. (WB... | https://www.immobilienscout24.de/expose/105725420 | 12163 | 1039.515338 | -380.855338 | 1061.055928 | -402.395928 |
871 | Lindenallee 27 | NaN | 1 | NaN | Berlin | Jessica Koenig | Friedrichshagen (Köpenick) | 250.00 | 1 | 106362748 | ... | 1300.00 | 3.0 | 146.00 | Wohlfühlen für Familien in Sanierter Stadtvilla | https://www.immobilienscout24.de/expose/106362748 | 12587 | 1620.441962 | -320.441962 | 1699.797717 | -399.797717 |
3120 | Schirnerstr. 23 | NaN | 0 | NaN | Berlin | Stephan Dorgerloh | Altglienicke (Treptow) | 130.00 | 0 | 93355803 | ... | 817.50 | 3.0 | 109.00 | Ruhige geräumige Dreizimmerwohnung mit Galerie... | https://www.immobilienscout24.de/expose/93355803 | 12524 | 1089.579779 | -272.079779 | 1208.437812 | -390.937812 |
22 | Manteuffelstr. 57a | NaN | 0 | NaN | Berlin | Vermietungsteam Stadthaus Verwaltungsgesellschaft | Tempelhof (Tempelhof) | 185.00 | 0 | 105298708 | ... | 744.00 | 3.0 | 111.30 | Tempelhof! Bosepark! Attraktive 3 Zimmerwohnun... | https://www.immobilienscout24.de/expose/105298708 | 12103 | 1139.361659 | -395.361659 | 1133.836197 | -389.836197 |
1309 | Pölnitzweg 1 | NaN | 1 | NaN | Berlin | Liz Geithner | Buch (Pankow) | 551.53 | 1 | 106517654 | ... | 1307.91 | 4.0 | 157.58 | Erstbezug: Große Familienwohnung auf 157qm, Li... | https://www.immobilienscout24.de/expose/106517654 | 13125 | 1673.310606 | -365.400606 | 1694.786044 | -386.876044 |
911 | Germaniapromenade 26 | NaN | 1 | NaN | Berlin | Steffen Haagen | Britz (Neukölln) | 200.00 | 1 | 106483488 | ... | 416.58 | 2.0 | 67.01 | Sonnige 2 Zimmer Dachgeschosswohnung in Berlin... | https://www.immobilienscout24.de/expose/106483488 | 12347 | 773.993156 | -357.413156 | 801.613492 | -385.033492 |
3266 | Schlieperstr. 33 | NaN | 0 | NaN | Berlin | Susanne Hess | Tegel (Reinickendorf) | 140.00 | 0 | 66036454 | ... | 830.00 | 3.0 | 107.00 | Sonnige 3-Zimmer Dachgeschosswohnung für Nicht... | https://www.immobilienscout24.de/expose/66036454 | 13507 | 1067.611074 | -237.611074 | 1214.276892 | -384.276892 |
634 | Otto-Nagel-Straße 19 | NaN | 1 | NaN | Berlin | Daniel Kerem | Biesdorf (Marzahn) | 400.00 | 0 | 106338432 | ... | 1070.00 | 3.0 | 134.00 | Schöner Wohnen nahe Schlosspark Biesdorf! *BES... | https://www.immobilienscout24.de/expose/106338432 | 12683 | 1447.918941 | -377.918941 | 1451.244253 | -381.244253 |
1073 | Pasewalker Straße 7 | NaN | 1 | NaN | Berlin | Silvia Schünemann | Wedding (Wedding) | 320.25 | 0 | 106594478 | ... | 681.28 | 4.0 | 106.45 | Helle 4 Zimmer Wohnung | https://www.immobilienscout24.de/expose/106594478 | 13347 | 1070.969880 | -389.689880 | 1059.410746 | -378.130746 |
1561 | Arndtstr. 41A | NaN | 1 | NaN | Berlin | Thomas Duwe | Adlershof (Treptow) | 240.00 | 1 | 106383920 | ... | 712.50 | 3.0 | 95.00 | Arndtstr.41 A 3 Zimmerwohnung | https://www.immobilienscout24.de/expose/106383920 | 12489 | 1007.115022 | -294.615022 | 1081.178168 | -368.678168 |
3047 | NaN | NaN | 1 | NaN | Berlin | Bartosz Makala | Bohnsdorf (Treptow) | 307.59 | 1 | 98459916 | ... | 1070.01 | 3.0 | 123.00 | Wohnen im Grünen! Komfortable 3-Zimmerwohnung ... | https://www.immobilienscout24.de/expose/98459916 | 12526 | 1314.676887 | -244.666887 | 1436.145355 | -366.135355 |
956 | Pillnitzer Weg 11 | NaN | 1 | NaN | Berlin | NaN | Staaken (Spandau) | 360.00 | 0 | 106618194 | ... | 535.00 | 4.0 | 87.41 | große 4 Zimmer Wohnung mit Balkon und Keller | https://www.immobilienscout24.de/expose/106618194 | 13593 | 861.827812 | -326.827812 | 890.719214 | -355.719214 |
1362 | Rathenaustr. 14 | NaN | 1 | NaN | Berlin | Vermietungsteam Stadthaus Verwaltungsgesellschaft | Oberschöneweide (Köpenick) | 204.00 | 0 | 106508144 | ... | 695.00 | 3.0 | 97.47 | An der Wuhlheide! - wunderschöne 3 Zimmerwohnu... | https://www.immobilienscout24.de/expose/106508144 | 12459 | 1046.660551 | -351.660551 | 1047.207830 | -352.207830 |
695 | Holländerstraße 18 | NaN | 1 | NaN | Berlin | Christel Neumann | Reinickendorf (Reinickendorf) | 180.00 | 0 | 100213638 | ... | 1320.00 | 4.5 | 165.00 | Erstbezug nach Komplettsanierung | https://www.immobilienscout24.de/expose/100213638 | 13407 | 1678.983246 | -358.983246 | 1669.931438 | -349.931438 |
3203 | Kirchhainer Damm 104 | NaN | 1 | NaN | Berlin | Sven - Olaf Knoche | Lichtenrade (Tempelhof) | 475.00 | 0 | 84347003 | ... | 1499.00 | 5.5 | 190.00 | Herrschaftliche Villenetage mit sonnigem Südba... | https://www.immobilienscout24.de/expose/84347003 | 12309 | 2010.029710 | -511.029710 | 1848.630580 | -349.630580 |
3225 | Lynarstrasse 9 | NaN | 0 | NaN | Berlin | Vermietungsteam Stadthaus Verwaltungsgesellschaft | Spandau (Spandau) | 289.00 | 0 | 79157087 | ... | 690.00 | 3.0 | 101.84 | Lutherplatz! sehr schöne 3 Zimmer - Wannenbad ... | https://www.immobilienscout24.de/expose/79157087 | 13585 | 1088.574657 | -398.574657 | 1036.140755 | -346.140755 |
3281 | Goldammerstr. 10 | NaN | 1 | NaN | Berlin | Hausverwaltung Bredemeier | Buckow (Neukölln) | 273.50 | 0 | 61471168 | ... | 521.50 | 2.0 | 77.26 | Bes. So. 19.08. um 15:00 Uhr, Wunderschöne 2-Z... | https://www.immobilienscout24.de/expose/61471168 | 12351 | 845.871975 | -324.371975 | 867.512634 | -346.012634 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
3097 | NaN | NaN | 0 | NaN | Berlin | NaN | Charlottenburg (Charlottenburg) | 195.00 | 0 | 94876407 | ... | 1716.00 | 2.0 | 78.00 | Kernsanierte, möblierte 2-Zimmer Altbauwohnung... | https://www.immobilienscout24.de/expose/94876407 | 10625 | 847.912882 | 868.087118 | 824.674952 | 891.325048 |
3103 | Chausseestr. 37 C 2 | NaN | 1 | NaN | Berlin | NaN | Mitte (Mitte) | 0.00 | 0 | 94643506 | ... | 1400.00 | 2.0 | 43.90 | Wong Deso Apartment in the heart of Berlin - W... | https://www.immobilienscout24.de/expose/94643506 | 10115 | 479.433982 | 920.566018 | 508.236661 | 891.763339 |
2761 | Französische Straße 56 | NaN | 0 | NaN | Berlin | Juliane Nestler | Mitte (Mitte) | 280.00 | 0 | 104641955 | ... | 1974.00 | 3.0 | 94.00 | Wohnen nahe Lafayette * Bestlage * zentral & ... | https://www.immobilienscout24.de/expose/104641955 | 10117 | 1002.457335 | 971.542665 | 1081.837332 | 892.162668 |
2731 | Boxhagener Straße 35 | NaN | 1 | NaN | Berlin | D. Schlösser | Friedrichshain (Friedrichshain) | 260.00 | 0 | 104743642 | ... | 1931.16 | 2.0 | 87.78 | Über den Dächern in Friedrichshain - Neubau - ... | https://www.immobilienscout24.de/expose/104743642 | 10245 | 961.427361 | 969.732639 | 1022.490084 | 908.669916 |
2428 | Gabriele-Tergit-Promenade 21 | NaN | 1 | NaN | Berlin | Juliane Nestler | Tiergarten (Tiergarten) | 300.00 | 0 | 105627584 | ... | 1900.00 | 3.0 | 94.60 | Wohnen mit tollem Ausblick * Potsdamer Platz *... | https://www.immobilienscout24.de/expose/105627584 | 10963 | 1015.135460 | 884.864540 | 976.263086 | 923.736914 |
1721 | Stralauer Platz 35 | NaN | 1 | NaN | Berlin | Manuela von Mallinckrodt | Friedrichshain (Friedrichshain) | 193.53 | 0 | 106320942 | ... | 1780.43 | 3.0 | 77.41 | SONNIGE 3 ZIMMER in FHAIN - mit Südbalkon und ... | https://www.immobilienscout24.de/expose/106320942 | 10243 | 826.314444 | 954.115556 | 852.967836 | 927.462164 |
3136 | Krausenstr. 37 | NaN | 1 | NaN | Berlin | NaN | Mitte (Mitte) | 299.00 | 0 | 92249224 | ... | 1590.00 | 2.0 | 60.00 | Erstbezug! Möblierte Neubauwohnung in Mitte Sc... | https://www.immobilienscout24.de/expose/92249224 | 10117 | 656.282054 | 933.717946 | 659.935269 | 930.064731 |
1901 | Stralauer Platz 38/39 | NaN | 1 | NaN | Berlin | Manuela von Mallinckrodt | Friedrichshain (Friedrichshain) | 195.55 | 0 | 106217845 | ... | 1740.40 | 3.0 | 78.22 | Sightseeing vom Balkon - 3 Zimmer mit Einbaukü... | https://www.immobilienscout24.de/expose/106217845 | 10243 | 835.211769 | 905.188231 | 809.145354 | 931.254646 |
824 | Gabriele-Tergit-Promenade 21 | NaN | 1 | NaN | Berlin | Guido Bars | Tiergarten (Tiergarten) | 266.00 | 0 | 106245148 | ... | 1600.00 | 2.0 | 63.00 | Schöne, geräumige zwei Zimmer Wohnung in Berli... | https://www.immobilienscout24.de/expose/106245148 | 10785 | 611.592271 | 988.407729 | 663.161742 | 936.838258 |
1306 | Kaiserstr. 4c | NaN | 1 | NaN | Berlin | NaN | Lichterfelde (Steglitz) | 114.74 | 1 | 106518343 | ... | 1835.76 | 2.0 | 76.49 | Erstbezug in einem KfW-55 Neubau! Hochwertig m... | https://www.immobilienscout24.de/expose/106518343 | 12209 | 878.124816 | 957.635184 | 896.597248 | 939.162752 |
2844 | Zillestraße 107 | NaN | 1 | NaN | Berlin | Ioannis Tzakris | Charlottenburg (Charlottenburg) | 0.00 | 0 | 104028928 | ... | 1980.00 | 3.0 | 96.00 | Hochwertig eingerichtete sanierte Altbauwohnun... | https://www.immobilienscout24.de/expose/104028928 | 10585 | 1030.513553 | 949.486447 | 1036.969495 | 943.030505 |
2565 | Gabriele-Tergit-Promenade 21 | NaN | 1 | NaN | Berlin | Sascha Lobeck | Tiergarten (Tiergarten) | 315.00 | 1 | 105322837 | ... | 1750.00 | 2.5 | 70.00 | Concierge-Erstbezug in exklusiver Lage - HIGH-... | https://www.immobilienscout24.de/expose/105322837 | 10963 | 796.233778 | 953.766222 | 797.074599 | 952.925401 |
774 | Puccinistr. 32 | NaN | 0 | NaN | Berlin | Ernst Konrad | Weißensee (Weißensee) | 100.00 | 0 | 106382335 | ... | 1500.00 | 2.0 | 50.00 | Wohnen auf Zeit 2 ZKB Loft in begehrter Umgebu... | https://www.immobilienscout24.de/expose/106382335 | 13088 | 462.708177 | 1037.291823 | 543.395289 | 956.604711 |
68 | NaN | NaN | 1 | NaN | Berlin | Petra Hubertus | Mitte (Mitte) | 200.00 | 0 | 106297883 | ... | 1500.00 | 2.0 | 45.60 | die perfekte single-dg-whg. in mitte am gipsdr... | https://www.immobilienscout24.de/expose/106297883 | 10119 | 498.107381 | 1001.892619 | 539.966823 | 960.033177 |
2990 | NaN | NaN | 1 | NaN | Berlin | Eva-Jannetje Gerlach | Mitte (Mitte) | 0.00 | 0 | 101605702 | ... | 1700.00 | 2.0 | 65.00 | 5706 - Chausseestraße - Geschmackvolles und so... | https://www.immobilienscout24.de/expose/101605702 | 10115 | 711.203816 | 988.796184 | 733.629470 | 966.370530 |
631 | Swinemünder Straße 5 | NaN | 1 | NaN | Berlin | Julia Schirrmeister | Mitte (Mitte) | 220.00 | 0 | 106343116 | ... | 1980.00 | 3.0 | 86.79 | Modernisierte drei Zimmer Wohnung am Arkonapla... | https://www.immobilienscout24.de/expose/106343116 | 10435 | 929.347668 | 1050.652332 | 1002.075399 | 977.924601 |
1962 | NaN | NaN | 1 | NaN | Berlin | Hendrik Schmidt | Kreuzberg (Kreuzberg) | 250.00 | 1 | 106188446 | ... | 1650.00 | 2.0 | 55.51 | Hochwertig möblierte Wohnung / 6-24 Monate | https://www.immobilienscout24.de/expose/106188446 | 10963 | 647.673105 | 1002.326895 | 665.702228 | 984.297772 |
1727 | Stralauer Platz 35 | NaN | 1 | NaN | Berlin | Manuela von Mallinckrodt | Friedrichshain (Friedrichshain) | 195.55 | 0 | 106320084 | ... | 1799.06 | 3.0 | 78.22 | GRANDIOSER AUSBLICK - 3 Zimmer mit vollausgest... | https://www.immobilienscout24.de/expose/106320084 | 10243 | 835.211769 | 963.848231 | 809.145354 | 989.914646 |
64 | NaN | NaN | 1 | NaN | Berlin | NaN | Charlottenburg (Charlottenburg) | 199.70 | 0 | 106535547 | ... | 1850.00 | 3.0 | 77.20 | Charlottenburg:Lietzensee:helles Dachgeschoss,... | https://www.immobilienscout24.de/expose/106535547 | 14057 | 824.007730 | 1025.992270 | 846.057328 | 1003.942672 |
1792 | NaN | NaN | 1 | NaN | Berlin | NaN | Friedrichshain (Friedrichshain) | 0.00 | 0 | 106290819 | ... | 1680.00 | 2.0 | 55.00 | helle, möblierte Mietwohnung direkt im Friedri... | https://www.immobilienscout24.de/expose/106290819 | 10245 | 601.360292 | 1078.639708 | 626.424434 | 1053.575566 |
3135 | Krausenstr. 37 | NaN | 1 | NaN | Berlin | NaN | Mitte (Mitte) | 350.00 | 0 | 92249264 | ... | 1750.00 | 3.0 | 67.00 | Erstbezug !Möblierte Neubauwohnung in Mitte nä... | https://www.immobilienscout24.de/expose/92249264 | 10117 | 711.967336 | 1038.032664 | 690.052123 | 1059.947877 |
27 | NaN | NaN | 1 | NaN | Berlin | Petra Hubertus reco immobilienbüro | Mitte (Mitte) | 134.51 | 0 | 104969872 | ... | 1500.00 | 1.0 | 39.00 | sophienstraße 1 zi-apt. mit südterrasse und ko... | https://www.immobilienscout24.de/expose/104969872 | 10178 | 446.815840 | 1053.184160 | 434.713289 | 1065.286711 |
67 | NaN | NaN | 1 | NaN | Berlin | Petra Hubertus reco immobilienbüro | Mitte (Mitte) | 134.51 | 0 | 105923967 | ... | 1500.00 | 1.0 | 39.00 | sophienstraße 1 zi-apt. mit südterrasse und ko... | https://www.immobilienscout24.de/expose/105923967 | 10178 | 446.815840 | 1053.184160 | 434.713289 | 1065.286711 |
146 | Wühlischstraße 29 | NaN | 1 | NaN | Berlin | Julian Karwath | Friedrichshain (Friedrichshain) | 150.00 | 0 | 106095319 | ... | 1900.00 | 2.0 | 80.00 | Schöne, geräumige zwei Zimmer Wohnung in Berli... | https://www.immobilienscout24.de/expose/106095319 | 10245 | 745.201289 | 1154.798711 | 773.452442 | 1126.547558 |
3095 | Mühlenstraße 60 | NaN | 1 | NaN | Berlin | Olaf Ruhnke | Friedrichshain (Friedrichshain) | 200.00 | 0 | 95250533 | ... | 1790.00 | 2.0 | 60.00 | Spektakuläres Wohnen über der Eastside Gallery | https://www.immobilienscout24.de/expose/95250533 | 10245 | 656.282054 | 1133.717946 | 659.935269 | 1130.064731 |
3224 | Otto-Braun Strasse 67 | NaN | 0 | NaN | Berlin | Renting Team Berlin | Mitte (Mitte) | 0.00 | 0 | 79469157 | ... | 1490.00 | 1.5 | 21.00 | Möbliertes Junior Studio Apartment in Berlin M... | https://www.immobilienscout24.de/expose/79469157 | 10178 | 232.407392 | 1257.592608 | 342.208134 | 1147.791866 |
1293 | Kaiserstr. 4c | NaN | 1 | NaN | Berlin | NaN | Lichterfelde (Steglitz) | 100.71 | 1 | 106519517 | ... | 1979.64 | 2.0 | 67.14 | Drei Terrassen! Möblierte Neubau-Wohnung mit A... | https://www.immobilienscout24.de/expose/106519517 | 12209 | 775.421122 | 1204.218878 | 806.222824 | 1173.417176 |
3222 | Otto-Braun Strasse 67 | NaN | 0 | NaN | Berlin | Renting Team Berlin | Mitte (Mitte) | 0.00 | 0 | 79469592 | ... | 1690.00 | 1.0 | 25.00 | Möbliertes Mini 1 Bedroom Apartment in Berlin ... | https://www.immobilienscout24.de/expose/79469592 | 10178 | 286.947393 | 1403.052607 | 358.741515 | 1331.258485 |
3221 | Otto-Braun Strasse 67 | NaN | 0 | NaN | Berlin | Renting Team Berlin | Mitte (Mitte) | 0.00 | 0 | 79469862 | ... | 1790.00 | 2.0 | 34.00 | Möbliertes Junior 1 Bedroom Apartment in Berli... | https://www.immobilienscout24.de/expose/79469862 | 10178 | 364.601380 | 1425.398620 | 404.547534 | 1385.452466 |
3223 | Otto-Braun Strasse 67 | NaN | 1 | NaN | Berlin | Renting Team Berlin | Mitte (Mitte) | 0.00 | 0 | 79469490 | ... | 1990.00 | 2.0 | 30.00 | Möbliertes Senior Grand Apartment in Berlin Mi... | https://www.immobilienscout24.de/expose/79469490 | 10178 | 326.751485 | 1663.248515 | 424.124734 | 1565.875266 |
2993 rows × 25 columns
df3_test["rent_error_relative"] = (df3_test["rent"] - df3_test["rent_predicted2"])/df3_test["rent"]
/Users/andi/.local/share/virtualenvs/ImmoSpider-M0SYrQN4/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy """Entry point for launching an IPython kernel.
top = df3_test.sort_values("rent_error_relative")
top[top["district"].str.contains("Zehlendorf")]
address | area | balcony | cellar | city | contact_name | district | extra_costs | garden | immo_id | ... | rooms | sqm | title | url | zip_code | rent_predicted | rent_error | rent_predicted2 | rent_error2 | rent_error_relative | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3169 | Von-der-Trenck-Straße 5 A | NaN | 1 | NaN | Berlin | Wohnbau Service Bonn GmbH Service Team | Nikolassee (Zehlendorf) | 195.98 | 1 | 89168579 | ... | 2.0 | 67.04 | WBS erforderlich!!! ruhige Wohnung mit Garten | https://www.immobilienscout24.de/expose/89168579 | 14129 | 774.322687 | -239.302687 | 802.642642 | -267.622642 | -0.500211 |
3090 | Alsterweg 53 | NaN | 1 | NaN | Berlin | Dave Felgenhauer | Zehlendorf (Zehlendorf) | 164.00 | 1 | 95781013 | ... | 1.5 | 52.68 | Bereits modernisierte Wohnung, mit großem Balk... | https://www.immobilienscout24.de/expose/95781013 | 14167 | 574.065009 | -165.885009 | 591.347406 | -183.167406 | -0.448742 |
3151 | Von-der-Trenck-Straße 3 | NaN | 1 | NaN | Berlin | Wohnbau Service Bonn GmbH Service Team | Nikolassee (Zehlendorf) | 182.17 | 0 | 90729049 | ... | 1.5 | 56.62 | Wohnen in der Natur! WBS erforderlich! Einbauk... | https://www.immobilienscout24.de/expose/90729049 | 14129 | 629.757535 | -177.927535 | 634.260168 | -182.430168 | -0.403758 |
1933 | NaN | NaN | 0 | NaN | Berlin | Philipp Vormeier | Zehlendorf (Zehlendorf) | 240.00 | 1 | 106200307 | ... | 4.0 | 105.00 | Ruhige Wohnung in Berlin, Zehlendorf | https://www.immobilienscout24.de/expose/106200307 | 14167 | 1065.147978 | -115.147978 | 1260.052699 | -310.052699 | -0.326371 |
825 | Riemeisterstraße 4 | NaN | 1 | NaN | Berlin | Nils Bock | Zehlendorf (Zehlendorf) | 0.00 | 1 | 89388312 | ... | 1.0 | 25.00 | Studenten wohnen wie Gott in Frankreich | https://www.immobilienscout24.de/expose/89388312 | 14169 | 256.102859 | 93.897141 | 433.109380 | -83.109380 | -0.237455 |
1790 | Am Sandwerder 24 | NaN | 1 | NaN | Berlin | Jörg-M. Meier | Wannsee (Zehlendorf) | 215.00 | 0 | 106291069 | ... | 2.0 | 61.01 | Helle 2-Zimmerwohnung im Grünen, nahe Wannsee. | https://www.immobilienscout24.de/expose/106291069 | 14109 | 614.251279 | -84.251279 | 629.856273 | -99.856273 | -0.188408 |
1071 | Marshallstr. 9 | NaN | 1 | NaN | Berlin | GmbH PRINTS | Dahlem (Zehlendorf) | 298.00 | 0 | 106595282 | ... | 3.0 | 110.00 | +NAHE GRUNEWALD+SONNENBALKON+PARKETT+WOHNKÜCHE | https://www.immobilienscout24.de/expose/106595282 | 14169 | 1131.169515 | -82.939515 | 1215.975747 | -167.745747 | -0.160028 |
2492 | Hugo Vogel Straße 6 | NaN | 1 | NaN | Berlin | Achim Emde | Wannsee (Zehlendorf) | 257.00 | 0 | 105518230 | ... | 4.0 | 124.80 | Ansprechende 4-Zimmer-Wohnung zur Miete in Wan... | https://www.immobilienscout24.de/expose/105518230 | 14109 | 1248.014875 | 21.985125 | 1424.893534 | -154.893534 | -0.121963 |
3261 | NaN | NaN | 1 | NaN | Berlin | G. Schmidt | Zehlendorf (Zehlendorf) | 315.00 | 1 | 68925463 | ... | 3.0 | 83.00 | 3-Zi.-Wohnung mit Terrasse u. Garten in sehr g... | https://www.immobilienscout24.de/expose/68925463 | 14169 | 850.784925 | 59.215075 | 1005.441058 | -95.441058 | -0.104880 |
2604 | Düppelstr. 19 | NaN | 0 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 115.00 | 0 | 105189965 | ... | 2.0 | 55.64 | Tolle Wohnung in ruhiger Zehlendorf-Lage | https://www.immobilienscout24.de/expose/105189965 | 14163 | 602.302764 | -32.302764 | 629.408644 | -59.408644 | -0.104226 |
2181 | Starkenburger Str. 3 | NaN | 0 | NaN | Berlin | Yvonne Fuchs | Zehlendorf (Zehlendorf) | 348.00 | 0 | 105996967 | ... | 3.5 | 100.53 | ++Wir renovieren für Sie: Ansprechende 3,5-Zim... | https://www.immobilienscout24.de/expose/105996967 | 14163 | 1010.457592 | -5.157592 | 1096.988452 | -91.688452 | -0.091205 |
1385 | NaN | NaN | 1 | NaN | Berlin | Ralph Wodrich | Wannsee (Zehlendorf) | 756.00 | 1 | 106495039 | ... | 3.0 | 148.00 | WANNSEE : EG-Maisonetten-Wohnung direkt am Kle... | https://www.immobilienscout24.de/expose/106495039 | 14109 | 1642.410666 | -14.410666 | 1734.694538 | -106.694538 | -0.065537 |
3166 | Clayallee 311 | NaN | 1 | NaN | Berlin | Anne Gärtner | Zehlendorf (Zehlendorf) | 280.00 | 0 | 89349917 | ... | 4.0 | 108.00 | Zehlendorf, Stadtvilla, DG Maisonette | https://www.immobilienscout24.de/expose/89349917 | 14169 | 1063.477757 | 146.122243 | 1265.753563 | -56.153563 | -0.046423 |
713 | Potsdamer Chaussee 26 | NaN | 0 | NaN | Berlin | Mirko Neumann | Nikolassee (Zehlendorf) | 340.00 | 1 | 57300477 | ... | 4.0 | 140.00 | Schöne, geräumige 4Zimmerwohnung im Dachgescho... | https://www.immobilienscout24.de/expose/57300477 | 14129 | 1396.475338 | 3.524662 | 1459.929540 | -59.929540 | -0.042807 |
2037 | Hammerstraße, 42 | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 220.00 | 1 | 106129364 | ... | 2.0 | 79.82 | Helle 2-Zimmer-Luxus-Wohnung in ruhiger Lage | https://www.immobilienscout24.de/expose/106129364 | 14167 | 837.059869 | 88.370131 | 955.697621 | -30.267621 | -0.032707 |
1064 | Pritchardstraße 13 | NaN | 1 | NaN | Berlin | Axel Pfeiffer | Dahlem (Zehlendorf) | 241.00 | 0 | 106596584 | ... | 3.0 | 89.49 | 3 Zimmer mit Balkon Nähe Grunewald ab September | https://www.immobilienscout24.de/expose/106596584 | 14169 | 905.880449 | -37.830449 | 885.648723 | -17.598723 | -0.020274 |
623 | NaN | NaN | 1 | NaN | Berlin | Ralph Wodrich | Wannsee (Zehlendorf) | 550.00 | 1 | 106245902 | ... | 2.0 | 98.79 | WANNSEE in Bestlage. : Attr. BALKON-Wohnung di... | https://www.immobilienscout24.de/expose/106245902 | 14109 | 1123.075873 | 56.924127 | 1197.245279 | -17.245279 | -0.014615 |
3147 | Mörchinger Str. 25 | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 120.00 | 0 | 91171284 | ... | 1.0 | 35.00 | Einzimmerwohnung im Grünen von Zehlendorf - ho... | https://www.immobilienscout24.de/expose/91171284 | 14169 | 402.878430 | 47.121570 | 454.560786 | -4.560786 | -0.010135 |
1451 | Breitensteinweg 10 | NaN | 1 | NaN | Berlin | Julia Ziglowski | Zehlendorf (Zehlendorf) | 120.00 | 0 | 106460055 | ... | 2.0 | 49.67 | Sonnenbalkon + Wohnküche, das passt! | https://www.immobilienscout24.de/expose/106460055 | 14165 | 489.688724 | 31.851276 | 518.242532 | 3.297468 | 0.006323 |
3083 | Albertinenstr. 12 | NaN | 1 | NaN | Berlin | BITTE NUR PER EMAIL WGW Hausverwaltung GmbH | Zehlendorf (Zehlendorf) | 350.00 | 1 | 96253253 | ... | 3.0 | 85.00 | SCHÖNE, HELLE 3-ZIMMERWOHNUNG MIT BALKON IN ZE... | https://www.immobilienscout24.de/expose/96253253 | 14169 | 950.396470 | -0.396470 | 936.127064 | 13.872936 | 0.014603 |
2773 | Podbielskiallee 40 | NaN | 1 | NaN | Berlin | Claudia von Zitzewitz | Dahlem (Zehlendorf) | 450.00 | 1 | 104558120 | ... | 3.0 | 118.30 | 3 - Zimmer Wohnung mit Südterrasse in bester L... | https://www.immobilienscout24.de/expose/104558120 | 14195 | 1316.175402 | 159.194598 | 1433.912052 | 41.457948 | 0.028100 |
1904 | Lange Stüclen 7 | NaN | 1 | NaN | Berlin | NaN | Wannsee (Zehlendorf) | 600.00 | 1 | 106216844 | ... | 5.0 | 149.44 | HOMESK - 5-Zimmer-Maisonette mit Terrasse in i... | https://www.immobilienscout24.de/expose/106216844 | 14109 | 1615.817765 | 159.182235 | 1722.101715 | 52.898285 | 0.029802 |
1752 | Sangebuchtweg 11 | NaN | 1 | NaN | Berlin | NaN | Wannsee (Zehlendorf) | 320.00 | 0 | 106315694 | ... | 3.0 | 107.00 | Erstbezug nach Modernisierung! 3-Zimmer-Wohnun... | https://www.immobilienscout24.de/expose/106315694 | 14109 | 1098.216458 | 0.783542 | 1061.379450 | 37.620550 | 0.034232 |
2494 | Königsstr. 67a | NaN | 0 | NaN | Berlin | Dr. Christian Schölzel | Wannsee (Zehlendorf) | 180.00 | 1 | 105511918 | ... | 1.0 | 20.00 | 1 Zimmer-Wohnung, ca. 20 qm mit Badesteg zum K... | https://www.immobilienscout24.de/expose/105511918 | 14109 | 141.968613 | 208.031387 | 335.170410 | 14.829590 | 0.042370 |
252 | Spilstraße 10 | NaN | 0 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 212.42 | 1 | 106296522 | ... | 2.0 | 75.08 | Helle und sanierte 2 Zimmer-Altbauwohnung in S... | https://www.immobilienscout24.de/expose/106296522 | 14195 | 856.549366 | 44.410634 | 858.729302 | 42.230698 | 0.046873 |
3055 | Ramsteinweg 23 | NaN | 0 | NaN | Berlin | Dennis Hirschberg | Zehlendorf (Zehlendorf) | 147.03 | 1 | 98023697 | ... | 2.0 | 52.70 | +++ ACHTUNG +++ NEUBAU RAMSTEINWEG 23 SUCHT NA... | https://www.immobilienscout24.de/expose/98023697 | 14165 | 557.594590 | 48.455410 | 574.921206 | 31.128794 | 0.051363 |
1412 | Dahlemer Weg 223 | NaN | 1 | NaN | Berlin | Möller Nadine | Zehlendorf (Zehlendorf) | 245.00 | 0 | 106484356 | ... | 3.0 | 70.96 | 3-Zi-Whg. am Heinrich-Laehr-Park - Besichtigun... | https://www.immobilienscout24.de/expose/106484356 | 14167 | 702.340400 | 77.659600 | 739.295399 | 40.704601 | 0.052185 |
2200 | Beerenstr. 11 | NaN | 1 | NaN | Berlin | Pamela Wunsch | Zehlendorf (Zehlendorf) | 131.47 | 0 | 105949718 | ... | 1.0 | 35.38 | Ruhige Seniorenwohnung im schönen Zehlendorf | https://www.immobilienscout24.de/expose/105949718 | 14163 | 353.927513 | 90.892487 | 420.942562 | 23.877438 | 0.053679 |
375 | Saargemünder Straße 27 b | NaN | 1 | NaN | Berlin | Sybille Löffelbein | Dahlem (Zehlendorf) | 179.00 | 1 | 106570653 | ... | 2.0 | 60.00 | "The Metropolitan Gardens" - Wohnen im Park: K... | https://www.immobilienscout24.de/expose/106570653 | 14195 | 696.992847 | 102.007153 | 749.583324 | 49.416676 | 0.061848 |
2232 | Taylorstr. 9 | NaN | 1 | NaN | Berlin | Stephanie Schulze | Dahlem (Zehlendorf) | 320.94 | 0 | 105941148 | ... | 5.0 | 106.50 | Familienfreundlich wohnen in ruhiger Lage | https://www.immobilienscout24.de/expose/105941148 | 14195 | 1050.313913 | 75.496087 | 1056.003654 | 69.806346 | 0.062005 |
3196 | Glockenstraße 2 | NaN | 1 | NaN | Berlin | Gerd Plensky | Zehlendorf (Zehlendorf) | 267.90 | 1 | 85787616 | ... | 3.0 | 105.64 | 3 Zimmer im EG und Souterrain in begehrter Wes... | https://www.immobilienscout24.de/expose/85787616 | 14163 | 1123.988531 | 196.051469 | 1217.931447 | 102.108553 | 0.077353 |
1980 | Breisgauer Str. 4 | NaN | 0 | NaN | Berlin | NaN | Nikolassee (Zehlendorf) | 117.00 | 0 | 106174394 | ... | 1.0 | 42.05 | 1-Zi-Apartment nahe Schlachtensee | https://www.immobilienscout24.de/expose/106174394 | 14129 | 474.230600 | 20.769400 | 454.515762 | 40.484238 | 0.081786 |
1526 | Hampsteadstraße 33 | NaN | 1 | NaN | Berlin | Thomas Nölle | Zehlendorf (Zehlendorf) | 390.00 | 1 | 106418297 | ... | 4.0 | 112.00 | Neuwertige 4-Zimmer-Erdgeschosswohnung mit Sou... | https://www.immobilienscout24.de/expose/106418297 | 14167 | 1148.125958 | 307.874042 | 1331.687891 | 124.312109 | 0.085379 |
3186 | Königin-Luise-Str. 5 | NaN | 1 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 95.00 | 0 | 87475137 | ... | 1.0 | 19.37 | Möbliertes, modernes 1-Zi-Appartement ab 01.10... | https://www.immobilienscout24.de/expose/87475137 | 14195 | 231.193004 | 163.806996 | 353.431037 | 41.568963 | 0.105238 |
2274 | Podbielskiallee 68 | NaN | 0 | NaN | Berlin | Markus Krause | Dahlem (Zehlendorf) | 204.00 | 1 | 105901612 | ... | 2.0 | 65.00 | schöne teilmöblierte 2 Zi. in Dahlemlage | https://www.immobilienscout24.de/expose/105901612 | 14195 | 745.827094 | 49.172906 | 706.101033 | 88.898967 | 0.111823 |
739 | Flanaganstrasse 20 | NaN | 1 | NaN | Berlin | Stefan Hainzl | Dahlem (Zehlendorf) | 232.00 | 0 | 106596591 | ... | 4.0 | 96.53 | Schöne vier Zimmer Wohnung direkt am Grunewald... | https://www.immobilienscout24.de/expose/106596591 | 14195 | 937.487235 | 269.142765 | 1070.342618 | 136.287382 | 0.112949 |
2336 | Hocksteinweg 17 | NaN | 0 | NaN | Berlin | Alexandra Nepomnyashcha | Zehlendorf (Zehlendorf) | 156.00 | 0 | 105796491 | ... | 2.5 | 53.55 | Kleines gemütliches Heim in einer angenehmen S... | https://www.immobilienscout24.de/expose/105796491 | 14165 | 515.617905 | 74.382095 | 520.540860 | 69.459140 | 0.117727 |
2510 | Taylorstr. 15 | NaN | 0 | NaN | Berlin | Stephanie Schulze | Dahlem (Zehlendorf) | 291.39 | 0 | 105476421 | ... | 3.0 | 88.10 | Erstbezug nach Sanierung in Dahlem! | https://www.immobilienscout24.de/expose/105476421 | 14195 | 884.524685 | 77.395315 | 835.823806 | 126.096194 | 0.131088 |
1153 | NaN | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 200.00 | 0 | 106574939 | ... | 2.0 | 51.00 | Schöne zwei Zimmer Wohnung in Berlin, Zehlendorf | https://www.immobilienscout24.de/expose/106574939 | 14167 | 426.655072 | 173.344928 | 518.510297 | 81.489703 | 0.135816 |
1262 | NaN | NaN | 1 | NaN | Berlin | Franz Du Chesne | Dahlem (Zehlendorf) | 345.00 | 0 | 106533126 | ... | 4.0 | 116.60 | Sanierte 4Zi Wohnung am Dreipfuhlpark mit Balk... | https://www.immobilienscout24.de/expose/106533126 | 14195 | 1182.461056 | 316.538944 | 1280.065191 | 218.934809 | 0.146054 |
3276 | NaN | NaN | 1 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 350.00 | 0 | 62407818 | ... | 6.0 | 147.00 | Exklusives Wohnen im Baudenkmal | https://www.immobilienscout24.de/expose/62407818 | 14163 | 1396.332157 | 403.667843 | 1531.081185 | 268.918815 | 0.149399 |
1560 | NaN | NaN | 1 | NaN | Berlin | Felicitas Rennert | Nikolassee (Zehlendorf) | 400.00 | 1 | 106384388 | ... | 4.0 | 114.00 | Chices Wohnen mit netten Nachbarn, 151 m² auf ... | https://www.immobilienscout24.de/expose/106384388 | 14129 | 1247.737503 | 348.262497 | 1356.174413 | 239.825587 | 0.150267 |
611 | Schorlemer Allee 3 | NaN | 1 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 150.67 | 0 | 106296679 | ... | 2.5 | 71.70 | Schöne, helle und sanierte 2,5 Zimmer-Altbauwo... | https://www.immobilienscout24.de/expose/106296679 | 14195 | 721.071413 | 139.328587 | 725.105191 | 135.294809 | 0.157246 |
2036 | Habelschwerdter Allee 1 | NaN | 1 | NaN | Berlin | Dennis Altinok | Dahlem (Zehlendorf) | 50.00 | 0 | 106129651 | ... | 1.0 | 37.65 | Helle 1-Zimmer Wohnung nahe der FU in super La... | https://www.immobilienscout24.de/expose/106129651 | 14195 | 378.861993 | 120.138007 | 416.737225 | 82.262775 | 0.164855 |
854 | NaN | NaN | 1 | NaN | Berlin | Leon Karsten | Dahlem (Zehlendorf) | 177.00 | 1 | 106385218 | ... | 2.0 | 56.00 | Neubau-Wohnung in Dahlem (inkl. EBK & Balkon) | https://www.immobilienscout24.de/expose/106385218 | 14195 | 575.412597 | 244.587403 | 673.233478 | 146.766522 | 0.178984 |
1743 | Mörchinger Str. 59 | NaN | 0 | NaN | Berlin | Rayk Welke | Zehlendorf (Zehlendorf) | 88.25 | 0 | 106317805 | ... | 1.0 | 31.48 | ***Aus alt mach neu!!*** | https://www.immobilienscout24.de/expose/106317805 | 14169 | 305.001025 | 143.868975 | 366.270552 | 82.599448 | 0.184016 |
719 | Königin-Luise-Straße 5 | NaN | 1 | NaN | Berlin | Karl-Heinz Jettinger | Dahlem (Zehlendorf) | 109.00 | 0 | 85047209 | ... | 1.0 | 30.50 | Großes Möbliertes Apartment für Studenten und ... | https://www.immobilienscout24.de/expose/85047209 | 14195 | 353.448845 | 166.551155 | 419.178517 | 100.821483 | 0.193887 |
804 | Lutterbacher Str. 22 | NaN | 1 | NaN | Berlin | Bernhard Reiter | Zehlendorf (Zehlendorf) | 320.00 | 1 | 85123148 | ... | 3.0 | 96.50 | Gehobenes Wohnen im Rhytmus der Jahreszeiten | https://www.immobilienscout24.de/expose/85123148 | 14167 | 999.073682 | 395.926318 | 1121.535427 | 273.464573 | 0.196032 |
1656 | Charlottenburger Straße 6 | NaN | 1 | NaN | Berlin | Lars Thieme | Zehlendorf (Zehlendorf) | 200.00 | 1 | 106350242 | ... | 3.0 | 100.00 | Sehr helle und ruhige 3 Zimmer Wohnung (Neubau) | https://www.immobilienscout24.de/expose/106350242 | 14169 | 1037.518915 | 462.481085 | 1202.181512 | 297.818488 | 0.198546 |
156 | Berliner Straße 12 | NaN | 0 | NaN | Berlin | Michael Röder | Zehlendorf (Zehlendorf) | 141.00 | 0 | 106368136 | ... | 3.0 | 85.00 | TRAUMHAFT helle Wohnung, Stuck, Einbauküche, W... | https://www.immobilienscout24.de/expose/106368136 | 14169 | 825.955324 | 302.044676 | 901.894797 | 226.105203 | 0.200448 |
1613 | Eschershauser Weg 29f | NaN | 1 | NaN | Berlin | Sabine Rösel | Zehlendorf (Zehlendorf) | 169.00 | 0 | 106365380 | ... | 2.0 | 53.00 | Spektakulärer Waldblick an der Krummen Lanke -... | https://www.immobilienscout24.de/expose/106365380 | 14163 | 526.266617 | 123.733383 | 517.658254 | 132.341746 | 0.203603 |
2658 | Potsdamer Straße 38 | NaN | 0 | NaN | Berlin | Sascha Lobeck | Zehlendorf (Zehlendorf) | 97.00 | 0 | 105030507 | ... | 3.0 | 58.00 | Dachgeschoss-Wohnung in Berlin-Zehlendorf fris... | https://www.immobilienscout24.de/expose/105030507 | 14163 | 607.020651 | 192.979349 | 628.095894 | 171.904106 | 0.214880 |
1742 | Mörchinger Str. 63 | NaN | 0 | NaN | Berlin | Rayk Welke | Zehlendorf (Zehlendorf) | 111.10 | 0 | 106317810 | ... | 1.5 | 39.93 | Wir modernisieren für Sie! | https://www.immobilienscout24.de/expose/106317810 | 14169 | 387.216210 | 138.813790 | 407.045002 | 118.984998 | 0.226194 |
357 | Brettnacher Straße 21 | NaN | 1 | NaN | Berlin | Marc Zellner | Zehlendorf (Zehlendorf) | 190.00 | 0 | 105849682 | ... | 2.5 | 79.30 | Umfassend modernisierte Wohnung mit Einbauküch... | https://www.immobilienscout24.de/expose/105849682 | 14167 | 857.677462 | 252.322538 | 849.797722 | 260.202278 | 0.234416 |
1508 | Am Hirschsprung 59 C | NaN | 0 | NaN | Berlin | Reinhard Timm e. K. | Dahlem (Zehlendorf) | 400.00 | 0 | 106434786 | ... | 3.0 | 130.00 | Top-Dahlem-Lage: Schönes Reihenmittelhaus mit ... | https://www.immobilienscout24.de/expose/106434786 | 14195 | 1397.894018 | 502.105982 | 1402.905561 | 497.094439 | 0.261629 |
139 | Berliner Straße 12 | NaN | 0 | NaN | Berlin | Thierry Dubois | Zehlendorf (Zehlendorf) | 132.00 | 0 | 104927243 | ... | 3.0 | 77.00 | TRAUMHAFT helle Wohnung, Stuck, Einbauküche, W... | https://www.immobilienscout24.de/expose/104927243 | 14169 | 738.080505 | 326.919495 | 772.676235 | 292.323765 | 0.274482 |
2533 | Goßlerstraße 15 | NaN | 0 | NaN | Berlin | NaN | Dahlem (Zehlendorf) | 150.00 | 1 | 105408183 | ... | 3.0 | 71.00 | 71qm in Dahlem Altbauvilla (möbliert) | https://www.immobilienscout24.de/expose/105408183 | 14195 | 712.885184 | 537.114816 | 802.250537 | 447.749463 | 0.358200 |
906 | Teltower Damm 203 B | NaN | 0 | NaN | Berlin | NaN | Zehlendorf (Zehlendorf) | 265.00 | 0 | 66633796 | ... | 2.0 | 74.53 | Barrierefreie 2-Zimmer-Wohnung | https://www.immobilienscout24.de/expose/66633796 | 14167 | 756.672208 | 385.127792 | 708.356545 | 433.443455 | 0.379614 |
141 | Kleiststraße 30 | NaN | 1 | NaN | Berlin | Uwe Peschel | Zehlendorf (Zehlendorf) | 200.00 | 0 | 69450128 | ... | 3.0 | 86.00 | Toplage!Attraktives Penthouse in einer Stadtvi... | https://www.immobilienscout24.de/expose/69450128 | 14163 | 920.670030 | 669.329970 | 965.793145 | 624.206855 | 0.392583 |
569 | Sundgauer Straße . | NaN | 1 | NaN | Berlin | Sandra Smarslik | Dahlem (Zehlendorf) | 240.00 | 0 | 106489995 | ... | 2.0 | 69.00 | Einziehen und Wohlfühlen! Moderne, vollmöblier... | https://www.immobilienscout24.de/expose/106489995 | 14169 | 755.141225 | 414.858775 | 708.755624 | 461.244376 | 0.394226 |
60 rows × 26 columns
top
address | area | balcony | cellar | city | contact_name | district | extra_costs | garden | immo_id | ... | rooms | sqm | title | url | zip_code | rent_predicted | rent_error | rent_predicted2 | rent_error2 | rent_error_relative | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3286 | Seegefelder Str. 173 | NaN | 1 | NaN | Berlin | Jörg-Rüdiger Arndt | Spandau (Spandau) | 100.00 | 0 | 57409239 | ... | 1.0 | 35.87 | Schöne Single-Wohnung in Spandau | https://www.immobilienscout24.de/expose/57409239 | 13583 | 412.434817 | -179.674817 | 449.042049 | -216.282049 | -0.929206 |
911 | Germaniapromenade 26 | NaN | 1 | NaN | Berlin | Steffen Haagen | Britz (Neukölln) | 200.00 | 1 | 106483488 | ... | 2.0 | 67.01 | Sonnige 2 Zimmer Dachgeschosswohnung in Berlin... | https://www.immobilienscout24.de/expose/106483488 | 12347 | 773.993156 | -357.413156 | 801.613492 | -385.033492 | -0.924273 |
1239 | Peter-Anders-Straße 8 | NaN | 0 | NaN | Berlin | Joachim Keyling | Neukölln (Neukölln) | 97.35 | 0 | 106535338 | ... | 1.0 | 25.62 | Blick ins Grüne - am grünen Mauerstreifen. | https://www.immobilienscout24.de/expose/106535338 | 12057 | 240.632721 | -64.112721 | 335.406017 | -158.886017 | -0.900102 |
2950 | Schwanter Weg 29 | NaN | 1 | NaN | Berlin | Gabriela Sawy | Spandau (Spandau) | 113.72 | 0 | 102741767 | ... | 2.0 | 50.47 | *Mit WBS* Schöne 2-Zimmerwohnung in Spandau, n... | https://www.immobilienscout24.de/expose/102741767 | 13589 | 551.601177 | -234.651177 | 583.506172 | -266.556172 | -0.841004 |
936 | Wattstrasse 11 | NaN | 0 | NaN | Berlin | Sarah Bauer | Oberschöneweide (Köpenick) | 150.00 | 1 | 106621033 | ... | 4.0 | 120.00 | Charismatisches Dachgeschoss mit viel Platz in... | https://www.immobilienscout24.de/expose/106621033 | 12459 | 1229.913263 | -401.913263 | 1419.280170 | -591.280170 | -0.714106 |
2117 | Altenhofer Str. 40 | NaN | 0 | NaN | Berlin | M. Richter | Alt-Hohenschönhausen (Hohenschönhausen) | 104.00 | 0 | 106057089 | ... | 1.0 | 30.35 | ANFRAGEN ÜBER DAS KONTAKTFELD!!! Süße 1-Zimmer... | https://www.immobilienscout24.de/expose/106057089 | 13055 | 292.588707 | -69.588707 | 381.862342 | -158.862342 | -0.712387 |
2118 | Altenhofer Str. 40 | NaN | 0 | NaN | Berlin | M. Richter | Alt-Hohenschönhausen (Hohenschönhausen) | 190.00 | 0 | 106056764 | ... | 2.0 | 61.36 | ANFRAGEN ÜBER DAS KONTAKTFELD!!! gut geschnitt... | https://www.immobilienscout24.de/expose/106056764 | 13055 | 612.008288 | -271.008288 | 577.608712 | -236.608712 | -0.693867 |
3300 | Stresowstr. 4 | NaN | 1 | NaN | Berlin | Marcel Reiche | Spandau (Spandau) | 301.00 | 0 | 42788681 | ... | 3.0 | 91.49 | 3- Zi-Wohnung mit Balkon in Berlin Spandau, au... | https://www.immobilienscout24.de/expose/42788681 | 13597 | 980.974124 | -351.524124 | 1062.876268 | -433.426268 | -0.688579 |
971 | Sewanstraße 255 | NaN | 1 | NaN | Berlin | Martin Silber | Friedrichsfelde (Lichtenberg) | 218.00 | 0 | 106616565 | ... | 4.0 | 74.00 | Nur mit Abschlag! Nur Familien oder Paare! Att... | https://www.immobilienscout24.de/expose/106616565 | 10319 | 690.009778 | -219.009778 | 791.836688 | -320.836688 | -0.681182 |
1123 | NaN | NaN | 0 | NaN | Berlin | Marina Schulze | Rudow (Neukölln) | 160.31 | 1 | 106588396 | ... | 2.0 | 86.00 | Kuschliges 2-Zimmer Dachgeschoss in Berlin-Rud... | https://www.immobilienscout24.de/expose/106588396 | 12357 | 976.498493 | -371.498493 | 1015.999039 | -410.999039 | -0.679337 |
979 | Prinzenallee 57 | NaN | 1 | NaN | Berlin | Ronald Meißner | Wedding (Wedding) | 211.00 | 0 | 106614942 | ... | 2.0 | 73.29 | ++Eine großzügige Wohnung erwartet sie++Wohnbe... | https://www.immobilienscout24.de/expose/106614942 | 13359 | 802.264096 | -332.474096 | 787.861200 | -318.071200 | -0.677050 |
956 | Pillnitzer Weg 11 | NaN | 1 | NaN | Berlin | NaN | Staaken (Spandau) | 360.00 | 0 | 106618194 | ... | 4.0 | 87.41 | große 4 Zimmer Wohnung mit Balkon und Keller | https://www.immobilienscout24.de/expose/106618194 | 13593 | 861.827812 | -326.827812 | 890.719214 | -355.719214 | -0.664896 |
3281 | Goldammerstr. 10 | NaN | 1 | NaN | Berlin | Hausverwaltung Bredemeier | Buckow (Neukölln) | 273.50 | 0 | 61471168 | ... | 2.0 | 77.26 | Bes. So. 19.08. um 15:00 Uhr, Wunderschöne 2-Z... | https://www.immobilienscout24.de/expose/61471168 | 12351 | 845.871975 | -324.371975 | 867.512634 | -346.012634 | -0.663495 |
1434 | Residenzstraße 97 | NaN | 1 | NaN | Berlin | Sandra Weiß | Reinickendorf (Reinickendorf) | 60.00 | 0 | 106471057 | ... | 2.0 | 64.00 | Schöne und geräumige 2-Zimmer-Wohnung mit Balk... | https://www.immobilienscout24.de/expose/106471057 | 13409 | 569.451652 | -189.451652 | 630.978918 | -250.978918 | -0.660471 |
1833 | Teichstraße 1 | NaN | 1 | NaN | Berlin | A. Kolbe | Reinickendorf (Reinickendorf) | 185.61 | 0 | 106240631 | ... | 2.0 | 61.81 | WBS mit besonderem Wohnbedarf nötig!!!! +++ BA... | https://www.immobilienscout24.de/expose/106240631 | 13407 | 676.163732 | -237.313732 | 728.460473 | -289.610473 | -0.659930 |
1492 | Tirschenreuther Ring 71 | NaN | 1 | NaN | Berlin | NaN | Marienfelde (Tempelhof) | 167.00 | 0 | 106440301 | ... | 2.0 | 65.16 | Besichtigungstermin Do, 02.08.2018 um 17.00 Uh... | https://www.immobilienscout24.de/expose/106440301 | 12279 | 712.961312 | -253.961312 | 760.213901 | -301.213901 | -0.656239 |
954 | Loschwitzer Weg 19 | NaN | 1 | NaN | Berlin | NaN | Staaken (Spandau) | 125.00 | 0 | 106618453 | ... | 2.0 | 67.07 | Neu renovierte 2 Zimmer Wohnung mit Balkon und... | https://www.immobilienscout24.de/expose/106618453 | 13593 | 680.816454 | -277.816454 | 663.858145 | -260.858145 | -0.647291 |
484 | Kamekestr. 14 | NaN | 1 | NaN | Berlin | Gabriele Bardt | Reinickendorf (Reinickendorf) | 141.00 | 0 | 106532699 | ... | 2.0 | 53.29 | 2-Zimmer-Wohnung in kleiner Wohnanlage | https://www.immobilienscout24.de/expose/106532699 | 13409 | 582.577050 | -209.577050 | 613.547493 | -240.547493 | -0.644899 |
1677 | Saatwinkler Damm 161 | NaN | 1 | NaN | Berlin | Gaby Fröb | Siemensstadt (Spandau) | 278.93 | 0 | 106340326 | ... | 2.0 | 68.69 | Für Selbstrenovierer! | https://www.immobilienscout24.de/expose/106340326 | 13629 | 698.611105 | -270.581105 | 697.156229 | -269.126229 | -0.628756 |
1315 | Lichtenhainer Str. 15 | NaN | 1 | NaN | Berlin | Christiane Hoffmann | Hellersdorf (Hellersdorf) | 179.42 | 0 | 106516071 | ... | 3.0 | 71.20 | Familienglück gesucht! | https://www.immobilienscout24.de/expose/106516071 | 12627 | 704.976645 | -252.286645 | 736.083494 | -283.393494 | -0.626021 |
1026 | Nahariyastr 32 | NaN | 1 | NaN | Berlin | Christina Schretzmair | Lichtenrade (Tempelhof) | 150.00 | 0 | 106611085 | ... | 2.0 | 65.00 | Schöne, geräumige zwei Zimmer Wohnung in Berli... | https://www.immobilienscout24.de/expose/106611085 | 12309 | 633.560975 | -183.560975 | 731.200866 | -281.200866 | -0.624891 |
1316 | Martin-Riesenburger-Str. 13 | NaN | 1 | NaN | Berlin | Christiane Hoffmann | Hellersdorf (Hellersdorf) | 181.71 | 0 | 106516069 | ... | 3.0 | 71.22 | Für jeden ein eigenes Zimmer! | https://www.immobilienscout24.de/expose/106516069 | 12627 | 705.196332 | -252.376332 | 735.702150 | -282.882150 | -0.624712 |
1303 | Mark-Twain-Str. 18 | NaN | 1 | NaN | Berlin | Christiane Hoffmann | Hellersdorf (Hellersdorf) | 179.47 | 0 | 106518678 | ... | 3.0 | 71.22 | Hier ist handwerkliches Geschick gefragt! | https://www.immobilienscout24.de/expose/106518678 | 12627 | 705.196332 | -252.376332 | 735.702150 | -282.882150 | -0.624712 |
1127 | Boddinstraße 49 | NaN | 1 | NaN | Berlin | Hardy Ney | Neukölln (Neukölln) | 123.30 | 0 | 106587389 | ... | 1.0 | 35.08 | 1-Zi.-Balkonwohnung (WBS-pflichtig) | https://www.immobilienscout24.de/expose/106587389 | 12053 | 350.632207 | -96.652207 | 412.197137 | -158.217137 | -0.622951 |
1678 | Ostpreußendamm 110A | NaN | 1 | NaN | Berlin | Lavinia Kolsut | Lichterfelde (Steglitz) | 211.43 | 0 | 106340293 | ... | 2.0 | 63.95 | Schmuckstück zum Wohlfühlen ! Anmietung nur mi... | https://www.immobilienscout24.de/expose/106340293 | 12207 | 699.670246 | -258.840246 | 714.244514 | -273.414514 | -0.620227 |
1159 | NaN | NaN | 0 | NaN | Berlin | Florian Dahnke | Marzahn (Marzahn) | 100.00 | 0 | 106572624 | ... | 2.0 | 45.00 | günstige Wohnung in Berlin-Marzahn | https://www.immobilienscout24.de/expose/106572624 | 12689 | 354.661444 | -74.661444 | 452.898175 | -172.898175 | -0.617493 |
967 | Ringslebenstr. 94 | NaN | 1 | NaN | Berlin | Vermietungs-Service Neukölln | Buckow (Neukölln) | 178.00 | 0 | 106616793 | ... | 2.0 | 57.42 | WBS-Berechtigung erforderlich. 2-Zimmer-Wohnun... | https://www.immobilienscout24.de/expose/106616793 | 12353 | 574.817454 | -215.937454 | 579.857464 | -220.977464 | -0.615742 |
1027 | Eschenbachstr. 7 | NaN | 0 | NaN | Berlin | Katrin Finke | Baumschulenweg (Treptow) | 150.00 | 0 | 106611012 | ... | 3.0 | 90.97 | Sanierungsbedürftige Wohnung sucht Mieter | https://www.immobilienscout24.de/expose/106611012 | 12437 | 916.049776 | -366.049776 | 887.857768 | -337.857768 | -0.614287 |
2390 | Schildhornstrasse 77 | NaN | 1 | NaN | Berlin | Hardy Ney | Steglitz (Steglitz) | 304.00 | 0 | 105725420 | ... | 4.0 | 98.75 | 4-Zi. Loggia-Balkonwohnung nahe Schloßstr. (WB... | https://www.immobilienscout24.de/expose/105725420 | 12163 | 1039.515338 | -380.855338 | 1061.055928 | -402.395928 | -0.610931 |
955 | Loschwitzer Weg 27 | NaN | 1 | NaN | Berlin | NaN | Staaken (Spandau) | 154.00 | 0 | 106618398 | ... | 3.0 | 72.61 | NEU renovierte 3 Zimmer Wohnung mit Balkon und... | https://www.immobilienscout24.de/expose/106618398 | 13593 | 720.464582 | -284.464582 | 700.295453 | -264.295453 | -0.606182 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
2788 | Karl-Stieler-Str. 18 | NaN | 1 | NaN | Berlin | NaN | Steglitz (Steglitz) | 0.00 | 0 | 104458175 | ... | 2.0 | 62.64 | Erstbezug! Terrasse mit teilmöblierter 2 Zi Wo... | https://www.immobilienscout24.de/expose/104458175 | 12167 | 685.280744 | 880.719256 | 682.227095 | 883.772905 | 0.564351 |
3130 | Köpenickerstr. 55 | NaN | 1 | NaN | Berlin | Jessica Serrano | Mitte (Mitte) | 60.00 | 0 | 92869294 | ... | 1.0 | 26.34 | Spacious 1-bedroom in Berlin-Mitte | https://www.immobilienscout24.de/expose/92869294 | 10197 | 307.753939 | 562.246061 | 377.410765 | 492.589235 | 0.566195 |
2990 | NaN | NaN | 1 | NaN | Berlin | Eva-Jannetje Gerlach | Mitte (Mitte) | 0.00 | 0 | 101605702 | ... | 2.0 | 65.00 | 5706 - Chausseestraße - Geschmackvolles und so... | https://www.immobilienscout24.de/expose/101605702 | 10115 | 711.203816 | 988.796184 | 733.629470 | 966.370530 | 0.568453 |
3183 | Atzpodienstr. 3 | NaN | 1 | NaN | Berlin | Frau Claudia Ewel | Lichtenberg (Lichtenberg) | 200.00 | 0 | 87915421 | ... | 1.0 | 35.76 | ++ SANIERT ++ Mit großzügige Terrasse in gepfl... | https://www.immobilienscout24.de/expose/87915421 | 10365 | 358.101567 | 641.898433 | 427.833601 | 572.166399 | 0.572166 |
3048 | Gutsmuthsstraße 11 | NaN | 0 | NaN | Berlin | NaN | Steglitz (Steglitz) | 70.00 | 0 | 98385971 | ... | 3.0 | 56.25 | TOP renovierte Gewerbe Nähe Forum Steglitz und... | https://www.immobilienscout24.de/expose/98385971 | 12163 | 534.673064 | 765.326936 | 546.620199 | 753.379801 | 0.579523 |
882 | Krossenerstr 13 | NaN | 0 | NaN | Berlin | NaN | Friedrichshain (Friedrichshain) | 0.00 | 0 | 106359698 | ... | 2.5 | 57.00 | Fully Furnished + All inclusive, Unique Design... | https://www.immobilienscout24.de/expose/106359698 | 10245 | 528.996051 | 921.003949 | 607.871711 | 842.128289 | 0.580778 |
3136 | Krausenstr. 37 | NaN | 1 | NaN | Berlin | NaN | Mitte (Mitte) | 299.00 | 0 | 92249224 | ... | 2.0 | 60.00 | Erstbezug! Möblierte Neubauwohnung in Mitte Sc... | https://www.immobilienscout24.de/expose/92249224 | 10117 | 656.282054 | 933.717946 | 659.935269 | 930.064731 | 0.584946 |
824 | Gabriele-Tergit-Promenade 21 | NaN | 1 | NaN | Berlin | Guido Bars | Tiergarten (Tiergarten) | 266.00 | 0 | 106245148 | ... | 2.0 | 63.00 | Schöne, geräumige zwei Zimmer Wohnung in Berli... | https://www.immobilienscout24.de/expose/106245148 | 10785 | 611.592271 | 988.407729 | 663.161742 | 936.838258 | 0.585524 |
2227 | Koloniestr. 11/12 | NaN | 1 | NaN | Berlin | Vanessa Hausauer | Wedding (Wedding) | 120.00 | 1 | 105943093 | ... | 1.0 | 36.00 | Modern möbilierte Studentenapartment mit Dacht... | https://www.immobilienscout24.de/expose/105943093 | 13357 | 401.448604 | 636.551396 | 427.011506 | 610.988494 | 0.588621 |
1293 | Kaiserstr. 4c | NaN | 1 | NaN | Berlin | NaN | Lichterfelde (Steglitz) | 100.71 | 1 | 106519517 | ... | 2.0 | 67.14 | Drei Terrassen! Möblierte Neubau-Wohnung mit A... | https://www.immobilienscout24.de/expose/106519517 | 12209 | 775.421122 | 1204.218878 | 806.222824 | 1173.417176 | 0.592743 |
146 | Wühlischstraße 29 | NaN | 1 | NaN | Berlin | Julian Karwath | Friedrichshain (Friedrichshain) | 150.00 | 0 | 106095319 | ... | 2.0 | 80.00 | Schöne, geräumige zwei Zimmer Wohnung in Berli... | https://www.immobilienscout24.de/expose/106095319 | 10245 | 745.201289 | 1154.798711 | 773.452442 | 1126.547558 | 0.592920 |
1962 | NaN | NaN | 1 | NaN | Berlin | Hendrik Schmidt | Kreuzberg (Kreuzberg) | 250.00 | 1 | 106188446 | ... | 2.0 | 55.51 | Hochwertig möblierte Wohnung / 6-24 Monate | https://www.immobilienscout24.de/expose/106188446 | 10963 | 647.673105 | 1002.326895 | 665.702228 | 984.297772 | 0.596544 |
2820 | wielandstrasse 25 | NaN | 0 | NaN | Berlin | Sheila Brause | Charlottenburg (Charlottenburg) | 80.00 | 0 | 104163977 | ... | 2.0 | 40.00 | Allerbeste Adresse Ku'damm Wohnung 2 Zimmer ko... | https://www.immobilienscout24.de/expose/104163977 | 10707 | 430.507494 | 769.492506 | 480.459007 | 719.540993 | 0.599617 |
830 | Jablonskistraße 21 | NaN | 0 | NaN | Berlin | Jeannette Gerekos | Prenzlauer Berg (Prenzlauer Berg) | 0.00 | 0 | 102200242 | ... | 1.0 | 22.00 | Berlin - Prenzlauer Berg | https://www.immobilienscout24.de/expose/102200242 | 10405 | 200.869365 | 599.130635 | 317.559939 | 482.440061 | 0.603050 |
430 | Monumentenstraße 28 | NaN | 0 | NaN | Berlin | Sandy Ecke | Kreuzberg (Kreuzberg) | 80.00 | 0 | 106382866 | ... | 1.0 | 30.68 | Umfassend modernisiert mit Einbauküche, Duschb... | https://www.immobilienscout24.de/expose/106382866 | 10965 | 349.338514 | 700.661486 | 414.853351 | 635.146649 | 0.604902 |
3135 | Krausenstr. 37 | NaN | 1 | NaN | Berlin | NaN | Mitte (Mitte) | 350.00 | 0 | 92249264 | ... | 3.0 | 67.00 | Erstbezug !Möblierte Neubauwohnung in Mitte nä... | https://www.immobilienscout24.de/expose/92249264 | 10117 | 711.967336 | 1038.032664 | 690.052123 | 1059.947877 | 0.605685 |
1792 | NaN | NaN | 1 | NaN | Berlin | NaN | Friedrichshain (Friedrichshain) | 0.00 | 0 | 106290819 | ... | 2.0 | 55.00 | helle, möblierte Mietwohnung direkt im Friedri... | https://www.immobilienscout24.de/expose/106290819 | 10245 | 601.360292 | 1078.639708 | 626.424434 | 1053.575566 | 0.627128 |
3095 | Mühlenstraße 60 | NaN | 1 | NaN | Berlin | Olaf Ruhnke | Friedrichshain (Friedrichshain) | 200.00 | 0 | 95250533 | ... | 2.0 | 60.00 | Spektakuläres Wohnen über der Eastside Gallery | https://www.immobilienscout24.de/expose/95250533 | 10245 | 656.282054 | 1133.717946 | 659.935269 | 1130.064731 | 0.631321 |
3103 | Chausseestr. 37 C 2 | NaN | 1 | NaN | Berlin | NaN | Mitte (Mitte) | 0.00 | 0 | 94643506 | ... | 2.0 | 43.90 | Wong Deso Apartment in the heart of Berlin - W... | https://www.immobilienscout24.de/expose/94643506 | 10115 | 479.433982 | 920.566018 | 508.236661 | 891.763339 | 0.636974 |
774 | Puccinistr. 32 | NaN | 0 | NaN | Berlin | Ernst Konrad | Weißensee (Weißensee) | 100.00 | 0 | 106382335 | ... | 2.0 | 50.00 | Wohnen auf Zeit 2 ZKB Loft in begehrter Umgebu... | https://www.immobilienscout24.de/expose/106382335 | 13088 | 462.708177 | 1037.291823 | 543.395289 | 956.604711 | 0.637736 |
68 | NaN | NaN | 1 | NaN | Berlin | Petra Hubertus | Mitte (Mitte) | 200.00 | 0 | 106297883 | ... | 2.0 | 45.60 | die perfekte single-dg-whg. in mitte am gipsdr... | https://www.immobilienscout24.de/expose/106297883 | 10119 | 498.107381 | 1001.892619 | 539.966823 | 960.033177 | 0.640022 |
3061 | Köpenicker Straße 55 | NaN | 1 | NaN | Berlin | Jessica Serrano | Mitte (Mitte) | 0.00 | 0 | 97712575 | ... | 2.0 | 40.00 | Fully furnished and equipped Apartment in Berl... | https://www.immobilienscout24.de/expose/97712575 | 10179 | 436.595008 | 863.404992 | 465.256742 | 834.743258 | 0.642110 |
829 | Jablonskistraße 21 | NaN | 0 | NaN | Berlin | Jeannette Gerekos | Prenzlauer Berg (Prenzlauer Berg) | 0.00 | 0 | 102200296 | ... | 2.0 | 30.00 | Berlin - Prenzlauer Berg | https://www.immobilienscout24.de/expose/102200296 | 10405 | 267.539000 | 832.461000 | 379.622862 | 720.377138 | 0.654888 |
67 | NaN | NaN | 1 | NaN | Berlin | Petra Hubertus reco immobilienbüro | Mitte (Mitte) | 134.51 | 0 | 105923967 | ... | 1.0 | 39.00 | sophienstraße 1 zi-apt. mit südterrasse und ko... | https://www.immobilienscout24.de/expose/105923967 | 10178 | 446.815840 | 1053.184160 | 434.713289 | 1065.286711 | 0.710191 |
27 | NaN | NaN | 1 | NaN | Berlin | Petra Hubertus reco immobilienbüro | Mitte (Mitte) | 134.51 | 0 | 104969872 | ... | 1.0 | 39.00 | sophienstraße 1 zi-apt. mit südterrasse und ko... | https://www.immobilienscout24.de/expose/104969872 | 10178 | 446.815840 | 1053.184160 | 434.713289 | 1065.286711 | 0.710191 |
2787 | Weserstr. 37 | NaN | 0 | NaN | Berlin | NaN | Neukölln (Neukölln) | 100.00 | 0 | 104474841 | ... | 1.0 | 10.00 | Krölln | https://www.immobilienscout24.de/expose/104474841 | 12045 | 69.057137 | 930.942863 | 286.221026 | 713.778974 | 0.713779 |
3224 | Otto-Braun Strasse 67 | NaN | 0 | NaN | Berlin | Renting Team Berlin | Mitte (Mitte) | 0.00 | 0 | 79469157 | ... | 1.5 | 21.00 | Möbliertes Junior Studio Apartment in Berlin M... | https://www.immobilienscout24.de/expose/79469157 | 10178 | 232.407392 | 1257.592608 | 342.208134 | 1147.791866 | 0.770330 |
3221 | Otto-Braun Strasse 67 | NaN | 0 | NaN | Berlin | Renting Team Berlin | Mitte (Mitte) | 0.00 | 0 | 79469862 | ... | 2.0 | 34.00 | Möbliertes Junior 1 Bedroom Apartment in Berli... | https://www.immobilienscout24.de/expose/79469862 | 10178 | 364.601380 | 1425.398620 | 404.547534 | 1385.452466 | 0.773996 |
3223 | Otto-Braun Strasse 67 | NaN | 1 | NaN | Berlin | Renting Team Berlin | Mitte (Mitte) | 0.00 | 0 | 79469490 | ... | 2.0 | 30.00 | Möbliertes Senior Grand Apartment in Berlin Mi... | https://www.immobilienscout24.de/expose/79469490 | 10178 | 326.751485 | 1663.248515 | 424.124734 | 1565.875266 | 0.786872 |
3222 | Otto-Braun Strasse 67 | NaN | 0 | NaN | Berlin | Renting Team Berlin | Mitte (Mitte) | 0.00 | 0 | 79469592 | ... | 1.0 | 25.00 | Möbliertes Mini 1 Bedroom Apartment in Berlin ... | https://www.immobilienscout24.de/expose/79469592 | 10178 | 286.947393 | 1403.052607 | 358.741515 | 1331.258485 | 0.787727 |
2993 rows × 26 columns