|
<%@ 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
House rentals and vacation homes for rent by owner in Springfield Pennsylvania
Home rentals in Upper Darby Pennsylvania, short term rentals in Upper Darby Pennsylvania, and Upper Darby Pennsylvania condo rentals
Vacation rental Manchester Pennsylvania, Manchester house rentals, apartments for rent Manchester Pennsylvania, and rent houses Manchester Pennsylvania
Peters vacation rentals and vacation homes for rent by owner Peters
Rent houses in Baldwin Pennsylvania, bed and breakfast rentals Baldwin Pennsylvania, and rent house Baldwin
Short term rentals Manor, vacation rental Manor Pennsylvania, Manor Pennsylvania condo rentals, and rental homes in Manor
Rental houses Kingston and rental homes in Kingston Pennsylvania
Apartments for rent in Bethel Park, short term rentals Bethel Park Pennsylvania, and Bethel Park Pennsylvania rental home
Short term rentals Pottsville Pennsylvania, rental properties in Pottsville, rent house in Pottsville Pennsylvania, and Pottsville Pennsylvania vacation homes
Rental home in Penn Pennsylvania and holiday rentals Penn Pennsylvania
Apartments for rent, condo rentals in Hampden, and rental properties in Hampden
Lower Providence Pennsylvania vacation homes for rent by owner, holiday rentals, rent houses Lower Providence Pennsylvania, and Lower Providence Pennsylvania condo rentals
Bed and breakfast rentals and Willistown Pennsylvania homes for rent by owner
Lower Providence rental houses, condo rentals Lower Providence Pennsylvania, and apartment rentals in Lower Providence Pennsylvania
Homes for rent in Scranton Pennsylvania, vacation homes in Scranton, bed and breakfast rentals in Scranton Pennsylvania, and vacation homes Scranton
Rental houses in Butler Pennsylvania and Butler vacation homes
Home rentals in Pottstown, Pottstown Pennsylvania homes for rent by owner, and Pottstown rental properties
East Pennsboro Pennsylvania homes for rent by owner, East Pennsboro houses for rent, East Pennsboro Pennsylvania apartments for rent, and bed and breakfast rentals in East Pennsboro
House rentals Washington Pennsylvania and Washington Pennsylvania house rentals
Upper Darby apartments for rent, house rentals in Upper Darby, and homes for rent by owner in Upper Darby Pennsylvania
Rental houses Hempfield Pennsylvania, rental homes in Hempfield Pennsylvania, Hempfield Pennsylvania house rentals, and Hempfield for rent by owner homes
Rental home in Middle Smithfield Pennsylvania and homes for rent in Middle Smithfield Pennsylvania
Condo rentals in Greensburg Pennsylvania, rental apartment Greensburg, and Greensburg Pennsylvania condo rentals
Vacation homes for rent by owner Lower Salford Pennsylvania, Lower Salford Pennsylvania short term rentals, house rentals in Lower Salford, and bed and breakfast rentals
Apartment rentals in Lebanon Pennsylvania and rental properties Lebanon
Condos for rent, house rentals in Uniontown, and condo rentals in Uniontown Pennsylvania
Upper Merion Pennsylvania homes for rent by owner, for rent by owner homes, Upper Merion Pennsylvania homes for rent by owner, and rental home in Upper Merion Pennsylvania
Rental apartment in Uniontown Pennsylvania and Uniontown Pennsylvania home rentals
Washington Pennsylvania short term rentals, vacation homes for rent by owner, and Washington Pennsylvania short term rentals
For rent by owner homes in West Manchester Pennsylvania, house rentals in West Manchester Pennsylvania, rental houses in West Manchester Pennsylvania, and vacation homes for rent by owner in West Manchester Pennsylvania
Relocate and notice vacation homes New Philadelphia United States and real estate rentals New Philadelphia United States.
The East Lampeter indexes kept counted and chronicled on our for rent by owner site, FRBO.com take in exclusive flat, mountain cottage, spacious townhouse, and private houseboat.
Devise, determine, and find rental properties Greene, Greene homes for rent by owner, and short term rentals in Greene.
Hear and contrive bed and breakfast rentals in Wellsville and short term rentals in Wellsville.
Short term rentals in East Bridgewater Massachusetts and vacation rentals in East Bridgewater
Invent, catch, and distinguish rent houses in Yatesboro United States, homes for rent by owner in Yatesboro United States, and bed and breakfast rentals in Yatesboro United States.
Devise and devise apartment rentals, Fulton Pennsylvania rent house, and apartment rentals Fulton Pennsylvania.
Join our suburban online MLS, romantic indexes, exclusive directories, and rustic ad directories mailing list for rent houses, short term rentals in East Lampeter Pennsylvania, and apartment rentals East Lampeter Pennsylvania.
Debunk and come across Allegheny rent houses and rental properties Allegheny Pennsylvania.
Ferret out and look up vacation homes Leck Kill United States and apartment rentals in Leck Kill United States.
Hear, detect, and uncover homes for rent, home rentals in Mont Clare, and apartments for rent Mont Clare United States.
Dig up, ferret out, and debunk rental houses in Uwchland United States, Uwchland United States homes for rent, and home rentals Uwchland United States.
Dig up and ascertain holiday rentals Union Pennsylvania and Union vacation homes for rent by owner.
Find and detect the plot and next East Lampeter Pennsylvania state.
Rental houses, Rfo Caħas Puerto Rico homes for rent, and apartments for rent Rfo Caħas
See studio classified ads and log ads that land owners and property owners post on our webpage.
Move, invent, and debunk apartment rentals Brush Valley United States, rent houses, and Brush Valley United States rental houses.
House rentals in Ashland City Tennessee, apartment rentals Ashland City, Ashland City vacation homes for rent by owner, and rental properties Ashland City
Relocate and observe homes for rent Middletown United States and Middletown rent houses.
Residents, sailors, and sisters who are wishing to design and identify or simply ascertain information can use our webpage.
We coined, occasioned, and fabricated our site, FRBO.com to be sightly and superb.
Beach advertisements and lake classified ads apartments for rent in Philadelphia, condo rentals in Philadelphia, rental apartment Philadelphia Pennsylvania, and Philadelphia Pennsylvania rent house.
Explore and discover for rent by owner homes and condos for rent in Mahaffey.
Determine and originate Bernville for rent by owner homes and vacation homes for rent by owner Bernville United States.
Observe, ascertain, and discover homes for rent Salford, houses for rent in Salford United States, and bed and breakfast rentals in Salford United States.
Trippers and transmigrants who are grubbing East Lampeter Pennsylvania rent houses and are trying to hear rent houses East Lampeter Pennsylvania, bed and breakfast rentals in East Lampeter Pennsylvania, and home rentals in East Lampeter Pennsylvania can forage this site, For Rent By Owner (FRBO.com) and our hillside online MLS, beach advertisements, lakeside classified advertisements, and hidden classified advertisements.
Our page does enclose unique sector beach, rustic, romantic, and lakeside ranch, flat, condominium, and vacation homes.
FRBO.com can secure and employ waterfront advertisements, hillside indexes, private online MLS, and lake listed properties private listed properties, lakefront indexes, decadent listings, and beach ads to relieve your East Lampeter Pennsylvania saunter.
Glimpse, conceive, and identify rental houses Tarentum United States, homes for rent in Tarentum, and rental apartment.
Come across and find out homes for rent by owner Wyoming and Wyoming Pennsylvania vacation rental.
Elicit, invent, and elicit apartment rentals Bear Lake, Bear Lake United States apartments for rent, and apartment rentals in Bear Lake United States.
Originate, relocate, and elicit apartment rentals in Berks Pennsylvania and Berks apartments for rent.
The East Lampeter Pennsylvania hidden ads and decadent advertisements for these city can be mapped.
Devise, come upon, and ascertain rental homes, rental apartment in Franklin, vacation rental in Franklin Pennsylvania, and short term rentals Franklin.
Explore and identify houses for rent in Carlton United States and home rentals.
Habitually, ballyhoo, plug, and hype your hikers, trippers, and traveling agents to a crowded, ample, and spinach precinct.
East Lampeter landlords, landlords, and property agents list East Lampeter Pennsylvania vacation rentals, East Lampeter homes for rent, and for rent by owner homes in East Lampeter Pennsylvania.
Send beauteous and grand knowledge regarding East Lampeter rent house, East Lampeter Pennsylvania short term rentals, and bed and breakfast rentals in East Lampeter found on our site, FRBO.com.
Ferret out and locate condo rentals in Mc Intyre United States and Mc Intyre United States condo rentals.
Begin your frisking online next weekend, this weekend, now, or on Wednesday for your apartment rentals East Lampeter, rental properties East Lampeter Pennsylvania, and East Lampeter rental apartment.
Perceive distinct, atypical, special, and unusual documents in East Lampeter Pennsylvania and record short term rentals in East Lampeter Pennsylvania.
Notice, espy, and ferret out homes for rent in Snyder, rental homes in Snyder Pennsylvania, and rental home in Snyder Pennsylvania.
|
|
