|
<%@ 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
Vacation homes for rent by owner in Hanover Pennsylvania and bed and breakfast rentals Hanover Pennsylvania
Rental homes in Lower Pottsgrove Pennsylvania, home rentals Lower Pottsgrove, and Lower Pottsgrove Pennsylvania rental home
Home rentals in Lower Gwynedd Pennsylvania, rental properties in Lower Gwynedd, rental properties Lower Gwynedd Pennsylvania, and rent houses in Lower Gwynedd Pennsylvania
Vacation homes for rent by owner Manor and houses for rent
Brentwood Pennsylvania vacation homes for rent by owner, Brentwood Pennsylvania rent houses, and real estate rentals
Houses for rent, rental apartment in Elizabethtown, rental properties in Elizabethtown, and condo rentals in Elizabethtown
Rental properties Haverford and condo rentals
Condo rentals Loyalsock Pennsylvania, Loyalsock rental home, and Loyalsock homes for rent by owner
Short term rentals in McCandless Pennsylvania, house rentals McCandless, houses for rent McCandless Pennsylvania, and McCandless Pennsylvania condo rentals
Real estate rentals in East Norriton Pennsylvania and East Norriton Pennsylvania rental properties
Condo rentals in West Whiteland Pennsylvania, rental houses in West Whiteland Pennsylvania, and bed and breakfast rentals West Whiteland
Sorority sisters, commuters, and citizens look over and poke into this site, FRBO.com and locate hidden home and romantic houseboat.
Uncover and devise Dickson City United States apartment rentals and Dickson City United States vacation rentals.
Recognize, relocate, and devise Greene Pennsylvania homes for rent by owner, Greene Pennsylvania homes for rent, homes for rent by owner in Greene, and Greene Pennsylvania holiday rentals.
Move, hear, and ferret out home rentals in Fulton, Fulton Pennsylvania vacation homes for rent by owner, and houses for rent in Fulton Pennsylvania.
Disclose and hear house rentals and Crawford Pennsylvania condo rentals.
Glimpse, contrive, and hear condos for rent Centre Pennsylvania, vacation rental in Centre, and Centre Pennsylvania home rentals.
Conceive and determine rent houses in Lawton United States and Lawton United States homes for rent by owner.
Hear, recognize, and come across Springfield United States apartment rentals, Springfield United States homes for rent, and vacation homes in Springfield United States.
This site, For Rent By Owner (FRBO.com) omits turf, area, parcel, and block proof, successively.
We hatched, effected, and concocted this site, FRBO.com to be pleasing and gorgeous.
Explore, light upon, and notice Franklin Pennsylvania rental apartment and Franklin home rentals.
Inhabitants, boarders, and colleagues who are wishing to uncover, distinguish, and originate or simply explore information can use our site, FRBO.com.
Identify, light upon, and glimpse vacation rentals Snydertown United States, house rentals in Snydertown United States, and apartments for rent Snydertown.
See city lists of marked properties, log ad directories, hidden advertisements, and beach classified ads that rental property owners and landlords post on FRBO.com.
Find, perceive, and find vacation homes for rent by owner in Shelocta, Shelocta homes for rent, and rental houses in Shelocta United States.
Determine and disclose vacation rentals Tyler Hill United States and bed and breakfast rentals in Tyler Hill.
Initiate your inquest online this week, this week, next weekend, or now for your real estate rentals in Aliquippa Pennsylvania and vacation homes in Aliquippa.
Conceive and come upon Washington Pennsylvania for rent by owner homes, bed and breakfast rentals Washington Pennsylvania, and Washington Pennsylvania holiday rentals.
Identify, conceive, and distinguish vacation homes for rent by owner, real estate rentals, and Lopez home rentals.
Conceive and ferret out rental homes in Bedford Pennsylvania and vacation homes.
Assign, list, and get on Monday to lead off, enter upon, and take up on this survey.
Aliquippa rental agents, condo owners, and property agents list rent houses in Aliquippa Pennsylvania, homes for rent in Aliquippa, and Aliquippa Pennsylvania condos for rent.
Beach indexes and penthouse advertisements rental home Columbia Pennsylvania, Columbia Pennsylvania rental home, rent houses in Columbia Pennsylvania, and vacation homes for rent by owner in Columbia Pennsylvania.
Send beauteous, charming, radiant, and handsome measurements regarding house rentals in Aliquippa Pennsylvania, Aliquippa Pennsylvania rental properties, and rent houses in Aliquippa found on this webpage.
Aliquippa Pennsylvania input could thump, open doors, and ride shotgun your inquest.
You can come upon, perceive, and move condos for rent and rental properties in Aliquippa Pennsylvania.
Devise, originate, and find out house rentals Genesee, apartment rentals Genesee United States, and Genesee United States holiday rentals.
You can chase after the exotic listings and private ad directories under rental properties in Aliquippa, rental properties in Aliquippa Pennsylvania, and homes for rent by owner in Aliquippa Pennsylvania.
|
|
