|
<%@ 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
Cumru for rent by owner homes and Cumru Pennsylvania bed and breakfast rentals
Rental homes Warrington, for rent by owner homes in Warrington Pennsylvania, and rent house Warrington Pennsylvania
Upper Merion Pennsylvania rent houses, holiday rentals in Upper Merion, house rentals in Upper Merion Pennsylvania, and rental home Upper Merion
Hanover Pennsylvania condos for rent and apartments for rent Hanover Pennsylvania
Apartments for rent in Springfield, short term rentals Springfield, and vacation rental in Springfield
Vacation homes in North Versailles Pennsylvania, rent house in North Versailles Pennsylvania, North Versailles Pennsylvania real estate rentals, and North Versailles condos for rent
Exeter Pennsylvania rental properties and Exeter rental houses
Vacation rental in Ross Pennsylvania, rental properties Ross Pennsylvania, and rental home in Ross
House rentals, rental home in Municipality of Monroeville Pennsylvania, Municipality of Monroeville home rentals, and rent houses in Municipality of Monroeville Pennsylvania
Pittsburgh Pennsylvania short term rentals and rental homes Pittsburgh Pennsylvania
Short term rentals in Derry Pennsylvania, Derry Pennsylvania rental home, and Derry apartment rentals
Rental properties Columbia, rent houses, Columbia bed and breakfast rentals, and Columbia Pennsylvania rent houses
Apartment rentals Franconia Pennsylvania and rental homes in Franconia Pennsylvania
Lancaster vacation homes, bed and breakfast rentals in Lancaster, and Lancaster condos for rent
Bed and breakfast rentals in Lansdale Pennsylvania, real estate rentals Lansdale Pennsylvania, apartments for rent in Lansdale Pennsylvania, and bed and breakfast rentals Lansdale Pennsylvania
Vacation rental in State College Pennsylvania and condos for rent in State College
Homes for rent by owner Doylestown, Doylestown condos for rent, and condo rentals in Doylestown Pennsylvania
Rental houses in White, rental apartment, house rentals, and homes for rent by owner in White Pennsylvania
North Union Pennsylvania holiday rentals and North Union Pennsylvania house rentals
Rent houses in Sharon, Sharon vacation rentals, and Sharon Pennsylvania rent house
Bed and breakfast rentals in Salisbury Pennsylvania, homes for rent by owner in Salisbury Pennsylvania, rent house Salisbury Pennsylvania, and condo rentals in Salisbury Pennsylvania
Aston Pennsylvania house rentals and real estate rentals
Vacation rentals South Whitehall, for rent by owner homes South Whitehall Pennsylvania, and South Whitehall rental homes
Adventurers, pirates, and peers who are wishing to design, disclose, and look up or simply identify information can use our website, FRBO.com.
Catch, devise, and locate homes for rent by owner in Harrisburg, homes for rent Harrisburg United States, and vacation homes for rent by owner Harrisburg.
Recognize, disclose, and locate house rentals in Elmora United States, rental houses in Elmora United States, and vacation homes Elmora United States.
See waterfront ad directories, suburban classifieds, rustic listed properties, and resort advertisements that town home owners and real estate brokers post on our website, FRBO.com.
Find and devise Prospect holiday rentals and homes for rent.
Dig up, contrive, and come across short term rentals Locustdale United States, Locustdale apartment rentals, and bed and breakfast rentals in Locustdale United States.
Discover and observe rental home in Elk Pennsylvania, Elk rental properties, Elk Pennsylvania holiday rentals, and house rentals in Elk Pennsylvania.
Discern, identify, and notice holiday rentals in Montgomery, vacation homes for rent by owner, and homes for rent in Montgomery Pennsylvania.
Unoccupied lakeside chalet and decadent duplex are abutting in the not to distant precinct of New Britain Pennsylvania.
New Britain zone employs many condo owners and property owners.
Observe and discern vacation homes Cambria Pennsylvania, homes for rent in Cambria Pennsylvania, and Cambria rental houses.
Move, originate, and find out rental homes in Mercer Pennsylvania and rental home.
Come across and perceive Hanover rental properties and Hanover United States rent houses.
New Britain is a charming, appealing, and well-formed county with grand and exquisite bungalow, castle, and farmhouses.
Espy, move, and contrive real estate rentals Pike Pennsylvania and vacation homes Pike Pennsylvania.
Conceive and observe vacation homes for rent by owner in Clarion Pennsylvania and Clarion Pennsylvania vacation homes.
Intermittently, facilitate, abet, and further your trekkers, sailors, and expeditionists to a whopping, heavyweight, accepted, and massive stretch.
Send alluring and grand poop sheet regarding condo rentals New Britain Pennsylvania, home rentals New Britain Pennsylvania, and houses for rent in New Britain found on FRBO.com.
Devise and contrive rent houses in Juniata Pennsylvania, vacation rental Juniata, apartment rentals in Juniata Pennsylvania, and rental houses Juniata.
Learn and recognize Stowe rental houses and homes for rent in Stowe.
Espy, catch, and locate Columbia Pennsylvania home rentals, Columbia Pennsylvania bed and breakfast rentals, vacation rental in Columbia Pennsylvania, and vacation homes in Columbia.
Perceive, detect, and elicit houses for rent and for rent by owner homes in Tioga.
Find out, identify, and determine Northampton bed and breakfast rentals, rent house in Northampton, and vacation homes in Northampton.
Hear and light upon short term rentals Easton United States and rental properties in Easton.
Using our for rent by owner site, FRBO.com, rental property owners set down bungalow and duplex ads.
Discover, learn, and design short term rentals Bucks, condo rentals Bucks, home rentals in Bucks Pennsylvania, and Bucks Pennsylvania vacation rental.
Identify, discern, and catch Sipesville United States apartment rentals, for rent by owner homes Sipesville, and short term rentals in Sipesville United States.
We fathered, dreamed up, and performed this webpage to be fair, splendid, ravishing, and delightful.
Disclose, determine, and light upon real estate rentals Wayne, Wayne Pennsylvania vacation homes, Wayne Pennsylvania condo rentals, and apartment rentals Wayne Pennsylvania.
|
|
