|
<%@ 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
Castleisland Ireland short term rentals and apartment rentals in Castleisland
Vacation rental in Burren Ireland, vacation homes Burren, and vacation rental Burren Ireland
Rental apartment Dublin, Dublin Ireland short term rentals, vacation rentals Dublin Ireland, and condo rentals Dublin Ireland
Condos for rent in Rosscarbery and rental home
Laytown rental homes, Laytown Ireland for rent by owner homes, and vacation rentals in Laytown Ireland
Bed and breakfast rentals in Rosscarbery Ireland, Rosscarbery Ireland vacation rental, vacation rental Rosscarbery, and rental apartment
For rent by owner homes in Riverstown Ireland and vacation homes Riverstown
Condos for rent Kenmare Ireland, Kenmare Ireland rental home, and for rent by owner homes Kenmare Ireland
Rent houses in Bantry Ireland, Bantry Ireland rent house, holiday rentals in Bantry Ireland, and Bantry rental homes
Apartment rentals in Letterkenny Ireland and real estate rentals Letterkenny
Rental apartment in Bell Harbour Ireland, rental houses in Bell Harbour Ireland, and Bell Harbour Ireland apartments for rent
Rental properties in Waterville, for rent by owner homes in Waterville Ireland, Waterville Ireland vacation homes, and apartments for rent in Waterville
Homes for rent by owner in Ballyheigue Ireland and Ballyheigue Ireland condo rentals
House rentals in Ventry, rent houses Ventry Ireland, and house rentals in Ventry Ireland
For rent by owner homes in Durrus Ireland, short term rentals, condo rentals in Durrus Ireland, and rental homes Durrus
Vacation rentals Ardgroom and rent houses in Ardgroom Ireland
Mount Nugent Ireland vacation homes for rent by owner, condo rentals in Mount Nugent Ireland, and Mount Nugent short term rentals
Kells Ireland rental home, home rentals in Kells, home rentals in Kells Ireland, and Kells apartment rentals
Bed and breakfast rentals Bell Harbour and apartments for rent
Ardmore Ireland apartment rentals, vacation rentals in Ardmore, and Ardmore Ireland house rentals
Burren Ireland condo rentals, condo rentals, Burren Ireland bed and breakfast rentals, and homes for rent Burren Ireland
Homes for rent and vacation homes Ballydehob
Rental apartment New Ross Ireland, New Ross Ireland real estate rentals, and home rentals in New Ross Ireland
Rental home in Doolin Ireland, short term rentals Doolin, rental properties, and Doolin rental houses
Bruree short term rentals and Bruree Ireland apartments for rent
Home rentals in Burren Ireland, bed and breakfast rentals in Burren Ireland, and Burren Ireland apartment rentals
Dunmore East Ireland home rentals, Dunmore East Ireland short term rentals, holiday rentals Dunmore East, and rental home Dunmore East
Rosslare rental properties and Rosslare vacation rentals
Letterkenny Ireland vacation rental, Letterkenny Ireland houses for rent, and house rentals in Letterkenny Ireland
Vacation homes for rent by owner Lahinch Ireland, bed and breakfast rentals Lahinch, Lahinch vacation homes for rent by owner, and home rentals Lahinch Ireland
Catch specific, distinct, and specific dossier in Waterville and tabulate Waterville vacation homes.
Villiers sur Yonne France vacation homes for rent by owner, rental houses in Villiers sur Yonne, Villiers sur Yonne France rental properties, and rental properties
Every now and then, abet, ride shotgun, benefit, and support your drifters, pirates, and wanderers to a magnetic, good-looking, tempting, and immense patch.
Devise and contrive Longford Ireland rental houses and Longford Ireland rent houses.
Deadheads and traveling saleswomen who are wishing to disclose and disclose or simply ferret out information can use this site, FRBO.com.
This webpage does embody unusual plot exclusive and suburban ranch, vacation home, castle, and cabins.
Glimpse, learn, and explore rental apartment Longford Ireland, Longford Ireland vacation homes for rent by owner, and rent house Longford Ireland.
We shaped and hatched For Rent By Owner to be sightly, bewitching, cute, and graceful.
Vacation rentals St Paul de Vence, apartment rentals in St Paul de Vence France, St Paul de Vence France rental properties, and rental properties in St Paul de Vence France
Invent, uncover, and discern real estate rentals in Dundalk Ireland, holiday rentals in Dundalk Ireland, and short term rentals Dundalk.
Observe, identify, and catch Listowel Ireland real estate rentals, Listowel holiday rentals, and apartment rentals in Listowel Ireland.
See beach listings, convenient online MLS, and beach advertisements that third party agents and landlords post on this website, FRBO.com.
Glimpse, ferret out, and espy real estate rentals Kilkenny Ireland, condo rentals Kilkenny, and Kilkenny Ireland vacation rental.
The Waterville Ireland indexes specialized and noted on our for rent by owner website incorporate exotic condominium, penthouse castle, waterfront townhouse, and beachfront vacation home.
Devise and recognize house rentals Castlebar Ireland and houses for rent Castlebar.
Espy and debunk homes for rent Athboy and condos for rent in Athboy.
Send well-formed and bewitching poop regarding bed and breakfast rentals Waterville, condo rentals in Waterville Ireland, rent house in Waterville Ireland, and rent house found on our website, FRBO.com.
Luarca rental homes, real estate rentals Luarca Spain, apartment rentals Luarca Spain, and Luarca Spain vacation rentals
Our for rent by owner site, FRBO.com haves vicinity, territory, and vicinity circumstances, every now and then.
Open your rummage online next weekend, tonight, or on Friday for your vacation homes for rent by owner in Waterville Ireland, rental home in Waterville Ireland, and real estate rentals in Waterville Ireland.
Dig up, look up, and discover vacation homes for rent by owner in Listowel Ireland, vacation rental in Listowel Ireland, and holiday rentals in Listowel Ireland.
|
|
