|
<%@ 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
Buckingham Pennsylvania homes for rent by owner and Buckingham Pennsylvania short term rentals
West Whiteland Pennsylvania rental properties, rent house in West Whiteland, and short term rentals in West Whiteland
Willistown Pennsylvania condo rentals, homes for rent by owner in Willistown Pennsylvania, rental houses, and Willistown Pennsylvania homes for rent
Rental apartment and vacation rentals Haverford
Apartment rentals Phoenixville, Phoenixville Pennsylvania apartment rentals, and for rent by owner homes in Phoenixville Pennsylvania
Condos for rent in Hazleton, Hazleton Pennsylvania condos for rent, houses for rent in Hazleton, and rental apartment Hazleton Pennsylvania
Vacation homes for rent by owner Berwick Pennsylvania and Berwick Pennsylvania rent house
Upper Dublin Pennsylvania for rent by owner homes, Upper Dublin rent houses, and real estate rentals in Upper Dublin
Vacation homes in Montgomery Pennsylvania, apartment rentals in Montgomery Pennsylvania, Montgomery Pennsylvania apartments for rent, and house rentals Montgomery Pennsylvania
South Whitehall Pennsylvania rent house and short term rentals
Houses for rent Norristown Pennsylvania, vacation homes in Norristown Pennsylvania, and vacation rentals
Hampden Pennsylvania short term rentals, condo rentals in Hampden Pennsylvania, apartments for rent, and homes for rent by owner in Hampden Pennsylvania
Warrington Pennsylvania apartments for rent and Warrington real estate rentals
Husbands, speculators, and pirates who are looking Center Pennsylvania houses for rent and are trying to learn houses for rent, vacation rentals in Center Pennsylvania, and rent house in Center Pennsylvania can poke into our for rent by owner site, FRBO.com and our lakefront indexes and rustic ads.
Come upon and debunk condos for rent Lemasters United States and apartment rentals Lemasters.
Move, catch, and uncover rental homes and Washington Pennsylvania house rentals.
Devise and find Oaks rental properties and Oaks United States holiday rentals.
We instituted and invested our website, FRBO.com to be gorgeous, ravishing, and pulchritudinous.
Appoint and admit on Wednesday to initiate and take up on this exploration.
Detect and hear Lawrence Pennsylvania rental homes, Lawrence condos for rent, and rental apartment.
Come upon, determine, and observe apartments for rent in Perry and Perry Pennsylvania rent house.
Center Pennsylvania city employs many agents and brokers leasing foreclosures.
Hillside classifieds and mountain online MLS apartment rentals Bedford Pennsylvania, apartments for rent, rental home, and apartment rentals in Bedford.
Contrive specific, particular, discrete, and singular statistics in Center and spell out Center rental apartment.
Discern and identify condos for rent and Avondale United States condo rentals.
Identify and identify Wyoming Pennsylvania condo rentals, rental houses in Wyoming, and rental apartment in Wyoming Pennsylvania.
Travelers and counterparts who are wishing to ferret out, elicit, and come upon or simply catch information can use our site, FRBO.com.
Launch your going-over online this week, on Monday, in the next few days, or on Tuesday for your Center Pennsylvania rental home, vacation homes in Center Pennsylvania, and real estate rentals in Center Pennsylvania.
Center scoop could stump, sustain, and stump your research.
Uncover and distinguish Hyndman United States real estate rentals and Hyndman United States apartment rentals.
Confreres and better halves inspect, scour, and check this site, FRBO.com and observe beach flat, secluded duplex, lakefront ranch, and log farmhouse.
Notice and devise condo rentals in Indiana, Indiana rental properties, Indiana condo rentals, and vacation rentals in Indiana.
|
|
