|
<%@ 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
Vacation homes for rent by owner in Gort Ireland and vacation rentals Gort Ireland
Real estate rentals in Letterkenny, apartment rentals Letterkenny Ireland, and short term rentals Letterkenny Ireland
Home rentals in Thomastown Ireland, Thomastown vacation rentals, rental houses in Thomastown, and bed and breakfast rentals
Ventry short term rentals and home rentals in Ventry Ireland
House rentals in O Callaghans Mills Ireland, homes for rent, and home rentals in O Callaghans Mills Ireland
Homes for rent Mount Nugent Ireland, rent houses in Mount Nugent Ireland, vacation rentals Mount Nugent Ireland, and homes for rent
Holiday rentals in Ballydehob and Ballydehob Ireland short term rentals
Cooraclare Ireland rent houses, Cooraclare Ireland holiday rentals, and home rentals in Cooraclare
Rental apartment Ballinskelligs, Ballinskelligs Ireland for rent by owner homes, Ballinskelligs vacation rentals, and apartments for rent in Ballinskelligs Ireland
Apartment rentals Lahinch Ireland and short term rentals in Lahinch Ireland
Thomastown apartments for rent, rental homes in Thomastown Ireland, and real estate rentals
Clonakilty Ireland apartment rentals, condos for rent in Clonakilty, rental properties in Clonakilty Ireland, and Clonakilty Ireland rent houses
House rentals in Kilkerrin Ireland and for rent by owner homes Kilkerrin Ireland
Condo rentals Dingle, Dingle Ireland houses for rent, and apartments for rent
Vacation homes for rent by owner in Liscannor, vacation homes Liscannor Ireland, rental houses in Liscannor Ireland, and Liscannor Ireland vacation homes
This website, FRBO.com can incorporate and inscribe private advertisements and private listed properties log listings, rustic classified ads, private ads, and penthouse online MLS to assist your Cooraclare Ireland transmigration.
You can quest the hidden listed properties and lakeside advertisements under vacation rentals Cooraclare Ireland, for rent by owner homes, and apartment rentals in Cooraclare Ireland.
See loft classified advertisements and waterfront ad directories that property agents and town home owners post on this site, FRBO.com.
Join our ski in/out ads, spacious ads, lakeside classified ads, and loft listings mailing list for Cooraclare Ireland rental homes and Cooraclare Ireland apartments for rent.
Dig up, relocate, and find rent houses in Dublin Ireland, rental apartment in Dublin Ireland, and houses for rent Dublin Ireland.
The Cooraclare Ireland directories manifested and catalogued on this site, FRBO.com enclose hillside bungalow, secluded townhouse, oceanfront cottage, and suburban lodge.
Voyagers and confreres who are casing about bed and breakfast rentals in Cooraclare and are trying to notice Cooraclare Ireland homes for rent, Cooraclare vacation rental, and rental home Cooraclare Ireland can chase after our for rent by owner website and our exotic ads, beach classified ads, log advertisements, and romantic indexes.
You can devise, relocate, and ascertain rental home in Cooraclare Ireland, Cooraclare Ireland apartments for rent, and houses for rent Cooraclare Ireland.
Debunk, distinguish, and discover Waterford Ireland holiday rentals, Waterford Ireland rental homes, and condo rentals in Waterford.
Expeditionists, professors, and habitants who are wishing to ascertain and contrive or simply contrive information can use this extensive website, FRBO.com.
Cooraclare property managers, agents serving the condo market, rental agents, and rental property owners list Cooraclare home rentals, Cooraclare Ireland bed and breakfast rentals, rental properties Cooraclare, and Cooraclare rental home.
Ferret out, detect, and glimpse apartment rentals in Letterkenny Ireland, Letterkenny vacation homes for rent by owner, and houses for rent in Letterkenny Ireland.
Uncover, recognize, and identify Shannon Ireland rent houses, Shannon homes for rent by owner, and Shannon Ireland condos for rent.
Espy and notice bed and breakfast rentals in Westport Ireland and house rentals Westport Ireland.
|
|
