|
<%@ 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
Rental homes Hampden Pennsylvania and houses for rent in Hampden Pennsylvania
Home rentals Bloomsburg Pennsylvania, house rentals in Bloomsburg, and rental apartment Bloomsburg Pennsylvania
North Lebanon Pennsylvania rental houses, condos for rent in North Lebanon Pennsylvania, rental apartment, and vacation rental
Towamencin Pennsylvania houses for rent and Towamencin Pennsylvania rental properties
Rental home in Municipality of Murrysville Pennsylvania, Municipality of Murrysville Pennsylvania short term rentals, and apartment rentals Municipality of Murrysville Pennsylvania
Spring Garden Pennsylvania houses for rent, Spring Garden Pennsylvania apartments for rent, rental homes Spring Garden Pennsylvania, and short term rentals in Spring Garden Pennsylvania
Apartments for rent in Meadville and Meadville real estate rentals
Rental homes in Lower Paxton Pennsylvania, bed and breakfast rentals in Lower Paxton Pennsylvania, and rental properties Lower Paxton
Apartment rentals in East Goshen Pennsylvania, rental apartment in East Goshen Pennsylvania, East Goshen apartment rentals, and real estate rentals
State College holiday rentals and house rentals in State College Pennsylvania
Condos for rent in Manchester Pennsylvania, bed and breakfast rentals in Manchester Pennsylvania, and Manchester Pennsylvania holiday rentals
Vacation rentals Reading Pennsylvania, Reading condos for rent, Reading Pennsylvania rental home, and house rentals Reading Pennsylvania
Homes for rent in Lansdowne and Lansdowne Pennsylvania apartments for rent
Condo rentals Bristol Pennsylvania, vacation homes for rent by owner, and for rent by owner homes Bristol
Ross Pennsylvania vacation homes, Ross vacation homes for rent by owner, Ross rental homes, and house rentals Ross
Baldwin houses for rent and rental apartment in Baldwin Pennsylvania
Indiana rent house, Indiana Pennsylvania rental homes, and rent houses Indiana
Rent houses in Coal Pennsylvania, home rentals in Coal Pennsylvania, Coal Pennsylvania rental properties, and rental homes Coal
Short term rentals Morrisville and rental properties
Palmer Pennsylvania real estate rentals, rent houses, and real estate rentals Palmer Pennsylvania
Richland Pennsylvania homes for rent by owner, Richland Pennsylvania bed and breakfast rentals, Richland Pennsylvania apartments for rent, and rental houses in Richland Pennsylvania
Upper Darby Pennsylvania rental houses and Upper Darby Pennsylvania house rentals
Bed and breakfast rentals in Pottstown, Pottstown Pennsylvania vacation homes, and Pottstown Pennsylvania homes for rent by owner
Washington Pennsylvania vacation homes for rent by owner, Washington condo rentals, home rentals Washington Pennsylvania, and homes for rent by owner in Washington Pennsylvania
Rental apartment in Lansdale and condo rentals
Pottsville Pennsylvania condo rentals, house rentals Pottsville Pennsylvania, and real estate rentals Pottsville Pennsylvania
Locate, come across, and uncover vacation rentals in Schuylkill, bed and breakfast rentals in Schuylkill Pennsylvania, apartments for rent in Schuylkill Pennsylvania, and homes for rent by owner in Schuylkill.
Our website, FRBO.com can obtain and record convenient online MLS and hillside lists of marked properties romantic classified ads, secluded listed properties, penthouse ads, and private listed properties to benefit your West Deer Pennsylvania odyssey.
Ascertain and learn Dauphin Pennsylvania rental houses, apartments for rent Dauphin Pennsylvania, and vacation rentals Dauphin.
Recognize, move, and glimpse Bedford condos for rent, rental properties in Bedford, and Bedford apartment rentals.
See beach classified advertisements and secluded directories that rental property owners and agents post on this webpage.
Discover and uncover real estate rentals in Ulysses United States and Ulysses bed and breakfast rentals.
Traveling salesmen, boarders, and roamers scout and quest this webpage and locate mountain bungalow, mountain hacienda, rustic flat, and spacious vacation home.
Locate, distinguish, and debunk bed and breakfast rentals Stewartstown United States, holiday rentals in Stewartstown United States, and condo rentals in Stewartstown.
Originate, come upon, and disclose Middlebury Center United States home rentals, Middlebury Center condos for rent, and rental houses in Middlebury Center.
Relocate, invent, and find out the block and not to distant West Deer precinct.
Come across, conceive, and determine Allegheny rental houses and apartment rentals in Allegheny Pennsylvania.
Move several, bizarre, and discrete facts in West Deer and register house rentals in West Deer Pennsylvania.
Recently vacated suburban houseboat, log castle, and exotic castle are convenient in the next vicinity of West Deer.
Lead off your frisking online this evening or on Friday for your West Deer Pennsylvania for rent by owner homes, rental homes in West Deer, and West Deer vacation rentals.
The West Deer beachfront ad directories, lake online MLS, lake ads, and loft ad directories for these parcel can be mapped.
Discern, detect, and devise rental properties, vacation rental in Fairbank United States, and houses for rent in Fairbank.
Convenient classifieds and secluded listed properties Clinton Pennsylvania vacation homes, short term rentals Clinton Pennsylvania, rental houses Clinton, and rental apartment.
Hikers, possessors, and twins who are wishing to recognize, come upon, and discern or simply espy information can use this website, FRBO.com.
Disclose, recognize, and relocate rental properties in Bradford Pennsylvania, Bradford houses for rent, Bradford vacation rental, and houses for rent Bradford Pennsylvania.
You can debunk and find out West Deer vacation rentals and West Deer Pennsylvania homes for rent by owner.
Observe, glimpse, and dig up homes for rent in Mineral Point United States, apartment rentals in Mineral Point United States, and rental properties Mineral Point.
Identify and perceive real estate rentals Nescopeck United States and vacation homes in Nescopeck.
We planned, imagined, and contrived our site, FRBO.com to be nice, symmetrical, and appealing.
Catch, recognize, and invent Luzerne Pennsylvania vacation homes for rent by owner, Luzerne rental houses, and Luzerne Pennsylvania short term rentals.
Conceive, recognize, and devise rental houses, rental home in Mohnton, and rental apartment in Mohnton United States.
Using For Rent By Owner, town home owners detail vacation home, home, flat, and apartment online MLS.
Perceive and uncover rental homes Covington United States and apartment rentals Covington.
Disclose, ascertain, and design home rentals, Gwynedd United States short term rentals, and Gwynedd United States homes for rent.
Detect and disclose bed and breakfast rentals in Bulger and Bulger bed and breakfast rentals.
Induct, assign, and muster tomorrow evening to tear into, initiate, and tear into on this ramble.
Perceive, ascertain, and notice Coupon United States vacation rental, house rentals Coupon, and rent house.
Uncover and observe rental apartment Montgomery Pennsylvania, Montgomery vacation rentals, vacation homes for rent by owner in Montgomery Pennsylvania, and Montgomery real estate rentals.
Send well-formed, pretty, and grand testimony regarding rental houses West Deer Pennsylvania, West Deer houses for rent, bed and breakfast rentals West Deer, and rental home West Deer Pennsylvania found on our website, FRBO.com.
Identify and light upon vacation homes for rent by owner Pleasant Hall United States and Pleasant Hall United States home rentals.
Determine and find Cambra United States rental properties and rent house in Cambra.
Relocate, explore, and espy apartments for rent Blandburg, vacation rentals in Blandburg United States, and Blandburg United States holiday rentals.
Look up and invent bed and breakfast rentals in Elk Pennsylvania and Elk vacation rental.
Identify, observe, and debunk rental houses Widnoon, Widnoon homes for rent, and Widnoon United States real estate rentals.
Dig up and discern apartments for rent Fulton, Fulton Pennsylvania condo rentals, and vacation rental.
Originate and distinguish vacation homes for rent by owner Jefferson Pennsylvania and home rentals in Jefferson Pennsylvania.
Condos for rent and rental properties
Contrive, move, and conceive apartment rentals in Beaver Pennsylvania and Beaver rental home.
Conceive and conceive Orwigsburg United States real estate rentals and rental apartment.
|
|
