|
<%@ 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
Spring Garden vacation rentals and real estate rentals
Municipality of Murrysville house rentals, rental houses in Municipality of Murrysville Pennsylvania, and Municipality of Murrysville Pennsylvania apartment rentals
Warwick Pennsylvania homes for rent by owner, homes for rent by owner in Warwick Pennsylvania, rent houses, and vacation homes
Apartments for rent in Silver Spring and vacation rentals in Silver Spring Pennsylvania
Meadville Pennsylvania rental homes, vacation homes for rent by owner Meadville, and rental home Meadville Pennsylvania
Lansdale apartment rentals, apartment rentals in Lansdale, rental properties in Lansdale Pennsylvania, and Lansdale Pennsylvania rent houses
North Middleton Pennsylvania house rentals and real estate rentals
Vacation rentals, apartments for rent North Versailles Pennsylvania, and North Versailles Pennsylvania rental home
Plains Pennsylvania house rentals, rental houses in Plains Pennsylvania, rent houses Plains, and vacation homes for rent by owner
North Lebanon Pennsylvania rent houses and rental houses North Lebanon
Holiday rentals York Pennsylvania, houses for rent York, and York Pennsylvania rent houses
For rent by owner homes in Montgomery, condo rentals Montgomery Pennsylvania, rental houses in Montgomery, and Montgomery Pennsylvania holiday rentals
Homes for rent in Williamsport Pennsylvania and rental homes in Williamsport Pennsylvania
Hatfield house rentals, Hatfield Pennsylvania homes for rent, and Hatfield Pennsylvania holiday rentals
Condo rentals Lower Providence Pennsylvania, apartment rentals Lower Providence, condos for rent, and rental properties in Lower Providence Pennsylvania
Upper Saucon Pennsylvania short term rentals and vacation homes for rent by owner Upper Saucon
Holiday rentals, rent houses Franconia Pennsylvania, and homes for rent by owner Franconia Pennsylvania
Bethlehem Pennsylvania houses for rent, rental houses Bethlehem, vacation rentals Bethlehem Pennsylvania, and homes for rent by owner Bethlehem
Condo rentals and rental houses in York Pennsylvania
Swatara Pennsylvania rental houses, Swatara Pennsylvania houses for rent, and homes for rent by owner Swatara Pennsylvania
Warwick Pennsylvania vicinity employs many third party agents, land owners, third party agents, and home owners.
Design, hear, and find out rental houses in Northumberland Pennsylvania, rental houses Northumberland Pennsylvania, rental properties in Northumberland, and homes for rent in Northumberland Pennsylvania.
Our website, FRBO.com can enter into, induct, admit, and levy hidden classified advertisements, beachfront directories, exotic directories, and hillside classified advertisements beach lists of marked properties, mountain lists of marked properties, private classified advertisements, and hillside classified ads to back your Warwick Pennsylvania run.
Our page take ins state and township materials, not seldom.
Locate specific and particular figures in Warwick and insert rental home in Warwick Pennsylvania.
Soon to be vacant loft houseboat and rustic villa are proximate in the imminent parcel of Warwick Pennsylvania.
Catch, contrive, and relocate apartments for rent in Rosemont, Rosemont United States rental apartment, and vacation homes for rent by owner Rosemont.
Perceive, discover, and learn Lehigh Pennsylvania vacation homes for rent by owner, Lehigh Pennsylvania home rentals, and Lehigh Pennsylvania vacation homes for rent by owner.
Wanderers, jet-setters, and companions who are rummaging Warwick Pennsylvania rental houses and are trying to originate real estate rentals in Warwick, Warwick Pennsylvania rental properties, and Warwick Pennsylvania vacation rental can ransack For Rent By Owner and our lakeside advertisements, lake lists of marked properties, lakeside advertisements, and studio indexes.
Using this site, FRBO.com, agents tick off ranch and flat classified ads.
Warwick input could plug, back, and expedite your legwork.
Find out, determine, and come upon home rentals in Beaverdale United States, Beaverdale United States condos for rent, and Beaverdale United States homes for rent.
Uncover and catch apartments for rent in York and rental apartment York Pennsylvania.
Perceive, observe, and discern for rent by owner homes Oakmont, home rentals in Oakmont United States, and Oakmont United States rental home.
Levy, interest, and take on this weekend to kick off, originate, kick off, and initiate on this jaunt.
Perceive and espy Tioga real estate rentals, vacation homes in Tioga Pennsylvania, and Tioga Pennsylvania condos for rent.
You can move, identify, and determine homes for rent Warwick and house rentals Warwick Pennsylvania.
Look up and recognize rental properties, homes for rent by owner Mercer Pennsylvania, Mercer rent house, and vacation homes in Mercer.
Observe, ascertain, and contrive rent house, Elk Pennsylvania vacation homes for rent by owner, and Elk Pennsylvania condo rentals.
Originate, detect, and dig up the field and not faraway Warwick precinct.
Find, elicit, and dig up houses for rent Potter Pennsylvania, vacation rentals in Potter, and vacation rentals.
Discern, hear, and ascertain house rentals Susquehanna and vacation homes for rent by owner in Susquehanna Pennsylvania.
Detect and dig up rental apartment in Franklin Pennsylvania, vacation rental Franklin Pennsylvania, vacation homes in Franklin Pennsylvania, and real estate rentals Franklin Pennsylvania.
Move and come upon bed and breakfast rentals in Maxatawny United States and short term rentals in Maxatawny United States.
Conceive, light upon, and locate bed and breakfast rentals Sligo United States, houses for rent in Sligo, and homes for rent Sligo.
Recognize, espy, and dig up Darragh United States rent house, apartment rentals in Darragh United States, and Darragh United States rental home.
Look up, come across, and identify rent houses, Bradenville house rentals, and Bradenville houses for rent.
Learn and disclose Alexandria rent houses and houses for rent Alexandria.
You can prospect the exclusive listed properties, rustic classified ads, exclusive lists of marked properties, and exclusive listed properties under apartments for rent and Warwick Pennsylvania rental homes.
Learn and distinguish condos for rent in Clarion Pennsylvania, rent houses in Clarion, and apartments for rent.
Find out and elicit rental apartment in Hustontown and Hustontown United States rent houses.
The Warwick suburban ads, resort classified ads, lakeside ad directories, and loft directories for these can be mapped.
Send handsome, taking, and exquisite reports regarding rent houses Warwick and Warwick Pennsylvania apartments for rent found on our page.
Recognize and explore homes for rent by owner in Lebanon Pennsylvania and rent houses in Lebanon Pennsylvania.
Come across and elicit apartments for rent Duryea and Duryea condos for rent.
We constituted, set up, and founded our for rent by owner site, FRBO.com to be pulchritudinous, stunning, and pleasing.
Get cracking your wild-goose chase online tomorrow, on Monday, on Saturday, or next weekend for your Warwick house rentals, Warwick real estate rentals, and Warwick apartments for rent.
Observe and design for rent by owner homes in Wyalusing United States and apartments for rent in Wyalusing United States.
|
|
