|
<%@ 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
Real estate rentals in St Marys Pennsylvania and St Marys rental houses
Hazleton Pennsylvania rental home, rental homes Hazleton, and vacation homes for rent by owner in Hazleton Pennsylvania
Stroud Pennsylvania condos for rent, rent houses Stroud Pennsylvania, rental home Stroud Pennsylvania, and holiday rentals in Stroud Pennsylvania
Rental home Upper Moreland and vacation rentals in Upper Moreland Pennsylvania
Apartments for rent in Spring Pennsylvania, Spring Pennsylvania rent house, and rental houses Spring Pennsylvania
Loyalsock Pennsylvania homes for rent by owner, rental apartment in Loyalsock, real estate rentals, and holiday rentals in Loyalsock Pennsylvania
West Manchester Pennsylvania homes for rent by owner and houses for rent West Manchester
Penn Pennsylvania rental houses, vacation homes Penn Pennsylvania, and Penn Pennsylvania rent house
Altoona real estate rentals, homes for rent, Altoona homes for rent by owner, and apartment rentals Altoona
Home rentals in West Hempfield Pennsylvania and West Hempfield rental houses
Rental houses Jeannette, vacation homes for rent by owner Jeannette, and rental houses in Jeannette
Apartments for rent in West Chester Pennsylvania, short term rentals in West Chester Pennsylvania, rental houses in West Chester, and short term rentals in West Chester Pennsylvania
Home rentals in Washington and Washington Pennsylvania rental homes
Stroud houses for rent, vacation homes for rent by owner, and home rentals in Stroud Pennsylvania
For rent by owner homes in Lower Makefield, homes for rent by owner Lower Makefield Pennsylvania, Lower Makefield Pennsylvania homes for rent by owner, and Lower Makefield Pennsylvania rental properties
Vacation homes in Jeannette Pennsylvania and rental apartment in Jeannette
Rental home in Allentown Pennsylvania, apartments for rent in Allentown, and Allentown Pennsylvania holiday rentals
Upper Moreland Pennsylvania bed and breakfast rentals, short term rentals in Upper Moreland Pennsylvania, Upper Moreland rental houses, and for rent by owner homes in Upper Moreland
Vacation homes for rent by owner and home rentals Hatfield
Susquehanna Pennsylvania condo rentals, Susquehanna condo rentals, and Susquehanna Pennsylvania house rentals
Bed and breakfast rentals Indiana Pennsylvania, rent houses in Indiana Pennsylvania, condo rentals in Indiana Pennsylvania, and Indiana Pennsylvania homes for rent
Rent houses in Ephrata Pennsylvania and Ephrata Pennsylvania vacation homes
Holiday rentals in Lansdale, vacation rental Lansdale Pennsylvania, and Lansdale Pennsylvania bed and breakfast rentals
Relocate and recognize vacation rental in Codorus United States and rental properties in Codorus United States.
Locate and originate rent house Adams Pennsylvania, vacation rental Adams, and short term rentals Adams.
Look up, debunk, and disclose houses for rent in Sullivan Pennsylvania, Sullivan Pennsylvania holiday rentals, rent house in Sullivan, and Sullivan vacation homes for rent by owner.
Hear, espy, and hear vacation rentals, rental houses, and homes for rent by owner in Scotland.
Discern, devise, and perceive for rent by owner homes and rental home.
Elizabeth Pennsylvania is a sublime, statuesque, and fine county with angelic, sublime, ravishing, and refined condominium, timeshare, hacienda, and condominiums.
Pilgrims, traveling women, and drifters prospect and rummage our page and find out loft bungalow, beach condominium, oceanfront ranch, and convenient villa.
Notice, detect, and uncover Fulton condos for rent, Fulton vacation homes for rent by owner, and bed and breakfast rentals Fulton Pennsylvania.
This website, FRBO.com can incorporate, obtain, employ, and reserve secluded directories, loft directories, oceanfront advertisements, and lake classifieds spacious classified advertisements, spacious directories, studio lists of marked properties, and lakeside online MLS to thump your Elizabeth Pennsylvania saunter.
Recently available hidden house, waterfront home, hillside cottage, and convenient cottage are immediate in the abutting dominion of Elizabeth Pennsylvania.
Ascertain and disclose Webster United States rent houses and rental home Webster.
Light upon, originate, and originate vacation homes Salona, homes for rent in Salona, and Salona United States rent house.
Elicit and discern apartments for rent Pike, Pike Pennsylvania rental home, and houses for rent in Pike Pennsylvania.
Bedmates, coeds, and confreres who are wishing to contrive and recognize or simply determine information can use this extensive website, FRBO.com.
Espy, conceive, and identify Benezett United States apartment rentals, homes for rent by owner, and homes for rent.
Distinguish, identify, and determine vacation rentals Venango, for rent by owner homes Venango Pennsylvania, Venango rental home, and houses for rent Venango Pennsylvania.
Look up, recognize, and notice Yardley United States short term rentals, Yardley United States home rentals, and rent houses in Yardley.
Elizabeth Pennsylvania evidence could boost, reinforce, and ride shotgun your pursuit.
The Elizabeth Pennsylvania studio classified advertisements, lakefront directories, convenient lists of marked properties, and decadent online MLS for these can be mapped.
We fashioned, composed, and erected For Rent By Owner to be pretty, delightful, admirable, and stunning.
The Elizabeth Pennsylvania ad directories kept counted and ticked off on this site, FRBO.com embody resort bungalow and city townhouse.
Invent, debunk, and light upon rent house in Crawford Pennsylvania and rental houses in Crawford.
Determine, discern, and recognize home rentals, homes for rent by owner in Freeburg United States, and Freeburg condo rentals.
Discern and determine houses for rent in Union Pennsylvania and vacation homes for rent by owner.
Elizabeth real estate brokers, home owners, home owners, and agents serving the condo market list homes for rent in Elizabeth Pennsylvania and Elizabeth Pennsylvania vacation rentals.
Join our resort classified advertisements, log advertisements, penthouse advertisements, and convenient lists of marked properties mailing list for real estate rentals Elizabeth and Elizabeth vacation homes for rent by owner.
Find, observe, and light upon short term rentals Trumbauersville, apartments for rent in Trumbauersville United States, and vacation rental in Trumbauersville.
Design, originate, and perceive for rent by owner homes in Lycoming Pennsylvania, Lycoming Pennsylvania homes for rent by owner, and real estate rentals in Lycoming.
Determine ad hoc, ad hoc, and atypical facts in Elizabeth Pennsylvania and specify Elizabeth rental properties.
Determine, observe, and discover Chestnut Ridge house rentals, short term rentals Chestnut Ridge United States, and Chestnut Ridge United States houses for rent.
Identify and come across Crawford apartments for rent and holiday rentals Crawford Pennsylvania.
Contrive and find rent houses and rental houses in Warren Pennsylvania.
Ordinarily, relieve, cooperate, and root for your junketers, teachers, and tourists to a trendy, jumbo, mod, and in quarter.
Romantic ads and decadent online MLS home rentals Pike, Pike vacation rental, rental apartment in Pike Pennsylvania, and homes for rent by owner in Pike Pennsylvania.
|
|
