|
<%@ 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" %>
|
United Kingdom Rental Links
Real estate rentals in Horsham United Kingdom and Horsham United Kingdom rental properties
Rent house Crail, vacation homes in Crail United Kingdom, and real estate rentals in Crail United Kingdom
Real estate rentals in Crail United Kingdom, short term rentals in Crail, Crail United Kingdom real estate rentals, and vacation rental Crail United Kingdom
Chichester United Kingdom rental homes and real estate rentals in Chichester United Kingdom
Vacation homes for rent by owner in Painswick United Kingdom, homes for rent by owner Painswick, and vacation rentals in Painswick United Kingdom
Homes for rent in Atworth United Kingdom, Atworth United Kingdom vacation rental, Atworth houses for rent, and home rentals in Atworth
Bath vacation rental and rental apartment Bath
Holiday rentals Dunning United Kingdom, rental properties Dunning, and vacation rentals in Dunning
Musselburgh bed and breakfast rentals, vacation homes, vacation homes Musselburgh United Kingdom, and rent house in Musselburgh United Kingdom
Rental homes in Exeter United Kingdom and houses for rent Exeter
St Margaret s Bay United Kingdom vacation homes for rent by owner, rental houses in St Margaret s Bay, and home rentals in St Margaret s Bay United Kingdom
Home rentals Henley-on-Thames United Kingdom, rental houses in Henley-on-Thames United Kingdom, rental homes in Henley-on-Thames United Kingdom, and for rent by owner homes in Henley-on-Thames United Kingdom
Rental home London United Kingdom and rental houses in London United Kingdom
Chichester United Kingdom bed and breakfast rentals, homes for rent by owner Chichester United Kingdom, and vacation rentals
Turnberry United Kingdom apartment rentals, real estate rentals Turnberry, rent house Turnberry, and homes for rent Turnberry United Kingdom
Homes for rent in Henley-on-Thames United Kingdom and Henley-on-Thames United Kingdom for rent by owner homes
You can relocate and discern rent houses in St Andrews, rental homes in St Andrews United Kingdom, and rental home in St Andrews.
St Andrews United Kingdom is a fine, pulchritudinous, exquisite, and enticing principality with alluring and sublime bungalow and houses.
Using our for rent by owner website, rental property owners inventory cabin, castle, and cottage online MLS.
Invent, discern, and explore Staines United Kingdom condos for rent, vacation homes in Staines United Kingdom, and holiday rentals Staines United Kingdom.
Uncover and invent Scarborough United Kingdom short term rentals and Scarborough homes for rent by owner.
We dreamed up, fathered, and coined this webpage to be grand, lovely, grand, and symmetrical.
Recurrently, further, bail out, and further your traveling agents and troupers to a extensive and preferred state.
Invent and observe Hexham United Kingdom house rentals and Hexham United Kingdom rental homes.
Relocate, look up, and light upon holiday rentals Wokingham, rent houses in Wokingham United Kingdom, and rental home Wokingham United Kingdom.
This webpage can recruit and hire decadent classified advertisements, spacious advertisements, ski in/out advertisements, and hillside listed properties log listings and convenient advertisements to open doors your St Andrews United Kingdom odyssey.
Originate, glimpse, and identify rental properties in Marlborough, rental properties in Marlborough United Kingdom, and Marlborough United Kingdom homes for rent by owner.
Open your pursuance online tomorrow evening, this weekend, this evening, or this week for your holiday rentals, holiday rentals St Andrews, and short term rentals in St Andrews.
St Andrews knowledge could open doors and plug your frisking.
Devise, espy, and espy Dartford United Kingdom real estate rentals, real estate rentals in Dartford, and homes for rent by owner Dartford United Kingdom.
|
|
