Print
Portrait brochure 1: A4, 4 page.
Image
Agriturismo, For SaleTo Let
8
10
0
Image

Freehold

Teramo, Morro d Oro, TE64020

FARMHOUSE with TEN BEDROOMS near the VILLAGE of MORRO D'ORO. It is CURRENTLY used as an AGRITURISMO. It has a LARGE SWIMMING POOL, VIEWS, PARKING, RESTAURANT, WINE CELLAR, GARDEN and LAND cultivated with FRUIT and OLIVE TREES. Can be used as a HOSPITALITY BUSINESS alternatively as a PRIVATE HOME.

FARMHOUSE with TEN BEDROOMS near the VILLAGE of MORRO D'ORO. It is CURRENTLY used as an AGRITURISMO. It has a LARGE SWIMMING POOL, VIEWS, PARKING, RESTAURANT, WINE CELLAR, GARDEN and LAND cultivated with FRUIT and OLIVE TREES. Can be used as a HOSPITALITY BUSINESS alternatively as a PRIVATE HOME.

No EPC chart found
Features :
abruzzopropertyitaly.com
Call:+44 7767 477580
Eagle House, Coventry, CV1 3EG
...
Teramo, Morro d Oro, TE64020
Image

Freehold

Image
Image
Image
Image
...
Teramo, Morro d Oro, TE64020
Image
Image
Image
Image
Image
Image
Image
Image
Image
Image
Image
FARMHOUSE with TEN BEDROOMS near the VILLAGE of MORRO D'ORO. It is CURRENTLY used as an AGRITURISMO. It has a LARGE SWIMMING POOL, VIEWS, PARKING, RESTAURANT, WINE CELLAR, GARDEN and LAND cultivated with FRUIT and OLIVE TREES. Can be used as a HOSPITALITY BUSINESS alternatively as a PRIVATE HOME.
FARMHOUSE with TEN BEDROOMS near the VILLAGE of MORRO D'ORO. It is CURRENTLY used as an AGRITURISMO. It has a LARGE SWIMMING POOL, VIEWS, PARKING, RESTAURANT, WINE CELLAR, GARDEN and LAND cultivated with FRUIT and OLIVE TREES. Can be used as a HOSPITALITY BUSINESS alternatively as a PRIVATE HOME.
No EPC chart found
Image
Abruzzo Property Italy
Abruzzo Property Italy
...

Debug info:
CMS core version: 3.1.0 - Estate Agency Edition
url:property-search~action=print,pid=3026
SELECT * FROM g_sitestructure WHERE seo_friendly_name COLLATE latin1_general_cs = 'property-search' AND archived = 0  AND domain_id = '1100'

SEO: Page found for property-search: property-search
PMS connection string found
Connected to pms3_abruzzoproperty
Page type:page
Public page
loading version: 43430
publish start date: 0000-00-00 00:00:00
publish end date: 0000-00-00 00:00:00
Content found for 43430 - id=51128
Loading breadcrumb from cache: bc43430
Loading module: pse3 / CombinedSearchResults / results1.tpl||||results_map1.tpl||||||||details1.tpl||||||1||2||||||||
Dom id: 1100
Unable to connect to the database server at 10.106.32.4:6033
SQL failed: 'select * from accounts where dbuser = 'pms3_abruzzoprop' AND dbname = 'pms3_abruzzoproperty''

Pconf set Abruzzo Property Italy
SELECT * FROM pms_properties WHERE id = 3026 AND isEnabled = 1 AND archived = 0 AND published = 1

get Images - pid: 3026
SELECT * FROM g_pse_conf WHERE domain_id = '1100'

Content filters are disabled
Loading module: feEditing / showInterface /
Page took 0.023 seconds to render
11 queries executed