|
<%@ 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
Oughterard rental home and apartments for rent Oughterard
Ballyheigue Ireland real estate rentals, Ballyheigue Ireland home rentals, and holiday rentals Ballyheigue
Rosscarbery Ireland rental properties, Rosscarbery Ireland bed and breakfast rentals, holiday rentals in Rosscarbery Ireland, and Rosscarbery bed and breakfast rentals
Mullingar Ireland apartments for rent and rent houses Mullingar
Vacation rental, rental home O Callaghans Mills, and O Callaghans Mills rental properties
Killarney homes for rent by owner, Killarney Ireland house rentals, for rent by owner homes in Killarney, and rental apartment Killarney
Letterkenny Ireland rental houses and apartment rentals Letterkenny
Ballyheigue Ireland rental homes, rental home in Ballyheigue Ireland, and vacation homes in Ballyheigue Ireland
Kilkerrin rental houses, home rentals in Kilkerrin, Kilkerrin Ireland vacation homes for rent by owner, and condos for rent in Kilkerrin Ireland
House rentals Kenmare Ireland and Kenmare Ireland rental houses
Bantry Ireland apartments for rent, Bantry homes for rent by owner, and bed and breakfast rentals
Bed and breakfast rentals in Bell Harbour Ireland, Bell Harbour Ireland homes for rent, Bell Harbour Ireland houses for rent, and Bell Harbour Ireland short term rentals
Homes for rent in Ardmore and house rentals Ardmore Ireland
Vacation rental in Renvyle, rental homes in Renvyle Ireland, and house rentals in Renvyle Ireland
Rental homes Tipperary Ireland, Tipperary Ireland rental homes, rental apartment in Tipperary Ireland, and Tipperary rent house
Waterville Ireland rental homes and Waterville houses for rent
Dunmore East Ireland houses for rent, vacation homes, and vacation rental in Dunmore East Ireland
Liscannor condo rentals, Liscannor homes for rent, Liscannor Ireland for rent by owner homes, and bed and breakfast rentals Liscannor
Rental home Mullingar Ireland and vacation homes for rent by owner in Mullingar Ireland
Home rentals in Castleisland Ireland, Castleisland apartment rentals, and Castleisland Ireland rental apartment
Dig up, identify, and locate holiday rentals Westport, Westport for rent by owner homes, and Westport Ireland house rentals.
Distinguish and dig up Bantry Ireland rental properties and Bantry Ireland vacation homes.
Draft, enter into, levy, and reserve tomorrow morning to open, open, and open on this venture.
Riverstown stretch employs many property agents, home owners, town home owners, and property managers.
Hikers and boarders frisk, quest, and scour this site, FRBO.com and learn lake duplex and exotic townhouse.
Move and come across homes for rent by owner Longford Ireland and bed and breakfast rentals in Longford.
Riverstown info could run interference, run interference, support, and bail out your pursuing.
Discover various, uncommon, and other details in Riverstown Ireland and place real estate rentals in Riverstown Ireland.
Light upon and discern Enniscorthy Ireland home rentals and Enniscorthy Ireland vacation rentals.
Tenants and globetrotters who are hunting for short term rentals in Riverstown and are trying to come across Riverstown Ireland real estate rentals, houses for rent Riverstown Ireland, and Riverstown Ireland holiday rentals can probe FRBO.Com, For Rent By Owner, and our romantic listings, rustic classified advertisements, waterfront ads, and convenient ad directories.
Empty studio home, beach lodge, penthouse bungalow, and spacious houseboat are not faraway in the nearest parcel of Riverstown Ireland.
Design, explore, and identify the domain and not far away Riverstown Ireland locality.
We concocted, established, and built For Rent By Owner to be splendid and graceful.
Begin your quest online tomorrow morning, in the next few days, tomorrow afternoon, or now for your holiday rentals in Riverstown Ireland and rental apartment in Riverstown.
|
|
