Quick Search


Search results: 410 properties.


...

Teramo, Teramo, TE64100

€349,000 PCMFor sale

LARGE, COUNTRY HOUSE in a WONDERFUL POSITION with UNINTERRUPTED VIEWS to the GRAN SASSO MASSIF. The property has an ABOVE GROUND SWIMMING POOL, with a LOVELY PANORAMA, and it CURRENTLY OPERATES as a HIGHLY RATED B&B. The HOUSE is CLOSE to TERAMO CITY with all FACILITIES.

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


...

Pescara, Abbateggio, PE65020

€350,000 PCMFor sale

LARGE, COUNTRY HOUSE with a BEAUTIFUL, STONE EXTERIOR which NEEDS RESTORATION/UPDATING. It has SEVEN HECTARES of LAND and OFFERS STUNNING VIEWS. A great OPPORTUNITY to create a SUBSTANTIAL, HOME which is TAILORED to the NEEDS and DESIGN of the NEW OWNERS.

Studio x 0 x 0 x {PARKING} x x 250.00SQM


...

Teramo, Nereto, TE64015

€360,000 PCMFor sale

LARGE VILLA which is DIVIDED into TWO SEPARATE UNITS. It is in the TOWN of NERETO and has been COMPLETELY RESTORED. There are SIX BEDROOMS and FOUR BATHROOMS in TOTAL. The property BENEFITS from a PANORAMIC TERRACE, GARDEN, STORAGE and FRUIT TREES.

6 x 4 x 2 x {PARKING} x Yes x 350.00SQM


...

Chieti, San Vito Chietino, CH66038

€365,000 PCMFor sale

BEAUTIFUL, COUNTRY HOUSE with SWIMMING POOL surrounded by an ORCHARD. It is a FEW MINUTES from the TOWN of SAN VITO CHIETINO and the TRABOCCHI COAST. The property has THREE BEDROOMS and there are PLENTY of TRADITIONAL FEATURES to ENJOY.

3 x 2 x 0 x {PARKING} x Yes x 0.00SQM


...

Pescara, Spoltore, PE65010

€375,000 PCMFor sale

THREE BEDOOM, DETACHED VILLA in the BEAUTIFUL COUNTRYSIDE near the TOWN of SPOLTORE. The house is CLOSE to the AIRPORT and ADRIATIC COAST. It is IMMEDIATELY HABITABLE, HAS a GARDEN, AGRICULTURAL LAND, GARAGE and PANORAMIC VIEWS. EXCELLENT FINISH, MUST BE VIEWED.

5 x 2 x 1 x {PARKING} x Yes x 210.00SQM


...

Chieti, Torino di Sangro, CH66020

€380,000 PCMFor sale

LARGE PROPERTY DIVIDED into APARTMENTS within WALKING DISTANCE of the BEACH at TORINO DI SANGRO. There is a GARDEN with the POSSIBILITIES of BUILDING an EXTENSION and SWIMMING POOL. GREAT TOURISM OPPORTUNITIES.

7 x 3 x 0 x {PARKING} x Yes x 420.00SQM


...

Teramo, Castelli, TE64041

€380,000 PCMFor sale

MODERN, THREE BEDROOM, DETACHED VILLA with a BEAUTIFUL PANORAMIC GARDEN and SWIMMING POOL. The VIEWS of the MOUNTAINS are STUNNING and the GARDEN even has a VINEYARD. In a TRANQUIL POSITION, ENJOY an APERITIVO or LUNCH by the POOL. MUST VIEW - AN AMAZING HOME.

3 x 3 x 1 x {PARKING} x x 230.00SQM


...

L'Aquila, Bugnara, AQ67030

€380,000 PCMFor sale

VILLA in the PICTURESQUE VILLAGE of BUGNARA. It CURRENTLY COMPRISES SIX BEDROOMS, FOUR BATHROOMS, TWO KITCHENS and TWO LIVING ROOMS. With a LITTLE RENOVATION the property can be USED as a SINGLE HOME, alternatively it would be PERFECT as a B&B or RENTAL ACCOMMODATION.

6 x 4 x 2 x {PARKING} x Yes x 280.00SQM


...

Chieti, Tollo, CH66010

€390,000 PCMFor sale

