|
<%@ 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
Holiday rentals in Wilkinsburg Pennsylvania and for rent by owner homes
Pottsville Pennsylvania rental houses, rental properties Pottsville, and apartments for rent in Pottsville
Chester Pennsylvania bed and breakfast rentals, rent houses in Chester, Chester Pennsylvania houses for rent, and vacation rental in Chester Pennsylvania
Real estate rentals in South Fayette Pennsylvania and rental homes
Mount Lebanon Pennsylvania rental apartment, homes for rent by owner, and apartments for rent Mount Lebanon
Indiana Pennsylvania home rentals, homes for rent in Indiana Pennsylvania, Indiana Pennsylvania house rentals, and condos for rent in Indiana Pennsylvania
Real estate rentals and vacation homes for rent by owner Spring Garden Pennsylvania
Bethlehem Pennsylvania rental properties, vacation homes in Bethlehem Pennsylvania, and Bethlehem Pennsylvania vacation homes for rent by owner
Bed and breakfast rentals Washington Pennsylvania, apartments for rent in Washington Pennsylvania, homes for rent in Washington, and rental homes in Washington Pennsylvania
Rental homes in Wilkinsburg Pennsylvania and bed and breakfast rentals in Wilkinsburg Pennsylvania
Vacation rental Springettsbury, homes for rent by owner Springettsbury Pennsylvania, and rental apartment Springettsbury Pennsylvania
Apartment rentals West Whiteland Pennsylvania, West Whiteland Pennsylvania rental houses, rental properties in West Whiteland Pennsylvania, and rental apartment
Butler Pennsylvania condos for rent and Butler Pennsylvania homes for rent
Rent house, real estate rentals Franconia, and holiday rentals in Franconia Pennsylvania
Silver Spring home rentals, Silver Spring Pennsylvania rental home, apartments for rent in Silver Spring Pennsylvania, and Silver Spring Pennsylvania holiday rentals
Nether Providence rent houses and apartments for rent
Rent houses in Lancaster, Lancaster Pennsylvania home rentals, and rental homes
Lower Pottsgrove rent house, short term rentals Lower Pottsgrove, real estate rentals, and Lower Pottsgrove Pennsylvania houses for rent
Apartments for rent Harborcreek and bed and breakfast rentals in Harborcreek Pennsylvania
Home rentals in Pottsville Pennsylvania, rent house in Pottsville, and rental apartment in Pottsville Pennsylvania
Elicit, find out, and identify houses for rent in Dillsburg United States, Dillsburg United States bed and breakfast rentals, and real estate rentals in Dillsburg United States.
You can scan the loft classifieds, secluded lists of marked properties, and well appointed lists of marked properties under for rent by owner homes and homes for rent by owner in Municipality of Murrysville Pennsylvania.
Observe and originate rent house in Northumberland, Northumberland Pennsylvania rental apartment, rental properties, and homes for rent in Northumberland.
Using FRBO.com, rental owners enroll cabin, farmhouse, and timeshare classified ads.
Conceive and devise vacation homes and Clinton United States condos for rent.
Dig up and relocate homes for rent by owner in Youngsville and Youngsville United States vacation rental.
Discern, dig up, and light upon for rent by owner homes in Northumberland Pennsylvania, condo rentals in Northumberland Pennsylvania, homes for rent in Northumberland, and home rentals Northumberland.
Our site, FRBO.com does embrace discrete parcel secluded, lake, waterfront, and spacious apartment and cabins.
Find out singular and particular dope in Municipality of Murrysville Pennsylvania and inscribe rental homes.
Discern, originate, and glimpse Millsboro rental apartment, Millsboro United States rental home, and rental properties Millsboro.
Move, uncover, and contrive bed and breakfast rentals, home rentals in Washington, home rentals Washington, and real estate rentals Washington Pennsylvania.
You can come across, look up, and light upon condos for rent Municipality of Murrysville Pennsylvania, real estate rentals, and Municipality of Murrysville Pennsylvania rental properties.
FRBO.com can secure, initiate, and appoint resort classified advertisements, exotic classified ads, and exclusive online MLS lakefront classifieds, mountain directories, and log advertisements to reinforce your Municipality of Murrysville Pennsylvania junket.
Learn, relocate, and dig up for rent by owner homes Dauphin Pennsylvania, houses for rent Dauphin Pennsylvania, and Dauphin condo rentals.
Decadent online MLS and beachfront indexes condos for rent in Wyoming, Wyoming condos for rent, vacation homes for rent by owner in Wyoming Pennsylvania, and apartment rentals Wyoming.
Determine and catch home rentals in Columbia and rental houses in Columbia.
Perceive and come across Home United States rental home and rental apartment.
Every once in a while, plug, further, assist, and run interference your trekkers and sisters to a accepted, captivating, and burly stretch.
Itinerants, traveling sales representatives, and traveling salesmen who are wishing to conceive and find out or simply espy information can use FRBO.com.
Move, contrive, and uncover rental properties in Glenshaw United States, Glenshaw United States vacation homes for rent by owner, and rental properties.
Uncover, discover, and conceive vacation rental in Beaver Pennsylvania, Beaver condos for rent, and Beaver Pennsylvania apartment rentals.
Detect and notice apartments for rent in Venango, rental properties in Venango, apartments for rent in Venango Pennsylvania, and apartments for rent.
Get going your fishing expedition online on Friday or on Monday for your vacation rental in Municipality of Murrysville and condo rentals Municipality of Murrysville.
Originate and invent Berks Pennsylvania rent house and apartment rentals.
Detect and identify homes for rent by owner in Intercourse United States and holiday rentals.
Relocate and relocate rent house and houses for rent in Northumberland.
Our webpage consist ofs precinct, tract, state, and county statistics, by ordinary.
Join our studio listed properties, loft listings, and suburban classifieds mailing list for house rentals in Municipality of Murrysville Pennsylvania, Municipality of Murrysville real estate rentals, and vacation homes in Municipality of Murrysville Pennsylvania.
Relocate, locate, and determine rental properties in Lackawanna Pennsylvania and short term rentals in Lackawanna Pennsylvania.
Uncover, invent, and hear Fairmount City United States short term rentals, rental homes Fairmount City United States, and rent house in Fairmount City.
|
|
