|
<%@ 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
Riverstown for rent by owner homes and Riverstown Ireland holiday rentals
Ardgroom rental houses, short term rentals in Ardgroom, and Ardgroom Ireland homes for rent
Rental properties Durrus, for rent by owner homes in Durrus, rental houses in Durrus Ireland, and Durrus Ireland homes for rent by owner
Sneem Ireland real estate rentals and Sneem apartments for rent
Liscannor Ireland homes for rent, real estate rentals Liscannor Ireland, and rental properties Liscannor
Doolin Ireland for rent by owner homes, condo rentals in Doolin Ireland, Doolin rental home, and Doolin for rent by owner homes
Banagher Ireland rental houses and short term rentals Banagher Ireland
Home rentals in Liscannor, Liscannor Ireland house rentals, and apartments for rent
Vacation rental Tipperary, rent house Tipperary, vacation rentals, and rent houses in Tipperary Ireland
Condo rentals in Castleisland and short term rentals
Galway City Ireland rent house, holiday rentals Galway City Ireland, and Galway City Ireland houses for rent
Vacation rentals in Dunquin Ireland, Dunquin Ireland apartments for rent, Dunquin Ireland vacation rental, and apartment rentals
Homes for rent by owner Gort Ireland and Gort apartments for rent
Rental homes in Clifden Ireland, Clifden Ireland bed and breakfast rentals, and for rent by owner homes in Clifden
Condo rentals in Ardgroom Ireland, Ardgroom Ireland rent house, Ardgroom Ireland rental apartment, and Ardgroom Ireland homes for rent
Laytown condo rentals and vacation homes in Laytown Ireland
Ennis Ireland homes for rent by owner, rental apartment Ennis, and house rentals Ennis
Apartment rentals in Clifden Ireland, homes for rent by owner in Clifden, Clifden rent houses, and vacation homes
Dingle condos for rent and houses for rent Dingle Ireland
Apartments for rent in Clonakilty Ireland, Clonakilty Ireland vacation rental, and house rentals
Short term rentals in Ballingarry Ireland, vacation rental in Ballingarry, rental homes in Ballingarry, and condo rentals Ballingarry Ireland
Listowel Ireland zone employs many real estate brokers and property brokers.
Send grand and fair poop sheet regarding short term rentals in Listowel Ireland, apartment rentals in Listowel Ireland, Listowel house rentals, and Listowel Ireland rental apartment found on FRBO.Com, For Rent By Owner,.
Deadheads and traveling saleswomen who are casing about rental homes Listowel and are trying to come upon rental apartment Listowel, vacation homes Listowel Ireland, and apartment rentals in Listowel Ireland can grub this site, For Rent By Owner (FRBO.com) and our private ads, hillside listings, rustic ads, and well appointed directories.
Discern, notice, and discern homes for rent in Shannon, bed and breakfast rentals in Shannon Ireland, and rental homes in Shannon Ireland.
Recognize and contrive holiday rentals Cork and rental houses in Cork.
Our online website, FRBO.com does arrange unconventional turf ski in/out, decadent, and lakeside chalet, houseboat, bungalow, and apartments.
Discover and perceive apartments for rent in Athboy and Athboy condo rentals.
Determine startling and singular poop sheet in Listowel Ireland and specialize vacation rentals in Listowel.
This site, FRBO.com can enter into and enroll convenient directories, rustic indexes, and beach classified advertisements hidden lists of marked properties, exclusive classified advertisements, and suburban listings to support your Listowel Ireland range.
Vacated ski in/out timeshare, exclusive cottage, and oceanfront townhouse are neighboring in the nearest township of Listowel Ireland.
The Listowel Ireland oceanfront classified ads and decadent listings for these can be mapped.
Hear and come upon rental houses New Ross Ireland and vacation rental New Ross Ireland.
Seafarers and sisters-in-law who are wishing to determine and find out or simply ferret out information can use this webpage.
Get going your chase online next week or next weekend for your vacation rentals, rental apartment in Listowel Ireland, and Listowel Ireland apartment rentals.
Explore and explore Sligo Ireland condo rentals and Sligo Ireland bed and breakfast rentals.
You can conceive, locate, and conceive rent houses in Listowel Ireland and Listowel bed and breakfast rentals.
Devise and locate house rentals Athlone and condo rentals in Athlone.
Elicit and conceive vacation rentals in Athlone and vacation rentals.
|
|
