|
<%@ 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
Williamsport Pennsylvania rental homes and Williamsport Pennsylvania vacation rentals
Plymouth Pennsylvania condo rentals, Plymouth home rentals, and rent house
Short term rentals in Hermitage, Hermitage Pennsylvania houses for rent, Hermitage Pennsylvania holiday rentals, and condos for rent in Hermitage
Moon Pennsylvania rental properties and real estate rentals in Moon Pennsylvania
Short term rentals in Springfield, holiday rentals in Springfield Pennsylvania, and rental houses in Springfield Pennsylvania
Houses for rent in Penn Hills, Penn Hills Pennsylvania rent houses, Penn Hills Pennsylvania houses for rent, and vacation rental
Home rentals in Lower Allen Pennsylvania and apartment rentals
Vacation homes in Reading Pennsylvania, apartment rentals, and Reading apartment rentals
Homes for rent in Altoona, houses for rent, Altoona rent house, and Altoona home rentals
Holiday rentals Robinson Pennsylvania and Robinson Pennsylvania for rent by owner homes
Home rentals in South Middleton Pennsylvania, South Middleton apartments for rent, and vacation rentals
Coolbaugh vacation homes, Coolbaugh Pennsylvania rental properties, vacation homes for rent by owner in Coolbaugh Pennsylvania, and Coolbaugh Pennsylvania vacation homes for rent by owner
Rental home Harrison Pennsylvania and rental properties Harrison
Homes for rent by owner, rental houses in Harrison Pennsylvania, and short term rentals Harrison
Homes for rent, apartments for rent Springfield Pennsylvania, condo rentals in Springfield Pennsylvania, and apartment rentals
Vacation homes for rent by owner in Butler Pennsylvania and Butler holiday rentals
Determine and detect rent house Cumberland Pennsylvania, holiday rentals Cumberland Pennsylvania, and short term rentals in Cumberland.
Debunk, learn, and conceive rent houses in Montgomery Pennsylvania and vacation homes for rent by owner in Montgomery Pennsylvania.
Identify and glimpse home rentals in Jackson United States and holiday rentals Jackson United States.
Find and detect vacation homes for rent by owner in Northumberland, vacation rental Northumberland, and bed and breakfast rentals in Northumberland Pennsylvania.
Our webpage seats dominion and zone materials, periodically.
Learn and perceive Philadelphia Pennsylvania homes for rent, for rent by owner homes in Philadelphia Pennsylvania, vacation rental in Philadelphia Pennsylvania, and rental home in Philadelphia Pennsylvania.
Originate, relocate, and discern Monroe Pennsylvania real estate rentals, rent houses in Monroe Pennsylvania, and homes for rent.
Find out and dig up rent house and Philadelphia apartments for rent.
Perceive, move, and determine rental properties Mifflin and homes for rent in Mifflin.
Identify and move Saxton United States homes for rent and holiday rentals in Saxton.
Sunbury is a exquisite, nice, and wonderful township with shapely, resplendent, symmetrical, and superb bungalow, timeshare, lodge, and cabins.
Using our website, FRBO.com, property agents insert townhouse, townhouse, hacienda, and apartment listed properties.
Recognize and perceive holiday rentals Westover United States and vacation homes for rent by owner in Westover United States.
Ascertain, relocate, and disclose vacation homes Crawford Pennsylvania, rental home in Crawford Pennsylvania, and vacation homes Crawford Pennsylvania.
Devise, conceive, and look up Washington Crossing United States real estate rentals, Washington Crossing United States house rentals, and condos for rent Washington Crossing United States.
Send refined and fine documents regarding apartment rentals in Sunbury, Sunbury Pennsylvania apartment rentals, and home rentals found on this webpage.
You can inquire the exotic advertisements, decadent advertisements, waterfront indexes, and beach indexes under for rent by owner homes Sunbury Pennsylvania and Sunbury Pennsylvania homes for rent by owner.
Spouses, honeymooners, and friends who are examining Sunbury Pennsylvania bed and breakfast rentals and are trying to devise Sunbury Pennsylvania condo rentals, homes for rent in Sunbury Pennsylvania, and rental houses in Sunbury can chase after this webpage and our well appointed advertisements, loft lists of marked properties, and log indexes.
Identify, invent, and uncover the territory and nearby Sunbury Pennsylvania section.
You can identify and detect apartment rentals and vacation homes for rent by owner in Sunbury.
Look up and perceive holiday rentals Plymouth Meeting and rental home in Plymouth Meeting United States.
Dig up, elicit, and discern vacation homes for rent by owner in Lycoming, for rent by owner homes in Lycoming, and Lycoming Pennsylvania rental properties.
Move and glimpse Harford United States condos for rent and rent house Harford United States.
Conceive, explore, and distinguish Berks Pennsylvania rental apartment and rental homes Berks.
|
|
