SELECT sites_prop_index.pid,sites_prop_index.accepted,sites_prop_index.adtype,sites_prop_index.pics,sites_prop_index.feed,sites_prop_details.pid,sites_prop_details.country,sites_prop_details.city,sites_prop_details.address1,sites_prop_details.address2,sites_prop_dates.pid, sites_prop_dates.date_added,sites_prop_pics.pid,sites_prop_pics.bdata FROM sites_prop_index JOIN sites_prop_dates ON sites_prop_index.pid = sites_prop_dates.pid JOIN sites_prop_pics ON sites_prop_index.pid = sites_prop_pics.pid JOIN sites_prop_details ON sites_prop_index.pid = sites_prop_details.pid WHERE sites_prop_index.accepted = 1 AND sites_prop_index.adtype = 1 AND sites_prop_index.pics = 1 AND sites_prop_pics.picid = 1 AND MATCH(sites_prop_details.country,sites_prop_details.city,sites_prop_details.address1,sites_prop_details.address2) AGAINST ('Famagusta District' IN BOOLEAN MODE) ORDER BY sites_prop_dates.date_added DESC LIMIT 20;
SELECT sites_prop_index.pid,sites_prop_index.accepted,sites_prop_index.adtype,sites_prop_index.pics,sites_prop_index.feed,sites_prop_details.pid,sites_prop_details.country,sites_prop_details.city,sites_prop_details.address1,sites_prop_details.address2,sites_prop_dates.pid,sites_prop_dates.date_added, listing_views.pid, listing_views.views FROM sites_prop_index JOIN sites_prop_dates ON sites_prop_index.pid = sites_prop_dates.pid JOIN listing_views ON sites_prop_index.pid = listing_views.pid JOIN sites_prop_details ON sites_prop_index.pid = sites_prop_details.pid WHERE sites_prop_index.adtype = 1 AND sites_prop_index.pics = 1 AND listing_views.views > 0 AND MATCH(sites_prop_details.country,sites_prop_details.city,sites_prop_details.address1,sites_prop_details.address2) AGAINST ('Famagusta District' IN BOOLEAN MODE) ORDER BY listing_views.views DESC,sites_prop_dates.date_added DESC LIMIT 20;
SELECT sites_prop_index.pid,sites_prop_index.accepted,sites_prop_index.adtype,sites_prop_index.pics,sites_prop_index.feed,sites_prop_details.pid,sites_prop_details.country,sites_prop_details.city,sites_prop_details.address1,sites_prop_details.address2,sites_prop_dates.pid, sites_prop_dates.date_added, sites_prop_ratings.pid, sites_prop_ratings.proprating, sites_prop_ratings.numofratings, listing_views.pid, listing_views.views FROM sites_prop_index JOIN sites_prop_dates ON sites_prop_index.pid = sites_prop_dates.pid JOIN sites_prop_ratings ON sites_prop_index.pid = sites_prop_ratings.pid JOIN sites_prop_details ON sites_prop_index.pid = sites_prop_details.pid JOIN listing_views ON sites_prop_index.pid = listing_views.pid WHERE sites_prop_index.accepted = 1 AND sites_prop_index.adtype = 1 AND sites_prop_index.pics = 1 AND sites_prop_ratings.proprating > 0 AND MATCH(sites_prop_details.country,sites_prop_details.city,sites_prop_details.address1,sites_prop_details.address2) AGAINST ('Famagusta District' IN BOOLEAN MODE) ORDER BY sites_prop_ratings.proprating DESC, listing_views.views DESC, sites_prop_dates.date_added DESC LIMIT 20;
Famagusta homes for sale and rent - villas in famagusta - luxury apartments famagusta
Famagusta homes for sale and rent - villas in famagusta - luxury apartments famagusta 
famagustahomes.com
A WORLD OF REAL ESTATE AT YOUR FINGERTIPS
Sign In 
Register  
Feeds click for RSS feeds
Selling | Letting | Agents  
 
 
QUICK PLACENAME SEARCH
Buy  Rent  All 
 Advanced Search
 
 
 
SEARCH BY COUNTRY
Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player
 
 
SEARCH BY LISTING TYPE
 
 
 
 
 
 
 
 
 
 
SEARCH LISTINGS BY USER
Buy  Rent  All 
 
 
LISTING & NETWORK DATA
 
For Sale Listings : 288,948
 
For Rent Listings : 169
 
Vacation Rentals : 56,699
 
Total Members : 920
 
Active Members : 1
 
Active Visitors : 33
 
Networked Sites : 310
 20 LATEST LISTINGS
Buying | Renting | Holiday Let   
 
 
 
Selling your real estate?
Choose how to sell or let your property in Three Easy Steps.
Register for a free account and list all your real estate for sale or let Free.
Anyone can list their home for sale without paying a cent.
 
 
Developer or Estate Agency?
Upload your logo to show on all listings.
Receive Instructions from users who
want you to sell their property for them. Find out more about how our service will benefit your business.
 
 
 20 TOP RATED LISTINGS
Buying | Renting | Holiday Let   
 
 
 
Holiday Letting your property?
Sign in and list a Holiday Let in minutes.
177 Euros for a full year searchable on all 310 sites in the network. Upload up to 12 photos and choose the dates available and booked. Return anytime to amend availability.
 
 
Upload your real estate feeds
Upload all your listings in seconds using our automated feed system. We now accept feeds from Enormo, Zillow, Rightmove, Googlebase, Kyero and xml2u. Find out more about how to upload your feed here.
 
 
 
 
 
Send us your feedback
At the goodmovemate network we appreciate all user feedback as it helps us evolve and improve our service at every level for all our members,
so let us know what you think and we'll take your ideas onboard. Thank you.
 
 
Promoting your business?
To promote your real estate related business on every one of the 310 sites that comprise the goodmovemate real estate portal network fill out this form and we will contact you to make arrangements.