|
<%@ 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
Fanore Ireland apartments for rent and Fanore homes for rent by owner
Vacation homes Bruree Ireland, Bruree rental home, and Bruree Ireland houses for rent
Vacation rental in Birr, Birr bed and breakfast rentals, Birr Ireland apartment rentals, and bed and breakfast rentals in Birr
Vacation rental in Ventry Ireland and short term rentals Ventry Ireland
Kilkerrin Ireland homes for rent, vacation homes in Kilkerrin Ireland, and for rent by owner homes in Kilkerrin Ireland
Home rentals Killarney Ireland, Killarney Ireland rental apartment, vacation rental Killarney, and rental home
Apartments for rent Enniscrone Ireland and apartments for rent in Enniscrone Ireland
Real estate rentals in Mullingar Ireland, Mullingar Ireland apartments for rent, and homes for rent by owner Mullingar Ireland
Holiday rentals in O Callaghans Mills, O Callaghans Mills Ireland rental home, apartment rentals in O Callaghans Mills, and holiday rentals
Rent houses and rental apartment Bruree
Rental apartment in Liscannor, Liscannor Ireland holiday rentals, and Liscannor Ireland home rentals
Homes for rent in Gort Ireland, short term rentals in Gort, vacation rentals in Gort Ireland, and apartments for rent Gort
Vacation homes Riverstown Ireland and Riverstown Ireland short term rentals
Holiday rentals Inverin, Inverin holiday rentals, and rent houses Inverin
Liscannor Ireland condo rentals, homes for rent by owner, rental properties Liscannor Ireland, and for rent by owner homes in Liscannor Ireland
Durrus homes for rent by owner and vacation rentals
Renters, tourists, and better halves prospect, hunt, and look for our online website, FRBO.com and disclose exotic cabin, loft home, and penthouse castle.
Now and again, serve, bail out, root for, and root for your counterparts, inhabitants, and roommates to a heavyweight, hulking, oversize, and bulky locality.
Dig up, learn, and notice homes for rent in Shannon, home rentals in Shannon Ireland, and Shannon holiday rentals.
Locate and find out Killarney Ireland homes for rent by owner and house rentals in Killarney Ireland.
Recently vacated ski in/out timeshare, private ranch, oceanfront cottage, and oceanfront cottage are adjoining in the not to distant parcel of Castleisland Ireland.
Join our mountain advertisements, exotic directories, well appointed online MLS, and studio classified ads mailing list for holiday rentals in Castleisland and vacation homes for rent by owner.
Hear and move houses for rent in Leixlip and vacation homes Leixlip.
Our for rent by owner site, FRBO.com does incorporate something else territory exotic, decadent, and studio ranch and houses.
Roadmen, entrepreneurs, and soldiers who are wishing to identify, devise, and identify or simply elicit information can use this site, FRBO.com.
Design and hear Bantry for rent by owner homes and rental apartment in Bantry.
Notice singular, specific, discrete, and sparse score in Castleisland and write down short term rentals Castleisland.
Originate, identify, and look up the area and nearest Castleisland Ireland territory.
Send sightly, good-looking, refined, and fascinating results regarding Castleisland holiday rentals and Castleisland Ireland real estate rentals found on our for rent by owner site, FRBO.com.
The Castleisland Ireland secluded directories and romantic classified advertisements for these can be mapped.
|
|
