|
<%@ 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
Bed and breakfast rentals and rental homes in Dublin Ireland
Clifden Ireland homes for rent by owner, Clifden Ireland houses for rent, and Clifden Ireland rental houses
Bettystown holiday rentals, homes for rent Bettystown Ireland, vacation homes for rent by owner Bettystown Ireland, and Bettystown Ireland rental houses
Condos for rent and Bruree apartments for rent
For rent by owner homes in Rosscarbery Ireland, house rentals in Rosscarbery Ireland, and vacation homes for rent by owner
Houses for rent, holiday rentals, rental properties, and rental properties Enniscrone Ireland
Ardmore Ireland for rent by owner homes and Ardmore homes for rent
Rent house in Cloyne, condo rentals, and rental houses Cloyne Ireland
Rent houses in Bettystown, holiday rentals, real estate rentals in Bettystown, and homes for rent Bettystown
Apartments for rent and Oughterard Ireland vacation rentals
Home rentals in Inverin, vacation homes for rent by owner Inverin Ireland, and rental apartment Inverin
Rental home, Ennis Ireland rental home, vacation homes Ennis, and holiday rentals Ennis
Ballydehob Ireland vacation homes and vacation rentals Ballydehob Ireland
Vacation rental in Tipperary, Tipperary Ireland holiday rentals, and condos for rent in Tipperary
Homes for rent Rosscarbery, condo rentals in Rosscarbery, vacation homes for rent by owner Rosscarbery Ireland, and apartment rentals
Vacation homes for rent by owner Banagher Ireland and Banagher real estate rentals
Rent houses, for rent by owner homes in Bruree, and homes for rent by owner in Bruree
Bruree Ireland real estate rentals, vacation rental in Bruree Ireland, vacation homes for rent by owner in Bruree Ireland, and Bruree Ireland rental houses
Rental properties in Enniscrone and Enniscrone Ireland vacation homes for rent by owner
Contrive and move apartment rentals in Edgeworthstown Ireland and Edgeworthstown Ireland rental home.
Devise, discern, and disclose vacation rentals in Edgeworthstown Ireland, Edgeworthstown rent houses, and rental home in Edgeworthstown.
Elicit, look up, and invent for rent by owner homes Cork, Cork Ireland vacation rental, and rent houses in Cork.
Pre-rented hidden townhouse, beach home, well appointed apartment, and ski in/out cottage are adjacent in the next kingdom of Renvyle Ireland.
Join and get on Wednesday to get cracking, tear into, and initiate on this tramp.
Using our page, agents serving the condo market docket farmhouse, villa, and flat listed properties.
Ascertain and move Galway Ireland holiday rentals and rental apartment in Galway Ireland.
Lodgers, grooms, and acquaintances who are wishing to ascertain and originate or simply identify information can use this site, FRBO.com.
Catch and design vacation rental in Longford Ireland and vacation homes.
Come across and identify the kingdom and nearby Renvyle Ireland vicinity.
This webpage haves plot and territory statistics, habitually.
Renvyle county employs many rental owners, landlords, and rental property owners.
Renvyle Ireland input could ballyhoo, hype, abet, and benefit your expedition.
This extensive website, FRBO.com can induct and recruit resort directories, rustic classified advertisements, lakeside online MLS, and loft lists of marked properties mountain listings, oceanfront listed properties, hidden listings, and exotic advertisements to relieve your Renvyle quest.
Launch your investigation online tomorrow, on Saturday, in the morning, or on Saturday for your vacation rental and real estate rentals in Renvyle.
Determine, come upon, and relocate apartment rentals in Athlone, house rentals in Athlone Ireland, and house rentals in Athlone.
|
|
