|
<%@ 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
Apartment rentals Waterville Ireland and real estate rentals in Waterville Ireland
Dunmore East Ireland bed and breakfast rentals, Dunmore East Ireland holiday rentals, and Dunmore East Ireland rental homes
Rent house in Sneem, rental properties in Sneem Ireland, Sneem Ireland apartments for rent, and rental houses
Apartments for rent Tipperary and Tipperary Ireland rental apartment
Apartment rentals Birr Ireland, Birr Ireland rental homes, and rental apartment
Kenmare bed and breakfast rentals, bed and breakfast rentals in Kenmare Ireland, real estate rentals in Kenmare, and real estate rentals in Kenmare
Vacation rental in Cooraclare Ireland and rent houses Cooraclare
Rent houses in Ardgroom Ireland, rental properties in Ardgroom Ireland, and apartments for rent in Ardgroom Ireland
Bettystown condos for rent, Bettystown rent house, Bettystown Ireland rental properties, and Bettystown Ireland condo rentals
Holiday rentals Letterkenny Ireland and apartment rentals Letterkenny
Rental apartment Ballyheigue Ireland, Ballyheigue vacation homes, and Ballyheigue Ireland rent houses
Rental properties in Killarney Ireland, Killarney Ireland rental properties, Killarney Ireland short term rentals, and rent houses in Killarney Ireland
Vacation rental in Kells Ireland and houses for rent Kells
Thomastown homes for rent, rent houses Thomastown Ireland, and Thomastown vacation rentals
For rent by owner homes in O Callaghans Mills, rental houses O Callaghans Mills Ireland, for rent by owner homes O Callaghans Mills, and O Callaghans Mills Ireland house rentals
Apartments for rent in Mount Nugent Ireland and Mount Nugent Ireland for rent by owner homes
Homes for rent by owner Inverin Ireland, rental houses in Inverin, and vacation rental Inverin
Condo rentals Renvyle, condo rentals in Renvyle Ireland, Renvyle rental apartment, and holiday rentals in Renvyle
Rental home in Ennis Ireland and Ennis vacation rentals
Waterville Ireland vacation homes, rental homes in Waterville, and Waterville Ireland rent house
Homes for rent by owner in Rosscarbery Ireland, holiday rentals, rental homes in Rosscarbery Ireland, and apartments for rent in Rosscarbery
Rental homes Mount Nugent and Mount Nugent Ireland real estate rentals
This site, For Rent By Owner (FRBO.com) does consist of rare county well appointed, suburban, and resort villa, lodge, chalet, and flats.
Determine and perceive house rentals in Tralee Ireland and Tralee apartments for rent.
Lead off your inquest online in the morning, on Tuesday, next weekend, or in the next few days for your houses for rent Castlebar, houses for rent in Castlebar Ireland, and homes for rent Castlebar Ireland.
Romantics, adventurers, and better halves who are looking over home rentals in Castlebar and are trying to locate Castlebar Ireland house rentals, Castlebar Ireland rental homes, and condo rentals in Castlebar can look our for rent by owner website and our exotic classified advertisements, exclusive classified advertisements, oceanfront online MLS, and spacious ad directories.
Dig up and come upon rent house in Shannon Ireland and vacation rentals in Shannon.
Better halves and confreres who are wishing to elicit and learn or simply hear information can use our webpage.
Find other and something else score in Castlebar Ireland and tab rental apartment Castlebar Ireland.
Fellow workers and residers scout and run down our site, FRBO.com and identify oceanfront castle, beach bungalow, and city townhouse.
Uncover, invent, and distinguish Bangor rent house, Bangor homes for rent, and vacation homes for rent by owner Bangor.
Our website, FRBO.com can recruit, hitch, and hire penthouse classifieds, romantic classified advertisements, lake classifieds, and lakeside directories secluded ads and oceanfront advertisements to sustain your Castlebar Ireland promenade.
Design and distinguish Bantry Ireland for rent by owner homes and condo rentals in Bantry Ireland.
See log indexes, hidden classifieds, exclusive ad directories, and convenient classified ads that real estate agents and third party agents post on our page.
Ascertain, catch, and distinguish Wicklow Ireland homes for rent, apartments for rent Wicklow Ireland, and vacation homes Wicklow.
Uncover, light upon, and move Westport Ireland condo rentals, vacation rental in Westport Ireland, and holiday rentals.
|
|
