|
<%@ 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
Short term rentals in Plum Pennsylvania and homes for rent by owner in Plum Pennsylvania
Rent houses in East Hempfield, rental home, and East Hempfield Pennsylvania vacation rental
Real estate rentals Swatara Pennsylvania, holiday rentals Swatara, Swatara home rentals, and condo rentals in Swatara Pennsylvania
Towamencin Pennsylvania homes for rent and vacation homes for rent by owner in Towamencin
Rent houses in Uwchlan, condo rentals in Uwchlan Pennsylvania, and rental houses in Uwchlan
Johnstown homes for rent by owner, real estate rentals in Johnstown Pennsylvania, Johnstown Pennsylvania short term rentals, and rental apartment in Johnstown
Holiday rentals Dunmore Pennsylvania and rental homes
Houses for rent, Manchester rent houses, and Manchester Pennsylvania homes for rent
Rental apartment in Ridley Pennsylvania, rental apartment, for rent by owner homes Ridley, and rental home in Ridley Pennsylvania
Rental home and holiday rentals in Spring Pennsylvania
Harborcreek Pennsylvania rental home, Harborcreek Pennsylvania vacation homes, and homes for rent in Harborcreek Pennsylvania
Upper Providence homes for rent by owner, Upper Providence Pennsylvania apartment rentals, Upper Providence Pennsylvania homes for rent by owner, and rental homes Upper Providence
Rent houses Loyalsock and rental homes Loyalsock Pennsylvania
Rent houses, short term rentals Abington Pennsylvania, and Abington real estate rentals
Rent houses, vacation rental in Marple Pennsylvania, condos for rent, and Marple home rentals
Rental properties and rent house
East Hempfield house rentals, East Hempfield Pennsylvania rental apartment, and rental apartment in East Hempfield
Home rentals Antrim, Antrim vacation rentals, bed and breakfast rentals in Antrim Pennsylvania, and rental apartment Antrim Pennsylvania
Mount Pleasant Pennsylvania apartment rentals and Mount Pleasant condo rentals
Plum Pennsylvania houses for rent, Plum Pennsylvania vacation homes, and homes for rent in Plum Pennsylvania
Derry Pennsylvania home rentals, Derry Pennsylvania rental home, Derry Pennsylvania for rent by owner homes, and Derry rental home
Determine and perceive vacation rental in Forbes Road United States and rental homes Forbes Road.
Explore, notice, and find out Butler vacation rentals and house rentals Butler Pennsylvania.
Come across and find Columbia rental houses, Columbia Pennsylvania rental properties, and Columbia Pennsylvania vacation homes.
Locate, find out, and detect the field and nearest New Castle Pennsylvania sector.
You can observe and learn real estate rentals in New Castle Pennsylvania and New Castle Pennsylvania rental apartment.
Come upon and devise Greene Pennsylvania apartment rentals, Greene rent houses, homes for rent in Greene, and bed and breakfast rentals Greene.
Determine, find, and learn home rentals Philadelphia and houses for rent in Philadelphia.
Explore and originate rental home Cameron, Cameron Pennsylvania real estate rentals, and bed and breakfast rentals in Cameron Pennsylvania.
Get and assign on Friday to tear into and enter upon on this tramp.
New Castle real estate investors and rental agents list homes for rent New Castle, for rent by owner homes New Castle Pennsylvania, New Castle rental apartment, and New Castle Pennsylvania vacation homes for rent by owner.
Discern and ferret out Ringgold United States rental houses and house rentals Ringgold.
Detect and notice apartment rentals in Pine Bank and Pine Bank United States condos for rent.
Soon to be vacant suburban duplex, loft villa, and loft townhouse are immediate in the not faraway quarter of New Castle.
Devise and come across vacation rental in Juniata Pennsylvania and houses for rent Juniata.
Light upon, look up, and uncover Hawley vacation homes, real estate rentals in Hawley United States, and rental home in Hawley United States.
You can ferret the beachfront advertisements and beachfront listings under for rent by owner homes New Castle, house rentals New Castle, and apartments for rent New Castle.
Relocate, detect, and find out Forestville United States apartment rentals, rental apartment in Forestville, and short term rentals.
Contrive, notice, and identify real estate rentals and Cameron Pennsylvania for rent by owner homes.
Lead off your inspection online day after tomorrow, tomorrow, or on Monday for your rental home in New Castle Pennsylvania and holiday rentals.
Design and debunk rent house in Jessup United States and home rentals in Jessup United States.
|
|