BEAUTIFUL VILLA with SEPARATE APARTMENT and LARGE GARDEN only a SHORT DRIVE from the ADRIATIC SEA. The property is ENERGY EFFICIENT and OUTSIDE there are OLIVE and FRUIT TREES together with ORNAMENTAL PLANTS. IMMEDIATELY HABITABLE, the property is PERFECT for LOVERS of the COAST.

4 x 3 x 2 x {PARKING} x Yes x 250.00SQM


...

Pescara, Moscufo, PE65010

€390,000 PCMFor sale

VILLA DIVIDED into FOUR SEPARATE UNITS with INDEPENDENT ENTRANCES in the VILLAGE of MOSCUFO. The property BENEFITS from a GARDEN, OLIVE GROVE, WRAP-AROUND BALCONY and LOVELY VIEWS. With some INVESTMENT the villa would CREATE FOUR APARTMENTS, a PERFECT RENTAL OPPORTUNITY.

3 x 6 x 0 x {PARKING} x Yes x 400.00SQM


...

Pescara, Moscufo, PE65010

€390,000 PCMFor sale

THREE BEDROOM, VILLA near the TOWN of MOSCUFO. There is some LAND cultivated with OLIVE TREES, SHADY PARKING and LOVELY VIEWS. The property is BUILT to LOW ENERGY CONSUMPTION STANDARDS. There is the POSSIBILITY to PURCHASE an ADDITIONAL ONE HECTARE of LAND.

3 x 3 x 1 x {PARKING} x Yes x 230.00SQM


...

Teramo, Colledara, TE64042

€390,000 PCMFor sale

STUNNING, THREE BEDROOM VILLA near COLLEDARA. It has a LITTLE LAND with the POSSIBILITY to PURCHASE 6 HECTARES MORE.

3 x 3 x 1 x {PARKING} x Yes x 337.00SQM


...

Chieti, Tollo, CH66010

€390,000 PCMFor sale

LARGE, FIVE BEDROOM, VILLA in the TOWN of TOLLO. It is CLOSE to the COAST and the MIGLIANICO GOLF CLUB and ABOUT THIRTY MINUTES from the MOUNTAINS. The property has a TERRACE. PERFECT HOUSE for a LARGE FAMILY or B&B.

5 x 6 x 0 x {PARKING} x Yes x 300.00SQM


...

Teramo, Castiglione Messer Raimondo, TE64034

€395,000 PCMFor sale

SIX BEDROOM VILLA near CASTIGLIONE MESSER RAIMONDO. It has a GARAGE, BALCONIES and BEAUTIFUL GARDEN. LARGE VILLA for ENTERTAINING with a FABULOUS TAVERNA or there is even the POSSIBILITY to CREATE a B&B.

6 x 6 x 3 x {PARKING} x Yes x 525.00SQM


...

Pescara, Citta Sant'Angelo, PE65013

€395,000 PCMFor sale

LARGE SEVEN BEDROOM VILLA near the TOWN of CITTÀ SANT’ANGELO with all its FACILITIES. It comes with BALCONIES, ENCLOSED GARDEN, GARAGE and LOVELY VIEWS. An IDEAL INVESTMENT OPPORTUNITY.

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


...

Pescara, Loreto Aprutino, PE65014

€397,000 PCMFor sale

LARGE VILLA with FOUR/FIVE BEDROOMS divided into TWO APARTMENTS on the EDGE of LORETO APRUTINO. It COMES with GARDEN, GARAGE and MOUNTAIN VIEWS. POSSIBILITY for TOURIST RENTAL.

4 x 3 x 2 x {PARKING} x Yes x 350.00SQM


...

Chieti, Chieti, CH66100

€398,000 PCMFor sale

FOUR BEDROOM VILLA near the CITY of CHIETI. It is FINISHED to a HIGH STANDARD and is CURRENTLY DIVIDED into TWO PROPERTIES although EASY to make into ONE. The PROPERTY has a TAVERN, MOUNTAIN VIEWS, GARAGE, FIREPLACE, LAND, TERRACE and BALCONY.

4 x 3 x 0 x {PARKING} x Yes x 600.00SQM


...

Pescara, Citta Sant'Angelo, PE65013

€399,000 PCMFor sale

FOUR BEDROOM COUNTRY VILLA in the DELIGHTFUL TOWN of CITTÀ SANT’ANGELO. It is BUILT in CONTEMPORARY STYLE and is IMMEDIATELY HABITABLE. The property COMES with a GARAGE, VIEWS and BALCONY. RARE OPPORTUNITY.

