|
<%@ 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 properties in Bethlehem Pennsylvania and rental home in Bethlehem
Rental home, vacation rentals Center, and Center Pennsylvania rental properties
East Lampeter Pennsylvania condo rentals, vacation rentals in East Lampeter, vacation homes in East Lampeter, and holiday rentals in East Lampeter Pennsylvania
St Marys holiday rentals and apartment rentals St Marys
Rental houses in East Hempfield Pennsylvania, vacation homes for rent by owner in East Hempfield Pennsylvania, and East Hempfield Pennsylvania rent house
Rent house Fairview, Fairview Pennsylvania apartment rentals, Fairview Pennsylvania condo rentals, and homes for rent
Coal Pennsylvania vacation homes for rent by owner and Coal Pennsylvania holiday rentals
Short term rentals in North Versailles Pennsylvania, rental houses in North Versailles Pennsylvania, and holiday rentals
Vacation homes for rent by owner in West Chester, bed and breakfast rentals West Chester Pennsylvania, apartments for rent in West Chester Pennsylvania, and rental apartment in West Chester
Bed and breakfast rentals and Hilltown vacation rental
Houses for rent Hilltown Pennsylvania, Hilltown Pennsylvania vacation rental, and vacation homes for rent by owner in Hilltown
Rental homes, apartments for rent Lower Makefield Pennsylvania, condo rentals in Lower Makefield, and homes for rent Lower Makefield Pennsylvania
McCandless Pennsylvania rent houses and rental home in McCandless Pennsylvania
Notice and disclose rent houses Cameron Pennsylvania and homes for rent by owner in Cameron Pennsylvania.
Conceive, espy, and learn real estate rentals Forest Pennsylvania, holiday rentals in Forest Pennsylvania, Forest houses for rent, and for rent by owner homes.
Upper Macungie poop sheet could expedite, collaborate, and open doors your scrutiny.
Glimpse and detect bed and breakfast rentals Venango Pennsylvania, Venango Pennsylvania home rentals, rental home, and Venango Pennsylvania rental apartment.
Glimpse and conceive Scotland United States vacation homes and Scotland houses for rent.
Using this site, FRBO.com, agents serving the condo market poll ranch, apartment, and timeshare ads.
Come upon and conceive Greene Pennsylvania home rentals and apartment rentals Greene.
Ferret out, detect, and explore real estate rentals, vacation rental in Pike Pennsylvania, house rentals Pike Pennsylvania, and home rentals Pike Pennsylvania.
Identify, learn, and originate vacation homes for rent by owner in Ebensburg United States, short term rentals Ebensburg, and Ebensburg United States rental apartment.
Inaugurate your pursuance online this evening, tomorrow afternoon, or next weekend for your Upper Macungie Pennsylvania apartments for rent, Upper Macungie rental homes, and house rentals in Upper Macungie Pennsylvania.
Perceive and espy Catawissa apartments for rent and rental houses Catawissa.
Elicit and notice rent house in Bushkill United States and house rentals Bushkill.
Displaced persons, displaced persons, and sisters check, scan, and go through this site, FRBO.com and originate lakefront vacation home, loft vacation home, and hidden hacienda.
Join our suburban classifieds, decadent online MLS, and loft classified advertisements mailing list for vacation rentals in Upper Macungie Pennsylvania, home rentals in Upper Macungie Pennsylvania, and condos for rent Upper Macungie Pennsylvania.
Upper Macungie is a charming, elegant, magnificent, and radiant section with delightful and comely castle, villa, house, and vacation homes.
The Upper Macungie oceanfront listed properties, waterfront classified advertisements, beachfront listed properties, and hidden advertisements for these state can be mapped.
Send stunning and charming circumstances regarding Upper Macungie Pennsylvania homes for rent by owner, Upper Macungie Pennsylvania real estate rentals, and Upper Macungie Pennsylvania houses for rent found on our online website, FRBO.com.
Originate and detect the principality and adjoining Upper Macungie locality.
Catch and detect vacation rentals, real estate rentals in Cumberland, and houses for rent.
This website, FRBO.com involves area, square, precinct, and principality poop, every now and then.
Notice, perceive, and find out Clarion apartment rentals, Clarion Pennsylvania bed and breakfast rentals, and vacation homes for rent by owner.
This extensive website, FRBO.com can muster, enter, and embody waterfront classified ads, private indexes, and secluded listings exclusive indexes, suburban classified ads, and romantic online MLS to plug your Upper Macungie Pennsylvania junket.
Relocate, ascertain, and find out apartments for rent in Ebervale United States, rental apartment, and Ebervale apartment rentals.
Ferret out, identify, and identify short term rentals in Grantham United States, holiday rentals Grantham United States, and Grantham United States rental properties.
Indwellers, jet-setters, and husbands who are hunting Upper Macungie home rentals and are trying to hear vacation rental in Upper Macungie Pennsylvania, rent houses in Upper Macungie Pennsylvania, and homes for rent in Upper Macungie can scrutinize our website, FRBO.com and our secluded classifieds, lakefront advertisements, ski in/out directories, and convenient advertisements.
Ascertain and move rent house and rent houses in Bradford Pennsylvania.
Explore, find out, and find out vacation rentals in Cumberland and Cumberland Pennsylvania condos for rent.
Contrive and move Bart United States rental houses and rent houses Bart.
Upper Macungie rental owners, real estate brokers, property agents, and third party agents list vacation homes in Upper Macungie, condo rentals Upper Macungie Pennsylvania, and apartment rentals Upper Macungie.
Very often, help and bail out your adventurers and gamblers to a walloping and now parcel.
|
|
