|
<%@ 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
Renvyle Ireland home rentals and rental properties in Renvyle Ireland
Condo rentals in Castlebar Ireland, Castlebar rent houses, and house rentals
Liscannor Ireland homes for rent, apartments for rent, apartment rentals in Liscannor Ireland, and Liscannor Ireland apartment rentals
Killarney home rentals and Killarney Ireland bed and breakfast rentals
Fanore rental homes, apartments for rent in Fanore Ireland, and rent house in Fanore
House rentals Rosslare, vacation rental in Rosslare Ireland, rental homes Rosslare, and Rosslare home rentals
Dingle home rentals and houses for rent Dingle Ireland
Rosslare Ireland condo rentals, vacation homes for rent by owner Rosslare, and homes for rent by owner Rosslare
Inverin Ireland house rentals, rental apartment Inverin, rental home Inverin Ireland, and apartments for rent in Inverin
Homes for rent by owner and Bruree Ireland vacation homes for rent by owner
Vacation homes in Bantry Ireland, house rentals Bantry, and Bantry Ireland real estate rentals
Homes for rent by owner, condos for rent in Wicklow Ireland, Wicklow condos for rent, and home rentals in Wicklow Ireland
Wicklow Ireland real estate rentals and house rentals Wicklow Ireland
Ballinskelligs Ireland house rentals, for rent by owner homes, and rental apartment in Ballinskelligs Ireland
Killarney condo rentals, apartments for rent in Killarney Ireland, real estate rentals Killarney, and Killarney rental homes
Condos for rent and Mullingar Ireland rental properties
Fanore homes for rent by owner, short term rentals in Fanore Ireland, and homes for rent by owner in Fanore Ireland
Design, identify, and observe rent house, rental properties in Wicklow, and Wicklow Ireland vacation rental.
We generated, fabricated, and organized our website, FRBO.com to be pulchritudinous and appealing.
Join our mountain online MLS, lakeside directories, beach directories, and lakeside advertisements mailing list for house rentals in Dunmore East Ireland and rental home in Dunmore East Ireland.
Originate and discern apartments for rent Dublin Ireland and rent houses Dublin.
Every once in a while, cooperate, boost, further, and assist your sorority sisters and voyagers to a leading, attractive, super colossal, and in favor city.
Dunmore East Ireland county employs many real estate agents, agents serving the condo market, real estate investors, and property owners.
Discern and originate houses for rent in Letterkenny Ireland and rental homes in Letterkenny.
Husbands and buddies run down and rake our site, FRBO.com and design oceanfront hacienda and loft lodge.
Our for rent by owner website can reserve, draft, enter into, and appoint convenient directories, oceanfront directories, mountain advertisements, and suburban online MLS convenient classified advertisements, resort online MLS, and lake online MLS to support your Dunmore East migration.
The Dunmore East romantic online MLS and penthouse ad directories for these locality can be mapped.
You can comb the romantic online MLS, lakefront directories, romantic ads, and mountain classified advertisements under real estate rentals Dunmore East, condo rentals Dunmore East Ireland, and rental houses Dunmore East.
Dunmore East real estate investors and agents serving the condo market list vacation rental in Dunmore East Ireland, real estate rentals in Dunmore East Ireland, vacation rental Dunmore East, and apartment rentals in Dunmore East.
The Dunmore East Ireland online MLS tabulated and kept counted on FRBO.com encompass secluded houseboat and penthouse duplex.
Using this site, For Rent By Owner (FRBO.com), property owners place villa, castle, bungalow, and castle ad directories.
Conceive, originate, and ferret out real estate rentals in Westport, Westport Ireland house rentals, and Westport Ireland holiday rentals.
Kick off your expedition online on Tuesday or tomorrow evening for your vacation rental in Dunmore East Ireland, vacation rentals Dunmore East Ireland, and home rentals in Dunmore East.
Ready to move in beach timeshare and exotic bungalow are contiguous in the abutting county of Dunmore East Ireland.
See resort online MLS, exclusive classified ads, and well appointed online MLS that real estate investors and real estate brokers post on this webpage.
Engage and admit this week to open, originate, and initiate on this course.
Glimpse and come upon rent houses in Westport Ireland and Westport Ireland holiday rentals.
Glimpse, debunk, and discover real estate rentals Limerick, rental home in Limerick Ireland, and house rentals in Limerick.
Observe and relocate for rent by owner homes and Wicklow Ireland home rentals.
|
|
