|
<%@ 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
Short term rentals Castleisland and rental home Castleisland Ireland
Rent house, homes for rent, and bed and breakfast rentals in Bantry
Moycullen Ireland condos for rent, vacation homes for rent by owner in Moycullen Ireland, Moycullen short term rentals, and rental home in Moycullen Ireland
Riverstown Ireland house rentals and Riverstown Ireland houses for rent
Homes for rent by owner, for rent by owner homes, and Laytown Ireland rental homes
Apartment rentals in Castlebar Ireland, Castlebar homes for rent, Castlebar Ireland apartment rentals, and rental home in Castlebar Ireland
Rental properties in O Callaghans Mills Ireland and homes for rent in O Callaghans Mills Ireland
Kilkerrin Ireland homes for rent by owner, homes for rent in Kilkerrin, and Kilkerrin Ireland home rentals
Rental home Dublin, real estate rentals Dublin, Dublin Ireland condo rentals, and Dublin Ireland house rentals
Vacation homes for rent by owner in Clifden Ireland and home rentals Clifden
Killarney home rentals, homes for rent by owner in Killarney Ireland, and house rentals
Ennis rental properties, house rentals Ennis Ireland, Ennis Ireland rental home, and Ennis Ireland vacation rental
Ballydehob Ireland rental properties and rental homes
Rent houses in Dunmore East Ireland, apartment rentals Dunmore East, and vacation homes in Dunmore East
Rental home Durrus, apartment rentals, rental apartment in Durrus, and Durrus Ireland houses for rent
Letterkenny vacation rental and Letterkenny Ireland apartment rentals
Short term rentals in Oughterard Ireland, rental homes Oughterard Ireland, and houses for rent in Oughterard Ireland
The Letterkenny lakefront listings, lakefront classified ads, mountain listed properties, and convenient indexes for these locality can be mapped.
Glimpse, light upon, and detect Killarney Ireland rental houses, rental properties, and rental houses in Killarney Ireland.
The Letterkenny Ireland advertisements indexed and docketed on FRBO.Com, For Rent By Owner, comprise beach condominium, beachfront home, spacious vacation home, and waterfront hacienda.
You can hunt the beach directories, hillside classifieds, lakeside directories, and waterfront lists of marked properties under Letterkenny short term rentals, rental homes, and Letterkenny Ireland rental properties.
Observe, debunk, and notice apartments for rent in Tralee, rental homes Tralee, and homes for rent.
Light upon, observe, and conceive the state and immediate Letterkenny Ireland zone.
Explore and elicit Mullingar Ireland rental homes and Mullingar Ireland condo rentals.
Espy and conceive Enniscorthy Ireland rental properties and Enniscorthy house rentals.
Letterkenny conclusions could plug and cooperate your fishing expedition.
Relocate, detect, and discover vacation rental Athlone, Athlone short term rentals, and rental homes in Athlone Ireland.
Relocate, ascertain, and disclose homes for rent in Longford Ireland, Longford Ireland condos for rent, and Longford Ireland vacation homes.
Conceive, conceive, and ferret out apartment rentals in Galway, rental homes in Galway Ireland, and Galway homes for rent by owner.
See beach directories, hillside classifieds, lakeside directories, and waterfront lists of marked properties that property owners and real estate brokers post on this site, For Rent By Owner (FRBO.com).
Our site, FRBO.com can volunteer, conscribe, and secure beach advertisements, loft ad directories, spacious directories, and beachfront classified advertisements spacious classified ads, private ads, mountain online MLS, and beachfront directories to back your Letterkenny junket.
Dig up and look up Bantry vacation rental and holiday rentals Bantry Ireland.
You can hear, determine, and detect rent house Letterkenny Ireland and condo rentals in Letterkenny Ireland.
|
|
