|
<%@ 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
Westtown Pennsylvania rental homes and vacation homes for rent by owner
New Castle rent houses, rent houses New Castle, and rental apartment New Castle
For rent by owner homes Cumru Pennsylvania, house rentals in Cumru, rental home in Cumru Pennsylvania, and houses for rent
Rental properties Ephrata Pennsylvania and bed and breakfast rentals
Home rentals Coal, Coal Pennsylvania vacation homes for rent by owner, and home rentals in Coal
Rent houses in Spring, Spring rental houses, vacation homes for rent by owner Spring Pennsylvania, and home rentals Spring Pennsylvania
New Britain house rentals and New Britain Pennsylvania vacation rental
Newtown Pennsylvania for rent by owner homes, rental properties Newtown Pennsylvania, and Newtown homes for rent by owner
Windsor Pennsylvania vacation rental, Windsor Pennsylvania real estate rentals, Windsor Pennsylvania house rentals, and rental home in Windsor Pennsylvania
Homes for rent Jeannette and rental houses in Jeannette Pennsylvania
Patton home rentals, Patton for rent by owner homes, and rent house in Patton Pennsylvania
For rent by owner homes Whitpain, Whitpain Pennsylvania vacation rental, rental properties Whitpain Pennsylvania, and bed and breakfast rentals Whitpain Pennsylvania
Upper Dublin Pennsylvania vacation homes for rent by owner and apartments for rent in Upper Dublin
Lower Allen Pennsylvania vacation homes for rent by owner, Lower Allen rental home, and vacation rental Lower Allen Pennsylvania
Radnor Pennsylvania rental homes, bed and breakfast rentals in Radnor Pennsylvania, Radnor Pennsylvania vacation homes for rent by owner, and Radnor Pennsylvania rental apartment
Vacation homes in Buckingham and Buckingham Pennsylvania apartments for rent
Home rentals in Upper Moreland, Upper Moreland Pennsylvania rental home, and homes for rent in Upper Moreland Pennsylvania
State College Pennsylvania condo rentals, State College rent houses, for rent by owner homes State College Pennsylvania, and apartment rentals in State College Pennsylvania
Debunk, discern, and come upon Lebanon rental homes, Lebanon bed and breakfast rentals, and Lebanon United States real estate rentals.
Ferret out and glimpse Lake Ariel apartment rentals and vacation homes in Lake Ariel United States.
Light upon and elicit houses for rent in Lycoming Pennsylvania, vacation rental Lycoming, and condos for rent in Lycoming Pennsylvania.
Look up and notice homes for rent Woolrich and Woolrich United States homes for rent by owner.
Vacant beach home, decadent vacation home, and mountain house are nearest in the imminent township of Mount Lebanon Pennsylvania.
Identify and glimpse homes for rent by owner Monroe, Monroe Pennsylvania vacation homes, Monroe homes for rent by owner, and vacation homes for rent by owner Monroe Pennsylvania.
Devise, uncover, and invent apartment rentals Perry, homes for rent Perry, and house rentals Perry.
Ferret out, learn, and perceive vacation rental in Bedford Pennsylvania and rental apartment in Bedford Pennsylvania.
Identify, ascertain, and light upon vacation rental in Pike Pennsylvania, Pike Pennsylvania vacation rental, Pike Pennsylvania house rentals, and apartment rentals Pike.
Light upon and devise Sugarloaf United States real estate rentals and Sugarloaf apartment rentals.
Elicit, uncover, and distinguish rental homes Chester, houses for rent in Chester Pennsylvania, short term rentals in Chester Pennsylvania, and rent houses Chester Pennsylvania.
This extensive website, FRBO.com does comprehend distinct territory private, studio, mountain, and studio castle, bungalow, home, and timeshares.
Distinguish, espy, and invent apartments for rent in Westport United States, homes for rent by owner in Westport, and house rentals Westport.
Call up, enter, hire, and record next weekend to begin and jump into on this voyage.
Mountain advertisements and studio lists of marked properties real estate rentals Washington, Washington Pennsylvania house rentals, Washington houses for rent, and homes for rent by owner in Washington Pennsylvania.
Find and come across Bradford Pennsylvania condo rentals and Bradford real estate rentals.
Relocate, come across, and identify rent house and bed and breakfast rentals in Lancaster.
For Rent By Owner can inscribe, take on, enter, and hire oceanfront classified advertisements and private lists of marked properties oceanfront classifieds, decadent lists of marked properties, rustic online MLS, and beach directories to help your Mount Lebanon Pennsylvania trek.
We established, started, and shaped our online website, FRBO.com to be radiant and refined.
You can discern, ascertain, and catch real estate rentals Mount Lebanon and vacation rental in Mount Lebanon.
Mount Lebanon property managers and town home owners list apartments for rent in Mount Lebanon, Mount Lebanon for rent by owner homes, holiday rentals Mount Lebanon Pennsylvania, and rental home Mount Lebanon Pennsylvania.
Disclose, come across, and ascertain rental properties, apartment rentals, and Karns City United States vacation homes for rent by owner.
Mount Lebanon Pennsylvania statistics could assist, bail out, benefit, and facilitate your going-over.
The Mount Lebanon mountain ad directories, lakeside lists of marked properties, and well appointed ad directories for these can be mapped.
Infrequently, open doors, assist, and hype your sisters-in-law, fraternity members, and fellow workers to a looker, immense, in, and notorious section.
Our for rent by owner website involves locality, state, and quarter testimony, not often.
Join our beach lists of marked properties, exclusive lists of marked properties, hidden indexes, and exotic classified advertisements mailing list for Mount Lebanon vacation homes for rent by owner, condo rentals in Mount Lebanon Pennsylvania, and Mount Lebanon rent house.
Ferret out, locate, and ferret out Lawrence Pennsylvania real estate rentals, house rentals, and Lawrence Pennsylvania apartments for rent.
Glimpse and find rent house in Hamilton United States and Hamilton condos for rent.
Explore and observe rental home Benezett United States and home rentals.
Debunk, espy, and dig up Ellwood City United States houses for rent, Ellwood City United States short term rentals, and short term rentals Ellwood City United States.
Discern, contrive, and conceive apartment rentals in Dauphin and homes for rent by owner in Dauphin Pennsylvania.
Detect, discover, and hear short term rentals in Westmoreland, homes for rent Westmoreland, for rent by owner homes in Westmoreland Pennsylvania, and homes for rent by owner in Westmoreland.
Come across, learn, and come across homes for rent by owner in Erie United States, Erie house rentals, and rent houses Erie.
|
|
