347 4260726
email address
Via G. Carducci, 121 55045 Pietrasanta (LU)
Toggle navigation
Menu
Home
Sales
Rents
About Us
Contacts
Call us
Contact us
Search filter
Typology
Municipality
Hamlet
Locality
select distinct cod_localita, nome_loc from localita join immobili using (cod_localita) join tipi_gestione USING (cod_tipo_gestione) where (immobili.EN = '1') and (tipi_gestione.cod_macrotipo_gestione='1') order by nome_loc
Price
From 0 to 100.000
From 100.001 to 300.000
From 300.001 to 500.000
From 500.001 to 1.000.000
From 1.000.001 a 3.000.000
Over 3.000.000
Number of Rooms
1
2
3
4
5
6
7 or more
Number of bathrooms
1
2
3
4
5
6
7 or more
Occasions
SEARCH
We are sorry, but we do not have any properties in the archive with the required characteristics
Scroll Top