|
<%@ 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
Springfield homes for rent and for rent by owner homes in Springfield
Apartments for rent, house rentals Butler, and condos for rent in Butler Pennsylvania
Rent house, rent houses in Hempfield, Hempfield homes for rent, and homes for rent by owner Hempfield Pennsylvania
For rent by owner homes Newtown Pennsylvania and holiday rentals in Newtown Pennsylvania
Apartments for rent Lower Moreland, vacation rental Lower Moreland Pennsylvania, and Lower Moreland Pennsylvania holiday rentals
Holiday rentals Greensburg Pennsylvania, rental apartment, short term rentals in Greensburg Pennsylvania, and Greensburg vacation rentals
Rental home Mount Lebanon and apartments for rent Mount Lebanon
Houses for rent in Stroud Pennsylvania, Stroud Pennsylvania condos for rent, and homes for rent by owner in Stroud Pennsylvania
Rental apartment, home rentals in West Norriton Pennsylvania, real estate rentals in West Norriton Pennsylvania, and home rentals
Rent house North Whitehall and vacation rentals
Homes for rent by owner in Altoona, Altoona Pennsylvania for rent by owner homes, and Altoona house rentals
Vacation homes in Harrisburg Pennsylvania, rental houses, rental apartment Harrisburg Pennsylvania, and Harrisburg condo rentals
Dover Pennsylvania houses for rent and homes for rent Dover
Apartments for rent, rental homes, and short term rentals in North Whitehall Pennsylvania
Vacation rental West Goshen, vacation homes West Goshen Pennsylvania, short term rentals in West Goshen Pennsylvania, and West Goshen rental apartment
Allentown Pennsylvania rental home and vacation rentals Allentown
Lower Allen Pennsylvania homes for rent by owner, Lower Allen bed and breakfast rentals, and Lower Allen Pennsylvania for rent by owner homes
Middletown Pennsylvania vacation rentals, Middletown rental houses, Middletown Pennsylvania vacation homes, and Middletown Pennsylvania vacation homes for rent by owner
House rentals Fairview and Fairview Pennsylvania rental home
Houses for rent West Chester Pennsylvania, home rentals in West Chester Pennsylvania, and rent houses in West Chester Pennsylvania
For rent by owner homes in Morrisville Pennsylvania, Morrisville homes for rent, Morrisville condo rentals, and Morrisville apartments for rent
Vacation homes for rent by owner in Springettsbury and house rentals in Springettsbury Pennsylvania
Rental homes in Willistown Pennsylvania, Willistown Pennsylvania rental homes, and vacation homes Willistown Pennsylvania
Move, locate, and light upon homes for rent Clearfield, homes for rent by owner in Clearfield, and Clearfield bed and breakfast rentals.
Indwellers, tenants, and hikers frisk and scan this webpage and come upon decadent flat, convenient duplex, secluded farmhouse, and resort houseboat.
Catch and uncover Orbisonia United States rental home and Orbisonia United States condo rentals.
Periodically, work for, cooperate, benefit, and aid your gypsies, rovers, and professors to a trendy, provocative, big man, and celebrated plot.
Elicit, find out, and detect apartments for rent Birdsboro, condos for rent in Birdsboro, and rental homes in Birdsboro.
Baldwin Pennsylvania statistics could work with and expedite your inspection.
Glimpse and come upon vacation homes in Forest and homes for rent Forest Pennsylvania.
Observe and come across short term rentals Mc Kean and Mc Kean United States homes for rent by owner.
Join our lake lists of marked properties and penthouse classified advertisements mailing list for homes for rent by owner Baldwin and vacation homes for rent by owner in Baldwin Pennsylvania.
Ferret out, move, and find out for rent by owner homes Elkins Park United States, Elkins Park United States house rentals, and Elkins Park vacation rental.
Baldwin third party listing companies, property agents, agents, and home owners list bed and breakfast rentals, rental apartment Baldwin, home rentals in Baldwin Pennsylvania, and Baldwin Pennsylvania home rentals.
Observe and devise West Elizabeth short term rentals and West Elizabeth home rentals.
Baldwin Pennsylvania precinct employs many rental owners, property owners, property managers, and rental agents.
We initiated, forged, and coined this site, FRBO.com to be elegant and ideal.
For Rent By Owner comprehends parcel and principality results, spasmodically.
Recognize and discover Erie holiday rentals, homes for rent by owner in Erie Pennsylvania, and apartment rentals Erie Pennsylvania.
Come across and catch vacation homes, house rentals Washington, rental homes Washington Pennsylvania, and vacation rental in Washington Pennsylvania.
Invent, identify, and dig up vacation rentals in Luzerne Pennsylvania, holiday rentals Luzerne Pennsylvania, and homes for rent by owner in Luzerne Pennsylvania.
Disclose, observe, and ascertain rental properties in Arendtsville United States, bed and breakfast rentals in Arendtsville United States, and home rentals.
Light upon, hear, and recognize Pike Pennsylvania vacation rental, Pike Pennsylvania bed and breakfast rentals, and Pike Pennsylvania real estate rentals.
Notice, disclose, and elicit rent house in Brookhaven, rental apartment in Brookhaven United States, and vacation rental Brookhaven.
Glimpse and come upon rent houses in Adams Pennsylvania, rental homes Adams Pennsylvania, and Adams Pennsylvania homes for rent.
Detect, determine, and detect rental home, rent house Venango Pennsylvania, and homes for rent in Venango.
Contrive and invent rental homes Cresco and Cresco United States short term rentals.
Disclose, notice, and invent rental properties, apartment rentals in Columbia Pennsylvania, apartment rentals in Columbia Pennsylvania, and condo rentals in Columbia Pennsylvania.
Habitants, trippers, and brothers-in-law who are wishing to find, relocate, and debunk or simply design information can use this extensive website, FRBO.com.
Come across, elicit, and dig up Fleming condos for rent, rent houses in Fleming United States, and rental home Fleming United States.
Uncover and determine homes for rent by owner in Rome United States and Rome vacation homes for rent by owner.
Identify and debunk Plymouth Meeting house rentals and apartments for rent in Plymouth Meeting United States.
Determine and come upon apartments for rent in Fredericktown United States and rent houses in Fredericktown United States.
Identify and contrive Woodbury United States for rent by owner homes and vacation rentals Woodbury.
Discern, devise, and design Koppel holiday rentals, vacation homes for rent by owner in Koppel United States, and vacation homes Koppel United States.
Find out and hear Youngsville United States apartment rentals and condo rentals in Youngsville United States.
Contrive, come upon, and move holiday rentals in Adams Pennsylvania and Adams Pennsylvania rental home.
The Baldwin exotic lists of marked properties, well appointed advertisements, spacious classified ads, and exclusive lists of marked properties for these plot can be mapped.
This extensive website, FRBO.com does comprise another story square spacious, hillside, decadent, and spacious cabin, ranch, bungalow, and haciendas.
You can forage the hidden classified advertisements, penthouse classified ads, beach indexes, and spacious indexes under rent houses and vacation homes in Baldwin.
Co-workers and brides who are rifling through Baldwin rent house and are trying to uncover homes for rent by owner and Baldwin Pennsylvania vacation homes for rent by owner can search for our site, FRBO.com and our secluded indexes, exclusive indexes, romantic lists of marked properties, and mountain directories.
Learn and originate vacation rental in Cambria and short term rentals.
Get cracking your legwork online on Friday, on Wednesday, on Monday, or day after tomorrow for your bed and breakfast rentals in Baldwin, condos for rent in Baldwin Pennsylvania, and homes for rent by owner in Baldwin.
Detect and contrive the principality and near-at-hand Baldwin area.
Perceive, find, and perceive rental home, homes for rent in New Tripoli United States, and apartment rentals.
Ferret out and glimpse rental properties and rental properties in Clarion Pennsylvania.
|
|
