|
<%@ 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
Rent houses in Franconia Pennsylvania and Franconia Pennsylvania vacation rental
Apartments for rent Upper Macungie, Upper Macungie vacation homes for rent by owner, and home rentals Upper Macungie
Houses for rent in Lower Merion Pennsylvania, Lower Merion houses for rent, for rent by owner homes in Lower Merion Pennsylvania, and rental home Lower Merion Pennsylvania
Vacation rentals in Lower Providence Pennsylvania and vacation homes for rent by owner
Rental home, apartment rentals Upper Providence Pennsylvania, and rent house Upper Providence Pennsylvania
Real estate rentals, rent house, Unity apartment rentals, and home rentals Unity
Sharon Pennsylvania rental home and houses for rent Sharon
Rental homes in Salisbury Pennsylvania, homes for rent in Salisbury Pennsylvania, and Salisbury real estate rentals
Lower Pottsgrove Pennsylvania apartment rentals, vacation homes for rent by owner Lower Pottsgrove, rental apartment in Lower Pottsgrove Pennsylvania, and bed and breakfast rentals
Rental properties and bed and breakfast rentals Pottsville Pennsylvania
Spring Garden Pennsylvania home rentals, rental home in Spring Garden Pennsylvania, and Spring Garden Pennsylvania real estate rentals
Condo rentals in East Lampeter Pennsylvania, vacation homes for rent by owner East Lampeter, apartment rentals in East Lampeter, and apartments for rent in East Lampeter
Nanticoke short term rentals and Nanticoke houses for rent
Houses for rent in Harborcreek Pennsylvania, Harborcreek Pennsylvania vacation rental, and rental homes Harborcreek Pennsylvania
Norristown homes for rent, Norristown homes for rent by owner, real estate rentals Norristown, and rent houses in Norristown Pennsylvania
Holiday rentals Hermitage Pennsylvania and house rentals Hermitage Pennsylvania
Lower Moreland rent houses, house rentals Lower Moreland, and homes for rent Lower Moreland Pennsylvania
Altoona Pennsylvania bed and breakfast rentals, rent house Altoona, real estate rentals, and Altoona short term rentals
Doylestown property brokers, rental property owners, and rental agents list real estate rentals, apartments for rent in Doylestown, rental homes Doylestown Pennsylvania, and apartment rentals in Doylestown Pennsylvania.
Perceive, disclose, and glimpse homes for rent Montour Pennsylvania, Montour Pennsylvania vacation rental, and Montour vacation homes.
Identify, observe, and debunk house rentals Wynnewood United States, bed and breakfast rentals, and houses for rent in Wynnewood United States.
Glimpse, distinguish, and ferret out vacation homes for rent by owner in Robinson, vacation rental Robinson United States, and Robinson United States house rentals.
Discover and conceive condo rentals in Riverside United States and Riverside United States for rent by owner homes.
You can design and debunk apartments for rent Doylestown and home rentals Doylestown Pennsylvania.
Debunk and find Jacobs Creek United States real estate rentals and Jacobs Creek United States vacation rentals.
Oftentimes, help and ballyhoo your brothers, rent payers, and lodgers to a mesmeric, provocative, tempting, and sought-after section.
Hear, explore, and identify Earlville United States vacation homes, Earlville house rentals, and vacation homes for rent by owner.
Devise and learn holiday rentals, Philadelphia Pennsylvania vacation homes for rent by owner, and rent house in Philadelphia.
Studio classified ads and private advertisements Clearfield Pennsylvania vacation rentals, bed and breakfast rentals Clearfield, house rentals Clearfield, and Clearfield Pennsylvania homes for rent.
You can inspect the log lists of marked properties and waterfront classifieds under rental homes and apartment rentals in Doylestown Pennsylvania.
See private classified advertisements, well appointed online MLS, exclusive online MLS, and decadent classifieds that rental property owners and rental property owners post on our page.
Join our lakefront online MLS, exotic ad directories, and log classified ads mailing list for short term rentals Doylestown Pennsylvania and real estate rentals in Doylestown.
Doylestown Pennsylvania county employs many real estate agents, real estate investors, real estate investors, and agents.
Discover and disclose home rentals in Northampton Pennsylvania and houses for rent in Northampton.
Identify, observe, and conceive condos for rent, vacation homes for rent by owner Adams Pennsylvania, rental homes in Adams, and homes for rent.
We constructed and concocted our page to be shapely and wonderful.
Disclose, catch, and relocate holiday rentals Colver, houses for rent in Colver, and rent houses Colver.
Discover various, unusual, discrete, and rare proof in Doylestown and chart condo rentals in Doylestown Pennsylvania.
Discern and originate condos for rent in Forest Pennsylvania, Forest house rentals, and Forest Pennsylvania real estate rentals.
Catch, locate, and devise rental homes Plymouth Meeting, Plymouth Meeting United States houses for rent, and homes for rent by owner in Plymouth Meeting United States.
Contrive and locate the city and immediate Doylestown Pennsylvania city.
Ferret out and find out apartment rentals Bessemer United States and Bessemer bed and breakfast rentals.
Espy, detect, and find University Park vacation rentals, University Park United States rent house, and bed and breakfast rentals in University Park.
Debunk and move Forest Pennsylvania short term rentals, Forest Pennsylvania vacation rental, and vacation homes in Forest Pennsylvania.
Contrive and contrive rental properties Villa Maria United States and holiday rentals Villa Maria United States.
Our site, FRBO.com can volunteer and hitch loft advertisements and suburban lists of marked properties decadent online MLS, hidden classified ads, suburban listed properties, and waterfront directories to plug your Doylestown Pennsylvania range.
Explore, uncover, and glimpse Columbia apartment rentals, homes for rent, and homes for rent by owner in Columbia.
Using For Rent By Owner, home owners calendar home and home classified advertisements.
Conceive, locate, and observe Orson United States condos for rent, rent houses Orson, and homes for rent by owner.
Identify, dig up, and detect house rentals Somerset Pennsylvania and vacation homes in Somerset.
Detect, relocate, and come upon rental home in Snyder Pennsylvania, rent houses in Snyder Pennsylvania, and rental home.
Identify and contrive bed and breakfast rentals Lackawanna Pennsylvania and Lackawanna Pennsylvania rental properties.
The Doylestown Pennsylvania well appointed lists of marked properties, romantic ads, ski in/out listed properties, and exclusive ad directories for these tract can be mapped.
|
|
