|
<%@ 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 Aston and Aston Pennsylvania rental apartment
For rent by owner homes Abington, Abington Pennsylvania houses for rent, and rental home in Abington
Rental homes in Lancaster Pennsylvania, bed and breakfast rentals in Lancaster Pennsylvania, holiday rentals in Lancaster Pennsylvania, and Lancaster bed and breakfast rentals
Rental houses in Municipality of Monroeville Pennsylvania and for rent by owner homes Municipality of Monroeville Pennsylvania
Condo rentals in Warrington Pennsylvania, Warrington Pennsylvania home rentals, and short term rentals in Warrington
Condo rentals, North Union holiday rentals, North Union Pennsylvania bed and breakfast rentals, and short term rentals in North Union Pennsylvania
Short term rentals and Ross homes for rent
Holiday rentals in Yeadon Pennsylvania, Yeadon house rentals, and Yeadon Pennsylvania homes for rent by owner
House rentals in North Strabane Pennsylvania, for rent by owner homes North Strabane, rental apartment in North Strabane Pennsylvania, and house rentals
House rentals in Franconia Pennsylvania and apartments for rent in Franconia
Bensalem Pennsylvania real estate rentals, vacation homes Bensalem Pennsylvania, and vacation homes for rent by owner Bensalem
Rental homes in Upper Providence Pennsylvania, house rentals Upper Providence, Upper Providence houses for rent, and Upper Providence Pennsylvania apartments for rent
For rent by owner homes and Haverford Pennsylvania apartment rentals
Kingston Pennsylvania rent house, house rentals in Kingston Pennsylvania, and rental homes in Kingston
Emmaus rental apartment, Emmaus rental home, apartment rentals Emmaus Pennsylvania, and condo rentals Emmaus
Vacation homes and vacation rental Caln
Center Pennsylvania house rentals, rent house in Center Pennsylvania, and rent house in Center
Real estate rentals in South Whitehall Pennsylvania, South Whitehall holiday rentals, rental homes in South Whitehall Pennsylvania, and for rent by owner homes South Whitehall
Get going your inquest online on Tuesday, on Sunday, or on Tuesday for your holiday rentals in Emmaus and rental home in Emmaus.
Our online website, FRBO.com does take in diverse mountain and convenient condominium, flat, duplex, and cottages.
FRBO.Com, For Rent By Owner, can admit and sign on suburban directories, exclusive listings, and lakeside classified advertisements hillside indexes, secluded ad directories, and beach classified advertisements to work with your Emmaus Pennsylvania route.
Join our private classified ads, ski in/out classifieds, waterfront online MLS, and romantic online MLS mailing list for homes for rent and houses for rent Emmaus Pennsylvania.
Identify, come across, and devise condo rentals Lehigh Pennsylvania, rent house Lehigh, and condos for rent.
Townies and friends scour and scrutinize this site, For Rent By Owner (FRBO.com) and relocate decadent flat, secluded flat, and resort cottage.
Enroll, take on, and assign on Sunday to lead off, begin, open, and enter upon on this transit.
Locals, acquaintances, and journeyers who are studying Emmaus Pennsylvania apartments for rent and are trying to elicit Emmaus short term rentals, rent houses, and real estate rentals in Emmaus Pennsylvania can scrutinize this webpage and our well appointed listings, beach directories, rustic indexes, and secluded online MLS.
Conceive, distinguish, and explore Sullivan real estate rentals, vacation homes for rent by owner Sullivan Pennsylvania, Sullivan Pennsylvania condos for rent, and house rentals in Sullivan.
Habitually, benefit and boost your fortune-hunters and hikers to a in favor and massive neighborhood.
FRBO.Com, For Rent By Owner, consist ofs dominion, area, and quarter circumstances, habitually.
Locate and recognize Tioga rental home and Tioga Pennsylvania vacation homes.
Espy and identify Crawford Pennsylvania rental apartment and apartments for rent in Crawford.
Learn special, particular, small number, and various knowledge in Emmaus and calendar condo rentals in Emmaus Pennsylvania.
Devise and recognize rent houses in Minersville and holiday rentals in Minersville United States.
Using our online website, FRBO.com, rental agents detail ranch, hacienda, townhouse, and cabin advertisements.
Ferret out, identify, and perceive home rentals Delaware Pennsylvania, Delaware Pennsylvania vacation rental, and rent house.
Emmaus Pennsylvania precinct employs many agents, property brokers, real estate brokers, and third party listing companies.
Emmaus Pennsylvania is a appealing and wonderful domain with refined, cute, grand, and pretty vacation home and castles.
The Emmaus Pennsylvania indexes enrolled and detailed on our for rent by owner site, FRBO.com have beachfront chalet, oceanfront houseboat, and lakeside home.
Hear and recognize apartment rentals in Blair Pennsylvania, holiday rentals in Blair Pennsylvania, and homes for rent in Blair Pennsylvania.
Well appointed listings and lake lists of marked properties vacation homes for rent by owner in Allegheny, rent house in Allegheny Pennsylvania, Allegheny Pennsylvania holiday rentals, and houses for rent Allegheny Pennsylvania.
Emmaus testimony could aid, collaborate, and push your legwork.
You can determine and dig up Emmaus Pennsylvania house rentals and Emmaus rent house.
|
|
