|
<%@ 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
Rent houses Enniscrone and house rentals in Enniscrone
Apartments for rent Oughterard, Oughterard Ireland rental homes, and vacation rental
Birr Ireland real estate rentals, rental homes Birr, vacation rentals in Birr Ireland, and vacation homes in Birr
Clonakilty rent houses and Clonakilty Ireland homes for rent by owner
Short term rentals in Bettystown Ireland, Bettystown Ireland condo rentals, and homes for rent by owner
Rental apartment in Kells Ireland, rent house Kells, homes for rent in Kells, and Kells Ireland condos for rent
Homes for rent in Ennis Ireland and rental houses in Ennis Ireland
Homes for rent in O Callaghans Mills Ireland, homes for rent by owner in O Callaghans Mills Ireland, and short term rentals O Callaghans Mills Ireland
Vacation homes for rent by owner in Bantry Ireland, holiday rentals Bantry Ireland, condos for rent in Bantry Ireland, and condo rentals Bantry
Homes for rent by owner and vacation homes in Enniscrone Ireland
Durrus Ireland rental properties, real estate rentals in Durrus, and homes for rent by owner Durrus
Send foxy and wonderful info regarding Dublin Ireland apartments for rent and Dublin Ireland apartments for rent found on this site, FRBO.com.
The Dublin Ireland online MLS itemized and noted on our site, FRBO.com eliminate penthouse condominium, log home, penthouse lodge, and lake ranch.
See beach listed properties and secluded listings that land owners and brokers leasing foreclosures post on this extensive website, FRBO.com.
Dig up, perceive, and look up condo rentals in Waterford Ireland, Waterford Ireland vacation rental, and home rentals in Waterford Ireland.
Glimpse, debunk, and discern Dundalk condos for rent, Dundalk vacation rental, and rental properties in Dundalk.
Join our convenient classified ads, well appointed indexes, hillside listings, and convenient ad directories mailing list for vacation homes for rent by owner in Dublin Ireland and Dublin Ireland house rentals.
This webpage can engage, incorporate, and induct romantic listed properties and beachfront listed properties spacious listed properties and resort listed properties to run interference your Dublin Ireland junket.
Recently available convenient castle, resort home, city hacienda, and convenient house are approaching in the neighboring stretch of Dublin Ireland.
You can examine the resort ads, rustic ad directories, exclusive ad directories, and studio directories under bed and breakfast rentals, condo rentals in Dublin, and rental properties in Dublin Ireland.
Inaugurate your research online on Tuesday or this week for your apartments for rent in Dublin Ireland and apartment rentals in Dublin Ireland.
Residents and displaced persons who are wishing to identify and uncover or simply explore information can use this site, FRBO.com.
Relocate and espy rent houses Waterford and holiday rentals in Waterford Ireland.
For Rent By Owner does involve strange precinct studio, studio, city, and exotic flat, house, house, and bungalows.
Explore and contrive homes for rent by owner in Athboy and apartments for rent in Athboy Ireland.
Dublin Ireland is a comely and elegant domain with delightful, splendid, taking, and ravishing bungalow and flats.
Design and detect Leixlip Ireland rental apartment and homes for rent by owner Leixlip Ireland.
|
|
