!!!!!! SELECT a.*,(a.p_price/a.p_area) AS price_sqm, c.p_location,c.description,c.imotbgtxt,c.complex_name,c.headpic_alt,c.vfile1,c.youtube_link,c.p_knowplace,c.gtrans,c.prop_of_week,c.social_post_link,c.social_post_link2,c.social_post_link3 from properties a use index(`ad_type`,`order_by`) ,properties_data c WHERE a.ad_hide='0' and a.ad_hide_BP='0' AND (a.p_townid='4732' or a.p_townid2='4732') AND a.p_quartid='848' AND a.publish=1 and a.p_cntrid='1' AND (YEAR( a.ad_pubdate ) >2018
OR ( YEAR( a.ad_pubdate ) <=2018 AND a.ad_status !=1 )
) and a.ID=c.ID AND c.lang='en' ORDER BY a.top DESC, a.ad_position ASC, a.ad_pubdate DESC LIMIT 0,20
Search
3
offers found
Sort by
You have property for sale in Quarter Belite brezi?
Cozy two bedroom apartment with TOP location in Belite Brezi Sofia , Quarter Belite brezi
Warm two bedroom apartment next to Niagara restaurant
We offer for sale a two-bedroom apartment with favorable location. Bright and comfortable apartment with full south exposure and excellent layout. The property has all necessary amenities and is ideal for families or people looking for convenience and space. The property is part of a brick building with an elevator and well maintained common areas. The area is extremely communicative and providing all modern amenities for a comfortable everyday life. There are grocery stores, market, service and
Spacious penthouse with a view of Vitosha in Beli Brezi district Sofia , Quarter Belite brezi
Excellent property within walking distance of two metro stations
Multi-room penthouse on two levels next to 126 "Petko Yu. Todorov" elementary school, within walking distance of two metro stations. The apartment is part of a brick building (2001) with well-maintained common areas. The neighborhood is among the preferred places to live in the capital – it offers an excellent environment for a peaceful life, appreciated by many families. In the area there are many schools and kindergartens, a children's party center, kindergartens for recreation and
Sunny two bedroom apartment on a quiet street in Beli Brezi district Sofia , Quarter Belite brezi
South two-bedroom apartment in a very communicative location and 700 meters from the metro station "Krasno Selo"
We present you a sunny two-bedroom apartment in one of the most desirable neighborhoods of Sofia - "Beli Brezi", located on a quiet street, 700 meters from the metro station "Krasno Selo" and with excellent access to the central part of the city.
This apartment is an ideal choice for a family looking for a spacious, bright and well-maintained home in a quiet part of the city, with all amenities within walking distance.
Located in a brick building, built in 2008, with well maintained
We use cookies to offer you a better browsing experience, serve personalized ads, measure results and analyze traffic. If you click on I accept all cookies button, you agree to receive all cookies from this site and from third parties.
Call
Send Email
Messenger
WhatsApp
