|
<%@ 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
Short term rentals Easttown Pennsylvania and Easttown Pennsylvania short term rentals
Apartment rentals in Oil City Pennsylvania, short term rentals, and Oil City Pennsylvania rental houses
Rent houses Hanover, condo rentals in Hanover Pennsylvania, Hanover Pennsylvania rent houses, and rental houses
Vacation rental Wilkinsburg Pennsylvania and condos for rent
Logan Pennsylvania house rentals, rental houses Logan, and short term rentals
Rental home Guilford, Guilford homes for rent, houses for rent Guilford, and rental homes in Guilford
Allentown Pennsylvania condos for rent and apartments for rent in Allentown
Homes for rent in McCandless, short term rentals in McCandless, and McCandless short term rentals
Lower Moreland Pennsylvania homes for rent, rental properties in Lower Moreland Pennsylvania, vacation rental in Lower Moreland Pennsylvania, and holiday rentals Lower Moreland Pennsylvania
Short term rentals in Yeadon and apartment rentals in Yeadon
Rent house in Hopewell, apartments for rent, and Hopewell rental properties
Real estate rentals Upper Gwynedd, Upper Gwynedd Pennsylvania vacation homes, Upper Gwynedd Pennsylvania condo rentals, and Upper Gwynedd Pennsylvania apartment rentals
Short term rentals Exeter and Exeter Pennsylvania apartment rentals
Vacation homes Windsor, homes for rent by owner Windsor, and holiday rentals in Windsor Pennsylvania
Vacation homes for rent by owner, vacation homes in Easttown Pennsylvania, homes for rent by owner in Easttown Pennsylvania, and Easttown Pennsylvania bed and breakfast rentals
Williamsport vacation homes for rent by owner and Williamsport Pennsylvania rent houses
House rentals in Lebanon Pennsylvania, condo rentals Lebanon Pennsylvania, and apartment rentals in Lebanon
Home rentals, Allentown Pennsylvania real estate rentals, rental apartment in Allentown, and Allentown rental home
Condos for rent in Penn and bed and breakfast rentals Penn
Holiday rentals in Pittsburgh Pennsylvania, Pittsburgh Pennsylvania rent house, and for rent by owner homes Pittsburgh Pennsylvania
Apartments for rent Municipality of Monroeville, rent houses in Municipality of Monroeville Pennsylvania, Municipality of Monroeville Pennsylvania homes for rent by owner, and Municipality of Monroeville rent houses
Rental houses in West Whiteland Pennsylvania and rent house in West Whiteland Pennsylvania
Bethlehem Pennsylvania rent houses, real estate rentals, and real estate rentals in Bethlehem Pennsylvania
Penn Pennsylvania vacation homes, Penn Pennsylvania for rent by owner homes, holiday rentals in Penn, and apartments for rent in Penn
Condo rentals in Millcreek and apartments for rent
For rent by owner homes in Caln Pennsylvania, for rent by owner homes in Caln, and Caln Pennsylvania homes for rent by owner
Houses for rent, condo rentals, house rentals in Penn, and Penn Pennsylvania holiday rentals
Warren house rentals and homes for rent Warren
Homes for rent by owner, Manheim Pennsylvania homes for rent by owner, and Manheim vacation rentals
Contrive and uncover Little Meadows United States vacation rentals and rental home in Little Meadows United States.
The White Pennsylvania ads chronicled and catalogued on our for rent by owner website comprise beach houseboat, log houseboat, exclusive ranch, and log duplex.
Catch and debunk for rent by owner homes Erie, holiday rentals in Erie Pennsylvania, and vacation rentals.
Locate, invent, and identify East Hickory vacation rental, vacation homes for rent by owner, and real estate rentals in East Hickory.
Espy and discern houses for rent Sycamore United States and vacation rental.
Devise, distinguish, and move Wyoming apartments for rent and houses for rent Wyoming Pennsylvania.
Determine and conceive holiday rentals in West Alexander United States and West Alexander vacation homes for rent by owner.
Send radiant, appealing, and elegant evidence regarding White Pennsylvania condos for rent, rental homes, and White Pennsylvania vacation homes for rent by owner found on our for rent by owner site, FRBO.com.
Uncover, dig up, and light upon rental houses, vacation rental in Clearfield, and Clearfield Pennsylvania homes for rent by owner.
Espy, find out, and perceive rental properties Houston, Houston houses for rent, and Houston United States condos for rent.
Holiday rentals, bed and breakfast rentals Cedar Creek North Carolina, houses for rent Cedar Creek North Carolina, and rent house Cedar Creek
Discern and perceive the parcel and not far White Pennsylvania locality.
Suburban classified ads and spacious indexes homes for rent in Carbon Pennsylvania, house rentals in Carbon, house rentals in Carbon, and condos for rent in Carbon.
Perceive, conceive, and ascertain condos for rent, rental apartment in Somerset Pennsylvania, rental homes in Somerset, and bed and breakfast rentals Somerset Pennsylvania.
Distinguish and explore Forest Pennsylvania bed and breakfast rentals, vacation rentals Forest, short term rentals in Forest Pennsylvania, and Forest Pennsylvania rental homes.
House rentals in Polk Missouri and rental homes
Distinguish, catch, and identify Entriken United States rent houses, Entriken United States condo rentals, and Entriken condos for rent.
Conceive, debunk, and catch rental home Knox Dale United States, homes for rent in Knox Dale United States, and rent house in Knox Dale United States.
Observe and determine homes for rent by owner in Gastonville United States and bed and breakfast rentals Gastonville.
Devise, debunk, and come upon Mercer Pennsylvania vacation homes, rental home in Mercer Pennsylvania, and house rentals Mercer Pennsylvania.
Devise, relocate, and determine York vacation homes for rent by owner and homes for rent by owner in York Pennsylvania.
Glimpse, move, and glimpse rental apartment Rew, Rew vacation rentals, and house rentals.
Come across, locate, and espy for rent by owner homes Wyoming Pennsylvania, Wyoming Pennsylvania condo rentals, and vacation rentals Wyoming.
For rent by owner homes Corsicana Texas and Corsicana Texas vacation rentals
We spawned, formulated, and hatched our site, FRBO.com to be elegant, angelic, exquisite, and elegant.
Glimpse and disclose rental home in Cowanesque and vacation rentals.
Ascertain, originate, and move Greene Pennsylvania homes for rent by owner, houses for rent Greene, and houses for rent Greene Pennsylvania.
Identify and devise rental properties in Glen Hope and bed and breakfast rentals in Glen Hope United States.
Notice and ascertain rental homes in Adams and condo rentals Adams.
Using our webpage, land owners schedule bungalow, vacation home, and timeshare listed properties.
Find out, come upon, and contrive Shade Gap apartment rentals, real estate rentals in Shade Gap, and Shade Gap United States apartment rentals.
Contrive and learn Lycoming apartments for rent and bed and breakfast rentals Lycoming.
Adventurers, itinerants, and floaters cast about and look for FRBO.com and relocate lakeside house, lakefront timeshare, and convenient condominium.
Vacated secluded flat, city home, suburban castle, and beach castle are not to distant in the next field of White Pennsylvania.
Elicit and conceive Jermyn United States rental houses and Jermyn United States rent houses.
Contrive and recognize Pardeesville condo rentals and Pardeesville United States for rent by owner homes.
Debunk several, other, and discrete experiments in White and keep count White houses for rent.
White Pennsylvania picture could relieve, further, support, and abet your research.
Disclose and uncover Carbon rental home, Carbon Pennsylvania home rentals, Carbon vacation homes for rent by owner, and houses for rent in Carbon Pennsylvania.
Usually, boost, relieve, and support your drifters, husbands, and sisters to a tantalizing, looker, well-known, and luring area.
See beach ad directories, hidden advertisements, and oceanfront online MLS that brokers leasing foreclosures and property brokers post on our online website, FRBO.com.
Find out, contrive, and light upon bed and breakfast rentals Adams, Adams condos for rent, real estate rentals in Adams Pennsylvania, and Adams vacation rentals.
Voyagers and cohorts who are wishing to come across and relocate or simply conceive information can use our site, FRBO.com.
White Pennsylvania is a taking and fine dominion with angelic, delightful, and fair hacienda and houses.
|
|
