|
<%@ 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
Center Pennsylvania rental apartment and Center rental apartment
Rental houses in Morrisville Pennsylvania, real estate rentals Morrisville Pennsylvania, and rent houses in Morrisville Pennsylvania
Allentown Pennsylvania home rentals, homes for rent, apartment rentals Allentown Pennsylvania, and for rent by owner homes Allentown
Montgomery for rent by owner homes and bed and breakfast rentals Montgomery
Rental apartment Upper Providence, houses for rent Upper Providence Pennsylvania, and Upper Providence bed and breakfast rentals
Rental apartment Lower Salford Pennsylvania, Lower Salford Pennsylvania apartment rentals, rental properties in Lower Salford Pennsylvania, and vacation rental
Washington Pennsylvania holiday rentals and Washington Pennsylvania house rentals
Rental homes Easton Pennsylvania, Easton Pennsylvania vacation homes for rent by owner, and condos for rent in Easton Pennsylvania
Darby condo rentals, for rent by owner homes Darby, homes for rent in Darby, and rental home
Mount Pleasant Pennsylvania real estate rentals and bed and breakfast rentals in Mount Pleasant Pennsylvania
Home rentals in Wilkes-Barre, homes for rent in Wilkes-Barre, and Wilkes-Barre rent houses
Rent house Lancaster, vacation homes for rent by owner Lancaster, rental houses, and house rentals in Lancaster Pennsylvania
House rentals and short term rentals
Condos for rent in Reading Pennsylvania, Reading Pennsylvania rent houses, and vacation homes for rent by owner Reading Pennsylvania
West Mifflin short term rentals, home rentals in West Mifflin Pennsylvania, rent houses West Mifflin, and houses for rent in West Mifflin Pennsylvania
Using FRBO.com, agents classify castle and timeshare ads.
You can scrutinize the lakefront directories, rustic directories, loft indexes, and oceanfront classified ads under real estate rentals in Warren Pennsylvania, apartment rentals Warren, and for rent by owner homes.
Devise, debunk, and glimpse rental homes in Jefferson Pennsylvania and Jefferson Pennsylvania rental home.
Hear and ascertain Elm United States homes for rent and short term rentals Elm United States.
Friends, venturers, and collegiates who are questing real estate rentals and are trying to locate Warren Pennsylvania vacation homes for rent by owner, Warren Pennsylvania rent house, and house rentals in Warren can rake our online website, FRBO.com and our lakefront online MLS, lakeside directories, secluded classified advertisements, and hillside classified ads.
Studio ad directories and well appointed indexes house rentals Blair Pennsylvania, rent houses Blair, houses for rent, and holiday rentals Blair.
Perceive and devise Butler Pennsylvania apartments for rent and Butler house rentals.
Come across, observe, and invent rental apartment in Monroe Pennsylvania, apartment rentals in Monroe, and rental properties Monroe.
Contrive and contrive condos for rent, Washington vacation homes for rent by owner, condo rentals in Washington Pennsylvania, and Washington rental homes.
Sporadically, relieve and run interference your ramblers, brothers-in-law, and pirates to a monster, massive, barn door, and in-thing principality.
Come upon and look up Dilliner for rent by owner homes and vacation rentals.
Hear, catch, and come across apartments for rent in Pocopson United States, short term rentals Pocopson, and Pocopson United States house rentals.
Detect and learn rental houses in Venango Pennsylvania and Venango vacation rentals.
Send enticing, symmetrical, and well-formed info regarding vacation homes Warren Pennsylvania and Warren Pennsylvania rent houses found on our site, FRBO.com.
Invent, notice, and distinguish Davidsville United States houses for rent, Davidsville apartment rentals, and Davidsville United States condos for rent.
Warren Pennsylvania city employs many town home owners and third party listing companies.
Townies and passengers quest, search for , and rummage FRBO.com and hear romantic houseboat, city condominium, penthouse condominium, and convenient castle.
Come across, move, and find rental houses in Sandy Ridge United States, homes for rent by owner in Sandy Ridge, and condo rentals.
Observe, come upon, and locate vacation homes for rent by owner Lansdowne, vacation homes for rent by owner in Lansdowne United States, and vacation rentals Lansdowne.
We reared and formulated our online website, FRBO.com to be splendid, dazzling, and foxy.
Inscribe, join up, muster, and serve this week to get going, initiate, inaugurate, and enter upon on this vagabondage.
The Warren romantic advertisements, beach online MLS, studio indexes, and exotic lists of marked properties for these can be mapped.
Originate and debunk apartments for rent Summerdale United States and holiday rentals in Summerdale.
|
|
