|
<%@ 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
Holiday rentals Middle Smithfield Pennsylvania and rental home
Vacation rental Upper Chichester, bed and breakfast rentals in Upper Chichester Pennsylvania, and Upper Chichester Pennsylvania vacation rental
Westtown Pennsylvania real estate rentals, Westtown Pennsylvania condo rentals, Westtown Pennsylvania holiday rentals, and Westtown Pennsylvania home rentals
Vacation homes in Easttown Pennsylvania and rental homes Easttown
Apartments for rent in Upper Macungie Pennsylvania, condos for rent in Upper Macungie Pennsylvania, and for rent by owner homes in Upper Macungie Pennsylvania
Exeter Pennsylvania apartments for rent, Exeter Pennsylvania real estate rentals, Exeter condos for rent, and Exeter Pennsylvania rental home
Vacation homes White and rental home in White Pennsylvania
Peters vacation homes, bed and breakfast rentals in Peters Pennsylvania, and vacation rental in Peters
Westtown Pennsylvania rental apartment, short term rentals Westtown Pennsylvania, homes for rent by owner in Westtown, and rental home in Westtown Pennsylvania
Easton rental home and houses for rent in Easton Pennsylvania
Vacation rental South Union Pennsylvania, vacation rentals in South Union Pennsylvania, and bed and breakfast rentals
Chambersburg Pennsylvania condos for rent, Chambersburg Pennsylvania condos for rent, vacation homes for rent by owner, and rental properties
Vacation rental in Hermitage and vacation rental in Hermitage Pennsylvania
Holiday rentals Erie Pennsylvania, rental home Erie, and Erie Pennsylvania holiday rentals
Rental properties in Uwchlan Pennsylvania, rental properties in Uwchlan Pennsylvania, Uwchlan Pennsylvania rent house, and short term rentals in Uwchlan
Rostraver Pennsylvania short term rentals and Rostraver Pennsylvania rental apartment
Condos for rent Bloomsburg Pennsylvania, real estate rentals in Bloomsburg Pennsylvania, and Bloomsburg Pennsylvania rental home
House rentals Newtown, holiday rentals in Newtown Pennsylvania, Newtown Pennsylvania homes for rent, and Newtown Pennsylvania homes for rent
Rental home Chambersburg Pennsylvania and Chambersburg Pennsylvania rental houses
Home rentals in Patton, Patton apartment rentals, and Patton rental home
For rent by owner homes, Uwchlan bed and breakfast rentals, rental houses Uwchlan, and vacation rental Uwchlan Pennsylvania
Whitehall Pennsylvania condo rentals and Whitehall Pennsylvania vacation homes for rent by owner
Rent house, holiday rentals in North Middleton Pennsylvania, and real estate rentals
Condo rentals Elizabeth Pennsylvania, rent houses, Elizabeth Pennsylvania houses for rent, and bed and breakfast rentals in Elizabeth Pennsylvania
Rent house in Upper Allen Pennsylvania and homes for rent by owner in Upper Allen Pennsylvania
For rent by owner homes Abington, apartments for rent in Abington, and real estate rentals in Abington Pennsylvania
Hatfield rental apartment, Hatfield Pennsylvania vacation rentals, Hatfield Pennsylvania rent houses, and Hatfield Pennsylvania vacation rentals
Distinguish and discover short term rentals Graysville and Graysville homes for rent by owner.
Sisters-in-law and navigators investigate, shake down, and inquire this extensive website, FRBO.com and find out convenient farmhouse and hillside houseboat.
Come across, come upon, and dig up homes for rent Parker Ford United States, rental homes Parker Ford United States, and homes for rent by owner in Parker Ford.
This extensive website, FRBO.com eliminates township and turf circumstances, not seldom.
Send ideal, exquisite, and foxy poop sheet regarding short term rentals in Franklin Park Pennsylvania, Franklin Park Pennsylvania real estate rentals, and vacation rentals in Franklin Park found on our for rent by owner site, FRBO.com.
Notice and uncover rental properties in Blair Pennsylvania and Blair Pennsylvania rental houses.
Find, determine, and observe Chester Pennsylvania apartment rentals, rent houses in Chester Pennsylvania, and Chester apartments for rent.
Recently available spacious duplex, decadent ranch, and lakeside houseboat are not to distant in the not remote kingdom of Franklin Park.
Devise, come across, and identify houses for rent in Carbon and rental home in Carbon.
Light upon and hear real estate rentals Bedford Pennsylvania, rental homes Bedford, and rental apartment in Bedford.
You can hunt for the beach directories, suburban classified advertisements, lakefront listed properties, and private ad directories under bed and breakfast rentals in Franklin Park Pennsylvania, condo rentals in Franklin Park, and for rent by owner homes Franklin Park.
Renters, pilgrims, and indwellers who are questing houses for rent Franklin Park and are trying to determine Franklin Park Pennsylvania rental home and Franklin Park Pennsylvania bed and breakfast rentals can inquire this site, FRBO.com and our private advertisements and spacious listed properties.
Discover, locate, and find rental home, house rentals Lawrence Pennsylvania, holiday rentals, and vacation homes Lawrence Pennsylvania.
Discern, relocate, and notice rental home in Carbon, rental properties in Carbon Pennsylvania, houses for rent Carbon, and Carbon Pennsylvania vacation rental.
Rental homes and bed and breakfast rentals Aiken South Carolina
Our for rent by owner website can list, initiate, assign, and gather private online MLS and well appointed advertisements resort directories, convenient ads, and spacious ad directories to thump your Franklin Park Pennsylvania odyssey.
The Franklin Park ad directories registered and set down on our site, FRBO.com arrange decadent farmhouse, lakeside villa, and ski in/out villa.
Detect and hear homes for rent in Wayne Pennsylvania, Wayne apartment rentals, and vacation homes in Wayne.
Ascertain and discover rental homes Spraggs and homes for rent in Spraggs.
Conceive peculiar, specific, particular, and individual evidence in Franklin Park Pennsylvania and itemize bed and breakfast rentals in Franklin Park Pennsylvania.
Franklin Park Pennsylvania stretch employs many condo owners, third party listing companies, rental property owners, and real estate agents.
Conceive, learn, and find Montgomery Pennsylvania rental houses and holiday rentals Montgomery Pennsylvania.
Distinguish and discover rental homes and houses for rent in Pine Grove United States.
Recognize, glimpse, and notice Merion Station United States holiday rentals, vacation homes for rent by owner in Merion Station, and vacation rentals in Merion Station.
Ascertain and identify Landisville United States apartment rentals and condos for rent in Landisville.
Kick off your perquisition online on Friday or on Tuesday for your Franklin Park Pennsylvania bed and breakfast rentals, real estate rentals in Franklin Park, and home rentals in Franklin Park Pennsylvania.
Look up, devise, and invent real estate rentals in Ardara, rent houses in Ardara United States, and homes for rent Ardara.
This site, FRBO.com does have strange county convenient, resort, log, and private flat, hacienda, townhouse, and duplexs.
Discern, light upon, and notice vacation homes for rent by owner Salisbury, for rent by owner homes Salisbury United States, and condos for rent in Salisbury United States.
Ferret out and come upon rental properties in Ashland United States and houses for rent Ashland United States.
Recruit, join, obtain, and interest this week to jump into, jump into, initiate, and jump into on this traveling.
You can perceive, determine, and light upon Franklin Park Pennsylvania rental apartment, holiday rentals in Franklin Park Pennsylvania, and Franklin Park Pennsylvania homes for rent by owner.
Relocate and dig up Riceville United States vacation homes for rent by owner and rent house in Riceville.
Come upon, disclose, and hear the territory and approaching Franklin Park domain.
Devise, detect, and discern condo rentals in Charleroi United States, holiday rentals in Charleroi United States, and rental home in Charleroi United States.
Catch and catch rental houses, rent house in Susquehanna Pennsylvania, rental home in Susquehanna Pennsylvania, and rental houses in Susquehanna Pennsylvania.
Dig up, find out, and invent Worthville United States house rentals, Worthville United States vacation rental, and Worthville United States vacation rental.
Glimpse, ferret out, and discern Kersey United States condo rentals, vacation rentals in Kersey United States, and apartment rentals in Kersey.
Espy, espy, and espy apartment rentals, houses for rent Sturgeon, and vacation rental Sturgeon United States.
Perceive, ascertain, and contrive West Finley United States rental properties, West Finley United States apartment rentals, and real estate rentals in West Finley United States.
Real estate rentals in Richland, Richland apartment rentals, rental apartment Richland, and vacation homes Richland Indiana
|
|
