Property Listing.................<%response.write(catlbl)%>.Renovated Village and Town houses                 

              



 

<% Select Case GS Case 1 If areaid=0 and categoryid=0 then sqlG= "SELECT * FROM Properties WHERE LnkLanguageID=2" elseif areaid<>0 and categoryid=0 then sqlG= "SELECT * FROM Properties WHERE LnkLanguageID=2 AND LnkZoneid= " & areaid elseif areaid<>0 and categoryid<>0 then sqlG= "SELECT * FROM Properties WHERE LnkLanguageID=2 AND LnkZoneid= " & areaid & " AND LnkCategoryid= " & categoryid elseif areaid=0 and categoryid<>0 then sqlG= "SELECT * FROM Properties WHERE LnkLanguageID=2 AND LnkCategoryid= " & categoryid else end if Select Case pricelimit Case 1 sqlG=sqlG & " AND Price between 0 and 20000" Case 2 sqlG=sqlG & " AND Price between 20001 and 40000" Case 3 sqlG=sqlG & " AND Price between 40001 and 90000" Case 4 sqlG=sqlG & " AND Price between 90001 and 170000" Case 5 sqlG=sqlG & " AND Price between 170001 and 500000" Case 6 sqlG=sqlG & " AND Price > 500000" Case else End Select sqlG=sqlG & " ORDER BY Field1Value ASC" RSprop.Open sqlG Case else sqlP= "SELECT * FROM Properties WHERE LnkLanguageID=2 and lnkcategoryid= " & categoryid & " ORDER BY Field1Value ASC" RSprop.Open sqlP End Select reccout=0 if not RSprop.eof then While not rsprop.eof reccount=reccount+1 %> <% lastCategory=RSprop("LnkCategoryID") RSProp.movenext Wend end if RSProp.close %> Criteria: pricelimit: <% response.write(pricelimit)%>, areaid:<% response.write(areaid)%>, categoryid: <% response.write(categoryid)%>, Nr. of records:<%response.write(reccount)%>

Property ID

Description

Photos/Detail
<%=RSprop("PropertyCode")%>
Giannades
 <%=formatnumber(RSprop( "price"),0)%> € 110,000		 A pretty, cottage style, traditional house on the edge of village. Built in the early 50's from local stone and rendered. This little house offers approx. 70 sq m of living space and now, through our addition of a balcony to the front of the property, views across the Ropa valley. On the lower floor we have constructed two bedroom, the front room having access to the property's small garden. A new bathroom has also been created in what was the storage area to the right of the property. On the upper level we have created a kitchen/diner (with staircase to the lower level) to the rear of the property. In the front we have made a large salon with two doors opening onto the sunny patio.<%=RSprop("Field1Value")%><%=RSprop("PropertyShortDes")%> Photos/details
<%=RSprop("PropertyCode")%>
Agrafi - 'Major's House'
 <%=formatnumber(RSprop( "price"),0)%> € 160,000		 Village centre house with the benefit of its own garden, parking area and annex. The main property is on two floors with approx. 90 sq m of living space. On the lower level we have created a large kitchen/diner and separate living room which opens onto a pathway to the garden. The upper level (accessed via a new spiral staircase) offers two double bedrooms and a bathroom. The garden overlooks a wooded valley with views to the mountains beyond. It has a number of mature fruit trees including lemons and oranges. The property also has an adjoining single story annex that we have converted into a 20 sq m studio with its own shower room and WC. Construction is of traditional stone with exposed beams and many traditional features.<%=RSprop("Field1Value")%><%=RSprop("PropertyShortDes")%> Photos/details
<%=RSprop("PropertyCode")%>
Magoulades - 'Stone Barn'
 <%=formatnumber(RSprop( "price"),0)%> € 160,000		 Almost the last property to be renovated in the village. A large single storey stone barn, with patio area and garage. This house offers approx. 70 sq m of living space and spectacular views from its large patio to the front of the property. We have excavated the land to the front of the property and created a garage area beneath the patio which is entered from the main village road. Inside, we have constructed a new mezzanine floor over a new bathroom and bedroom. The mezzanine keeps the space open to the lovely timber beamed roof whilst offering a further 20 sq m space for a second bedroom or office. Beneath we have made a large salon/diner and L-shaped kitchen space.<%=RSprop("Field1Value")%><%=RSprop("PropertyShortDes")%> Photos/details
<%=RSprop("PropertyCode")%>
Agios Matheos - 'Tassias' House'
 <%=formatnumber(RSprop( "price"),0)%> € 99,000		 Village centre town house on two floors with approx. 100 sq m living space. Construction is rendered stone and brick. Large (11 sq m) balcony with views across town to valley and mountains beyond. The ground floor has been converted into a huge (36.5 sq m) open plan, kitchen/living room . The upper floor has been divided into two double bedrooms (one with access onto the balcony) a large bathroom and store. The property is in a quiet side street (nearest parking in church square, 70m away) and within 2 minutes walk of shops. Photos/details
<%=RSprop("PropertyCode")%>
Gardelades
 € 150,000		 Village centre town house with approx. 90 sq m living space. Construction is rendered stone and brick. The property consists of one two storey and one single storey building. We have constructed a roof terrace over the single storey unit. The ground floor has two double bedrooms, the kitchen and bathroom. The upper floor has a living room, study (or third bedroom) and access to the roof terrace. Parking is within 15m of the property which is suited behind the main square of this popular village. Photos/details