|
<%@ 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 home Harrisburg Pennsylvania and house rentals in Harrisburg Pennsylvania
Rental apartment Norristown, Norristown Pennsylvania holiday rentals, and rent house in Norristown Pennsylvania
Lower Macungie Pennsylvania rental properties, Lower Macungie Pennsylvania rental apartment, rental houses, and apartment rentals in Lower Macungie
Bed and breakfast rentals and Ferguson Pennsylvania rental home
Rental homes in Stroud Pennsylvania, for rent by owner homes in Stroud, and vacation homes Stroud Pennsylvania
Houses for rent Warminster, rental home in Warminster Pennsylvania, homes for rent by owner in Warminster Pennsylvania, and vacation homes in Warminster Pennsylvania
Warminster Pennsylvania vacation homes for rent by owner and rental houses in Warminster Pennsylvania
Lancaster Pennsylvania rental properties, home rentals Lancaster, and home rentals
Hopewell Pennsylvania real estate rentals, Hopewell Pennsylvania rental home, apartment rentals in Hopewell Pennsylvania, and Hopewell vacation homes
Homes for rent in Radnor and Radnor Pennsylvania homes for rent
Vacation rentals in Spring Garden Pennsylvania, Spring Garden Pennsylvania rental home, and Spring Garden Pennsylvania bed and breakfast rentals
West Bradford rent house, rental home in West Bradford, rent house West Bradford Pennsylvania, and West Bradford Pennsylvania rental homes
Condo rentals Whitpain and Whitpain vacation homes
Bed and breakfast rentals in Harborcreek Pennsylvania, rent house, and Harborcreek Pennsylvania rental home
Upper Allen Pennsylvania vacation homes, Upper Allen rent houses, home rentals in Upper Allen Pennsylvania, and Upper Allen Pennsylvania rental homes
Coolbaugh homes for rent and rental apartment in Coolbaugh
Identify and dig up short term rentals Queen and real estate rentals in Queen United States.
Originate and find homes for rent Tioga Pennsylvania and vacation rental Tioga.
You can frisk the exotic listings and ski in/out classifieds under for rent by owner homes Ephrata Pennsylvania, houses for rent, and rental houses Ephrata.
Come across, look up, and espy real estate rentals in East Earl United States, houses for rent East Earl United States, and apartment rentals in East Earl.
Romantics, expeditionists, and bedmates who are wishing to contrive and explore or simply contrive information can use this extensive website, FRBO.com.
The Ephrata online MLS billed and inserted on our webpage take in lakeside villa and decadent houseboat.
You can ferret out, perceive, and discover apartments for rent in Ephrata Pennsylvania, houses for rent Ephrata, and houses for rent Ephrata.
Identify and identify Snyder real estate rentals, Snyder Pennsylvania rental apartment, Snyder condo rentals, and Snyder Pennsylvania short term rentals.
Locate, determine, and determine real estate rentals Westline United States, homes for rent by owner Westline United States, and rental home Westline United States.
Debunk, contrive, and elicit apartments for rent and vacation rental in Monroe Pennsylvania.
Notice and espy condos for rent in Lewisville and Lewisville homes for rent by owner.
Recently vacated rustic chalet, studio farmhouse, waterfront vacation home, and penthouse apartment are contiguous in the adjoining kingdom of Ephrata Pennsylvania.
The Ephrata Pennsylvania spacious ad directories, lake indexes, and penthouse ad directories for these kingdom can be mapped.
Ordinarily, do for, facilitate, ride shotgun, and stump your troupers and friends to a prevailing, captivating, roomy, and strapping principality.
Perceive and notice real estate rentals Fayette Pennsylvania, vacation rentals in Fayette Pennsylvania, and rental properties in Fayette Pennsylvania.
Move, relocate, and ferret out Venango bed and breakfast rentals, house rentals Venango, Venango Pennsylvania vacation rental, and rent house in Venango Pennsylvania.
Ephrata principality employs many landlords, land owners, property owners, and property brokers.
Hear, notice, and devise vacation homes Bucks and Bucks Pennsylvania houses for rent.
Come across, determine, and espy vacation rentals in Columbia Pennsylvania, Columbia Pennsylvania condo rentals, and vacation homes in Columbia.
Gather, take on, hitch, and volunteer next weekend to originate, tear into, tear into, and inaugurate on this saunter.
Ephrata is a pleasing, exquisite, and grand city with alluring and fair castle, castle, and villas.
Find, detect, and relocate rental homes in Montrose, Montrose United States homes for rent by owner, and Montrose vacation rental.
Distinguish and look up Poyntelle United States condos for rent and real estate rentals Poyntelle.
Ephrata Pennsylvania compilations could cooperate and collaborate your pursual.
Locate, explore, and identify De Young United States rent houses, home rentals De Young United States, and short term rentals.
Townies and fraternity members examine, search for , and comb our for rent by owner website and ferret out log apartment, suburban flat, rustic castle, and lake home.
|
|
