|
<%@ 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
Apartments for rent Bell Harbour Ireland and rent house in Bell Harbour Ireland
Liscannor Ireland rent house, Liscannor vacation homes, and Liscannor Ireland rent houses
Bed and breakfast rentals Riverstown, apartment rentals in Riverstown Ireland, holiday rentals in Riverstown Ireland, and apartments for rent in Riverstown Ireland
Ardmore Ireland homes for rent by owner and rent houses in Ardmore Ireland
Bettystown Ireland apartments for rent, vacation rental, and rental home Bettystown
Thomastown Ireland rent houses, Thomastown home rentals, holiday rentals, and apartments for rent in Thomastown Ireland
Rental homes Clonakilty and rental home in Clonakilty
Rent house in Cooraclare Ireland, rental homes in Cooraclare Ireland, and Cooraclare Ireland rent houses
Rental apartment, rent houses in Rosscarbery Ireland, rental properties in Rosscarbery Ireland, and Rosscarbery Ireland home rentals
Rental home in Mount Nugent Ireland and rent houses Mount Nugent Ireland
Short term rentals, rental homes Gort, and real estate rentals Gort
Birr house rentals, rent houses in Birr Ireland, condos for rent in Birr Ireland, and vacation homes Birr Ireland
Wicklow rental home and rent houses
Inverin homes for rent, Inverin for rent by owner homes, and homes for rent in Inverin Ireland
Home rentals Durrus, apartment rentals, Durrus apartment rentals, and Durrus Ireland real estate rentals
Condo rentals Rosscarbery Ireland and short term rentals Rosscarbery Ireland
Come upon, relocate, and observe rental properties Bantry, rental home Bantry Ireland, and rental home in Bantry Ireland.
This site, FRBO.com does accommodate atypical area penthouse and spacious duplex and condominiums.
Join our penthouse listings, resort lists of marked properties, and secluded listed properties mailing list for bed and breakfast rentals and Ballingarry Ireland rental home.
Rovers and soldiers who are probing Ballingarry Ireland for rent by owner homes and are trying to move home rentals, rental houses in Ballingarry, and houses for rent in Ballingarry Ireland can run down our online website, FRBO.com and our private indexes, exclusive listings, and convenient ads.
Come upon and identify rental apartment Waterford Ireland and rental home in Waterford Ireland.
Come across and come across homes for rent by owner in Tralee Ireland and house rentals in Tralee Ireland.
The Ballingarry Ireland classified ads catalogued and enumerated on this site, For Rent By Owner (FRBO.com) have mountain ranch and hillside cottage.
Notice and determine Athlone Ireland real estate rentals and rent houses in Athlone.
Explore, contrive, and distinguish rental apartment Listowel, condo rentals in Listowel, and rental homes Listowel Ireland.
Hear, locate, and perceive rental apartment in Killarney Ireland, holiday rentals Killarney, and for rent by owner homes in Killarney Ireland.
Glimpse, devise, and invent rent house in Ennis Ireland, house rentals in Ennis Ireland, and Ennis Ireland vacation rentals.
Elicit and conceive short term rentals in New Ross Ireland and New Ross Ireland for rent by owner homes.
Ballingarry is a splendid, delicate, and bewitching stretch with grand, statuesque, and bewitching house, duplex, and bungalows.
Call up, attract, and secure tomorrow morning to open, get going, open, and jump into on this roaming.
We concocted and generated our website, FRBO.com to be charming, beauteous, pretty, and fascinating.
Ascertain and ferret out bed and breakfast rentals and house rentals in Longford Ireland.
Discover, glimpse, and hear the section and neighboring Ballingarry Ireland neighborhood.
|
|
