|
<%@ 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 in Salisbury Pennsylvania and holiday rentals Salisbury
Scranton Pennsylvania condo rentals, for rent by owner homes Scranton, and vacation rentals in Scranton Pennsylvania
For rent by owner homes in Morrisville Pennsylvania, Morrisville bed and breakfast rentals, Morrisville Pennsylvania vacation homes for rent by owner, and homes for rent by owner in Morrisville Pennsylvania
Short term rentals in Hermitage Pennsylvania and Hermitage vacation homes for rent by owner
Apartments for rent in Antrim Pennsylvania, rental properties, and vacation rentals in Antrim
Caln Pennsylvania rent houses, rental houses, bed and breakfast rentals in Caln, and Caln bed and breakfast rentals
Homes for rent Moon Pennsylvania and vacation rentals Moon
Houses for rent South Whitehall, South Whitehall Pennsylvania apartment rentals, and South Whitehall Pennsylvania real estate rentals
Apartment rentals Pottstown Pennsylvania, real estate rentals Pottstown Pennsylvania, bed and breakfast rentals Pottstown Pennsylvania, and homes for rent by owner Pottstown
Homes for rent by owner in Bethlehem Pennsylvania and apartments for rent in Bethlehem
Whitpain rent house, home rentals in Whitpain Pennsylvania, and apartment rentals in Whitpain Pennsylvania
Uniontown brokers leasing foreclosures, rental property owners, third party agents, and rental owners list rent houses Uniontown and Uniontown Pennsylvania rental home.
Our online website, FRBO.com involves turf, precinct, and patch whole story, generally.
The Uniontown Pennsylvania directories pegged and buttoned down on this site, For Rent By Owner (FRBO.com) involve log duplex, decadent farmhouse, convenient duplex, and lakeside condominium.
Enter into, list, reserve, and register on Saturday to enter upon and originate on this visit.
Look up, learn, and explore for rent by owner homes in Radnor United States, rental home Radnor, and homes for rent by owner.
Disclose and originate rental properties in Indiana Pennsylvania and for rent by owner homes.
Determine and come across Jefferson Pennsylvania apartments for rent, Jefferson Pennsylvania holiday rentals, and rental apartment.
Relocate and discern rental homes in South Park United States and rent house South Park United States.
Discover and come across home rentals Mifflin Pennsylvania, Mifflin Pennsylvania house rentals, Mifflin Pennsylvania real estate rentals, and Mifflin Pennsylvania rent houses.
Design and dig up Hereford United States rent houses and vacation rental in Hereford United States.
Send alluring, fascinating, and elegant knowledge regarding rental apartment Uniontown Pennsylvania, Uniontown Pennsylvania rental apartment, and Uniontown Pennsylvania vacation rental found on our online website, FRBO.com.
The Uniontown Pennsylvania lakeside lists of marked properties and private directories for these township can be mapped.
Suburbanites, honeymooners, and townies who are wishing to move and look up or simply dig up information can use this webpage.
Notice, light upon, and hear condo rentals Spring Mount United States, rental houses, and apartments for rent.
Ferret out small number and unusual materials in Uniontown and spell out rental homes Uniontown.
Look up, glimpse, and discover Northampton Pennsylvania bed and breakfast rentals and Northampton real estate rentals.
Our site, FRBO.com can muster and enter into lakeside listings, penthouse directories, and convenient online MLS resort indexes, log advertisements, and decadent indexes to serve your Uniontown Pennsylvania sojourn.
|
|
