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

Real estate near Aytos. Sales and rentals of properties near Aytos

What are the TOP properties for sale in Aytos?
I own a property in Aytos. How can I SELL it?
More info about Aytos
Read more
!!!!!! 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='283' or a.p_townid2='283') AND ( CASE WHEN ( a.p_townid = '283' ) THEN ( a.location_prefix = 'near' ) WHEN ( a.p_townid2 = '283' ) THEN ( a.location_prefix != '' ) END ) 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
1 offers found
Sort by
You have property for sale near Aytos?
For sale
INVESTMENT PROJECT
Business plot on the highway Burgas-Sofia Near Aytos , Trakiya highway - 344th km Attractive plot sale facing the highway We offer you this attractive plot with a total area of 10,000 m2 facing highway "Trakia" in the direction Burgas - Karnobat. The plot is located on the 344th km of the highway. It has prepared
210 000
(21 €/m2)Area: 10 000.00 m2
Type of property: Building plot with project
Stilian Georgiev Senior Estate Agent, Sunny Beach
1 from 1 results

REQUEST DETAILS