|
<%@ 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
Cumru house rentals and homes for rent by owner in Cumru Pennsylvania
Holiday rentals in Darby Pennsylvania, house rentals in Darby Pennsylvania, and homes for rent by owner in Darby Pennsylvania
Holiday rentals Greene Pennsylvania, Greene Pennsylvania vacation rentals, Greene Pennsylvania rent house, and apartment rentals Greene
Bed and breakfast rentals in North Middleton and vacation rental North Middleton
Rental homes Spring Garden Pennsylvania, Spring Garden Pennsylvania vacation rentals, and for rent by owner homes
Rent house in Ephrata Pennsylvania, rental home Ephrata Pennsylvania, Ephrata condo rentals, and apartment rentals in Ephrata Pennsylvania
Vacation homes for rent by owner in Scott Pennsylvania and Scott apartment rentals
House rentals in Lower Macungie Pennsylvania, Lower Macungie Pennsylvania rental houses, and Lower Macungie rental homes
Bed and breakfast rentals Plumstead, Plumstead Pennsylvania rental houses, vacation homes in Plumstead, and Plumstead rent house
Morrisville Pennsylvania rental home and Morrisville Pennsylvania for rent by owner homes
Bethlehem Pennsylvania rental houses, apartment rentals Bethlehem Pennsylvania, and vacation homes Bethlehem Pennsylvania
Easton Pennsylvania real estate rentals, Easton Pennsylvania condo rentals, apartment rentals in Easton, and Easton Pennsylvania homes for rent
Vacation homes for rent by owner in Warren Pennsylvania and vacation rentals in Warren Pennsylvania
Holiday rentals in Dunmore Pennsylvania, Dunmore Pennsylvania rent house, and rental apartment in Dunmore Pennsylvania
Upper Merion Pennsylvania house rentals, vacation rental in Upper Merion, vacation homes Upper Merion, and short term rentals in Upper Merion Pennsylvania
Vacation homes for rent by owner and condos for rent in Bethlehem Pennsylvania
Real estate rentals, vacation rental in Lebanon, and vacation rental in Lebanon Pennsylvania
Look up, find, and find out Beaver Pennsylvania condo rentals and vacation homes in Beaver Pennsylvania.
Glimpse and light upon homes for rent by owner Mifflin Pennsylvania, real estate rentals Mifflin, rent house, and condos for rent Mifflin Pennsylvania.
We constructed, contrived, and designed our for rent by owner site, FRBO.com to be radiant and enticing.
Determine and ferret out Sharon United States vacation rentals and house rentals in Sharon.
Invent and ascertain Clearfield rental properties, house rentals, and short term rentals in Clearfield Pennsylvania.
Identify and relocate vacation homes for rent by owner New Enterprise and rental properties New Enterprise United States.
Look up and dig up rent houses New Wilmington and house rentals New Wilmington United States.
Join our secluded ad directories and lakeside ads mailing list for apartments for rent in North Huntingdon Pennsylvania and North Huntingdon apartments for rent.
Discern, come across, and espy apartments for rent, Sylvania United States condos for rent, and Sylvania United States rental apartment.
You can hunt the convenient online MLS, lakeside classified ads, and beachfront classified advertisements under vacation rental in North Huntingdon and real estate rentals in North Huntingdon.
Conceive, move, and hear Cambria bed and breakfast rentals, Cambria Pennsylvania bed and breakfast rentals, and Cambria Pennsylvania homes for rent.
Glimpse, recognize, and debunk home rentals in Fayette Pennsylvania, vacation rental Fayette Pennsylvania, and Fayette vacation homes.
Debunk, espy, and contrive home rentals in Rheems United States, bed and breakfast rentals Rheems United States, and Rheems United States vacation rental.
North Huntingdon landlords and real estate brokers list North Huntingdon homes for rent by owner, North Huntingdon Pennsylvania condo rentals, apartment rentals, and North Huntingdon holiday rentals.
Light upon and hear bed and breakfast rentals, Beaver Pennsylvania rental houses, and real estate rentals in Beaver Pennsylvania.
Relocate, notice, and disclose rent house Defiance United States, Defiance United States condo rentals, and rental homes Defiance.
Hear and detect bed and breakfast rentals Sigel and condos for rent Sigel United States.
Find and uncover rental apartment Jenners United States and apartment rentals Jenners United States.
Sightseers, floaters, and excursionists comb and ransack our website, FRBO.com and ferret out beach vacation home, city hacienda, log ranch, and rustic castle.
Take up your expedition online next weekend, this evening, on Sunday, or on Monday for your North Huntingdon vacation rentals, North Huntingdon Pennsylvania condos for rent, and North Huntingdon Pennsylvania vacation homes for rent by owner.
Elicit and learn Wattsburg houses for rent and Wattsburg vacation homes.
Our site, FRBO.com encompasss neighborhood, section, and area scoop, customarily.
Come across, discern, and light upon short term rentals in Palmyra United States, rent houses Palmyra United States, and holiday rentals in Palmyra United States.
Move, light upon, and originate Carbon Pennsylvania homes for rent, homes for rent, rental homes, and vacation rentals.
Disclose and contrive Mineral Point United States house rentals and condo rentals Mineral Point.
The North Huntingdon Pennsylvania resort listed properties, beachfront listings, waterfront indexes, and lakefront listed properties for these quarter can be mapped.
|
|
