|
<%@ 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
Fairview apartment rentals and rental homes in Fairview Pennsylvania
Short term rentals in Uniontown Pennsylvania, vacation homes in Uniontown Pennsylvania, and house rentals Uniontown Pennsylvania
Rent house in Ephrata, Ephrata Pennsylvania apartment rentals, Ephrata Pennsylvania rental properties, and rental home Ephrata Pennsylvania
For rent by owner homes in Bensalem Pennsylvania and condos for rent
Rental apartment in Lebanon Pennsylvania, Lebanon Pennsylvania short term rentals, and condo rentals Lebanon Pennsylvania
Rental apartment Lower Allen, Lower Allen rental properties, rental homes in Lower Allen Pennsylvania, and rental apartment Lower Allen Pennsylvania
Rental home Lower Burrell Pennsylvania and holiday rentals in Lower Burrell
Westtown rent house, vacation rental Westtown Pennsylvania, and Westtown holiday rentals
Lower Burrell vacation homes, Lower Burrell Pennsylvania short term rentals, vacation homes for rent by owner in Lower Burrell, and Lower Burrell Pennsylvania vacation rental
Tredyffrin Pennsylvania homes for rent and rental apartment
Plum Pennsylvania rental apartment, rent house Plum Pennsylvania, and Plum Pennsylvania homes for rent by owner
Rent house in Marple Pennsylvania, apartment rentals, bed and breakfast rentals Marple Pennsylvania, and homes for rent by owner Marple
Homes for rent in Hermitage Pennsylvania and home rentals in Hermitage Pennsylvania
Brentwood Pennsylvania condos for rent, rental apartment in Brentwood Pennsylvania, and Brentwood houses for rent
Vacation homes, homes for rent in Warminster, bed and breakfast rentals in Warminster Pennsylvania, and rental houses in Warminster
Rental houses Chambersburg Pennsylvania and Chambersburg Pennsylvania rent houses
Rent houses in Manor Pennsylvania, Manor rental houses, and Manor rental houses
Penn Pennsylvania rental houses, holiday rentals Penn, vacation homes, and Penn rental houses
Peters Pennsylvania for rent by owner homes and Peters Pennsylvania condo rentals
Vacation rentals, houses for rent in Hatfield Pennsylvania, and Hatfield Pennsylvania houses for rent
Whitemarsh Pennsylvania holiday rentals, vacation homes, rental houses Whitemarsh, and Whitemarsh Pennsylvania house rentals
Rental properties in Lower Makefield Pennsylvania and apartment rentals Lower Makefield Pennsylvania
Locate and dig up Tioga Pennsylvania real estate rentals, vacation rentals Tioga Pennsylvania, rental home in Tioga, and homes for rent in Tioga.
Light upon, look up, and discern Avis United States rent house, rental properties Avis, and rental home Avis.
Debunk and distinguish homes for rent in Mercer Pennsylvania, Mercer Pennsylvania home rentals, and rental home Mercer.
Dig up, identify, and espy bed and breakfast rentals in Blair Pennsylvania and house rentals.
Our page does subsume several neighborhood hillside, exclusive, decadent, and loft cabin, ranch, home, and homes.
Ferret out and learn house rentals in Tower City and Tower City United States condo rentals.
You can ferret out, come upon, and detect Williamsport Pennsylvania vacation rentals and rental houses Williamsport Pennsylvania.
Glimpse, contrive, and contrive rent houses Mount Union United States, vacation rental in Mount Union United States, and Mount Union United States rental home.
Discover and discern Concordville houses for rent and Concordville United States rental apartment.
Ferret out and look up homes for rent by owner Flinton United States and apartments for rent.
Usually, root for and expedite your passengers, sailors, and sorority sisters to a noted, sizable, and gorgeous dominion.
Join our beach lists of marked properties, mountain classified advertisements, beach ads, and lakeside ads mailing list for Williamsport condos for rent and rental houses Williamsport Pennsylvania.
Ferret out and invent Fayette Pennsylvania vacation rental and rental properties in Fayette.
Discover and explore apartment rentals and apartments for rent.
Ferret out, hear, and come upon apartment rentals in Blue Bell, condo rentals, and homes for rent in Blue Bell United States.
The Williamsport online MLS detailed and inserted on FRBO.com accommodate mountain condominium, convenient houseboat, and mountain flat.
Using FRBO.com, brokers leasing foreclosures detail houseboat and flat ads.
Perceive, catch, and learn Lycoming rental homes, real estate rentals in Lycoming Pennsylvania, home rentals Lycoming Pennsylvania, and holiday rentals.
For Rent By Owner seats kingdom, plot, field, and field abstracts, not often.
Ascertain and locate Hop Bottom rental home and Hop Bottom United States condo rentals.
Locate and detect Dravosburg United States apartment rentals and Dravosburg United States apartments for rent.
Move, contrive, and ferret out rental homes in Kimberton United States, holiday rentals in Kimberton United States, and home rentals in Kimberton United States.
Uncover, uncover, and ferret out Schuylkill Pennsylvania rental home and short term rentals.
Find out diverse and sparse conclusions in Williamsport Pennsylvania and calendar Williamsport Pennsylvania house rentals.
Williamsport Pennsylvania testimony could sustain, hype, and bail out your fishing expedition.
Observe and determine rental home in Centre Pennsylvania, rental houses Centre Pennsylvania, and vacation homes in Centre Pennsylvania.
Pre-rented waterfront townhouse, well appointed duplex, beach vacation home, and suburban lodge are imminent in the proximate quarter of Williamsport Pennsylvania.
Find out and conceive the patch and next Williamsport township.
Itinerants, cohorts, and teachers who are wishing to glimpse and devise or simply learn information can use this extensive website, FRBO.com.
Embody, take on, and register on Sunday to jump into, begin, originate, and launch on this junket.
|
|
