Newsletter

Subscribe to our newsletter and you'll receive regular emails keeping you up to date on our latest news, special offers and exclusive member only deals!

Latest News

Port Cyprium Marina, first fully serviced marina in North Cyprus:
Port Cyprium Marina & Village is a unique mixed-use development project located at Kuchuk Erenkoy (Kucuk Erenkoy), just 30 km east of the port town of Kyrenia. In its entirety, the project concept res...
North Cyprus Property Prices Set to Soar as Reunification Talks Start:
UN and Cypriot Leaders: High Expectations for Accord in 2009. Property prices in North Cyprus have shot upwards as Turkish and Greek Cypriot leaders have agreed to enter into intense negotiations ...
Major Boost To North Cyprus Property Market? Greek Cypriots Vote In a Presidential Election That Is Seen As Pivotal For Efforts To Reunite Cyprus:
The closest-ever election in southern Cyrus has ended President Tassos Papadopoulos's five years in power. The MEP Ioannis Kasoulides won the knife-edge poll by just 980 votes, after a turnout of aro...
 

<< BackPrint-friendly version
 

North Cyprus Bungalow


 
SELECT TYPE as Type1 , type_id, (SELECT count( property_type ) FROM pt_property p WHERE p.property_type = pt.type_id AND price >0 AND p.status =0 AND property_type='58' and shop_id='2' ) AS Total_Number FROM pt_property_type pt WHERE shop_id='2' GROUP BY type_id
Property Type
Apartment (0)
Penthouse (0)
Villa (0)
Bungalow (27)
Town House (0)
Land for Development (0)
Hotels & Casinos for Sale (0)
select bedrooms,count(bedrooms) as Total_Number from pt_property where property_type ='58' and shop_id='2' AND price >0 AND status =0 group by bedrooms order by bedrooms
Bedrooms
SELECT pr . * , (SELECT count( property_id ) FROM pt_property p WHERE p.price > pr.price_from AND p.price <= pr.price_to AND property_type='58' and shop_id='2' AND STATUS =0 ) AS Total_Number FROM price_range pr
Property Price Range
£0-£50000 (0)
£50000-£150000 (26)
£150000-£500000 (1)
£500000-+ (0)
SELECT pl1.parent_id, pl2.value, count( p.property_id ) AS Total_Number FROM pt_locations pl1 LEFT JOIN pt_locations pl2 ON pl1.parent_id = pl2.Location_id LEFT JOIN pt_property p ON pl1.location_id = p.property_location WHERE pl1.STATUS =1 AND pl1.location_id <>62 AND pl1.shop_id ='2' AND p.status =0 AND p.price >0 AND p.shop_id ='2' AND property_type='58' GROUP BY pl2.value ORDER BY pl2.value
Property Location
You are viewing results  1 to 10 of 27  1  2  3  Next 


Reference: GUZ1259BUNG
14196
Price:£63,600
Location: Guzelyurt

 Add to Favourites

3 Bedroom Cypriot Village House in North Cyprus, Needs some attention


3 bedroom bungalow on one and a half donums of land in the agricultural village of Kozan, the property is full exchange land and boasts a selection of mature olive, fruit and nut trees. This is a fant...
Completion Status: Resale
Category: Cypriot Village House Refurbishment Property Retirement Home(S)
Property Type: Bungalow
More Info Contact Us
 
Reference: KAR1003BUN
12265
Price:£65,000
Location: Karsiyaka

 Add to Favourites

3 Bedroom Beachfront Bungalows in Cyprus Karsiyaka, Perfect North Cyprus Property Investment and Ideal Holiday Home in Cyprus


3 bedroom luxury Karsiyaka North Cyprus bungalows at unbeatable prices. Top real estate investment in Cyprus! Superb location, great stylish design, in stunning Kyrenia. This site is superbly placed a...
Completion Status: Off Plan
Category: Ideal Holiday Home(S) Beach Sea Front Investment Property
Property Type: Bungalow
More Info Contact Us
 
Reference: TAT1191BUN
14364
Price:£74,900
Location: Tatlisu

 Add to Favourites

3 Bedroom Sea View Bungalows in North Cyprus Tatlisu Offered at Bargain Prices


This beautiful Tatlisu North Cyprus development consists of 10 bungalows and 41 villas with 3 bedrooms and 2 bathrooms. The properties are currently off plan and offered at bargain prices without com...
Completion Status: New Build
Category: Ideal Holiday Home(S) Retirement Home(S) Bargain Property Investment Property
Property Type: Bungalow
More Info Contact Us
 
