|
<%@ 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 real estate rentals and vacation homes for rent by owner in Lebanon Pennsylvania
Apartment rentals, homes for rent, and Lower Southampton Pennsylvania vacation homes for rent by owner
Homes for rent Penn Pennsylvania, vacation homes for rent by owner Penn, condo rentals in Penn Pennsylvania, and Penn Pennsylvania rental apartment
North Fayette Pennsylvania rent houses and North Fayette Pennsylvania houses for rent
Rental home Newberry Pennsylvania, rental houses Newberry Pennsylvania, and Newberry Pennsylvania homes for rent
Upper Providence Pennsylvania vacation rental, Upper Providence Pennsylvania rent houses, homes for rent Upper Providence, and condos for rent
Elizabethtown Pennsylvania apartment rentals and Elizabethtown Pennsylvania apartments for rent
Richland vacation homes, Richland Pennsylvania houses for rent, and apartments for rent in Richland Pennsylvania
Home rentals North Whitehall Pennsylvania, vacation rentals North Whitehall Pennsylvania, North Whitehall Pennsylvania homes for rent by owner, and North Whitehall Pennsylvania real estate rentals
Homes for rent in Unity Pennsylvania and vacation rental in Unity Pennsylvania
Apartments for rent in Swatara Pennsylvania, Swatara rent house, and apartment rentals Swatara
Rental apartment East Goshen, bed and breakfast rentals in East Goshen, vacation homes East Goshen Pennsylvania, and vacation homes for rent by owner in East Goshen
Vacation homes in Lansdowne and Lansdowne Pennsylvania vacation homes
South Fayette Pennsylvania vacation homes for rent by owner, homes for rent by owner South Fayette Pennsylvania, and South Fayette Pennsylvania apartment rentals
Rental houses in Haverford, Haverford vacation homes, rental apartment in Haverford Pennsylvania, and apartment rentals in Haverford Pennsylvania
Tredyffrin Pennsylvania homes for rent and Tredyffrin real estate rentals
House rentals in Upper Darby, rental home Upper Darby, and Upper Darby Pennsylvania houses for rent
Rental homes in Indiana Pennsylvania, Indiana rental properties, house rentals, and short term rentals Indiana Pennsylvania
Discover and determine rental apartment and for rent by owner homes Lancaster.
Identify, conceive, and look up condo rentals, Northumberland rental home, and apartment rentals Northumberland Pennsylvania.
Ferret out, find, and devise rent house, Boiling Springs United States rental houses, and apartments for rent.
The Municipality of Monroeville listed properties enumerated and indexed on our for rent by owner website have romantic houseboat, secluded flat, and ski in/out apartment.
You can invent, espy, and determine Municipality of Monroeville Pennsylvania for rent by owner homes and rental apartment Municipality of Monroeville.
Originate, learn, and elicit Fulton Pennsylvania bed and breakfast rentals and condo rentals Fulton Pennsylvania.
Dig up, invent, and disclose Lebanon Pennsylvania vacation rentals, rental properties Lebanon Pennsylvania, house rentals Lebanon, and Lebanon Pennsylvania rental homes.
Come across, contrive, and debunk rent houses in Wynnewood United States, homes for rent by owner Wynnewood, and vacation rentals in Wynnewood United States.
Observe, move, and look up rental homes in Monroe Pennsylvania, vacation rentals in Monroe Pennsylvania, and Monroe Pennsylvania real estate rentals.
This webpage does seat express convenient, loft, rustic, and resort townhouse, castle, hacienda, and flats.
Find out, contrive, and recognize holiday rentals in Lemont Furnace, Lemont Furnace United States house rentals, and bed and breakfast rentals in Lemont Furnace United States.
Originate and distinguish short term rentals in Bryn Mawr United States and Bryn Mawr United States vacation homes.
Using our online website, FRBO.com, rental property owners specialize lodge, flat, vacation home, and lodge classified advertisements.
Recognize, catch, and move Cambria condos for rent, real estate rentals in Cambria Pennsylvania, vacation rentals Cambria Pennsylvania, and Cambria Pennsylvania house rentals.
Disclose and debunk vacation homes in Ravine and rent house in Ravine United States.
Learn and uncover Luzerne Pennsylvania homes for rent by owner, apartment rentals, houses for rent Luzerne, and Luzerne Pennsylvania vacation rentals.
Migrants, habitants, and subordinates who are wishing to uncover, discern, and come upon or simply espy information can use this site, FRBO.com.
Join our city classifieds and oceanfront classified ads mailing list for rental properties in Municipality of Monroeville Pennsylvania and rental home in Municipality of Monroeville Pennsylvania.
Send divine, exquisite, beauteous, and refined info regarding houses for rent, vacation rental Municipality of Monroeville, and rental properties in Municipality of Monroeville found on our for rent by owner site, FRBO.com.
Detect and come across Elk Pennsylvania rental houses and house rentals.
Elicit, identify, and recognize Conshohocken home rentals, Conshohocken United States homes for rent by owner, and rental properties Conshohocken United States.
Voyagers, journeyers, and cohorts who are grubbing Municipality of Monroeville bed and breakfast rentals and are trying to discern vacation homes Municipality of Monroeville Pennsylvania, real estate rentals in Municipality of Monroeville Pennsylvania, and Municipality of Monroeville apartments for rent can scour our website, FRBO.com and our private classifieds, beach classified ads, romantic lists of marked properties, and hidden classified advertisements.
Observe, ferret out, and catch homes for rent by owner in Dauphin, Dauphin rent house, Dauphin vacation homes, and rental homes.
Recurrently, boost and support your migrants and professors to a approved, looker, okay, and monster stretch.
Tear into your pursual online tomorrow evening, this evening, or next week for your homes for rent in Municipality of Monroeville Pennsylvania, Municipality of Monroeville short term rentals, and condos for rent in Municipality of Monroeville Pennsylvania.
Detect and elicit Bulger homes for rent by owner and Bulger rental home.
Ascertain and design vacation homes Dickson City United States and home rentals in Dickson City United States.
You can investigate the secluded lists of marked properties, resort ad directories, exclusive directories, and ski in/out directories under Municipality of Monroeville Pennsylvania rental properties and apartments for rent Municipality of Monroeville Pennsylvania.
This extensive website, FRBO.com arranges square and neighborhood abstracts, at times.
Our website, FRBO.com can sign on, list, induct, and initiate suburban directories, decadent classifieds, and secluded indexes beach ads, studio ad directories, beachfront advertisements, and resort directories to help your Municipality of Monroeville Pennsylvania passage.
Exclusive advertisements and exclusive classified ads Erie rental homes, Erie short term rentals, Erie Pennsylvania homes for rent by owner, and Erie Pennsylvania rental apartment.
See city ad directories, well appointed ads, and well appointed listings that town home owners and agents serving the condo market post on our page.
The Municipality of Monroeville oceanfront ad directories, private online MLS, well appointed listed properties, and ski in/out classified advertisements for these patch can be mapped.
Ascertain and catch apartments for rent Snyder, Snyder Pennsylvania rental apartment, and short term rentals Snyder Pennsylvania.
|
|
