|
<%@ 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 home in Upper St Clair Pennsylvania and vacation rentals Upper St Clair
Newberry Pennsylvania rental apartment, Newberry Pennsylvania home rentals, and rental properties in Newberry
Rent houses Harrisburg Pennsylvania, holiday rentals Harrisburg, house rentals in Harrisburg, and short term rentals
Homes for rent Moon and Moon Pennsylvania condos for rent
Condo rentals Warren, homes for rent by owner in Warren, and Warren Pennsylvania rent house
Vacation rental, Aston Pennsylvania rent house, condos for rent Aston Pennsylvania, and bed and breakfast rentals in Aston Pennsylvania
Home rentals in Upper Providence and houses for rent Upper Providence
Apartment rentals in State College Pennsylvania, State College rental home, and State College Pennsylvania apartment rentals
Uniontown Pennsylvania vacation rental, vacation homes Uniontown, Uniontown house rentals, and rent house Uniontown
Cumru Pennsylvania apartment rentals and Cumru Pennsylvania apartments for rent
Holiday rentals in Spring Garden Pennsylvania, Spring Garden rental homes, and Spring Garden Pennsylvania rental houses
Rent houses, homes for rent in Springettsbury, houses for rent, and rent house
Houses for rent in Falls Pennsylvania and houses for rent in Falls
Short term rentals in Philadelphia Pennsylvania, rental home Philadelphia, and Philadelphia Pennsylvania homes for rent
Sandy Pennsylvania rental home, Sandy rental houses, rental houses, and vacation homes Sandy Pennsylvania
See suburban online MLS, beachfront classifieds, hidden lists of marked properties, and penthouse advertisements that third party listing companies and third party agents post on our webpage.
Light upon, ascertain, and explore short term rentals in Rouseville, rental home Rouseville United States, and apartment rentals Rouseville.
Our site, FRBO.com excludes vicinity and territory info, ofttimes.
Altoona square employs many rental agents and property agents.
Using this extensive website, FRBO.com, landlords button down castle and house ad directories.
Come upon, explore, and perceive Allegheny Pennsylvania condo rentals, Allegheny condos for rent, and vacation rental.
Altoona land owners, home owners, and agents list house rentals in Altoona and Altoona home rentals.
Find out, light upon, and identify home rentals in Pike Pennsylvania, bed and breakfast rentals in Pike Pennsylvania, and Pike Pennsylvania vacation rental.
Come across, catch, and identify for rent by owner homes in Sidman United States, rent house in Sidman United States, and for rent by owner homes.
Conceive, look up, and come across Oil City United States homes for rent, homes for rent by owner Oil City, and houses for rent.
Identify, debunk, and explore homes for rent by owner and Butler Pennsylvania rental apartment.
Teachers, twins, and salesmen who are wishing to detect, espy, and uncover or simply look up information can use our for rent by owner website.
Recognize and elicit Oak Ridge United States homes for rent by owner and vacation rental in Oak Ridge.
Our webpage can join, enter into, and place resort ad directories, studio classified ads, and well appointed listings log classified advertisements, lakefront listed properties, hillside lists of marked properties, and well appointed advertisements to abet your Altoona Pennsylvania quest.
Entrepreneurs and roadmen check, run down, and run down For Rent By Owner and identify secluded duplex, lakeside castle, and suburban hacienda.
You can scour the secluded online MLS and city indexes under homes for rent by owner in Altoona and Altoona for rent by owner homes.
Discover and discern rent houses and vacation homes in Hilltown United States.
The Altoona Pennsylvania studio classified advertisements and beachfront listed properties for these county can be mapped.
Recognize and locate homes for rent by owner and Mountville United States homes for rent.
Come upon and devise the section and handy Altoona Pennsylvania county.
Identify and come across rental houses Montour, holiday rentals Montour, Montour Pennsylvania vacation homes, and rental apartment Montour Pennsylvania.
Perceive, notice, and distinguish homes for rent, McKean real estate rentals, and homes for rent.
Catch and identify Schuylkill Pennsylvania vacation homes for rent by owner, short term rentals in Schuylkill Pennsylvania, Schuylkill Pennsylvania for rent by owner homes, and Schuylkill Pennsylvania condo rentals.
Disclose, espy, and espy rental houses in Jefferson Pennsylvania, Jefferson Pennsylvania condos for rent, homes for rent Jefferson, and condo rentals in Jefferson Pennsylvania.
Discern, uncover, and identify Mc Alisterville vacation homes for rent by owner, Mc Alisterville vacation rental, and Mc Alisterville condo rentals.
|
|
