Property Showroom

Change Your Search Results:
List by Price: help Show Location: help
Show Categories: help Show Types: help

Properties 1 to 2 of 2
Under Offer
Click here for more details about this property
Address:
Orchard Road
Location:
Downpatrick
Type:
Farms
 
Offers Over £500,000
Under Offer
Under Offer
Click here for more details about this property
Address:
88 Vianstown Road
Location:
Downpatrick
Type:
Farms
 
POA
« Previous1Next »

 

Downpatrick Estate Agents

,

Northern Ireland

Estate Agents in Downpatrick

real estate services including property sales and rentals for the residential, commercial and farming properties in Downpatrick and County Down

Peter Fitzpatrick and Sons are an estate agents based in Downpatrick on the outskirts of Downpatrick, County Down, Northern Ireland. near Belfast

Peter Fitzpatrick and Sons are an estate agents based in Downpatrick on the outskirts of Downpatrick, County Down, Northern Ireland. near Belfast.

Ireland, Irish, northern Ireland, Northern Irish, UK, Peter Fitzpatrick and Sons are an estate agents based in Downpatrick on the outskirts of Downpatrick, County Down, Northern Ireland.

Downpatrick Estate Agent Peter Fitzpatrick and Sons are an estate agents based in Downpatrick on the outskirts of Downpatrick, County Down, Northern Ireland. Peter Fitzpatrick and Sons provide a range of real estate services including property sales and rentals for the residential, commercial and farming client. Peter Fitzpatrick and Sons service the Downpatrick, South County Down and North County Down areas focusing on Downpatrick, Northern Ireland Downpatrick Estate Agents - Peter Fitzpatrick and Sons - "Estate Agents in Downpatrick" Peter Fitzpatrick and Sons estate agent Downpatrick -"Downpatrick Estate Agents" Estate Agent sell house buy home house property estate agency estate agency estate agency estate agent Peter Fitzpatrick and Sons Downpatrick Estate Agent Ciaran Fitzpatrick of Peter Fitzpatrick and Sons, Carryduff, Downpatrick
SELECT tbl_listing.Id, tbl_listing.address, tbl_listing.nobedrooms,tbl_listing.price,tbl_listing.thumbnail1, tbl_listing.town, tbl_towns.townname,tbl_mod_listingtype.listingtypename,tbl_mod_pricetype.pricetypename, tbl_mod_propertytype.propertytypename, tbl_mod_currency.currencycode,tbl_mod_status.statusname FROM tbl_listing INNER JOIN tbl_towns ON tbl_towns.townid=tbl_listing.town INNER JOIN tbl_mod_listingtype ON tbl_listing.listingtypeid=tbl_mod_listingtype.listingtypeid INNER JOIN tbl_mod_pricetype ON tbl_listing.pricetypeid=tbl_mod_pricetype.pricetypeid INNER JOIN tbl_mod_propertytype ON tbl_listing.propertytypeid=tbl_mod_propertytype.propertytypeid INNER JOIN tbl_mod_currency ON tbl_listing.currencyid=tbl_mod_currency.currencyid INNER JOIN tbl_mod_status ON tbl_listing.statusid=tbl_mod_status.statusid WHERE tbl_listing.listingtypeid =3 AND tbl_listing.categoryid <>-1 AND tbl_listing.town <>-1 ORDER BY Id ASC