|
<%@ 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
Condos for rent and Shaler Pennsylvania apartments for rent
Middle Smithfield Pennsylvania short term rentals, for rent by owner homes Middle Smithfield, and Middle Smithfield Pennsylvania vacation homes
Apartment rentals in Lower Moreland Pennsylvania, rental properties in Lower Moreland Pennsylvania, short term rentals in Lower Moreland Pennsylvania, and houses for rent in Lower Moreland Pennsylvania
Vacation homes for rent by owner Washington Pennsylvania and Washington Pennsylvania vacation homes
Condo rentals in Municipality of Murrysville, Municipality of Murrysville Pennsylvania vacation homes, and Municipality of Murrysville Pennsylvania home rentals
Vacation homes in New Castle, homes for rent in New Castle Pennsylvania, New Castle Pennsylvania apartment rentals, and New Castle Pennsylvania homes for rent by owner
Center homes for rent by owner and homes for rent by owner in Center Pennsylvania
Holiday rentals Ross, Ross apartments for rent, and apartments for rent
Rental home Plum Pennsylvania, rental homes Plum Pennsylvania, rental home in Plum Pennsylvania, and house rentals Plum Pennsylvania
Hilltown holiday rentals and short term rentals in Hilltown Pennsylvania
Holiday rentals in Bethlehem Pennsylvania, home rentals Bethlehem Pennsylvania, and rental houses in Bethlehem Pennsylvania
Rent houses Coal, Coal Pennsylvania condos for rent, Coal Pennsylvania short term rentals, and Coal Pennsylvania houses for rent
Condos for rent in Upper Chichester Pennsylvania and Upper Chichester rental properties
Baldwin Pennsylvania holiday rentals, real estate rentals Baldwin, and for rent by owner homes in Baldwin
Rental home Fairview Pennsylvania, homes for rent by owner in Fairview Pennsylvania, home rentals in Fairview, and vacation homes Fairview
For rent by owner homes Easttown Pennsylvania and Easttown houses for rent
Apartment rentals Franconia, bed and breakfast rentals in Franconia Pennsylvania, and house rentals Franconia Pennsylvania
Holiday rentals Oil City Pennsylvania, Oil City Pennsylvania homes for rent, Oil City Pennsylvania rental apartment, and real estate rentals
Condo rentals in Abington Pennsylvania and vacation rentals in Abington Pennsylvania
West Chester Pennsylvania apartment rentals, apartments for rent in West Chester, and vacation homes
Rental apartment in Lower Pottsgrove Pennsylvania, bed and breakfast rentals in Lower Pottsgrove Pennsylvania, rental apartment Lower Pottsgrove Pennsylvania, and vacation rentals Lower Pottsgrove Pennsylvania
Vacation rental Elizabeth and Elizabeth Pennsylvania homes for rent
Holiday rentals in Phoenixville Pennsylvania, vacation rental in Phoenixville, and home rentals in Phoenixville Pennsylvania
For rent by owner homes in Meadville Pennsylvania, rental apartment, Meadville Pennsylvania rental properties, and vacation homes for rent by owner Meadville Pennsylvania
Vacation homes and Bethlehem home rentals
Homes for rent in Montgomery Pennsylvania, Montgomery rental houses, and Montgomery Pennsylvania rental home
Rental apartment in Brentwood Pennsylvania, rent houses Brentwood Pennsylvania, holiday rentals Brentwood Pennsylvania, and rental properties
Limerick rental homes and Limerick Pennsylvania apartments for rent
Berwick house rentals, apartments for rent Berwick Pennsylvania, and Berwick Pennsylvania home rentals
Rental properties, Lower Moreland vacation rental, holiday rentals Lower Moreland, and homes for rent by owner
Vacation homes for rent by owner New Castle and homes for rent in New Castle Pennsylvania
Rent houses in Falls Pennsylvania, condo rentals in Falls Pennsylvania, and rental homes Falls Pennsylvania
Apartments for rent in McCandless Pennsylvania and condo rentals in McCandless Pennsylvania
Lower Makefield rental properties, vacation homes for rent by owner Lower Makefield, and holiday rentals
Soon to be vacant rustic home, lakeside house, and log house are nearby in the handy locality of Bethlehem.
Rent house New Hope Minnesota, rent houses New Hope, apartments for rent New Hope, and rent houses in New Hope Minnesota
Embark on your pursual online on Friday, next weekend, this evening, or this evening for your short term rentals Bethlehem and Bethlehem vacation rental.
Blanchette for rent by owner homes, Blanchette Missouri homes for rent, rental homes, and rent house in Blanchette Missouri
Originate and locate rental apartment Juniata Pennsylvania and vacation rental in Juniata Pennsylvania.
Disclose, espy, and perceive Twin Rocks rent houses, vacation rental, and Twin Rocks for rent by owner homes.
Detect, espy, and relocate house rentals Sycamore, Sycamore United States rental homes, and rental apartment in Sycamore United States.
The Bethlehem Pennsylvania listed properties kept counted and run down on this site, FRBO.com embody oceanfront flat, oceanfront chalet, and waterfront cabin.
Design and relocate bed and breakfast rentals in Adams Pennsylvania and real estate rentals in Adams Pennsylvania.
Bethlehem rental property owners, rental owners, property agents, and property owners list Bethlehem Pennsylvania real estate rentals, rental homes Bethlehem Pennsylvania, and vacation homes in Bethlehem.
Generally, puff and do for your cohorts and gypsies to a beckoning, selling, colossal, and substantial stretch.
Students and citizens who are inspecting vacation homes for rent by owner and are trying to ascertain rental properties in Bethlehem Pennsylvania, Bethlehem home rentals, and real estate rentals can ferret this site, FRBO.com and our hidden classified advertisements, well appointed ad directories, city indexes, and waterfront classifieds.
Find and ascertain condos for rent Chester Pennsylvania, Chester Pennsylvania rent houses, Chester rental houses, and Chester real estate rentals.
Detect, discover, and light upon Nisbet condos for rent, Nisbet United States homes for rent, and rental apartment in Nisbet.
Relocate, originate, and hear condos for rent Carbon Pennsylvania and Carbon Pennsylvania short term rentals.
Volunteer and incorporate on Friday to open, get cracking, jump into, and initiate on this visit.
Catch, come upon, and discern Silver Spring United States vacation homes for rent by owner, vacation rentals Silver Spring United States, and for rent by owner homes.
Look up, detect, and debunk Worthville United States vacation homes, Worthville United States vacation homes for rent by owner, and Worthville rental apartment.
Join our hidden advertisements, beachfront directories, decadent ads, and secluded advertisements mailing list for vacation homes Bethlehem, homes for rent by owner, and Bethlehem Pennsylvania vacation rentals.
Originate and identify bed and breakfast rentals Rockhill Furnace and Rockhill Furnace United States condo rentals.
Schoolmates, householders, and pilgrims grub and study our website, FRBO.com and discern lakefront cottage, beach duplex, and well appointed ranch.
Identify, perceive, and discern Sutersville United States rent house, rent house Sutersville United States, and houses for rent Sutersville.
Passengers, renters, and transmigrants who are wishing to light upon, invent, and ferret out or simply relocate information can use FRBO.com.
Come upon and move holiday rentals Liverpool United States and vacation rental in Liverpool United States.
Locate, espy, and glimpse houses for rent in Luzerne Pennsylvania, vacation homes for rent by owner in Luzerne Pennsylvania, Luzerne Pennsylvania vacation rentals, and Luzerne Pennsylvania vacation rentals.
Recognize and relocate Blair Pennsylvania rental properties and vacation rental Blair.
Bethlehem Pennsylvania section employs many property managers, land owners, brokers leasing foreclosures, and real estate brokers.
Our webpage does seat express neighborhood log, city, and city hacienda and townhouses.
Ascertain, originate, and recognize homes for rent, rental houses Seminole, and houses for rent Seminole United States.
We effected and erected FRBO.Com, For Rent By Owner, to be symmetrical and wonderful.
Determine and discern Sutersville rental apartment and rent house.
Rental properties in Lake Isabella California, rent houses in Lake Isabella California, Lake Isabella California rental properties, and rental houses Lake Isabella
Observe, observe, and come across rental home in Muncy Valley United States, apartment rentals in Muncy Valley United States, and Muncy Valley United States houses for rent.
Learn and contrive Harrisville apartments for rent and homes for rent in Harrisville.
Discern and uncover rental homes in Monocacy Station United States and Monocacy Station condos for rent.
Determine and discern Rural Ridge United States houses for rent and rental properties Rural Ridge.
Wilson bed and breakfast rentals, vacation rentals in Wilson, and short term rentals
Find and explore rental home Brockway and Brockway United States for rent by owner homes.
Relocate, glimpse, and originate rental home Lancaster, houses for rent in Lancaster Pennsylvania, and Lancaster rental home.
Light upon, detect, and distinguish Shawville rental houses, rental home, and Shawville United States houses for rent.
Distinguish strange, special, and some proof in Bethlehem Pennsylvania and manifest Bethlehem Pennsylvania vacation homes.
Determine, elicit, and discover apartment rentals in Bradford, vacation rental Bradford, homes for rent by owner Bradford, and rental properties in Bradford Pennsylvania.
Send ravishing and stunning circumstances regarding condos for rent, apartment rentals in Bethlehem Pennsylvania, and Bethlehem Pennsylvania holiday rentals found on our website, FRBO.com.
Notice and invent Snyder Pennsylvania rental apartment and Snyder Pennsylvania rental houses.
Uncover, ferret out, and find out rental apartment Allegheny, vacation homes Allegheny Pennsylvania, and condo rentals in Allegheny.
Hear, discern, and identify home rentals in Cumberland Pennsylvania and vacation rentals Cumberland.
Homes for rent Cascade Michigan, rental homes Cascade, homes for rent in Cascade Michigan, and home rentals
Find and discover Sterling apartment rentals and apartment rentals Sterling.
Hill Arkansas bed and breakfast rentals, rental home in Hill, and Hill Arkansas apartments for rent
Short term rentals in Weymouth Massachusetts and Weymouth Massachusetts home rentals
You can relocate, come upon, and recognize bed and breakfast rentals in Bethlehem Pennsylvania and home rentals in Bethlehem.
Light upon and distinguish vacation rental in Armstrong Pennsylvania, homes for rent in Armstrong Pennsylvania, and rental apartment Armstrong.
Discern, move, and come upon Norristown United States rental homes, rent houses Norristown United States, and apartment rentals Norristown.
Identify and observe Northern Cambria rent houses and apartments for rent in Northern Cambria United States.
Design, relocate, and devise vacation rentals Pottersdale, Pottersdale United States houses for rent, and Pottersdale vacation homes.
|
|
