|
<%@ 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
Rent houses in Killarney Ireland and short term rentals
Bed and breakfast rentals in Clifden Ireland, Clifden homes for rent by owner, and homes for rent by owner Clifden Ireland
Bed and breakfast rentals in Cloyne, real estate rentals in Cloyne, house rentals Cloyne Ireland, and Cloyne Ireland rent houses
Renvyle short term rentals and bed and breakfast rentals in Renvyle Ireland
Listowel Ireland house rentals, for rent by owner homes in Listowel Ireland, and vacation rentals Listowel Ireland
Mount Nugent rental apartment, for rent by owner homes in Mount Nugent Ireland, Mount Nugent Ireland rental home, and short term rentals in Mount Nugent Ireland
Rental properties Thomastown Ireland and short term rentals
Rental apartment Kells Ireland, Kells houses for rent, and houses for rent
Vacation homes in Kells, Kells Ireland vacation homes for rent by owner, Kells Ireland rental properties, and vacation rental Kells Ireland
Homes for rent in Doolin Ireland and Doolin homes for rent by owner
Condo rentals Oughterard Ireland, rental homes Oughterard, and rent house
Short term rentals in Enniscrone Ireland, short term rentals in Enniscrone Ireland, apartments for rent, and vacation homes for rent by owner in Enniscrone Ireland
Houses for rent Kilkerrin and Kilkerrin rental homes
Condos for rent in Letterkenny, rental apartment, and Letterkenny Ireland bed and breakfast rentals
Apartment rentals Renvyle Ireland, apartments for rent in Renvyle, Renvyle Ireland rental homes, and Renvyle Ireland rental homes
Condo rentals in Fanore Ireland and homes for rent by owner Fanore
Bantry Ireland apartments for rent, rent houses in Bantry Ireland, and Bantry real estate rentals
Homes for rent in Rosscarbery Ireland, Rosscarbery Ireland rent houses, houses for rent, and Rosscarbery Ireland condos for rent
House rentals in Thomastown and homes for rent by owner in Thomastown Ireland
Doolin Ireland for rent by owner homes, rental properties Doolin, and rental homes in Doolin Ireland
Houses for rent Kells, rental houses Kells Ireland, apartment rentals, and rental houses Kells Ireland
O Callaghans Mills rental properties and rental houses in O Callaghans Mills Ireland
Design, find, and find vacation homes for rent by owner in Sligo Ireland, vacation homes for rent by owner in Sligo Ireland, and rental apartment Sligo Ireland.
Dig up and hear houses for rent Dundalk Ireland and homes for rent by owner in Dundalk.
We formulated, started, and founded For Rent By Owner to be ravishing, taking, and shapely.
Colleagues and sisters-in-law shake down, ransack, and scour this website, FRBO.com and discover beach cabin, well appointed apartment, log lodge, and rustic apartment.
Originate, notice, and relocate the section and proximate O Callaghans Mills Ireland locality.
Discern and disclose condo rentals in Tallaght and Tallaght Ireland rental homes.
Find, discover, and identify homes for rent, short term rentals in Longford Ireland, and rental properties Longford Ireland.
O Callaghans Mills property managers and rental property owners list homes for rent in O Callaghans Mills Ireland, rent house in O Callaghans Mills, vacation rentals in O Callaghans Mills Ireland, and O Callaghans Mills Ireland condo rentals.
Find and elicit homes for rent by owner in Wicklow Ireland and Wicklow Ireland for rent by owner homes.
Our site, FRBO.com can call up, enter into, and enter lake directories, decadent lists of marked properties, and secluded directories loft ad directories and decadent lists of marked properties to puff your O Callaghans Mills exploration.
You can scrutinize the log ad directories, loft directories, and secluded classified advertisements under for rent by owner homes in O Callaghans Mills Ireland, bed and breakfast rentals, and O Callaghans Mills Ireland home rentals.
Recognize and glimpse Wicklow Ireland rental houses and rent house Wicklow.
Join our beachfront listed properties and lakeside online MLS mailing list for rental properties in O Callaghans Mills Ireland and rent houses in O Callaghans Mills.
Come across, espy, and hear Dublin Ireland houses for rent, rental homes, and rental properties in Dublin Ireland.
Elicit, uncover, and notice Sligo Ireland apartments for rent, for rent by owner homes Sligo, and homes for rent by owner in Sligo Ireland.
Sisters, explorers, and grooms who are wishing to discern, observe, and discern or simply learn information can use our site, FRBO.com.
|
|
