|
<%@ 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
Rental properties in Ballyheigue Ireland and home rentals in Ballyheigue Ireland
Renvyle Ireland houses for rent, Renvyle holiday rentals, and Renvyle Ireland rental home
Homes for rent by owner in Galway City Ireland, Galway City Ireland condo rentals, vacation rental Galway City, and short term rentals Galway City
For rent by owner homes and rent houses in Bantry Ireland
Ballydehob Ireland apartments for rent, rental apartment in Ballydehob, and houses for rent Ballydehob Ireland
Homes for rent, Birr real estate rentals, short term rentals in Birr Ireland, and Birr vacation homes
Doolin Ireland rent houses and Doolin vacation homes
Rent house in Kells, rent house in Kells Ireland, and vacation rentals in Kells
Sneem condos for rent, Sneem house rentals, holiday rentals Sneem, and rental properties Sneem
House rentals Bantry Ireland and rental homes in Bantry
House rentals in Doolin Ireland, homes for rent in Doolin Ireland, and for rent by owner homes in Doolin Ireland
Rental homes in Enniscrone Ireland, vacation rentals, Enniscrone Ireland short term rentals, and bed and breakfast rentals in Enniscrone Ireland
Condo rentals Rosslare and homes for rent by owner in Rosslare Ireland
Birr Ireland vacation rental, rental apartment Birr, and Birr Ireland condo rentals
Mount Nugent rent houses, rental home in Mount Nugent Ireland, condos for rent in Mount Nugent, and rent houses Mount Nugent
Join our hidden classified ads, exclusive online MLS, loft advertisements, and beach listings mailing list for Kenmare Ireland real estate rentals and vacation homes Kenmare Ireland.
Perceive and look up Bangor Ireland condo rentals and rental homes.
Disclose and glimpse Kilkenny Ireland condos for rent and bed and breakfast rentals Kilkenny Ireland.
Conceive, locate, and come upon rental apartment in Leixlip, vacation homes for rent by owner in Leixlip Ireland, and apartments for rent.
Elicit and learn New Ross home rentals and rental homes New Ross.
Learn and discern short term rentals in Castlebar Ireland and rent houses in Castlebar.
Identify and contrive homes for rent by owner and condo rentals Ennis Ireland.
Send angelic, appealing, bewitching, and nice info regarding rental apartment in Kenmare Ireland and Kenmare Ireland houses for rent found on our site, FRBO.com.
Come across, identify, and identify vacation rentals in Westport Ireland, rental properties in Westport Ireland, and vacation rental in Westport Ireland.
Kenmare Ireland is a bewitching, dazzling, nice, and statuesque principality with beauteous, bewitching, and angelic villa, vacation home, bungalow, and townhouses.
Kenmare landlords, town home owners, brokers leasing foreclosures, and landlords list for rent by owner homes in Kenmare Ireland and rental apartment in Kenmare.
Deadheads and entrepreneurs who are wishing to observe, look up, and observe or simply conceive information can use this webpage.
Explore, relocate, and come upon Waterford Ireland condo rentals, apartment rentals in Waterford Ireland, and vacation homes for rent by owner Waterford.
You can look the rustic classified ads, beach classified advertisements, and romantic indexes under holiday rentals Kenmare and homes for rent by owner in Kenmare Ireland.
|
|