4 x 2 x 0 x {PARKING} x Yes x 320.00SQM


...

Pescara, Penne, PE65017

€400,000 PCMFor sale

LARGE COUNTRY HOUSE with FOUR BEDROOMS, close to the HISTORIC TOWN of PENNE. It BENEFITS from a LARGE PLOT of LAND with ARABLE CROPS, OLIVE GROVE and WOODLAND. The house has BEAUTIFUL TRADITIONAL FEATURES. EXCELLENT POTENTIAL for FARM ACTIVITIES.

4 x 2 x 1 x {PARKING} x Yes x 450.00SQM


...

Pescara, Caramanico Terme, PE65013

€400,000 PCMFor sale

NOBLE PALACE with PRIVATE CHAPEL in the TOWN of CARAMANICO TERME. It is IMMEDIATELY HABITABLE and has AMAZING VIEWS. With SOME MAINTENANCE WORK it could be USED as a B&B or LOCATION for PRVATE PARTIES, WEDDINGS ETC. VIEWING REQUIRED to APPRECIATE the BEAUTY of this POROPERTY.

9 x 3 x 0 x {PARKING} x Yes x 900.00SQM


...

Pescara, Cugnoli, PE65020

€410,000 PCMFor sale

BEAUTIFUL THREE/FOUR BEDROOM, DETACHED HOUSE near the PRETTY TOWN of CUGNOLI. Recently RESTORED it has LOVELY GARDENS, LAND, OUTBUILDING, VIEWS, TERRACES and PARKING. During the RENOVATION PROCESS, MANY FEATURES were MAINTAINED and ENHANCED.

4 x 3 x 3 x {PARKING} x Yes x 250.00SQM


...

Campobasso, Castelmauro, CB86031

€420,000 PCMFor sale

LARGE PROPERTY which COMPRISES approximately 65 HECTARES of LAND and TWO LARGE, STONE HOUSES for RESTORATION. It is LOCATED in a GOOD POSITION with LOVELY VIEWS. An INTERESTING PROJECT.

6 x 0 x 0 x {PARKING} x Yes x 500.00SQM


...

Pescara, Abbateggio, PE65020

€425,000 PCMFor sale

B&B ideally located MIDWAY between AIRPORT, SKI RESORTS and ADRIATIC COAST. It includes a FOUR BEDROOM VILLA and attractive STONE HOUSE with TWO BEDROOMS, used for GUEST ACCOMMODATION. There is a SWIMMING POOL, COURTYARD and OLIVE GROVE. GOOD BUSINESS OPPORTUNITY.

6 x 5 x 0 x {PARKING} x Yes x 400.00SQM


...

Teramo, Atri, TE64032

€450,000 PCMFor sale

CHARACTERISTIC, PROPERTY within a PALACE. It is in the BEAUTIFUL CENTRE of the HISTORICAL and much SOUGHT AFTER TOWN of ATRI. The house MAINTAINS many INTERESTING FEATURES and its position BENEFITS from LOCAL SHOPS, RESTAURANTS, BARS and ANCIENT TREASURES. VIEWING is RECOMMENDED.

3 x 4 x 1 x {PARKING} x Yes x 320.00SQM


...

Pescara, Penne, PE65017

€450,000 PCMFor sale

OLD PALACE with EIGHT BEDROOMS in the HISTORICAL HEART of PENNE. It is CURRENTLY DIVIDED into THREE UNITS which can be USED as an INVESTMENT OPPORTUNITY but AFTER RENOVATION would make a WONDERFUL BOUTIQUE HOTEL.

8 x 8 x 0 x {PARKING} x Yes x 951.00SQM


...

Pescara, Collecorvino, PE65010

€450,000 PCMFor sale

MODERN, FOUR BEDROOM VILLA near the TOWN of COLLECORVINO. The property is IMMEDIATELY HABITABLE and HAS a LARGE GARDEN with BBQ. There is an UNDERGROUND GARAGE, and from the REAR, the VILLA overlooks MANY OLIVE TREES. CONTEMPORARY STYLE. VIEWING ESSENTIAL.

4 x 4 x 1 x {PARKING} x Yes x 470.00SQM


...

Pescara, Citta Sant'Angelo, PE65013

€450,000 PCMFor sale

