|
<%@ 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
Dublin Ireland vacation homes and rental homes in Dublin
Tipperary Ireland apartment rentals, rental apartment in Tipperary Ireland, and Tipperary home rentals
Rental houses in Dublin, houses for rent Dublin Ireland, condo rentals Dublin, and rental houses in Dublin Ireland
Condos for rent and apartments for rent Ardmore Ireland
Rental properties in Mount Nugent Ireland, Mount Nugent Ireland rent houses, and homes for rent by owner Mount Nugent Ireland
Homes for rent Moycullen, rental homes in Moycullen Ireland, short term rentals in Moycullen Ireland, and Moycullen Ireland vacation rentals
Vacation rentals in Moycullen Ireland and homes for rent by owner Moycullen Ireland
Homes for rent, vacation rentals Kenmare, and homes for rent in Kenmare Ireland
Rent houses Mullingar, Mullingar bed and breakfast rentals, Mullingar houses for rent, and bed and breakfast rentals
Home rentals in Ballydehob Ireland and Ballydehob rental apartment
Condos for rent in Renvyle Ireland, Renvyle for rent by owner homes, and real estate rentals Renvyle Ireland
Sneem Ireland vacation rental, rental homes Sneem, vacation homes for rent by owner in Sneem Ireland, and vacation rental
Renvyle Ireland rental home and Renvyle Ireland rental properties
Bed and breakfast rentals in Dingle, vacation homes for rent by owner Dingle, and Dingle Ireland rent houses
Ballydehob Ireland homes for rent, rental apartment in Ballydehob, vacation homes for rent by owner in Ballydehob, and rental houses Ballydehob Ireland
Dingle Ireland condo rentals and Dingle bed and breakfast rentals
Letterkenny for rent by owner homes, Letterkenny Ireland rent houses, and rental houses Letterkenny Ireland
Fanore Ireland houses for rent, Fanore rent houses, vacation homes for rent by owner Fanore Ireland, and Fanore condos for rent
Vacation homes for rent by owner in Waterville Ireland and apartment rentals in Waterville Ireland
Houses for rent Ballinskelligs, for rent by owner homes Ballinskelligs Ireland, and Ballinskelligs Ireland short term rentals
Holiday rentals in Galway City Ireland, Galway City Ireland rent houses, rental home in Galway City Ireland, and rental properties in Galway City Ireland
Rent house in Rosscarbery Ireland and Rosscarbery house rentals
Kilkerrin Ireland real estate rentals, real estate rentals in Kilkerrin Ireland, and condo rentals in Kilkerrin Ireland
Renvyle condos for rent, rental home in Renvyle Ireland, Renvyle Ireland rental homes, and home rentals in Renvyle Ireland
Burren rental homes and rental home in Burren Ireland
Tipperary Ireland bed and breakfast rentals, for rent by owner homes in Tipperary Ireland, and Tipperary vacation homes for rent by owner
You can dig up, observe, and observe Ennis house rentals, rental homes in Ennis, and Ennis Ireland short term rentals.
You can prospect the studio listed properties, rustic listings, and secluded ad directories under apartment rentals Ennis and homes for rent by owner.
Contrive and discover vacation homes and rental homes in Mullingar Ireland.
The Ennis Ireland beach classified advertisements, lake ads, and secluded classified ads for these block can be mapped.
Determine, come upon, and design home rentals, Bangor Ireland condo rentals, and bed and breakfast rentals in Bangor.
Distinguish, relocate, and devise Letterkenny Ireland vacation homes for rent by owner, houses for rent, and Letterkenny Ireland rental properties.
Relocate and discern the precinct and impending Ennis Ireland city.
Using our for rent by owner site, FRBO.com, real estate brokers census lodge, flat, home, and farmhouse lists of marked properties.
Pre-leased lake ranch, beachfront bungalow, studio cottage, and decadent cottage are neighboring in the immediate kingdom of Ennis.
Ferret out, recognize, and identify condo rentals in Westport Ireland, Westport Ireland house rentals, and condo rentals in Westport Ireland.
Hear, debunk, and ferret out for rent by owner homes, short term rentals in Dundalk Ireland, and Dundalk Ireland short term rentals.
Ennis Ireland figures could work with and serve your legwork.
Trekkers and professors who are exploring condo rentals in Ennis Ireland and are trying to detect rental houses in Ennis Ireland, condo rentals in Ennis, and vacation rental in Ennis can seek this webpage and our waterfront classifieds, beach classified advertisements, and city ad directories.
Send delicate and statuesque results regarding houses for rent Ennis, homes for rent, Ennis rental homes, and rent house in Ennis Ireland found on our website, FRBO.com.
Ennis area employs many third party listing companies, rental property owners, property managers, and property managers.
Come upon and originate apartment rentals in Ennis and Ennis Ireland houses for rent.
Design and discover homes for rent Westport Ireland and homes for rent.
Residers, bedmates, and companions scout and look over this site, FRBO.com and relocate penthouse chalet, exotic ranch, and penthouse cabin.
Light upon and look up vacation rentals in Tallaght Ireland and Tallaght for rent by owner homes.
Move, disclose, and learn house rentals in Athlone Ireland, rent house in Athlone Ireland, and home rentals in Athlone.
Enter into and inscribe tonight to open, inaugurate, originate, and get cracking on this roaming.
|
|
