0
Hello,
Favourite properties (0)
Saved searches
Selected for you
Notifications
Subscriptions
Settings
Sign out
Close

Properties and apartments in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district, town Burgas, Quarter Horizont for sale and rent

!!!!!! 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, t4.ID as pl_ID,t4.type,t4.floor, t4.rn, t4.unit_name, t4.price as pricelist_price, t4.total_area as total_area_pricelist, t4.pricelist_price_sqm, t4.type_arr,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`) LEFT JOIN ( SELECT pricelist_tmp_table.* FROM ( SELECT tmp.ID,tmp.type,tmp.propID,tmp.type_arr, tmp.floor, tmp.apartment as unit_name, least( CASE WHEN tmp.price = 0 THEN 10000000 ELSE tmp.price END, CASE WHEN tmp.price1 = 0 THEN 10000000 ELSE tmp.price1 END, CASE WHEN tmp.price2 = 0 THEN 10000000 ELSE tmp.price2 END, CASE WHEN tmp.price3 = 0 THEN 10000000 ELSE tmp.price3 END, CASE WHEN tmp.price4 = 0 THEN 10000000 ELSE tmp.price4 END, CASE WHEN tmp.price5 = 0 THEN 10000000 ELSE tmp.price5 END, CASE WHEN tmp.price6 = 0 THEN 10000000 ELSE tmp.price6 END, CASE WHEN tmp.price7 = 0 THEN 10000000 ELSE tmp.price7 END, CASE WHEN tmp.price8 = 0 THEN 10000000 ELSE tmp.price8 END ) as price, tmp.total_area, (tmp.price/tmp.total_area) AS pricelist_price_sqm, @row_number:=CASE WHEN @propID = propID THEN @row_number + 1 ELSE 1 END AS rn, @propID := propID FROM properties_rows as tmp use index(`search_engine`) CROSS JOIN (select @row_number := 1) as x CROSS JOIN (select @propID := -1) as y WHERE CASE WHEN (type =6 OR type =7 OR type =14) THEN floor >=0 WHEN type!=5 THEN floor >= 9 ELSE floor >= 10 END AND apartment!='' AND status=0 and hide=0 AND type not in (14,15,16,17,26,46,59) AND type>4 ORDER BY propID, tmp.floor ASC ) as pricelist_tmp_table ) as t4 ON a.ID = t4.propID AND t4.rn <= 1000 ,properties_data c WHERE a.ad_hide='0' and a.ad_hide_BP='0' AND a.ID='87577' 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 ((a.offplan=1 AND rn>0) OR a.offplan=0 ) AND c.lang='en' ORDER BY a.top DESC, a.ad_position ASC, a.ad_pubdate DESC, t4.rn ASC LIMIT 60,20
106 offers found
Sort by
You have property for sale in complex ?
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B51
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 79 257
54.66 m2 (1450€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B50
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 87 038
62.17 m2 (1400€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B59
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 88 183
62.99 m2 (1399€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B57
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 89 047
61.41 m2 (1450€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B49
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 89 543
63.96 m2 (1399€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B60
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 91 235
65.17 m2 (1399€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B56
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 91 550
65.39 m2 (1400€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B53
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 98 632
70.45 m2 (1400€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
Euphoria Club Hotel & Resort - your paradise in Borovets!
Fully furnished 1- and 2-bedroom apartments in a unique complex in Borovets. All-year-round complex with all needed facilities for your comfortable stay - lobby bar, reception, bar and restaurant, outdoor and indoor pool, SPA center, underground parking and many more. Choose your holiday home here! No buyer's commission! Suitable for rental income.
See More
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B54
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 98 632
70.45 m2 (1400€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B55
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 98 632
70.45 m2 (1400€/m2) Floor: 6
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
2-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B58
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 137 912
98.51 m2 (1399€/m2) Floor: 6
Type of property: 2-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
2-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B52
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 146 168
104.41 m2 (1399€/m2) Floor: 6
Type of property: 2-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B63
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 81 990
54.66 m2 (1500€/m2) Floor: 7
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment A59
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 86 365
61.69 m2 (1399€/m2) Floor: 7
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B62
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 87 038
62.17 m2 (1400€/m2) Floor: 7
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment A57
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 87 985
62.85 m2 (1399€/m2) Floor: 7
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B71
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 88 183
62.99 m2 (1399€/m2) Floor: 7
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment B69
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 89 047
61.41 m2 (1450€/m2) Floor: 7
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment A66
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 89 912
64.22 m2 (1400€/m2) Floor: 7
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
For sale
new
1-bedroom apartment in 1-bed, 2-bed and 3-bed seaside apartments in Horizont district Burgas , Quarter Horizont
Apartment A65
New residential building next to "Prof. Dr. Asen Zlatarov" University
We present to your attention a new, unique residential project with functionally distributed apartments - one-, two- and three-bedroom dwellings in Burgas - Horizont district, close to the University "Prof. Dr Asen Zlatarov" and the student campus, which is planned to be built,
€ 89 944
62.03 m2 (1450€/m2) Floor: 7
Type of property: 1-bedroom apartment
Georgi Ivanov Estate Agent, Burgas
<< 1 2 34 5 6>>
80 from 106 results

REQUEST DETAILS