SIX BEDROM VILLA with FANTASTIC VIEWS CLOSE to CITTA SANT'ANGELO. The HOUSE is DIVIDED into TWO IDENTICAL UNITS. EACH has a DRIVEWAY LEADING to its OWN GARAGE. The properties HAVE ACCESS to a SWIMMING POOL, EN-SUITE BATHROOMS and TERRACES.

6 x 7 x 0 x {PARKING} x Yes x 369.00SQM


...

Chieti, Casalbordino, CH66021

€450,000 PCMFor sale

BEAUTIFUL, THREE BEDROOM, DETACHED VILLA with SEA VIEW, OUTBUILDINGS and LAND. This wonderful property is JUST 15 MINS from the FAMOUS TRABOCCHI COAST. It has been METICULOUSLY RESTORED with ATTENTION to ENVIRONMENTAL DETAILS. The THREE BEDROOMS all have EN-SUITE BATHROOMS, with VIEWS.

3 x 3 x 1 x {PARKING} x Yes x 229.00SQM


...

Teramo, Tortoreto, TE64018

€460,000 PCMFor sale

RENOVATED, THREE BEDROOM, APARTMENT in the RESORT TOWN of TORTORETO. It is WITHIN WALKING DISTANCE of the BEACH and FACILITIES. The RENOVATION is MAGNIFICENT as it INCLUDES all MOD CONS. The property BENEFITS from SEA VIEWS and a LARGE TERRACE for OUTDOOR DINING and RELAXATION.

3 x 2 x 2 x {PARKING} x No x 180.00SQM


...

Cheiti, Ortona, CH66026

€460,000 PCMFor sale

WONDERFUL, THREE BEDROOM, VILLA with SEA VIEWS and CLOSE to the COAST near ORTONA. The property has an OLIVE GROVE, FRUIT TREES, CELLAR, TERRACE and there is the POSSIBILITY to INSTALL a SWIMMING POOL. The VILLA is PERFECT for a FAMILY.

3 x 2 x 0 x {PARKING} x Yes x 220.00SQM


...

Pescara, Spoltore, PE65010

€485,000 PCMFor sale

DIVIDED INTO TWO APARTMENTS, with FIVE BEDROOMS, this DETACHED HOUSE has a GARDEN and SWIMMING POOL. It has FANTASTIC MOUNTAIN VIEWS and POTENTIAL for an EXTRA APARTMENT. The SURROUNDING LAND is WELL-KEPT. IDEAL as a RESIDENTIAL HOME or a RENTAL PROPERTY.

5 x 6 x 0 x {PARKING} x Yes x 307.00SQM


...

Chieti, Atessa, CH66041

€485,000 PCMFor sale

THREE BEDROOM, VILLA in the HISTORIC TOWN of ATESSA. This BEAUTIFUL property has DOUBLE GARAGE, BALCONY and SWIMMING POOL. There are TWO ADDITIONAL ROOMS in the LOFT .

3 x 2 x 1 x {PARKING} x Yes x 280.00SQM


...

Teramo, Bellante, TE64020

€490,000 PCMFor sale

DETACHED PROPERTY with ANNEXE in BELLANTE. The main HOUSE has THREE BEDROOMS, VAULTED CEILING and FIREPLACES. The OUTBUILDING has another DOUBLE BEDROOM, BATHROOM and KITCHEN / DINER. The ENTIRE PROPERTY has OLIVE GROVES, PARKLAND and LOVELY VIEWS.

4 x 4 x 1 x {PARKING} x Yes x 341.00SQM


...

Teramo, Frondarola, TE64100

€495,000 PCMFor sale

NINE BEDROOM HOUSE in the heart of FRONDAROLA VILLAGE. It has a SMALL GARDEN, adjacent PUBLIC PARKING, MOUNTAIN VIEWS and is in GOOD CONDITION. The property comes FULLY FURNISHED and would provide an ideal BED & BREAKFAST or RENTAL OPPORTUNITY. It COMPLIES to ANTI-SEISMIC REGULATIONS.

9 x 4 x 2 x {PARKING} x No x 0.00SQM


...

Pescara, Penne, PE65017

€495,000 PCMFor sale

