Quick Search


Search results: 407 properties.

List View Map View
...

Chieti, Fossacesia, CH66022

€800,000 PCMFor sale

BEAUTIFUL, SIX BEDROOM VILLA in FOSSACESIA. The PROPERTY has VIEWS of the COAST, LARGE GARAGE, TERRACES, PLANS for a SWIMMING POOL and is COMPLETED with HIGH QUALITY MATERIALS. VIEWING RECOMMENDED.

6 x 5 x 2 x {PARKING} x Yes x 500.00SQM

View details �     +Add to favorits

...

Chieti, Ortona, CH66038

€1,050,000 PCMFor sale

STUNNING VILLA with SEA VIEWS in SAN VITO CHIETINO. It is CONTEMPORARY with a delightful SWIMMING POOL in the HEART of the COSTA DEI TRABOCCHI. The property is SET in ONE HECTARE of PRIVATE LAND with OLIVE TREES.

4 x 5 x 1 x {PARKING} x Yes x 250.00SQM

View details �     +Add to favorits

...

Chieti, Vasto, CH66054

€1,150,000 PCMFor sale

AMAZING VILLA with BEAUTIFUL SEA VIEWS within ONE KILOMETRE of VASTO. The HOUSE is FLEXIBLE with a BASEMENT that could BECOME a SEPARATE APARTMENT and an ATTIC with LARGE ROOMS to DIVIDE. The VILLA BENEFITS from a FENCED GARDEN and TERRRACES. MUST VIEW.

3 x 3 x 2 x {PARKING} x Yes x 160.00SQM

View details �     +Add to favorits

...

Teramo, Teramo, TE64100

€1,300,000 PCMFor sale

WONDERFUL, ANCIENT ESTATE in the HILLS SURROUNDING TERAMO. It has SO MUCH SPACE and can EITHER be a PERMANENT RESIDENCE or an ACCOMMODATION FACILITY.

10 x 10 x 2 x {PARKING} x Yes x 0.00SQM

View details �     +Add to favorits

...

Chieti, Francavilla al Mare, CH66023

€1,550,000 PCMFor sale

PRESTIGIOUS, FIVE BEDROOM VILLA on the HILL in the DELIGHTFUL RESORT of FRANCAVILLA AL MARE. The PROPERTY needs some WORK but there is a BEAUTIFUL LARGE SALOON with BRICK PASSAGEWAYS, IDEAL for laying down WINE. A VIEWING is RECOMMENDED.

5 x 3 x 1 x {PARKING} x Yes x 650.00SQM

View details �     +Add to favorits

...

Chieti, Francavilla al Mare, CH66023

€2,200,000 PCMFor sale

RENOVATED VILLA in the RESORT TOWN of FRANCAVILLA AL MARE currently used as a RESTAURANT and for LARGE WEDDING CEREMONIES. CLOSE to BEACH and with SEA VIEWS.

Studio x 1 x 0 x {PARKING} x Yes x 2400.00SQM

View details �     +Add to favorits

...

Chieti, Ortona, CH66026

€7,500,000 PCMFor sale

LOOKING for a LIFESTYLE CHANGE then CHOOSE this 65 BEDROOM HOTEL, LOCATED on the BEACHFRONT at ORTONA. PLEASE CALL for MORE DETAILS

Studio x 0 x 0 x {PARKING} x Yes x 5000.00SQM

View details �     +Add to favorits

Showing page 9 of 9 | Go to page: 1 2 3 4 5 6 7 8 9

Debug info:
CMS core version: 3.1.0 - Estate Agency Edition
url:map~page=8
SELECT * FROM g_sitestructure WHERE seo_friendly_name COLLATE latin1_general_cs = 'map' AND archived = 0  AND domain_id = '1100'
SEO: Page found for map: map
PMS connection string found
Connected to pms3_abruzzoproperty
Page type:page
Public page
loading version: 43431
publish start date: 0000-00-00 00:00:00
publish end date: 0000-00-00 00:00:00
Content found for 43431 - id=51129
Loading breadcrumb from cache: bc43431
Loading module: pse3 / CombinedSearchResults / ||||results_map_only.tpl||||||||||||||1||1||||||||
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 id, branch_id, pid, date_added, multilet, external_vtour, internal_reference, category, development, property_type, property_for, published, property_status, isEnabled, unit, property_no, property_name, address1, address2, address3, county, country, area, area_name, postcode, price, annual_rent, price_qualifier, currency, rate, currency_symbol, dec_sep, thousand_sep, short_description, furnished, beds, bathrooms, receptions, land_size, features, status, field1, field2, field3, field4, field5, field6, longitude, latitude, os_reference, wgs84_longitude, wgs84_latitude, grid_northing, grid_easting, available_date, archived, search_index, living_space, student_let, student_let_rent, negotiator, built_year FROM pms_properties WHERE multilet = 0 AND property_for = '1' AND (price >= '0' AND price <= '99999999999') AND (beds >= 0 AND beds <= 9999) AND (land_size >= 0 AND land_size <= 999999999) AND (living_space >= 0 AND living_space <= 999999999) AND isEnabled = 1 AND archived = 0 AND published = 1 ORDER BY price ASC LIMIT 400, 50
paging mode: 2 Query: 
SELECT * FROM pms_properties WHERE id = 2968 AND isEnabled = 1 AND archived = 0 AND published = 1
SELECT * FROM pms_properties WHERE id = 3070 AND isEnabled = 1 AND archived = 0 AND published = 1
SELECT * FROM pms_properties WHERE id = 2790 AND isEnabled = 1 AND archived = 0 AND published = 1
SELECT * FROM pms_properties WHERE id = 3089 AND isEnabled = 1 AND archived = 0 AND published = 1
SELECT * FROM pms_properties WHERE id = 2597 AND isEnabled = 1 AND archived = 0 AND published = 1
SELECT * FROM pms_properties WHERE id = 2835 AND isEnabled = 1 AND archived = 0 AND published = 1
SELECT * FROM pms_properties WHERE id = 2805 AND isEnabled = 1 AND archived = 0 AND published = 1
SELECT * FROM g_configuration WHERE domain_id = '1100'
SELECT * FROM g_configuration WHERE domain_id = '1100'
Content filters are disabled
Loading module: feEditing / showInterface /
Loading module: pse3 / QuickSearch / ||||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
QuickSearch params: ||||2||
Quicksearch - For: 2
SELECT * FROM g_pse_conf WHERE domain_id = '1100'
SELECT * FROM g_pse_conf WHERE domain_id = '1100'
Loading module: feEditing / showInterface /
Page took 0.059 seconds to render
21 queries executed