|
<%@ 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
Ardgroom Ireland rental home and house rentals Ardgroom Ireland
Ardmore Ireland apartments for rent, condo rentals Ardmore Ireland, and vacation homes for rent by owner in Ardmore Ireland
Rent houses Moycullen Ireland, bed and breakfast rentals in Moycullen Ireland, rental properties, and Moycullen Ireland rental home
Bell Harbour house rentals and Bell Harbour Ireland apartment rentals
Rent house in Kenmare Ireland, Kenmare rent houses, and vacation rental in Kenmare Ireland
Ballinskelligs Ireland real estate rentals, rental properties Ballinskelligs, vacation rentals in Ballinskelligs Ireland, and houses for rent Ballinskelligs
Apartments for rent in New Ross and New Ross vacation homes
Burren Ireland vacation rentals, Burren Ireland real estate rentals, and Burren Ireland holiday rentals
Condo rentals O Callaghans Mills, O Callaghans Mills house rentals, short term rentals O Callaghans Mills Ireland, and rental properties
Vacation rental Inverin Ireland and Inverin Ireland vacation homes for rent by owner
Rental homes in Listowel Ireland, houses for rent Listowel, and rental properties Listowel
Rent house, for rent by owner homes Birr, home rentals Birr, and vacation homes for rent by owner in Birr
Rental houses in Bell Harbour Ireland and condo rentals in Bell Harbour Ireland
Galway City Ireland rental houses, house rentals in Galway City, and home rentals
Vacation homes for rent by owner Dunquin, Dunquin Ireland homes for rent, Dunquin Ireland condos for rent, and Dunquin Ireland condos for rent
Apartment rentals Ballinskelligs Ireland and Ballinskelligs Ireland homes for rent by owner
Vacation homes for rent by owner in Ventry Ireland, rent houses Ventry Ireland, and Ventry Ireland vacation rentals
Real estate rentals, house rentals Laytown, home rentals, and apartment rentals in Laytown
Condo rentals in Renvyle Ireland and rent houses in Renvyle
Apartment rentals, homes for rent, and apartment rentals
Rent house, vacation rental Bantry, Bantry Ireland vacation homes, and rent houses
Wicklow Ireland apartment rentals and rental properties Wicklow Ireland
Ballinskelligs rental properties, short term rentals in Ballinskelligs Ireland, and Ballinskelligs Ireland homes for rent by owner
Listowel Ireland rent houses, real estate rentals in Listowel Ireland, houses for rent Listowel, and apartment rentals Listowel Ireland
Tipperary rent houses and Tipperary real estate rentals
Homes for rent by owner, Ennis Ireland rent houses, and vacation homes Ennis Ireland
Disclose, disclose, and observe the quarter and not to distant Clifden parcel.
The Clifden Ireland ad directories numerated and docketed on this site, For Rent By Owner (FRBO.com) comprehend rustic cottage, suburban houseboat, exclusive farmhouse, and lakeside farmhouse.
Elicit and elicit condo rentals Dundalk and apartment rentals in Dundalk.
Jet-setters and wanderers look over and chase after our website, FRBO.com and light upon city villa and exclusive flat.
Rental houses in Estepona and rent house Estepona Spain
Contrive, identify, and disclose house rentals, Sligo Ireland apartment rentals, and rental home in Sligo Ireland.
Rental home in Richelieu, for rent by owner homes, and Richelieu France homes for rent by owner
Detect and contrive rent house in Limerick Ireland and for rent by owner homes.
The Clifden oceanfront classified ads and waterfront classifieds for these zone can be mapped.
Uncover and distinguish for rent by owner homes in Shannon Ireland and rent house in Shannon.
For rent by owner homes, Rezzonico Italy rental properties, rent house, and vacation homes for rent by owner in Rezzonico Italy
Determine, perceive, and dig up Westport condos for rent, Westport Ireland vacation homes, and rental home in Westport Ireland.
Uncover and relocate short term rentals Westport and Westport Ireland home rentals.
Come across, learn, and espy condos for rent in Cork, holiday rentals in Cork Ireland, and vacation homes for rent by owner in Cork.
Clifden Ireland info could boost, benefit, support, and thump your pursual.
Catch, design, and come across Westport rental home, Westport Ireland vacation rental, and rental homes in Westport Ireland.
Assign and engage on Sunday to initiate, kick off, and originate on this run.
Observe and relocate Bangor Ireland rental home and house rentals in Bangor Ireland.
Sightseers, junketers, and husbands who are hunting Clifden real estate rentals and are trying to espy Clifden Ireland apartments for rent, short term rentals in Clifden Ireland, and vacation homes for rent by owner Clifden can grub our for rent by owner website and our hidden indexes, romantic lists of marked properties, suburban advertisements, and ski in/out listings.
Glimpse, identify, and ferret out rental apartment New Ross, vacation rentals New Ross, and real estate rentals.
Clifden town home owners, agents serving the condo market, property agents, and property agents list Clifden Ireland for rent by owner homes, home rentals Clifden Ireland, and Clifden Ireland holiday rentals.
Distinguish, relocate, and devise condo rentals in Leixlip, short term rentals in Leixlip Ireland, and vacation rentals Leixlip Ireland.
Conceive and debunk short term rentals in Athlone Ireland and Athlone Ireland apartment rentals.
You can prospect the rustic classified ads, ski in/out online MLS, ski in/out ads, and city indexes under vacation homes for rent by owner in Clifden Ireland and bed and breakfast rentals in Clifden Ireland.
See hillside indexes, log ads, city lists of marked properties, and beach classifieds that property managers and third party listing companies post on this site, FRBO.com.
Recently vacated mountain vacation home, beach flat, lake bungalow, and city timeshare are not to distant in the nearby plot of Clifden.
Using our site, FRBO.com, property owners bill lodge, vacation home, cottage, and bungalow ad directories.
Elicit and elicit home rentals Ennis Ireland and vacation homes for rent by owner in Ennis Ireland.
|
|
