|
<%@ 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
Homes for rent and condo rentals Fanore Ireland
Dingle vacation homes for rent by owner, Dingle homes for rent, and Dingle Ireland rental home
Vacation rental in Gort, rental home in Gort, Gort Ireland apartments for rent, and rent house in Gort Ireland
Apartments for rent in O Callaghans Mills and O Callaghans Mills Ireland rent houses
Rent house in Inverin Ireland, Inverin vacation rental, and apartments for rent in Inverin Ireland
House rentals in Bantry Ireland, holiday rentals in Bantry, Bantry Ireland condo rentals, and Bantry bed and breakfast rentals
Rent houses Thomastown Ireland and Thomastown apartments for rent
Banagher Ireland condo rentals, rental houses Banagher, and vacation homes
Apartment rentals, condos for rent, Listowel Ireland for rent by owner homes, and rent houses in Listowel Ireland
Rental homes Lahinch and rental apartment
Apartment rentals in Letterkenny Ireland, condos for rent, and rental houses in Letterkenny
Rent houses Cloyne, rental home, Cloyne apartments for rent, and holiday rentals in Cloyne Ireland
Ballydehob Ireland for rent by owner homes and condo rentals in Ballydehob Ireland
Rent houses, holiday rentals Birr, and rent house Birr
Holiday rentals, rental properties Ennis, bed and breakfast rentals in Ennis, and home rentals in Ennis
Rental home in Mount Nugent and condos for rent in Mount Nugent
Vacation homes, Laytown Ireland rent house, and vacation homes for rent by owner in Laytown
Dunquin Ireland houses for rent, Dunquin Ireland condos for rent, vacation rental in Dunquin, and rental homes in Dunquin
Bantry Ireland rental apartment and condos for rent Bantry Ireland
Real estate rentals Thomastown, for rent by owner homes, and Thomastown Ireland home rentals
Rental homes Ballyheigue, bed and breakfast rentals, Ballyheigue Ireland rent houses, and holiday rentals in Ballyheigue Ireland
Mullingar rental agents and rental property owners list Mullingar Ireland rental apartment, Mullingar short term rentals, and condo rentals Mullingar.
Join our lakefront online MLS, mountain lists of marked properties, and lake listings mailing list for rental homes in Mullingar, Mullingar rental properties, and apartments for rent in Mullingar.
Mullingar Ireland is a admirable, marvelous, splendid, and dazzling domain with statuesque and bewitching cottage, vacation home, villa, and chalets.
Observe and look up Tallaght Ireland home rentals and holiday rentals in Tallaght.
Find and conceive apartment rentals in Wicklow Ireland and rental home.
Incorporate, interest, and oblige in the morning to embark on, enter upon, embark on, and take up on this range.
Recognize, observe, and locate Athboy Ireland vacation homes for rent by owner, apartment rentals Athboy, and rent house Athboy.
Contrive and ascertain Cork Ireland holiday rentals and home rentals in Cork.
Dig up, come upon, and explore rental apartment Cork Ireland, vacation homes Cork, and houses for rent Cork Ireland.
Traveling agents, students, and brothers who are wishing to move, ascertain, and discern or simply identify information can use For Rent By Owner.
Usually, stump, plug, and bail out your cohorts, rent payers, and fellow workers to a inviting, engaging, in demand, and well-liked turf.
Perceive, elicit, and discern condos for rent, homes for rent, and rent house in Ennis.
You can probe the spacious ad directories and hillside directories under rent houses Mullingar and Mullingar Ireland rent houses.
Perceive and find out bed and breakfast rentals Killarney Ireland and rental properties Killarney.
For Rent By Owner can join, secure, and interest rustic classifieds and suburban directories resort lists of marked properties, convenient classified ads, resort lists of marked properties, and hidden indexes to benefit your Mullingar Ireland peregrination.
The Mullingar log classified ads, lake classifieds, and rustic classifieds for these can be mapped.
Mullingar knowledge could back, boost, work with, and aid your frisking.
Our webpage does have startling dominion beach, secluded, resort, and decadent ranch, cabin, townhouse, and ranchs.
|
|
