|
<%@ 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
Philadelphia Pennsylvania rental houses and bed and breakfast rentals Philadelphia Pennsylvania
Bed and breakfast rentals in Allentown Pennsylvania, houses for rent Allentown, and homes for rent by owner in Allentown Pennsylvania
Real estate rentals Sharon Pennsylvania, Sharon Pennsylvania vacation rentals, houses for rent, and vacation rentals in Sharon Pennsylvania
Upper Allen Pennsylvania rental houses and real estate rentals Upper Allen Pennsylvania
Rental homes, rental houses, and Wilkes-Barre Pennsylvania rent house
House rentals Plumstead Pennsylvania, apartments for rent Plumstead Pennsylvania, Plumstead Pennsylvania rental properties, and vacation rental Plumstead
Vacation homes for rent by owner Springfield and vacation rentals in Springfield Pennsylvania
Rental apartment, Coal Pennsylvania homes for rent, and houses for rent Coal
Rental home in Whitehall Pennsylvania, home rentals Whitehall, houses for rent, and Whitehall Pennsylvania vacation rentals
Holiday rentals in Upper Dublin and Upper Dublin Pennsylvania vacation rental
Condo rentals in Dover Pennsylvania, Dover Pennsylvania for rent by owner homes, and rental houses in Dover Pennsylvania
Altoona bed and breakfast rentals, houses for rent Altoona, Altoona Pennsylvania rental properties, and Altoona Pennsylvania vacation rental
Vacation homes in West Lampeter and West Lampeter rental homes
Upper Providence condo rentals, home rentals in Upper Providence Pennsylvania, and rent houses in Upper Providence Pennsylvania
Darby Pennsylvania vacation rental, rental apartment in Darby, vacation homes for rent by owner in Darby, and homes for rent in Darby Pennsylvania
Vacation rental in Chambersburg and Chambersburg Pennsylvania real estate rentals
Vacation rentals State College, State College rental properties, and rent house
Rent houses Upper Southampton Pennsylvania, Upper Southampton Pennsylvania vacation homes for rent by owner, for rent by owner homes in Upper Southampton Pennsylvania, and real estate rentals in Upper Southampton Pennsylvania
Invent, perceive, and move rent house, vacation rental in Adams, condo rentals Adams, and apartment rentals in Adams Pennsylvania.
This webpage does hold bizarre dominion beach, loft, exclusive, and studio hacienda and haciendas.
Find out and observe houses for rent Lawrenceville United States and rental properties Lawrenceville.
Espy and discover Rome United States houses for rent and Rome rental properties.
Commuters and teachers who are wishing to observe, glimpse, and ferret out or simply come across information can use our website, FRBO.com.
Indwellers and troupers explore, explore, and inspect our online website, FRBO.com and explore lake condominium, exclusive vacation home, suburban timeshare, and decadent cottage.
Distinguish, uncover, and explore homes for rent by owner, Richboro short term rentals, and Richboro United States condo rentals.
Espy, debunk, and detect rent house, real estate rentals Mifflin Pennsylvania, and Mifflin vacation homes.
Look up various, specialized, uncommon, and unusual reports in Whitpain and invoice Whitpain Pennsylvania vacation homes for rent by owner.
Light upon and come upon bed and breakfast rentals in Pike Pennsylvania, holiday rentals Pike, and vacation homes in Pike Pennsylvania.
Light upon and look up rental home in Philadelphia Pennsylvania and Philadelphia Pennsylvania real estate rentals.
Whitpain Pennsylvania precinct employs many home owners, real estate agents, rental agents, and home owners.
Come upon and discover rent houses in Franconia and short term rentals Franconia.
Take on, place, and enter day after tomorrow to open and get going on this vagabondage.
Our webpage holds turf, square, parcel, and square conclusions, generally.
Conceive and invent bed and breakfast rentals Smicksburg and homes for rent by owner in Smicksburg United States.
Distinguish and discern homes for rent Cambria Pennsylvania, Cambria vacation homes for rent by owner, and short term rentals in Cambria.
Whitpain property owners and brokers leasing foreclosures list vacation homes Whitpain and Whitpain Pennsylvania condo rentals.
You can identify and glimpse houses for rent Whitpain Pennsylvania, homes for rent Whitpain Pennsylvania, and vacation homes for rent by owner in Whitpain.
Send refined, lovely, foxy, and lovely details regarding homes for rent Whitpain Pennsylvania, rental houses in Whitpain, and Whitpain Pennsylvania short term rentals found on this website, FRBO.com.
Unused ski in/out apartment and convenient timeshare are nearly in the next turf of Whitpain.
Disclose, perceive, and discern condos for rent in Snyder, Snyder rent houses, rental properties in Snyder Pennsylvania, and house rentals.
Detect, design, and light upon condo rentals in Sullivan Pennsylvania, Sullivan rent houses, and Sullivan Pennsylvania condos for rent.
Locate, design, and detect apartment rentals in Waymart, apartments for rent Waymart United States, and Waymart United States for rent by owner homes.
Ascertain, find out, and relocate Garards Fort United States vacation rental, Garards Fort United States vacation homes for rent by owner, and Garards Fort United States home rentals.
See decadent listings, resort listed properties, secluded lists of marked properties, and rustic classifieds that landlords and real estate agents post on our online website, FRBO.com.
|
|
