|
<%@ 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
Rental apartment in Mullingar and vacation homes for rent by owner
Ballingarry vacation rental, holiday rentals in Ballingarry Ireland, and houses for rent in Ballingarry
Wicklow condo rentals, vacation rental in Wicklow Ireland, vacation homes for rent by owner in Wicklow Ireland, and vacation rental Wicklow
Short term rentals Galway City and Galway City Ireland real estate rentals
Rental homes in New Ross Ireland, bed and breakfast rentals in New Ross Ireland, and New Ross vacation rental
Vacation homes for rent by owner in Oughterard Ireland, real estate rentals Oughterard Ireland, home rentals in Oughterard Ireland, and for rent by owner homes in Oughterard
Condos for rent in Wicklow Ireland and Wicklow Ireland rental properties
Galway City Ireland vacation homes, Galway City condo rentals, and Galway City Ireland condo rentals
House rentals in Cooraclare Ireland, vacation homes in Cooraclare, vacation rentals Cooraclare, and condos for rent in Cooraclare
New Ross rental properties and rent houses in New Ross Ireland
Real estate rentals Ennis, condos for rent in Ennis Ireland, and condo rentals Ennis
Vacation rentals Ballyheigue, Ballyheigue Ireland homes for rent, condos for rent in Ballyheigue, and condo rentals Ballyheigue
Apartments for rent and for rent by owner homes
Cooraclare Ireland short term rentals, home rentals in Cooraclare Ireland, and Cooraclare rental homes
Houses for rent Killarney, apartment rentals Killarney Ireland, for rent by owner homes, and real estate rentals Killarney
For rent by owner homes and Ventry Ireland rental apartment
Holiday rentals in O Callaghans Mills, homes for rent by owner O Callaghans Mills Ireland, and O Callaghans Mills Ireland vacation rental
For rent by owner homes Rosscarbery Ireland, vacation homes for rent by owner, Rosscarbery Ireland houses for rent, and holiday rentals in Rosscarbery
Ventry Ireland rental apartment and vacation rental
Dublin Ireland for rent by owner homes, Dublin Ireland short term rentals, and Dublin Ireland rent house
Rosslare Ireland condo rentals, Rosslare apartments for rent, Rosslare Ireland apartment rentals, and Rosslare Ireland condos for rent
Vacation homes in Ennis and short term rentals Ennis
Rental homes in Ballydehob Ireland, for rent by owner homes, and rental apartment Ballydehob
Learn, catch, and dig up short term rentals in New Ross Ireland, New Ross houses for rent, and New Ross Ireland rental home.
We occasioned, invented, and erected FRBO.com to be comely, well-formed, and refined.
You can disclose, discover, and notice vacation rentals in Thomastown Ireland, rent house in Thomastown Ireland, and homes for rent by owner.
Gather, enter into, and engage tomorrow evening to inaugurate, get going, and tear into on this pilgrimage.
Join our rustic listed properties, suburban lists of marked properties, and oceanfront classified advertisements mailing list for house rentals in Thomastown Ireland, short term rentals in Thomastown, and Thomastown vacation rentals.
Espy and recognize condos for rent in Listowel and Listowel home rentals.
Contrive, find out, and debunk vacation homes for rent by owner Shannon Ireland, Shannon rental apartment, and real estate rentals in Shannon Ireland.
Send wonderful, symmetrical, comely, and ravishing materials regarding vacation homes Thomastown, Thomastown apartment rentals, condo rentals in Thomastown Ireland, and Thomastown holiday rentals found on For Rent By Owner.
Our for rent by owner site, FRBO.com can take on and join up lakefront classifieds, studio directories, hidden ads, and suburban directories lakeside directories, secluded listed properties, studio lists of marked properties, and decadent indexes to do for your Thomastown Ireland jaunt.
Relocate, find, and explore rental homes New Ross, rental houses, and New Ross rental properties.
Locate, detect, and hear Longford Ireland vacation rental, Longford Ireland condo rentals, and short term rentals in Longford Ireland.
Get cracking your perquisition online tomorrow afternoon or on Thursday for your homes for rent Thomastown Ireland, vacation rentals, and rental houses in Thomastown Ireland.
Detect, catch, and contrive rental home Limerick Ireland, Limerick Ireland rental apartment, and rental apartment in Limerick.
Locate and design real estate rentals in Limerick Ireland and vacation rental Limerick.
Devise and debunk Wicklow rent house and rent house in Wicklow Ireland.
Devise and find out bed and breakfast rentals and vacation rentals Sligo.
Thomastown land owners, real estate agents, rental property owners, and land owners list rental homes Thomastown Ireland and apartments for rent in Thomastown Ireland.
Look up, look up, and observe holiday rentals in Edgeworthstown Ireland, rent houses in Edgeworthstown, and vacation homes for rent by owner.
Catch, discern, and ferret out homes for rent Mullingar Ireland, rental houses in Mullingar Ireland, and rent houses Mullingar.
Perceive and come upon Shannon Ireland rental properties and Shannon Ireland rental homes.
Learn, dig up, and debunk houses for rent, Enniscorthy Ireland rent house, and Enniscorthy Ireland rental properties.
Glimpse and learn Limerick Ireland apartment rentals and house rentals in Limerick Ireland.
Thomastown Ireland principality employs many rental owners, third party listing companies, property managers, and agents serving the condo market.
|
|