BEAUTIFUL, SIX BEDROOM, RESTORED, FARMHOUSE close to the HISTORIC TOWN of PENNE. THREE of the BEDROOMS have EN-SUITE BATHROOMS. This AMAZING PROPERTY has WONDERFUL VIEWS, SWIMMING POOL, OLIVE TREES, ANNEX, PHOTOVOLTAIC SYSTEM and GARDEN. RECOMMENDED.

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


...

Teramo, Pineto, TE64025

€510,000 PCMFor sale

HALF WAY between the RESORT TOWN of PINETO and the HISTORIC TOWN of ATRI is this FOUR BEDROOM VILLA with a FANTASTIC VIEW of both MOUNTAINS and SEA. The property has PLENTY of LAND and is within WALKING DISTANCE of the VILLAGE of MUTIGNANO. The POSITION is AMAZING and VIEWING IS RECOMMENDED.

4 x 3 x 1 x {PARKING} x Yes x 306.00SQM


...

Teramo, Atri, TE64032

€520,000 PCMFor sale

STUNNING, FIVE BEDROOM, COUNTRY HOUSE near the HISTORIC TOWN of ATRI. The property has been COMPLETED to a VERY HIGH STANDARD and BENEFITS from GARAGES, PARKING, TERRACE, LAND and BEAUTIFUL PANORAMAS. The HOUSE is INEXPENSIVE to RUN and VIEWING IS STRONGLY RECOMMENDED.

5 x 3 x 2 x {PARKING} x Yes x 240.00SQM


...

Teramo, Tortoreto, TE64018

€530,000 PCMFor sale

BEAUTIFUL, FOUR BEDROOM, VILLA near the TOWN of TORTORETO. The property has a GARDEN, GARAGE and PANORAMIC TERRACE. There is the POSSIBILITY of INSTALLING a SWIMMING POOL.

4 x 3 x 1 x {PARKING} x Yes x 432.00SQM


...

Termao, Notaresco, TE64024

€540,000 PCMFor sale

LARGE, NINE BEDROOM, COUNTRY HOUSE near the HILLTOP TOWN of NOTARESCO. It BENEFITS from a TERRACE and AGRICULTURAL LAND which is CULTIVATED with OLIVE TREES and MONTEPULCIANO VINEYARDS. CLOSE to the ADRIATIC COAST.

9 x 8 x 1 x {PARKING} x Yes x 330.00SQM


...

Pescara, Civitaquana, PE65010

€560,000 PCMFor sale

BEAUTIFUL COUNTRY HOUSE operating as a B&B. It has TEN BEDROOMS and is IMMEDIATELY HABITABLE . The property comes with GARDEN and VIEWS. GOOD PRICE and INVESTMENT OPPORTUNITY.

10 x 10 x 0 x {PARKING} x Yes x 500.00SQM


...

Pescara, Citta Sant'Angelo, PE65013

€560,000 PCMFor sale

LARGE, EIGHT BEDROOM, VILLA in the WONDERFUL TOWN of CITTÀ SANT'ANGELO. The property has PANORAMIC VIEWS, TERRACE and 1,000 SQ. MTS of GARDEN. There is ENOUGH SPACE for a SWIMMING POOL. VIEWING is a MUST.

8 x 6 x 2 x {PARKING} x Yes x 600.00SQM


...

Pescara, Loreto Aprutino, PE65014

€580,000 PCMFor sale

THREE BEDROOM, VILLA in the HISTORIC TOWN of LORETO APRUTINO. The VILLA has a VIEW of the FAMOUS CASTELLO CIOLA although it is POSSIBLE to IMMERSE oneself in the NATURALNESS of the LARGE GARDEN accentuated by OLIVE TREES. With PLANNING PERMISSION there is the OPPORTUNITY to INSTALL a SWIMMING POOL.

3 x 4 x 2 x {PARKING} x Yes x 300.00SQM


...

Pescara, Manoppello, PE65024

€620,000 PCMFor sale

DETACHED COUNTRY HOUSE CLOSE to the TOWN of MANOPPELLO. It has SIX BEDROOMS, SWIMMING POOL and VIEWS. Some COSMETIC WORK is REQUIRED but the property would be an IDEAL FAMILY HOME or a PRETTY BED & BREAKFAST.

6 x 4 x 1 x {PARKING} x Yes x 480.00SQM


...

Teramo, Morro d Oro, TE64020

€630,000 PCMFor sale

