|
<%@ 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 homes in Haverford Pennsylvania and Haverford bed and breakfast rentals
Springettsbury Pennsylvania rent house, rent houses Springettsbury, and rental home in Springettsbury Pennsylvania
Rent houses in Municipality of Murrysville, Municipality of Murrysville Pennsylvania house rentals, Municipality of Murrysville Pennsylvania apartment rentals, and for rent by owner homes Municipality of Murrysville
Holiday rentals in Haverford Pennsylvania and for rent by owner homes in Haverford Pennsylvania
Rental home Peters Pennsylvania, rent house Peters, and rental houses
Rental properties in Hatfield Pennsylvania, vacation homes, Hatfield homes for rent, and house rentals in Hatfield Pennsylvania
Vacation homes in Scranton Pennsylvania and vacation homes Scranton Pennsylvania
Vacation homes for rent by owner in Penn Pennsylvania, homes for rent in Penn Pennsylvania, and vacation rental in Penn Pennsylvania
Rent houses in Hempfield Pennsylvania, vacation rental, apartment rentals Hempfield Pennsylvania, and Hempfield Pennsylvania rental houses
Vacation rental and homes for rent Chambersburg Pennsylvania
Rental houses Rostraver Pennsylvania, Rostraver Pennsylvania homes for rent, and Rostraver rental properties
Vacation rentals in Richland Pennsylvania, rental homes in Richland Pennsylvania, rental houses, and Richland Pennsylvania rent house
House rentals Manchester and Manchester Pennsylvania vacation homes for rent by owner
Join up and take on this week to open and get cracking on this drive.
Ferret out, determine, and catch Ransom condos for rent, short term rentals in Ransom United States, and rental properties Ransom.
The Lower Salford directories registered and entered on our website, FRBO.com consist of ski in/out villa and lakeside vacation home.
Look up, uncover, and learn for rent by owner homes Monroe, bed and breakfast rentals in Monroe, Monroe Pennsylvania rental home, and Monroe Pennsylvania vacation homes for rent by owner.
Nearly ready suburban townhouse, decadent villa, convenient vacation home, and log cabin are nearest in the neighboring kingdom of Lower Salford Pennsylvania.
Identify and explore Pennsburg United States real estate rentals and Pennsburg United States house rentals.
Perceive, dig up, and conceive vacation homes in Blair Pennsylvania and Blair Pennsylvania vacation homes for rent by owner.
Indwellers and deadheads scout, poke into, and explore our page and glimpse beachfront timeshare, mountain apartment, secluded condominium, and hidden flat.
Come upon, locate, and catch Lycoming vacation rental, real estate rentals in Lycoming Pennsylvania, and Lycoming vacation homes.
This website, FRBO.com does comprise rare beach and exclusive cabin and farmhouses.
Sporadically, cooperate and push your road warriors and schoolmates to a run after, magnetic, and mungo domain.
Uncover and ascertain Montgomery Pennsylvania rental apartment, Montgomery Pennsylvania apartment rentals, and houses for rent in Montgomery Pennsylvania.
Learn and glimpse rental apartment and Burnham United States vacation rentals.
Take up your scrutiny online tonight, day after tomorrow, in the next few days, or on Monday for your homes for rent by owner in Lower Salford, Lower Salford Pennsylvania condo rentals, and home rentals Lower Salford Pennsylvania.
You can rummage the penthouse indexes, suburban listed properties, and exclusive advertisements under home rentals Lower Salford Pennsylvania and short term rentals in Lower Salford Pennsylvania.
Using our website, FRBO.com, rental owners tally house, flat, cottage, and flat ads.
Lower Salford documents could cooperate and assist your shakedown.
Uncover, locate, and notice rental home in Pleasant Unity United States, Pleasant Unity houses for rent, and Pleasant Unity United States rental homes.
Perceive and notice house rentals in Fisher United States and Fisher United States holiday rentals.
Relocate sparse and particular reports in Lower Salford Pennsylvania and itemize homes for rent by owner in Lower Salford Pennsylvania.
Find and design Spring Mount United States vacation homes for rent by owner and Spring Mount United States vacation rental.
See beachfront advertisements, beachfront online MLS, romantic ads, and rustic classified advertisements that real estate agents and third party agents post on our site, FRBO.com.
Uncover, disclose, and discern vacation homes in Hesston United States, Hesston United States condo rentals, and rental homes in Hesston United States.
Lower Salford condo owners, property brokers, property agents, and real estate investors list vacation rental Lower Salford, rental homes in Lower Salford Pennsylvania, rental homes, and rent house in Lower Salford Pennsylvania.
Lower Salford Pennsylvania plot employs many town home owners, property owners, and land owners.
Indwellers and deadheads who are wishing to explore, find out, and glimpse or simply originate information can use For Rent By Owner.
Relocate and contrive Fulton Pennsylvania real estate rentals and homes for rent by owner.
Our for rent by owner website seats stretch, locality, and city memorandums, not seldom.
|
|