Reference: ESE1057BUN
12589
Price:£79,950
Location: Esentepe

 Add to Favourites

3 Bedroom Bungalows in North Cyprus Esentepe, Close to the Sea and Esentepe Golf Course, Ideal North Cyprus Property for Retirement


3 bedroom detached Esentepe North Cyprus bungalows close to sea in sought after area of Esentepe.   45 detached bungalows close to the sea between Esentepe and Tatlisu all set in the own individual di...
Completion Status: New Build
Category: Ideal Holiday Home(S) Retirement Home(S) Golf Property Bargain Property
Property Type: Bungalow
More Info Contact Us
 
Reference: KAR1060BUN
12645
Price:£79,950
Location: Karsiyaka

 Add to Favourites

3 Bedroom 2 Bathroom Bungalows in Cyprus Karsiyaka with Private pools and Gardens, Ideal Retirement Home


3 bedroom 3 bathroom detached bungalow with private pool, excellent sea and mountain views.  Ideal North Cyprus Property for retirement and excellent holiday home in Cyprus.   The off-plan prices are ...
Completion Status: New Build
Category: Ideal Holiday Home(S) Retirement Home(S) Bargain Property
Property Type: Bungalow
More Info Contact Us
 
Reference: ALA1282BUN
14668
Price:£85,000
Location: Alagadi

 Add to Favourites

2 Bedroom 3 Bathroom Turtle Beach Luxury Bungalows In Alagadi North Cyprus


With the golf course and famous Turtle Beach close by, these luxurious bungalows are located in Esentepe, just a 15 min drive away from Kyrenia city centre. These luscious 2 bedroom bungalows boast st...
Completion Status: Off Plan
Category: Bargain Property Ideal Holiday Home(S)
Property Type: Bungalow
More Info Contact Us
 
Reference: BAH1107BUN
12982
Price:£85,000
Location: Bahceli

 Add to Favourites

2 Bedroom North Cyprus Bungalows In Bahceli 200 Metres To The Beach And Within Natural Settings, Ideal North Cyprus Retirement Home And Perfect Mediterranean Property For Holiday Home


Exceptional development of 9 North Cyprus bungalows built to the highest specification in the Pine Forest in the Bahçeli ‘Garden of North Cyprus'. These bungalows have 3 bedrooms with ceramic flooring...
Completion Status: Off Plan
Category: Ideal Holiday Home(S) Retirement Home(S) Bargain Property
Property Type: Bungalow
More Info Contact Us
 
Reference: CAT1299BUN
14941
Price:£89,000
Location: Catalkoy

 Add to Favourites

2/3 Bedroom Beautifully Designed Bungalows In Catalkoy Kyrenia Set Amongst Olive Trees


Set in the tranquil village of Catalkoy, Kyrenia, amongst age old olive trees, this beautifully laid out estate offers 2 and 3 bedroom bungalows ideal for year-round living.  Each bungalow sits o...
Completion Status: New Build
Category: Cypriot Village House
Property Type: Bungalow
More Info Contact Us
 
Reference: FAM1102BU
12950
Price:£89,000
Location: Salamis

 Add to Favourites

2 Bedroom 2 Bathroom Bungalows in North Cyprus Famagusta with Panoramic Sea Views. This Cyprus Property is Only 5 minutes from the Beach, Perfect North Cyprus Holiday Home


2 Bedroom 2 Bathroom Bungalows in Famagusta, North Cyprus with Panoramic Views. This Cyprus Property is Only 5 minutes from the Beach, and are thoughtfully planned for Comfort, designed in a luxurious...
Completion Status: New Build
Category: Ideal Holiday Home(S) Retirement Home(S) Beach Sea Front
Property Type: Bungalow
More Info Contact Us
 
Reference: ESE1145BUN
14276
Price:£89,950
Location: Esentepe

 Add to Favourites

2 Bedroom 2 Bathroom Bungalow in Esentepe near Korineum Golf Club with Private Pool and Garden


2 bedroom spacious North Cyprus bungalows with excellent sea and mountain views designed by architects and built by builders with a proven track record for high quality design, build and finish. ...
Completion Status: Nearing Completion
Category: Bargain Property Golf Property Ideal Holiday Home(S) Retirement Home(S)
Property Type: Bungalow
More Info Contact Us
 

You are viewing results 1 to 10 of 27  1  2  3  Next