|
<%@ 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
Moycullen Ireland rent house and Moycullen Ireland real estate rentals
Homes for rent in Laytown Ireland, rental apartment in Laytown, and Laytown Ireland rental houses
Condos for rent, Bell Harbour Ireland apartment rentals, Bell Harbour vacation rentals, and apartment rentals in Bell Harbour Ireland
Rental houses in Ardgroom and rent house in Ardgroom Ireland
Rental properties in Bantry Ireland, bed and breakfast rentals Bantry, and Bantry Ireland houses for rent
Riverstown Ireland vacation homes for rent by owner, Riverstown Ireland short term rentals, house rentals in Riverstown Ireland, and holiday rentals Riverstown Ireland
Homes for rent by owner in Ardmore Ireland and rental apartment in Ardmore Ireland
Kilkerrin bed and breakfast rentals, Kilkerrin Ireland rental apartment, and Kilkerrin apartment rentals
House rentals in Dunquin Ireland, house rentals Dunquin, Dunquin rental apartment, and vacation homes in Dunquin
Bruree Ireland real estate rentals and Bruree Ireland vacation homes
Enniscrone Ireland for rent by owner homes, Enniscrone Ireland bed and breakfast rentals, and rent house
House rentals Cooraclare, rental home Cooraclare Ireland, Cooraclare Ireland holiday rentals, and Cooraclare Ireland apartment rentals
Holiday rentals Rosslare and Rosslare Ireland houses for rent
Homes for rent by owner in Kells, Kells Ireland houses for rent, and rental home in Kells
Short term rentals Galway City Ireland, rental properties Galway City Ireland, rent houses Galway City, and rental houses Galway City Ireland
Rental houses Sneem and Sneem Ireland rent houses
Gort Ireland vacation rentals, bed and breakfast rentals in Gort Ireland, and Gort vacation homes
Rent house in O Callaghans Mills Ireland, O Callaghans Mills vacation homes, house rentals in O Callaghans Mills Ireland, and O Callaghans Mills Ireland real estate rentals
Ballyheigue Ireland real estate rentals and bed and breakfast rentals Ballyheigue Ireland
Mullingar Ireland rental houses, Mullingar houses for rent, and rental home in Mullingar Ireland
Bed and breakfast rentals New Ross, rental homes in New Ross Ireland, apartments for rent in New Ross Ireland, and New Ross Ireland homes for rent by owner
Bruree bed and breakfast rentals and short term rentals
Rent house Castleisland, homes for rent, and apartments for rent in Castleisland Ireland
Dingle Ireland vacation rentals, Dingle Ireland real estate rentals, holiday rentals in Dingle, and Dingle Ireland apartment rentals
Ballyheigue Ireland apartments for rent and vacation rental
Dunmore East Ireland house rentals, rental apartment, and apartments for rent in Dunmore East
Houses for rent Letterkenny Ireland, short term rentals in Letterkenny Ireland, Letterkenny vacation rentals, and apartment rentals
Short term rentals in Rosslare Ireland and holiday rentals in Rosslare Ireland
Homes for rent by owner Sneem Ireland, bed and breakfast rentals Sneem, and Sneem bed and breakfast rentals
Killarney Ireland rental apartment, Killarney Ireland apartments for rent, Killarney Ireland short term rentals, and Killarney Ireland condo rentals
Dingle apartments for rent and vacation rental in Dingle Ireland
Catch and elicit Kilkenny home rentals and Kilkenny Ireland condos for rent.
Catch, recognize, and espy bed and breakfast rentals Galway, Galway for rent by owner homes, and rental homes in Galway Ireland.
Find and light upon rental homes and vacation homes for rent by owner in Ennis Ireland.
Condo rentals in Lourmarin France, short term rentals in Lourmarin, rent house Lourmarin, and vacation homes
Dig up and discern condos for rent Castlebar Ireland and house rentals.
Customarily, work with, push, back, and further your residers and displaced persons to a voluminous and bulky field.
Vacation homes for rent by owner in Carate Urio, vacation homes in Carate Urio, vacation rentals, and vacation homes for rent by owner in Carate Urio
Send stunning and charming notes regarding rental properties Enniscrone, rent house Enniscrone, homes for rent in Enniscrone, and rental home found on our for rent by owner website.
The Enniscrone ski in/out ad directories, lakefront classifieds, loft advertisements, and exotic online MLS for these can be mapped.
We invested, built, and constructed our page to be fine and dazzling.
Ferret out and look up New Ross apartment rentals and vacation rental New Ross Ireland.
Contrive, find out, and explore Dundalk Ireland condo rentals, Dundalk Ireland apartment rentals, and Dundalk Ireland real estate rentals.
Distinguish, find, and hear rental apartment in Athlone Ireland, Athlone houses for rent, and vacation rentals in Athlone Ireland.
Design and uncover Letterkenny Ireland condos for rent and vacation rentals in Letterkenny Ireland.
Determine several, various, and various memorandums in Enniscrone Ireland and post Enniscrone rental homes.
Explore and ascertain rental houses Castlebar and apartment rentals in Castlebar.
Rental houses in Positano Italy and apartment rentals Positano Italy
|
|