RENOVATED, WONDERFUL, FARMHOUSE LOCATED in the GENTLE HILLS of MORRO D'ORO. It BENEFITS from LAND, SWIMMING POOL and LOVELY VIEWS. PERFECT INVESTMENT / BUSINESS OPPORTUNITY with TEN BEDROOMS.

10 x 13 x 0 x {PARKING} x Yes x 500.00SQM


...

Cuneo, Alba, CN12050

€630,000 PCMFor sale

FOUR BEDROOM, FARMHOUSE near CASTINO. It is PRIVATE but not ISOLATED and LESS than 2 KMS from the VILLAGE of CASTINO and 30 MINUTES from the TOWN of ALBA which is RENOWNED for GASTRONOMY, WHITE TRUFFLES and FERERRO. It comes with FLAT LAND, ideal for INSTALLING a POOL, 1000 HAZELNUT TREES and VIEWS.

4 x 2 x 1 x {PARKING} x Yes x 300.00SQM


...

Teramo, Morro d Oro, TE64020

€630,000 PCMFor sale

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.

10 x 8 x 0 x {PARKING} x Yes x 500.00SQM


...

Pescara, Montesilvano, PE65015

€650,000 PCMFor sale

PRESTIGIOUS, FOUR BEDROOM, VILLA located in MONTESILVANO. The property has a GARDEN, BALCONIES, TERRACE and BARBECUE, ideal for AL FRESCO DINING. There are BREATHTAKING SEA VIEWS. The LIVELY ADRIATIC RESORT of MONTESILVANO is CLOSEBY.

4 x 4 x 2 x {PARKING} x Yes x 600.00SQM


...

Pescara, Loreto Aprutino, PE65014

€650,000 PCMFor sale

BED & BREAKFEST in the BEAUTIFUL VALLEY near the HISTORIC TOWN of LORETO APRUTINO. It has 10 ROOMS with BATHROOMS - 21 BEDS, RESTAURANT, SPORTS CENTRE with POOL, STABLES, OLIVE TREES, LAKE and is only TWO KMS from the TOWN.

10 x 10 x 1 x {PARKING} x Yes x 1000.00SQM


...

Chieti, Miglianico, CH66010

€695,000 PCMFor sale

BEAUTIFUL, THREE BEDROOM VILLA in MIGLIANICO GOLF COUNTRY CLUB. In an ENCHANTING POSITION, the property is UNIQUE and MUST BE VIEWED. It BENEFITS from PRIVATE SWIMMING POOL, TERRACES and MANY ECO FUNCTIONS including HEAT PUMP and PHOTOVOLTAIC SYSTEM. PERFECT HOME for GOLFERS - RARE OPPORTUNITY.

3 x 4 x 1 x {PARKING} x Yes x 0.00SQM


...

Pescara, Montesilvano, PE65015

€700,000 PCMFor sale

LARGE, FIVE BEDROOM VILLA close to all the COASTAL RESORT ATTRACTIONS of MONTESILVANO. BUILT to a HIGH SPECIFICATION the property BENEFITS from TWO ENSUITE BATHROOMS, THREE GARAGES, SEA VIEW, TERRACE and MEDITERRANEAN GARDEN. There is space to INSTALL a SWIMMING POOL. Only 20 MINUTES to the AIRPORT.

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


Showing page 8 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=7
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 350, 50
paging mode: 2 Query:
SELECT * FROM pms_properties WHERE id = 2829 AND isEnabled = 1 AND archived = 0 AND published = 1

SELECT * FROM pms_properties WHERE id = 2306 AND isEnabled = 1 AND archived = 0 AND published = 1

SELECT * FROM pms_properties WHERE id = 2857 AND isEnabled = 1 AND archived = 0 AND published = 1

SELECT * FROM pms_properties WHERE id = 3055 AND isEnabled = 1 AND archived = 0 AND published = 1

SELECT * FROM pms_properties WHERE id = 2701 AND isEnabled = 1 AND archived = 0 AND published = 1

SELECT * FROM pms_properties WHERE id = 3081 AND isEnabled = 1 AND archived = 0 AND published = 1

SELECT * FROM pms_properties WHERE id = 3041 AND isEnabled = 1 AND archived = 0 AND published = 1

SELECT * FROM pms_properties WHERE id = 2770 AND isEnabled = 1 AND archived = 0 AND published = 1

SELECT * FROM pms_properties WHERE id = 3138 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.111 seconds to render
64 queries executed