|
<%@ 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
For rent by owner homes and holiday rentals in Manchester Pennsylvania
Logan Pennsylvania for rent by owner homes, home rentals, and for rent by owner homes in Logan
Rental apartment in Marple Pennsylvania, rent house in Marple Pennsylvania, Marple Pennsylvania rental homes, and Marple Pennsylvania home rentals
Short term rentals in Norristown Pennsylvania and real estate rentals Norristown
Houses for rent in Nether Providence Pennsylvania, vacation homes in Nether Providence, and Nether Providence Pennsylvania bed and breakfast rentals
Butler Pennsylvania homes for rent, Butler Pennsylvania rental home, Butler Pennsylvania apartments for rent, and vacation rental Butler
Short term rentals East Hempfield Pennsylvania and rental home in East Hempfield
South Park Pennsylvania condo rentals, rent houses in South Park Pennsylvania, and South Park vacation homes for rent by owner
Pottstown Pennsylvania vacation homes for rent by owner, rental properties in Pottstown Pennsylvania, vacation rentals in Pottstown Pennsylvania, and home rentals
East Goshen Pennsylvania condo rentals and vacation homes for rent by owner in East Goshen
Apartment rentals in Spring Garden, Spring Garden apartment rentals, and vacation rentals in Spring Garden Pennsylvania
Houses for rent, York Pennsylvania vacation homes, York rental apartment, and rent house in York Pennsylvania
Bed and breakfast rentals in Upper Merion and rental home in Upper Merion Pennsylvania
Houses for rent North Whitehall Pennsylvania, North Whitehall Pennsylvania rental houses, and vacation rental in North Whitehall Pennsylvania
Real estate rentals Harborcreek, apartment rentals Harborcreek Pennsylvania, apartments for rent Harborcreek Pennsylvania, and rental houses Harborcreek
Rent house in Middletown Pennsylvania and rent houses Middletown Pennsylvania
Holiday rentals in Pittsburgh Pennsylvania, rent house Pittsburgh, and rental properties in Pittsburgh Pennsylvania
Vacation rental in Nether Providence, Nether Providence Pennsylvania apartments for rent, rental home in Nether Providence, and homes for rent by owner in Nether Providence
Wilkes-Barre short term rentals and homes for rent by owner Wilkes-Barre Pennsylvania
Vacation homes for rent by owner in Uniontown, Uniontown Pennsylvania home rentals, and Uniontown Pennsylvania house rentals
Whitehall Pennsylvania bed and breakfast rentals, vacation rental Whitehall Pennsylvania, Whitehall Pennsylvania vacation homes for rent by owner, and short term rentals Whitehall Pennsylvania
Radnor Pennsylvania for rent by owner homes and Radnor Pennsylvania vacation homes
Find out, move, and originate vacation homes for rent by owner, homes for rent by owner in Saint Boniface United States, and home rentals Saint Boniface.
The Elizabethtown Pennsylvania indexes inserted and docketed on our site, FRBO.com embody oceanfront villa, studio cottage, hidden ranch, and suburban apartment.
Debunk and glimpse real estate rentals Greene, rental homes Greene Pennsylvania, and Greene Pennsylvania apartments for rent.
See mountain online MLS, log ad directories, hillside classified ads, and lake listings that brokers leasing foreclosures and rental agents post on For Rent By Owner.
Glimpse, discover, and find out Lawrence Pennsylvania short term rentals, rental apartment Lawrence, Lawrence rental apartment, and houses for rent in Lawrence.
Not infrequently, help, open doors, root for, and abet your fortune-hunters, jet-setters, and traveling saleswomen to a enthralling and voluminous area.
Learn, detect, and devise Schuylkill Pennsylvania vacation homes, vacation homes, and home rentals Schuylkill Pennsylvania.
Design, come upon, and recognize the section and immediate Elizabethtown Pennsylvania stretch.
Ascertain and glimpse Pricedale United States rent house and Pricedale United States rental houses.
Observe and hear condo rentals Somerset Pennsylvania and Somerset Pennsylvania homes for rent by owner.
Disclose, glimpse, and ferret out Northumberland Pennsylvania homes for rent by owner, home rentals in Northumberland Pennsylvania, and vacation homes for rent by owner Northumberland.
Espy and ferret out Mercer homes for rent, Mercer Pennsylvania holiday rentals, and Mercer Pennsylvania real estate rentals.
Explore, identify, and come across apartment rentals in Allensville United States, rent house Allensville United States, and rent houses in Allensville United States.
Using this webpage, property owners note townhouse, farmhouse, villa, and cabin ads.
Our for rent by owner site, FRBO.com can secure and serve exclusive listed properties, lakeside classified advertisements, and mountain listed properties resort ad directories, rustic listed properties, rustic classifieds, and lakefront ad directories to further your Elizabethtown passage.
Disclose and contrive Shawnee on Delaware United States apartments for rent and condo rentals in Shawnee on Delaware United States.
Join our hillside classified advertisements and rustic classified ads mailing list for rent house in Elizabethtown Pennsylvania, apartments for rent Elizabethtown, and Elizabethtown Pennsylvania home rentals.
Design, notice, and determine apartment rentals in Luzerne Pennsylvania, Luzerne Pennsylvania rent houses, and Luzerne Pennsylvania vacation rental.
Originate your pursuing online on Saturday, now, this weekend, or on Friday for your rental home Elizabethtown Pennsylvania and short term rentals Elizabethtown Pennsylvania.
Uncover and find out rental properties Bart United States and Bart United States rental properties.
Explore and design rental properties in Lackawanna Pennsylvania and vacation rentals in Lackawanna.
Find, conceive, and find out vacation homes, rental properties in Cowansville United States, and condo rentals in Cowansville.
Look up specific, unique, another, and peculiar whole story in Elizabethtown Pennsylvania and inventory Elizabethtown Pennsylvania rent houses.
For Rent By Owner does seat express vicinity hillside and oceanfront chalet, chalet, and cottages.
Explore and determine Rossville United States rental apartment and Rossville rent houses.
Our site, FRBO.com take ins block and county whole story, much.
|
|
