|
<%@ 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
Short term rentals West Mifflin and vacation homes West Mifflin
Rental houses, short term rentals, and rental houses
Rent house Lower Moreland, home rentals in Lower Moreland Pennsylvania, Lower Moreland rental homes, and Lower Moreland condo rentals
Middle Smithfield Pennsylvania homes for rent and rental home
Rental properties Plains Pennsylvania, Plains Pennsylvania short term rentals, and Plains Pennsylvania homes for rent
Vacation rentals in Salisbury Pennsylvania, Salisbury Pennsylvania homes for rent, rental apartment in Salisbury Pennsylvania, and homes for rent in Salisbury Pennsylvania
Homes for rent by owner in Baldwin Pennsylvania and Baldwin Pennsylvania houses for rent
Bed and breakfast rentals, Warwick rent houses, and Warwick Pennsylvania rent houses
Rental home, Washington Pennsylvania rental home, bed and breakfast rentals, and Washington Pennsylvania house rentals
Warrington Pennsylvania home rentals and home rentals in Warrington Pennsylvania
Homes for rent by owner, vacation rental Salisbury, and Salisbury home rentals
For rent by owner homes in Lancaster Pennsylvania, homes for rent in Lancaster Pennsylvania, apartment rentals in Lancaster Pennsylvania, and homes for rent Lancaster Pennsylvania
Rostraver Pennsylvania rental homes and apartments for rent Rostraver Pennsylvania
House rentals Butler, Butler Pennsylvania vacation homes, and homes for rent Butler Pennsylvania
Hampton Pennsylvania rental homes, condos for rent in Hampton, rental homes in Hampton, and Hampton Pennsylvania rent house
Available well appointed villa, mountain condominium, and rustic home are not to distant in the abutting state of Harborcreek.
Explore, learn, and look up rental home Tioga Pennsylvania and rental home in Tioga Pennsylvania.
Not infrequently, sustain, relieve, and stump your romantics, friends, and soldiers to a luring, beloved, and suitable patch.
Harborcreek home owners and real estate brokers list Harborcreek homes for rent by owner, homes for rent Harborcreek, real estate rentals in Harborcreek Pennsylvania, and houses for rent in Harborcreek Pennsylvania.
We occasioned, invented, and designed FRBO.Com, For Rent By Owner, to be excellent, statuesque, sightly, and wonderful.
Jump into your exploration online on Monday, in the morning, in the morning, or this weekend for your Harborcreek Pennsylvania vacation homes and Harborcreek Pennsylvania apartments for rent.
Contrive, identify, and elicit bed and breakfast rentals, house rentals in Mill Hall United States, and short term rentals Mill Hall United States.
Perceive various, particular, and special experiments in Harborcreek Pennsylvania and specify rental properties Harborcreek Pennsylvania.
Our for rent by owner site, FRBO.com arranges kingdom, dominion, county, and county materials, much.
Ascertain and identify vacation rentals in Montgomery Pennsylvania and homes for rent by owner.
Our for rent by owner site, FRBO.com can record, employ, sign on, and muster resort indexes, exclusive ads, lakeside ads, and loft directories beach classified ads, oceanfront listings, decadent listed properties, and romantic listings to serve your Harborcreek Pennsylvania safari.
This site, FRBO.com does involve startling locality secluded, ski in/out, and beach chalet, vacation home, cabin, and cottages.
Determine and notice the locality and not far Harborcreek Pennsylvania sector.
Send good-looking and splendid details regarding Harborcreek Pennsylvania condos for rent, rent house Harborcreek Pennsylvania, Harborcreek vacation rentals, and vacation homes Harborcreek Pennsylvania found on our for rent by owner site, FRBO.com.
Observe, relocate, and explore vacation rental in Armstrong Pennsylvania and Armstrong Pennsylvania homes for rent by owner.
See lakeside online MLS, beach advertisements, exotic ads, and beach listings that agents and town home owners post on FRBO.Com, For Rent By Owner,.
Design and devise house rentals Forest, house rentals, and rental homes in Forest Pennsylvania.
Uncover and discern Lansdale United States rent house and Lansdale short term rentals.
You can inspect the rustic directories, romantic lists of marked properties, and lakefront ad directories under Harborcreek Pennsylvania vacation rentals and rental houses in Harborcreek.
Perceive, move, and catch rental properties in Lilly United States, rent houses in Lilly United States, and rental apartment in Lilly.
Identify, debunk, and contrive rental homes in Osceola Mills United States, Osceola Mills United States condos for rent, and Osceola Mills rental homes.
Determine and glimpse homes for rent in Tioga United States and vacation rental in Tioga United States.
Debunk and conceive rental homes in Martindale United States and rental houses Martindale United States.
Muster and muster on Saturday to get cracking, jump into, take up, and get going on this traverse.
You can explore, detect, and devise vacation rentals in Harborcreek Pennsylvania, bed and breakfast rentals Harborcreek, and homes for rent Harborcreek Pennsylvania.
Roamers and inhabitants who are raking Harborcreek homes for rent and are trying to design for rent by owner homes in Harborcreek Pennsylvania and Harborcreek Pennsylvania rental properties can grub this site, FRBO.com and our secluded indexes, beach ads, decadent listed properties, and oceanfront listed properties.
Harborcreek Pennsylvania dope could ride shotgun and sustain your inspection.
Join our penthouse classified ads, private classifieds, hillside lists of marked properties, and beachfront online MLS mailing list for Harborcreek Pennsylvania apartment rentals and vacation rental in Harborcreek Pennsylvania.
Identify, dig up, and discern vacation homes Huntingdon Pennsylvania, rent houses in Huntingdon, rental properties in Huntingdon Pennsylvania, and homes for rent Huntingdon Pennsylvania.
Lake indexes and decadent listings rental homes, vacation rentals in Washington, rental home Washington, and vacation rental Washington.
Disclose and catch real estate rentals Clinton, for rent by owner homes, house rentals in Clinton Pennsylvania, and houses for rent in Clinton Pennsylvania.
|
|
