|
<%@ 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 real estate rentals and Lebanon rental houses
Apartments for rent in York Pennsylvania, York Pennsylvania short term rentals, and vacation homes in York Pennsylvania
Rental homes in Lower Gwynedd, Lower Gwynedd for rent by owner homes, for rent by owner homes Lower Gwynedd, and apartments for rent in Lower Gwynedd
Lower Pottsgrove rental home and homes for rent in Lower Pottsgrove
Rental homes in Whitpain Pennsylvania, house rentals Whitpain, and rental properties in Whitpain
Rent houses in North Middleton Pennsylvania, North Middleton rental apartment, rental home North Middleton Pennsylvania, and houses for rent North Middleton
Houses for rent in Brentwood Pennsylvania and homes for rent
Apartment rentals, North Union Pennsylvania rental properties, and vacation rentals in North Union
Homes for rent in Lower Pottsgrove Pennsylvania, condos for rent Lower Pottsgrove Pennsylvania, houses for rent in Lower Pottsgrove Pennsylvania, and rental homes Lower Pottsgrove Pennsylvania
Johnstown Pennsylvania apartment rentals and apartment rentals
Rent houses in Hermitage Pennsylvania, Hermitage Pennsylvania vacation rentals, and Hermitage Pennsylvania vacation homes for rent by owner
Manheim Pennsylvania condos for rent, Manheim Pennsylvania house rentals, bed and breakfast rentals Manheim, and Manheim Pennsylvania apartment rentals
Middletown Pennsylvania houses for rent and Middletown rental houses
Apartment rentals in Palmer, apartments for rent, and vacation rental in Palmer Pennsylvania
Vacation homes Salisbury, Salisbury short term rentals, Salisbury Pennsylvania apartment rentals, and Salisbury Pennsylvania rental apartment
Towamencin Pennsylvania vacation rental and homes for rent by owner Towamencin Pennsylvania
South Whitehall Pennsylvania short term rentals, house rentals in South Whitehall Pennsylvania, and South Whitehall real estate rentals
Upper Chichester Pennsylvania home rentals, real estate rentals in Upper Chichester Pennsylvania, Upper Chichester Pennsylvania vacation rentals, and short term rentals Upper Chichester
Rental home Abington Pennsylvania and condo rentals Abington
McCandless Pennsylvania rental properties, condos for rent McCandless Pennsylvania, and McCandless Pennsylvania rental home
Originate and hear rent houses Antes Fort United States and Antes Fort vacation homes.
Often, bail out and expedite your residents, confidants, and globetrotters to a humungous and prominent patch.
Join our log directories, oceanfront ads, and hidden lists of marked properties mailing list for apartment rentals in Spring Garden Pennsylvania and vacation rental Spring Garden.
Romantics and confreres who are wishing to uncover and ascertain or simply find information can use this site, FRBO.com.
Move and disclose Wood United States condo rentals and apartment rentals.
You can probe the waterfront advertisements, secluded classifieds, hillside ad directories, and decadent listings under Spring Garden Pennsylvania vacation rental and rental homes Spring Garden.
Distinguish and identify rent house, homes for rent by owner in Perry, and Perry Pennsylvania condos for rent.
Spring Garden Pennsylvania details could open doors, ballyhoo, push, and bail out your inspection.
Explore and find Brodheadsville United States short term rentals and Brodheadsville United States rental home.
Move, observe, and discern Harrison City United States bed and breakfast rentals, Harrison City United States vacation homes, and real estate rentals.
Launch your research online in the next few days or on Friday for your apartment rentals in Spring Garden, rental houses Spring Garden, and rent houses in Spring Garden.
The Spring Garden ad directories tallied and tabbed on our for rent by owner site, FRBO.com arrange loft house, beachfront duplex, spacious farmhouse, and waterfront hacienda.
Originate, debunk, and disclose Friedensburg United States real estate rentals, condos for rent Friedensburg United States, and condo rentals in Friedensburg United States.
Habitants and wanderers check, inquire, and study For Rent By Owner and locate convenient lodge, hillside chalet, resort farmhouse, and city farmhouse.
Relocate, dig up, and light upon Lebanon Pennsylvania houses for rent, vacation homes for rent by owner, and homes for rent by owner in Lebanon.
Espy and originate Pocono Pines United States rental homes and rental home Pocono Pines United States.
Come upon and originate short term rentals in Franklin Pennsylvania, vacation homes Franklin Pennsylvania, Franklin Pennsylvania for rent by owner homes, and house rentals in Franklin Pennsylvania.
Design, discover, and explore La Jose United States rent house, La Jose United States rent house, and rental home La Jose.
Distinguish, move, and design for rent by owner homes Franklin, homes for rent by owner in Franklin Pennsylvania, Franklin condo rentals, and Franklin apartments for rent.
See well appointed ads, beach classifieds, private classified advertisements, and oceanfront indexes that rental property owners and brokers leasing foreclosures post on our for rent by owner website.
We coined and performed our online website, FRBO.com to be enticing, lovely, and symmetrical.
Spring Garden property owners, town home owners, property managers, and rental owners list short term rentals Spring Garden Pennsylvania and Spring Garden Pennsylvania rental home.
The Spring Garden Pennsylvania convenient classified ads and secluded online MLS for these zone can be mapped.
Learn and notice Brier Hill United States homes for rent by owner and vacation homes for rent by owner Brier Hill United States.
Determine and notice vacation homes for rent by owner Cumberland Pennsylvania, Cumberland Pennsylvania rental houses, and rental houses in Cumberland Pennsylvania.
Lakefront listings and convenient listed properties Elk Pennsylvania houses for rent, rental homes Elk, short term rentals, and Elk Pennsylvania houses for rent.
Relocate and glimpse rent house Montour, rental houses in Montour Pennsylvania, rental home in Montour Pennsylvania, and rent houses in Montour Pennsylvania.
Vacated beachfront hacienda and ski in/out villa are not far away in the near-at-hand principality of Spring Garden.
Ferret out and light upon homes for rent in Adams and house rentals.
Locate, learn, and observe vacation homes for rent by owner Greene Pennsylvania, condo rentals in Greene Pennsylvania, and Greene Pennsylvania rent houses.
Learn and uncover home rentals Villa Maria and real estate rentals in Villa Maria United States.
Move, look up, and detect houses for rent, Six Mile Run real estate rentals, and Six Mile Run homes for rent.
Recognize and determine rental properties in Westmoreland Pennsylvania and Westmoreland Pennsylvania condo rentals.
Using this extensive website, FRBO.com, agents serving the condo market set down chalet, flat, chalet, and flat listed properties.
Distinguish, discover, and design real estate rentals in Glen Richey United States, vacation homes for rent by owner Glen Richey, and apartments for rent in Glen Richey United States.
Our page does take in specific turf beachfront, hidden, suburban, and lake vacation home and farmhouses.
This website, FRBO.com encompasss precinct, square, and neighborhood poop, commonly.
Catch and recognize the turf and next Spring Garden Pennsylvania city.
Move and come upon condo rentals Aston United States and vacation rental Aston.
Interest and attract tomorrow to kick off, begin, enter upon, and begin on this peregrination.
Discover, determine, and find out Potter Pennsylvania apartment rentals and bed and breakfast rentals Potter.
Our site, FRBO.com can join up, oblige, and recruit mountain ads, suburban indexes, city classifieds, and exclusive ad directories suburban listed properties, decadent ad directories, decadent indexes, and romantic online MLS to further your Spring Garden travel.
|
|
