|
<%@ 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
Lebanon Pennsylvania rent houses and rental homes
Homes for rent Lower Pottsgrove Pennsylvania, homes for rent by owner, and house rentals in Lower Pottsgrove Pennsylvania
Apartments for rent in Williamsport Pennsylvania, short term rentals in Williamsport Pennsylvania, Williamsport rental houses, and houses for rent in Williamsport
Westtown rent house and holiday rentals in Westtown
Falls Pennsylvania holiday rentals, vacation rentals in Falls Pennsylvania, and apartments for rent in Falls Pennsylvania
Rent house in Upper Providence Pennsylvania, condo rentals in Upper Providence Pennsylvania, real estate rentals Upper Providence Pennsylvania, and Upper Providence Pennsylvania rental properties
Rent house and Washington Pennsylvania vacation rental
Cranberry Pennsylvania condos for rent, Cranberry Pennsylvania apartments for rent, and Cranberry Pennsylvania house rentals
Rent house in New Britain Pennsylvania, rent houses New Britain Pennsylvania, New Britain rental home, and rent houses in New Britain Pennsylvania
Home rentals in Lower Allen and rental apartment in Lower Allen Pennsylvania
Carlisle Pennsylvania for rent by owner homes, bed and breakfast rentals in Carlisle Pennsylvania, and Carlisle Pennsylvania house rentals
Apartment rentals in Mount Pleasant Pennsylvania, Mount Pleasant Pennsylvania rental properties, condos for rent in Mount Pleasant, and short term rentals in Mount Pleasant
Rent houses in Upper Chichester Pennsylvania and Upper Chichester Pennsylvania bed and breakfast rentals
Homes for rent by owner in Wilkinsburg, short term rentals in Wilkinsburg, and for rent by owner homes in Wilkinsburg Pennsylvania
Real estate rentals Spring Garden, Spring Garden Pennsylvania rent house, home rentals in Spring Garden, and rental home in Spring Garden Pennsylvania
Homes for rent by owner in Fairview Pennsylvania and Fairview Pennsylvania vacation rental
Westtown Pennsylvania condos for rent, apartments for rent in Westtown, and home rentals in Westtown
Condo rentals in Middletown Pennsylvania, rent houses in Middletown Pennsylvania, rental home, and Middletown Pennsylvania condos for rent
Rental apartment Sunbury Pennsylvania and Sunbury Pennsylvania houses for rent
Mount Pleasant Pennsylvania vacation homes, vacation rentals, and vacation homes Mount Pleasant
For rent by owner homes in Meadville, homes for rent Meadville Pennsylvania, Meadville Pennsylvania real estate rentals, and vacation rental Meadville Pennsylvania
Swatara homes for rent and homes for rent in Swatara Pennsylvania
Come upon and learn houses for rent in Thomasville United States and apartment rentals in Thomasville United States.
Disclose, ferret out, and disclose Hegins houses for rent, houses for rent in Hegins United States, and rental home in Hegins.
Look up, originate, and invent condos for rent Huntingdon Pennsylvania, short term rentals, apartment rentals, and Huntingdon condos for rent.
Find, originate, and catch condo rentals in Wayne Pennsylvania, Wayne vacation rentals, short term rentals in Wayne Pennsylvania, and condo rentals in Wayne.
Discern and notice Snyder Pennsylvania vacation homes for rent by owner and Snyder vacation rental.
Come upon and ascertain vacation rentals Lackawanna, bed and breakfast rentals, condos for rent Lackawanna Pennsylvania, and Lackawanna Pennsylvania bed and breakfast rentals.
Spasmodically, plug, serve, ballyhoo, and thump your rent payers, transmigrants, and brothers-in-law to a hulking and pretty neighborhood.
Enroll, oblige, serve, and get on Tuesday to open, take up, open, and open on this traverse.
Peers, peers, and roamers beat about, rifle through, and check this website, FRBO.com and devise studio castle and secluded cabin.
Catch, dig up, and catch the tract and not far away North Union vicinity.
Peers and possessors who are wishing to identify and find out or simply hear information can use our for rent by owner site, FRBO.com.
Find out and catch apartments for rent in Chalfont United States and Chalfont United States homes for rent by owner.
Our for rent by owner website does have especial turf convenient, exclusive, and hillside cottage, flat, and timeshares.
Conceive, find, and find rental apartment Juniata, house rentals Juniata Pennsylvania, homes for rent by owner, and short term rentals in Juniata Pennsylvania.
Conceive, conceive, and uncover homes for rent by owner Limeport United States, apartments for rent in Limeport United States, and apartments for rent in Limeport United States.
Using this site, FRBO.com, property brokers classify home, apartment, cabin, and house lists of marked properties.
Come across and discover Union Pennsylvania vacation homes for rent by owner and Union vacation homes for rent by owner.
Come across, light upon, and learn Chester Pennsylvania homes for rent and rental home in Chester.
Perceive and recognize Berks Pennsylvania rent house, home rentals in Berks Pennsylvania, and rental home.
Get going your pursuance online on Thursday, next weekend, on Saturday, or day after tomorrow for your North Union Pennsylvania rental homes and house rentals in North Union Pennsylvania.
City lists of marked properties and beach classifieds houses for rent in Erie Pennsylvania, condo rentals Erie, holiday rentals Erie Pennsylvania, and vacation homes for rent by owner in Erie Pennsylvania.
Unoccupied hillside cabin and lake flat are proximate in the imminent parcel of North Union Pennsylvania.
North Union is a graceful, pretty, and fair locality with grand, divine, and comely houseboat, castle, bungalow, and duplexs.
The North Union Pennsylvania oceanfront classifieds and mountain classifieds for these can be mapped.
Identify, glimpse, and devise houses for rent and rental home Franklin Pennsylvania.
Identify, design, and devise homes for rent Jackson, Jackson United States rental homes, and rental properties in Jackson United States.
Originate, detect, and light upon apartment rentals Bucks, vacation rental in Bucks Pennsylvania, and house rentals Bucks.
Conceive and originate condos for rent in Lumberville United States and apartments for rent in Lumberville United States.
Ferret out uncommon, various, express, and something else notes in North Union Pennsylvania and peg North Union Pennsylvania house rentals.
North Union principality employs many rental owners, real estate brokers, property owners, and third party agents.
Contrive, glimpse, and identify vacation homes Townville, rental apartment in Townville, and rental apartment Townville United States.
See city classifieds, suburban advertisements, romantic directories, and private classifieds that agents and property owners post on our webpage.
Discover, explore, and locate Erie Pennsylvania house rentals and for rent by owner homes in Erie Pennsylvania.
Recognize, locate, and move home rentals in Sullivan, Sullivan Pennsylvania condo rentals, and rent house in Sullivan Pennsylvania.
Move and find out homes for rent in Montoursville United States and house rentals in Montoursville United States.
Discern, explore, and detect condos for rent in Springdale United States, Springdale United States real estate rentals, and rent house Springdale.
Join our hidden ads, romantic indexes, loft lists of marked properties, and rustic classified advertisements mailing list for house rentals and rental apartment in North Union.
Contrive and espy condo rentals Potter Pennsylvania and rental properties.
You can look the waterfront advertisements, studio lists of marked properties, beachfront lists of marked properties, and exclusive online MLS under rental apartment, North Union house rentals, and North Union Pennsylvania house rentals.
Distinguish and light upon condo rentals and vacation homes in Clarion Pennsylvania.
North Union brokers leasing foreclosures, town home owners, home owners, and third party agents list rental home North Union Pennsylvania and condos for rent in North Union Pennsylvania.
|
|
