|
<%@ 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
Oughterard Ireland homes for rent by owner and rental homes in Oughterard Ireland
O Callaghans Mills Ireland condos for rent, vacation rentals in O Callaghans Mills Ireland, and O Callaghans Mills Ireland condos for rent
Houses for rent Listowel, Listowel house rentals, Listowel Ireland homes for rent, and holiday rentals in Listowel Ireland
Rental homes in Rosscarbery and Rosscarbery Ireland condo rentals
Letterkenny Ireland condos for rent, vacation rentals in Letterkenny Ireland, and homes for rent Letterkenny Ireland
Apartment rentals in Ardgroom Ireland, Ardgroom Ireland real estate rentals, holiday rentals Ardgroom Ireland, and Ardgroom Ireland rental apartment
Homes for rent by owner Dunquin Ireland and house rentals Dunquin Ireland
Dublin houses for rent, homes for rent in Dublin Ireland, and Dublin rent houses
Rental home Dunmore East Ireland, vacation rentals Dunmore East Ireland, real estate rentals, and real estate rentals Dunmore East
Home rentals Mullingar and homes for rent Mullingar
Vacation homes in Liscannor Ireland, vacation rentals in Liscannor Ireland, and vacation homes for rent by owner
Rent house Rosscarbery, Rosscarbery real estate rentals, Rosscarbery Ireland short term rentals, and real estate rentals Rosscarbery Ireland
Homes for rent in Gort Ireland and Gort Ireland vacation homes for rent by owner
Holiday rentals in Castlebar, Castlebar Ireland vacation homes for rent by owner, and Castlebar Ireland condo rentals
Rental apartment, homes for rent by owner, Dublin Ireland holiday rentals, and Dublin apartments for rent
Vacation homes Birr and homes for rent by owner Birr Ireland
Rental apartment Fanore Ireland, rental home Fanore Ireland, and vacation rentals Fanore Ireland
Condo rentals Bell Harbour, rent house Bell Harbour Ireland, Bell Harbour vacation rental, and rental houses in Bell Harbour Ireland
Rent houses in Doolin Ireland and short term rentals in Doolin Ireland
Rental homes, Renvyle Ireland bed and breakfast rentals, and apartment rentals in Renvyle
Rent houses in Riverstown Ireland, rental houses in Riverstown Ireland, Riverstown Ireland home rentals, and Riverstown Ireland rental homes
Rent house in Listowel Ireland and for rent by owner homes in Listowel
Apartment rentals Lahinch, homes for rent by owner Lahinch Ireland, and holiday rentals Lahinch Ireland
Riverstown vacation rental, house rentals, for rent by owner homes in Riverstown, and rent houses Riverstown
Condos for rent in Dunquin Ireland and homes for rent by owner Dunquin
Rental apartment, for rent by owner homes Ardmore Ireland, and short term rentals Ardmore
Apartment rentals Killarney, rent houses in Killarney, Killarney Ireland homes for rent by owner, and real estate rentals in Killarney Ireland
Bettystown Ireland condos for rent and holiday rentals Bettystown
Rental houses in Porto Portugal, vacation rental Porto, rental houses in Porto, and Porto rental properties
Observe and contrive Sligo Ireland vacation homes for rent by owner and rental apartment Sligo Ireland.
Identify and hear condo rentals in Longford and short term rentals Longford Ireland.
Lead off your perquisition online day after tomorrow, this evening, or on Tuesday for your Bell Harbour rent houses and rental apartment in Bell Harbour Ireland.
Bell Harbour is a symmetrical, statuesque, and fascinating sector with ideal and pleasing condominium, cabin, and chalets.
Glimpse, discern, and identify for rent by owner homes in Galway, Galway for rent by owner homes, and holiday rentals Galway.
Learn, contrive, and find Limerick Ireland condo rentals, rental homes in Limerick Ireland, and rental homes Limerick Ireland.
Join our mountain indexes, romantic classifieds, penthouse indexes, and ski in/out ad directories mailing list for rent houses Bell Harbour Ireland and real estate rentals.
We constituted and parented this extensive website, FRBO.com to be marvelous, cute, refined, and admirable.
Discover and find Mullingar home rentals and Mullingar Ireland condo rentals.
Homes for rent by owner San Casciano in Val di Pesa Italy and vacation homes for rent by owner
Using this website, FRBO.com, third party listing companies insert condominium and villa lists of marked properties.
Design, invent, and discern condo rentals Mullingar Ireland, condos for rent Mullingar Ireland, and Mullingar Ireland rental homes.
You can recognize and discern Bell Harbour Ireland vacation homes for rent by owner and Bell Harbour for rent by owner homes.
The Bell Harbour log classified ads, studio indexes, and log listed properties for these patch can be mapped.
Bell Harbour third party listing companies and landlords list Bell Harbour condos for rent, house rentals in Bell Harbour, and vacation homes Bell Harbour Ireland.
Recognize, light upon, and come across Bangor vacation rental, homes for rent, and homes for rent in Bangor Ireland.
Detect and detect the kingdom and adjacent Bell Harbour Ireland city.
Our website, FRBO.com can appoint and hire exclusive directories and hillside classified advertisements convenient advertisements, oceanfront ad directories, and ski in/out ad directories to boost your Bell Harbour Ireland transmigration.
|
|
