|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Ireland Rental Links
Vacation homes for rent by owner in Inverin and Inverin Ireland house rentals
Rental houses in Clifden, apartment rentals in Clifden Ireland, and holiday rentals in Clifden Ireland
Rental homes in Thomastown Ireland, bed and breakfast rentals Thomastown Ireland, Thomastown rental houses, and short term rentals Thomastown
Homes for rent and rent house in Ardgroom Ireland
Rental home in Thomastown Ireland, houses for rent in Thomastown Ireland, and homes for rent
Vacation rental in Gort Ireland, vacation rentals, rental properties, and Gort Ireland home rentals
Rent house in Liscannor Ireland and bed and breakfast rentals
Mount Nugent condo rentals, vacation rentals in Mount Nugent Ireland, and homes for rent by owner in Mount Nugent Ireland
Condo rentals in Riverstown, rental home Riverstown Ireland, rent houses Riverstown Ireland, and apartments for rent Riverstown Ireland
Birr Ireland apartments for rent and holiday rentals in Birr
Ventry Ireland vacation rentals, bed and breakfast rentals in Ventry Ireland, and homes for rent by owner Ventry Ireland
Moycullen Ireland rental houses, Moycullen Ireland real estate rentals, homes for rent in Moycullen Ireland, and Moycullen Ireland for rent by owner homes
Laytown Ireland vacation homes for rent by owner and short term rentals
Rental homes Dunmore East Ireland, rental properties, and Dunmore East Ireland real estate rentals
Vacation rentals in Castlebar, Castlebar Ireland condos for rent, rental houses in Castlebar Ireland, and Castlebar Ireland rent house
Rental apartment in Lahinch Ireland and bed and breakfast rentals in Lahinch Ireland
Homes for rent, Ennis rental home, and holiday rentals Ennis
Condos for rent in Liscannor Ireland, bed and breakfast rentals in Liscannor Ireland, Liscannor Ireland vacation rentals, and apartment rentals in Liscannor Ireland
Vacation homes for rent by owner Lahinch Ireland and condos for rent in Lahinch Ireland
Rental houses in Sneem Ireland, homes for rent in Sneem Ireland, and Sneem holiday rentals
You can look over the waterfront advertisements, well appointed ads, waterfront listings, and secluded listed properties under bed and breakfast rentals in Sneem, rental properties in Sneem Ireland, and holiday rentals.
Contrive and ferret out rent house in Sligo Ireland and Sligo Ireland home rentals.
Determine, identify, and elicit Bantry Ireland condos for rent, condo rentals Bantry, and homes for rent.
Find out, ascertain, and identify condo rentals in Dublin, homes for rent by owner in Dublin Ireland, and apartment rentals Dublin Ireland.
Identify and ferret out Tallaght Ireland for rent by owner homes and condo rentals.
Look up, design, and conceive Bangor Ireland rent house, rental homes Bangor Ireland, and Bangor rental houses.
Discover and observe Killarney home rentals and homes for rent.
We fabricated, devised, and composed this webpage to be statuesque, angelic, sightly, and taking.
You can observe and dig up vacation rentals in Sneem Ireland, vacation homes for rent by owner Sneem, and rental apartment in Sneem Ireland.
Locate and ascertain rent houses in Tallaght Ireland and rent house in Tallaght.
Come across, notice, and conceive homes for rent, vacation rental in Leixlip Ireland, and homes for rent in Leixlip Ireland.
The Sneem Ireland mountain classified ads, exclusive directories, and ski in/out classified advertisements for these can be mapped.
Available decadent townhouse, convenient cabin, beach ranch, and convenient ranch are adjoining in the impending neighborhood of Sneem Ireland.
Deadheads and bedmates hunt and look over For Rent By Owner and look up secluded bungalow and city farmhouse.
Sneem Ireland is a sublime and pulchritudinous precinct with handsome and elegant condominium and haciendas.
Ascertain strange and other measurements in Sneem Ireland and run down Sneem Ireland apartments for rent.
Volunteer, enter, inscribe, and enroll next weekend to get going and open on this round.
Send exquisite, radiant, exquisite, and excellent evidence regarding rental properties in Sneem Ireland, real estate rentals in Sneem, and house rentals in Sneem found on FRBO.com.
|
|
