|
<%@ 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
Patton Pennsylvania condos for rent and homes for rent by owner Patton
Bed and breakfast rentals, rental houses, and rental home in Warrington
Rental properties, apartment rentals Lansdale, short term rentals in Lansdale, and Lansdale Pennsylvania condo rentals
Vacation homes Warwick and Warwick Pennsylvania homes for rent
For rent by owner homes in Wilkinsburg Pennsylvania, vacation homes for rent by owner Wilkinsburg Pennsylvania, and bed and breakfast rentals
Home rentals in Uniontown, vacation homes for rent by owner Uniontown Pennsylvania, homes for rent by owner in Uniontown Pennsylvania, and condo rentals in Uniontown
Peters Pennsylvania homes for rent and Peters Pennsylvania rent houses
Vacation homes, Manheim Pennsylvania rental houses, and Manheim Pennsylvania rental apartment
Apartments for rent, Manchester Pennsylvania holiday rentals, vacation homes for rent by owner in Manchester, and houses for rent Manchester Pennsylvania
Hampton Pennsylvania apartment rentals and Hampton Pennsylvania house rentals
Vacation homes in York Pennsylvania, York vacation rental, and vacation rentals York
Abington Pennsylvania rental houses, vacation rentals in Abington Pennsylvania, for rent by owner homes in Abington Pennsylvania, and Abington Pennsylvania rent house
Apartments for rent Philadelphia Pennsylvania and homes for rent by owner Philadelphia
Homes for rent by owner Marple Pennsylvania, holiday rentals in Marple Pennsylvania, and holiday rentals Marple Pennsylvania
Vacation rental in Bethlehem Pennsylvania, Bethlehem Pennsylvania rental houses, condo rentals in Bethlehem, and vacation rentals in Bethlehem
Apartment rentals in Greene and bed and breakfast rentals
Pottsville Pennsylvania houses for rent, holiday rentals in Pottsville Pennsylvania, and houses for rent Pottsville
Apartments for rent Hilltown Pennsylvania, vacation homes for rent by owner in Hilltown, vacation rental Hilltown Pennsylvania, and rental home in Hilltown
Bed and breakfast rentals Fairview and Fairview Pennsylvania rental apartment
Condos for rent in Hermitage Pennsylvania, homes for rent by owner in Hermitage, and vacation homes Hermitage
Hopewell Pennsylvania short term rentals, Hopewell Pennsylvania rental homes, Hopewell Pennsylvania condo rentals, and houses for rent in Hopewell Pennsylvania
Holiday rentals and condos for rent Coatesville Pennsylvania
Rent house in Richland Pennsylvania, homes for rent in Richland Pennsylvania, and Richland Pennsylvania real estate rentals
Rental properties in Upper Providence Pennsylvania, rental houses Upper Providence, vacation rentals, and short term rentals in Upper Providence
Home rentals and holiday rentals in Lower Pottsgrove Pennsylvania
West Bradford Pennsylvania condo rentals, home rentals in West Bradford Pennsylvania, and homes for rent by owner in West Bradford Pennsylvania
Look up and conceive Benton United States rental home and apartment rentals in Benton United States.
Move, perceive, and identify Adams Pennsylvania for rent by owner homes, homes for rent in Adams, condo rentals Adams, and rental properties in Adams.
Relocate, originate, and identify rent houses in Karthaus, rental homes in Karthaus United States, and Karthaus United States home rentals.
Discover and debunk holiday rentals Germansville United States and rental homes.
Rostraver Pennsylvania is a exquisite, taking, and fair township with ideal and alluring castle, duplex, and lodges.
Come upon, relocate, and find out condo rentals in Schuylkill, vacation homes Schuylkill, and homes for rent by owner in Schuylkill Pennsylvania.
Using our website, FRBO.com, real estate agents record flat, lodge, farmhouse, and townhouse indexes.
Espy, light upon, and identify home rentals in Marchand, home rentals in Marchand United States, and homes for rent in Marchand United States.
Discern, recognize, and identify rental homes in Manorville United States, Manorville United States homes for rent, and for rent by owner homes Manorville United States.
Look up and debunk houses for rent McKean Pennsylvania and rental apartment McKean.
Contrive, come across, and recognize West Chester United States real estate rentals, holiday rentals in West Chester United States, and real estate rentals in West Chester United States.
Spouses and schoolmates who are wishing to ferret out and identify or simply originate information can use FRBO.Com, For Rent By Owner,.
You can elicit, discern, and originate real estate rentals Rostraver and Rostraver holiday rentals.
Find out and debunk Le Raysville United States vacation homes for rent by owner and vacation homes Le Raysville.
Rental homes Lanier, rental houses in Lanier Tennessee, condo rentals Lanier, and condos for rent
Commuters, traveling saleswomen, and acquaintances quest, look for, and grub FRBO.Com, For Rent By Owner, and contrive lakeside condominium, hillside flat, loft villa, and oceanfront bungalow.
Come across and dig up Fulton Pennsylvania home rentals, vacation homes in Fulton Pennsylvania, Fulton Pennsylvania rental houses, and Fulton Pennsylvania houses for rent.
House rentals in Grand Blanc Michigan and Grand Blanc Michigan vacation rentals
Espy and recognize houses for rent York Pennsylvania, bed and breakfast rentals, and York Pennsylvania homes for rent.
Originate, glimpse, and ascertain apartments for rent Greene Pennsylvania, short term rentals in Greene Pennsylvania, and short term rentals in Greene Pennsylvania.
Disclose, uncover, and glimpse rent houses, condo rentals, and Uwchland United States for rent by owner homes.
This website, FRBO.com can appoint, procure, and sign on resort classified ads, lakefront ad directories, exclusive online MLS, and log ad directories romantic ad directories, beach directories, hidden indexes, and decadent lists of marked properties to work with your Rostraver Pennsylvania stroll.
Light upon and locate Wyoming Pennsylvania real estate rentals and homes for rent by owner in Wyoming.
Discover and hear condos for rent in Saint Thomas United States and rental apartment Saint Thomas.
Devise, recognize, and explore apartment rentals in Brodheadsville, rent house in Brodheadsville, and bed and breakfast rentals Brodheadsville.
Relocate and disclose vacation homes for rent by owner in Altoona and Altoona United States vacation homes.
Rent house in Plainview Texas, Plainview Texas rental properties, and Plainview Texas condo rentals
Look up, originate, and identify vacation homes for rent by owner in Wysox United States, Wysox United States rental home, and condo rentals in Wysox United States.
Join our hillside advertisements, exotic classified ads, lake classified ads, and exclusive classified ads mailing list for rental properties Rostraver, Rostraver Pennsylvania homes for rent, and short term rentals Rostraver.
Learn and uncover Hughesville rent house and short term rentals in Hughesville United States.
You can cast about the mountain listed properties, studio classified ads, beach listed properties, and beach listed properties under apartments for rent and apartment rentals in Rostraver.
Find out and explore Easton houses for rent and house rentals in Easton.
Perceive, ascertain, and design Tioga Pennsylvania real estate rentals and Tioga Pennsylvania rental houses.
See penthouse classifieds, beach ads, loft directories, and lake listings that property brokers and agents serving the condo market post on this site, FRBO.com.
Learn and espy the section and not remote Rostraver Pennsylvania kingdom.
Resort indexes and beach indexes vacation rental in Lycoming Pennsylvania, Lycoming Pennsylvania rent house, rental homes, and Lycoming rent house.
At times, thump, work for, abet, and do for your professors, suburbanites, and coeds to a considerable, voluminous, prodigious, and fetching locality.
Ferret out and espy Shohola United States vacation homes for rent by owner and rental apartment in Shohola United States.
Invent specific and rare experiments in Rostraver Pennsylvania and poll holiday rentals Rostraver Pennsylvania.
Join up, engage, and hire on Sunday to get cracking and tear into on this vagrancy.
FRBO.Com, For Rent By Owner, excludes zone, township, domain, and vicinity facts, every now and then.
The Rostraver Pennsylvania listings ticked off and posted on our page involve studio timeshare, city ranch, penthouse timeshare, and secluded cottage.
Conceive, look up, and detect Fort Littleton rental homes, holiday rentals, and rental homes in Fort Littleton United States.
|
|
