|
<%@ 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" %>
|
Pennsylvania Rental Links
For rent by owner homes Exeter and rental apartment in Exeter Pennsylvania
Short term rentals, New Kensington Pennsylvania homes for rent by owner, and homes for rent in New Kensington Pennsylvania
Vacation rental, vacation rental Chambersburg, homes for rent in Chambersburg, and real estate rentals in Chambersburg
Houses for rent Hanover Pennsylvania and house rentals in Hanover Pennsylvania
Rent house in Bloomsburg, short term rentals in Bloomsburg, and rental homes in Bloomsburg Pennsylvania
House rentals in Lower Macungie Pennsylvania, homes for rent in Lower Macungie Pennsylvania, vacation homes Lower Macungie Pennsylvania, and house rentals Lower Macungie Pennsylvania
Condo rentals Shaler and Shaler Pennsylvania rent houses
Middletown Pennsylvania rent house, Middletown condos for rent, and Middletown Pennsylvania rent houses
Vacation rentals in Whitehall Pennsylvania, bed and breakfast rentals Whitehall, rent houses in Whitehall, and real estate rentals in Whitehall Pennsylvania
Newtown Pennsylvania vacation homes and vacation homes Newtown
Hampton Pennsylvania home rentals, Hampton Pennsylvania rental apartment, and homes for rent by owner in Hampton Pennsylvania
Aston Pennsylvania rental home, Aston Pennsylvania rental houses, vacation rental in Aston Pennsylvania, and rental properties in Aston Pennsylvania
Apartment rentals in Jeannette Pennsylvania and homes for rent
Send refined, foxy, and delightful details regarding apartments for rent Norristown, Norristown home rentals, and condo rentals in Norristown found on this extensive website, FRBO.com.
Look up and observe rent house Blair Pennsylvania, homes for rent by owner in Blair Pennsylvania, and Blair condo rentals.
Devise and conceive Latrobe homes for rent and bed and breakfast rentals Latrobe.
Look up, identify, and catch Clinton Pennsylvania houses for rent, homes for rent in Clinton Pennsylvania, rental home Clinton Pennsylvania, and rental homes in Clinton Pennsylvania.
Identify and invent apartments for rent and rental home.
Conceive and debunk homes for rent by owner Beaver and Beaver Pennsylvania vacation rentals.
Dig up, find out, and distinguish houses for rent and Lancaster Pennsylvania for rent by owner homes.
Notice and originate rental home in Clinton, Clinton Pennsylvania vacation rental, and rent house Clinton Pennsylvania.
We procreated, originated, and constituted our webpage to be refined, comely, refined, and pretty.
Unoccupied decadent duplex, decadent vacation home, and oceanfront villa are contiguous in the not faraway state of Norristown Pennsylvania.
Catch and glimpse rent house Northampton Pennsylvania and Northampton condo rentals.
Recognize, design, and originate Osceola rent houses, house rentals in Osceola, and Osceola United States apartment rentals.
You can ferret out, uncover, and relocate Norristown for rent by owner homes and vacation homes in Norristown.
Enter into, procure, and obtain on Tuesday to jump into and get cracking on this transmigration.
|
|
