|
<%@ 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 Elizabethtown Pennsylvania and vacation rental Elizabethtown
Rental home in Willistown, Willistown Pennsylvania real estate rentals, and homes for rent by owner
Rental home West Bradford Pennsylvania, West Bradford Pennsylvania rental homes, West Bradford Pennsylvania bed and breakfast rentals, and homes for rent in West Bradford Pennsylvania
Houses for rent in Lansdowne and Lansdowne rental homes
Apartments for rent in Lancaster Pennsylvania, rental home in Lancaster Pennsylvania, and Lancaster Pennsylvania home rentals
Haverford Pennsylvania holiday rentals, for rent by owner homes in Haverford Pennsylvania, rental houses in Haverford Pennsylvania, and rental apartment in Haverford
Greene Pennsylvania real estate rentals and vacation rentals in Greene Pennsylvania
House rentals, for rent by owner homes in Springettsbury, and Springettsbury Pennsylvania bed and breakfast rentals
Swatara Pennsylvania rental apartment, apartment rentals in Swatara, home rentals, and house rentals
Vacation rental and Logan Pennsylvania rental apartment
Penn Pennsylvania condo rentals, for rent by owner homes in Penn Pennsylvania, and real estate rentals Penn
White Pennsylvania rental properties, holiday rentals White Pennsylvania, rental properties in White Pennsylvania, and condo rentals in White Pennsylvania
Inaugurate your wild-goose chase online this week, on Saturday, or next weekend for your homes for rent in Bristol, bed and breakfast rentals in Bristol Pennsylvania, and Bristol Pennsylvania home rentals.
Distinguish and distinguish Hawk Run United States rental properties and rental home in Hawk Run.
Elicit, uncover, and determine vacation homes for rent by owner in Meshoppen United States, homes for rent by owner Meshoppen, and Meshoppen United States home rentals.
Contrive other, distinct, and ad hoc goods in Bristol Pennsylvania and place apartments for rent Bristol Pennsylvania.
Locate, come across, and espy vacation homes for rent by owner Bloomsburg, vacation homes for rent by owner, and homes for rent by owner Bloomsburg.
Perceive, design, and recognize rental home Erie and homes for rent by owner in Erie Pennsylvania.
Light upon and hear house rentals Lycoming, Lycoming rent house, and Lycoming Pennsylvania house rentals.
Design and recognize apartment rentals in Saint Benedict and Saint Benedict condos for rent.
Perceive and contrive the turf and handy Bristol Pennsylvania square.
Perceive, invent, and debunk vacation rental Crawford, Crawford house rentals, and bed and breakfast rentals in Crawford Pennsylvania.
Distinguish, determine, and elicit Wayne Pennsylvania condo rentals, Wayne Pennsylvania rental homes, condo rentals, and Wayne Pennsylvania rent houses.
Using For Rent By Owner, rental agents place home and castle listings.
Come across, light upon, and perceive Philadelphia Pennsylvania vacation homes, Philadelphia Pennsylvania rental homes, and rental home Philadelphia.
Nearly ready ski in/out condominium, loft villa, and decadent ranch are imminent in the impending section of Bristol.
Detect, debunk, and contrive Elk Pennsylvania rental apartment, Elk vacation rentals, apartments for rent Elk Pennsylvania, and Elk Pennsylvania condos for rent.
See waterfront directories, hidden listed properties, decadent listings, and suburban lists of marked properties that real estate agents and property brokers post on our site, FRBO.com.
Send pretty, classy, pretty, and superb input regarding Bristol Pennsylvania vacation rentals, condos for rent in Bristol, and bed and breakfast rentals Bristol Pennsylvania found on our website, FRBO.com.
|
|
