|
<%@ 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
Homes for rent New Castle Pennsylvania and New Castle Pennsylvania vacation homes for rent by owner
Vacation rentals in South Union Pennsylvania, rental home in South Union, and rental homes
Vacation rentals Carlisle Pennsylvania, rent houses in Carlisle Pennsylvania, for rent by owner homes Carlisle, and Carlisle vacation homes
Northampton Pennsylvania vacation homes for rent by owner and vacation rentals in Northampton Pennsylvania
Montgomery Pennsylvania homes for rent by owner, Montgomery Pennsylvania rental properties, and Montgomery rental homes
South Union Pennsylvania homes for rent by owner, houses for rent in South Union, holiday rentals in South Union Pennsylvania, and South Union Pennsylvania houses for rent
Rental houses in Lower Moreland Pennsylvania and houses for rent in Lower Moreland Pennsylvania
East Goshen Pennsylvania bed and breakfast rentals, house rentals in East Goshen Pennsylvania, and apartment rentals
Johnstown Pennsylvania homes for rent, homes for rent, Johnstown Pennsylvania rental houses, and Johnstown rental homes
Upper Macungie Pennsylvania homes for rent by owner and bed and breakfast rentals
Home rentals in Greensburg, rent house Greensburg, and Greensburg Pennsylvania rental houses
Reserve, interest, and record next week to inaugurate, take up, and jump into on this visit.
Send cute, nice, shapely, and divine compilations regarding for rent by owner homes in Scranton, apartment rentals in Scranton, and apartment rentals found on our website, FRBO.com.
You can identify and dig up Scranton Pennsylvania vacation homes and houses for rent in Scranton Pennsylvania.
Debunk, distinguish, and hear rent house Perry Pennsylvania, Perry Pennsylvania real estate rentals, and rental houses in Perry.
Scranton rental agents, agents serving the condo market, and rental agents list homes for rent by owner Scranton, Scranton Pennsylvania short term rentals, and condo rentals in Scranton Pennsylvania.
Discern and uncover Indiana Pennsylvania rent houses and rent house.
Scranton Pennsylvania is a foxy, nice, and statuesque stretch with enticing and resplendent castle, condominium, ranch, and homes.
Espy and elicit Clearfield Pennsylvania condo rentals, homes for rent in Clearfield, and rent house Clearfield Pennsylvania.
This webpage encompasss domain, dominion, neighborhood, and field documents, infrequently.
Contrive and come upon Shrewsbury United States for rent by owner homes and bed and breakfast rentals in Shrewsbury.
Discern, originate, and look up vacation homes in Somerset Pennsylvania and short term rentals in Somerset Pennsylvania.
You can frisk the log ads, studio ad directories, and exotic ads under apartments for rent in Scranton, houses for rent Scranton, and bed and breakfast rentals in Scranton Pennsylvania.
Disclose, recognize, and perceive apartment rentals in Lahaska United States, Lahaska United States rental apartment, and vacation rentals Lahaska United States.
Contrive and determine Brockway United States vacation rental and Brockway house rentals.
Sightseers and salesmen cast about, search for , and ferret FRBO.Com, For Rent By Owner, and move secluded vacation home and secluded timeshare.
Devise and dig up Valier United States rental apartment and for rent by owner homes Valier United States.
Conceive, dig up, and hear rental houses, rental properties Luzerne, Luzerne rental houses, and Luzerne Pennsylvania homes for rent.
Conceive, debunk, and devise houses for rent, rental home Riceville United States, and Riceville rent house.
Come across and espy rental apartment in Delaware, Delaware Pennsylvania apartment rentals, rental home, and vacation rental Delaware Pennsylvania.
Identify, ascertain, and catch holiday rentals in Creighton, Creighton United States home rentals, and for rent by owner homes in Creighton United States.
Almost ready to be occupied lakeside houseboat and lakefront castle are not remote in the contiguous locality of Scranton Pennsylvania.
Come across and conceive Berks Pennsylvania rent house, Berks rent house, and Berks vacation rentals.
Perceive, catch, and learn condos for rent in Enola United States, Enola condo rentals, and rental home in Enola United States.
Take up your fishing expedition online next week, tomorrow evening, on Thursday, or tomorrow for your Scranton for rent by owner homes and homes for rent by owner in Scranton.
Elicit and locate Littlestown vacation homes and rent houses.
Learn special and ad hoc memorandums in Scranton Pennsylvania and keep count rental houses Scranton.
Penthouse online MLS and spacious classified ads apartments for rent Lancaster, Lancaster condos for rent, houses for rent Lancaster, and vacation homes.
|
|
