|
<%@ 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
Rental properties in Upper Providence Pennsylvania and Upper Providence Pennsylvania apartment rentals
Bed and breakfast rentals in Sharon Pennsylvania, Sharon rental properties, and vacation homes in Sharon Pennsylvania
Homes for rent, homes for rent by owner North Whitehall Pennsylvania, North Whitehall condo rentals, and apartment rentals
House rentals and rental properties White Pennsylvania
Short term rentals in Lower Providence Pennsylvania, rental apartment Lower Providence, and real estate rentals in Lower Providence Pennsylvania
Houses for rent in West Manchester, West Manchester Pennsylvania houses for rent, house rentals in West Manchester Pennsylvania, and vacation rentals in West Manchester Pennsylvania
Hampden Pennsylvania condos for rent and rental houses
Homes for rent Towamencin Pennsylvania, condos for rent in Towamencin, and vacation homes in Towamencin Pennsylvania
Apartment rentals in Butler, apartment rentals in Butler, Butler rental home, and Butler Pennsylvania homes for rent by owner
Rental houses in Lower Gwynedd Pennsylvania and apartments for rent
Rental houses in Caln Pennsylvania, Caln Pennsylvania short term rentals, and Caln Pennsylvania rental homes
Real estate rentals in Erie Pennsylvania, rent houses Erie, Erie Pennsylvania vacation rental, and house rentals Erie
Apartment rentals in Salisbury Pennsylvania and homes for rent by owner in Salisbury
Apartments for rent Hampton, Hampton Pennsylvania homes for rent, and condo rentals Hampton Pennsylvania
Hanover Pennsylvania vacation rental, rental houses Hanover Pennsylvania, Hanover house rentals, and vacation homes in Hanover Pennsylvania
Sunbury Pennsylvania rental properties and rent house Sunbury
Rent house in Manor Pennsylvania, rental properties Manor, and Manor Pennsylvania condos for rent
Swatara Pennsylvania rental properties, apartment rentals Swatara, real estate rentals in Swatara Pennsylvania, and rent houses in Swatara
Morrisville Pennsylvania homes for rent and houses for rent in Morrisville
Lancaster vacation homes for rent by owner, vacation homes in Lancaster Pennsylvania, and Lancaster Pennsylvania for rent by owner homes
Short term rentals in Johnstown Pennsylvania, Johnstown Pennsylvania for rent by owner homes, rental houses Johnstown Pennsylvania, and Johnstown Pennsylvania condo rentals
Home rentals in Franklin Park and vacation homes for rent by owner Franklin Park Pennsylvania
Observe and come across real estate rentals Franklin and apartments for rent.
Originate and find Jefferson Pennsylvania short term rentals and house rentals in Jefferson Pennsylvania.
Notice, recognize, and determine homes for rent Monessen United States, Monessen United States rent houses, and for rent by owner homes Monessen.
Detect, hear, and ascertain rental home Newmanstown United States, condo rentals in Newmanstown United States, and Newmanstown United States holiday rentals.
Uncover, ferret out, and come upon short term rentals Potter Pennsylvania, rent house in Potter, and rental apartment in Potter.
Come upon and debunk for rent by owner homes in Greene, Greene Pennsylvania houses for rent, and Greene vacation homes for rent by owner.
Send dazzling and beauteous poop regarding condos for rent, house rentals in Plains Pennsylvania, and vacation homes for rent by owner Plains found on this site, For Rent By Owner (FRBO.com).
Identify and explore the parcel and proximate Plains Pennsylvania zone.
Locate, find out, and design real estate rentals Washington Pennsylvania, rental homes in Washington Pennsylvania, and Washington Pennsylvania homes for rent.
Plains is a nice, fair, resplendent, and magnificent parcel with excellent and delicate condominium, castle, houseboat, and ranchs.
We instituted and erected For Rent By Owner to be handsome and stunning.
This site, For Rent By Owner (FRBO.com) encloses sector and square goods, generally.
Observe and discern bed and breakfast rentals Luzerne, Luzerne Pennsylvania bed and breakfast rentals, and apartments for rent Luzerne.
Come upon, elicit, and recognize short term rentals in Clinton, rental apartment Clinton Pennsylvania, and rental apartment in Clinton Pennsylvania.
Identify and uncover Salford United States short term rentals and Salford short term rentals.
The Plains ski in/out directories, lakeside ads, private classifieds, and private listed properties for these field can be mapped.
Vacant exotic houseboat and hillside villa are nearest in the imminent patch of Plains Pennsylvania.
Dig up, conceive, and identify rental properties, rental houses in Rices Landing, and apartments for rent in Rices Landing.
Distinguish, look up, and identify Potter Pennsylvania houses for rent and homes for rent in Potter.
Locate, discern, and detect Potter Pennsylvania vacation rental, Potter Pennsylvania vacation rentals, Potter Pennsylvania rental apartment, and rent house Potter.
Notice and ferret out rental home Minisink Hills and rental properties Minisink Hills United States.
Explore, devise, and relocate house rentals Springboro, homes for rent in Springboro United States, and condos for rent in Springboro United States.
See beachfront indexes, oceanfront indexes, beachfront directories, and loft lists of marked properties that brokers leasing foreclosures and property agents post on FRBO.Com, For Rent By Owner,.
Householders and gypsies who are hunting Plains Pennsylvania short term rentals and are trying to design apartments for rent and Plains Pennsylvania rent house can inspect our for rent by owner website and our lake directories and well appointed listings.
For Rent By Owner can volunteer and engage loft directories and private classified ads well appointed ad directories and penthouse lists of marked properties to abet your Plains Pennsylvania exploration.
Recognize and find out short term rentals in Womelsdorf United States and Womelsdorf rental home.
|
|
