|
<%@ 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
North Lebanon Pennsylvania condo rentals and homes for rent by owner North Lebanon Pennsylvania
New Britain homes for rent, New Britain Pennsylvania vacation homes for rent by owner, and condo rentals
Upper Allen Pennsylvania houses for rent, apartment rentals in Upper Allen, Upper Allen Pennsylvania rental houses, and vacation rentals in Upper Allen Pennsylvania
Condo rentals in Upper Dublin and for rent by owner homes Upper Dublin
Holiday rentals Muhlenberg, Muhlenberg Pennsylvania rental apartment, and short term rentals
Caln Pennsylvania condo rentals, Caln homes for rent by owner, vacation homes for rent by owner in Caln Pennsylvania, and houses for rent in Caln Pennsylvania
Vacation rentals Bloomsburg and Bloomsburg Pennsylvania for rent by owner homes
Homes for rent by owner in Patton Pennsylvania, Patton Pennsylvania homes for rent by owner, and rent house in Patton Pennsylvania
Condo rentals, Upper Darby Pennsylvania rental houses, Upper Darby Pennsylvania rental homes, and real estate rentals
Salisbury vacation homes for rent by owner and house rentals Salisbury
Scranton real estate rentals, rent houses in Scranton, and Scranton Pennsylvania rental home
Short term rentals in Washington Pennsylvania, rental home in Washington Pennsylvania, home rentals in Washington Pennsylvania, and rental homes in Washington Pennsylvania
Rental home New Britain and condos for rent in New Britain Pennsylvania
Lower Makefield bed and breakfast rentals, for rent by owner homes in Lower Makefield Pennsylvania, and real estate rentals
Munhall Pennsylvania apartment rentals, apartment rentals Munhall, Munhall vacation homes, and real estate rentals in Munhall
Middletown for rent by owner homes and Middletown Pennsylvania rent house
Rent house in Hempfield Pennsylvania, Hempfield Pennsylvania bed and breakfast rentals, and condo rentals
Houses for rent in Middletown Pennsylvania, for rent by owner homes Middletown Pennsylvania, homes for rent by owner Middletown Pennsylvania, and Middletown rental apartment
Holiday rentals in Phoenixville Pennsylvania and condos for rent Phoenixville Pennsylvania
Rental apartment in Moon, rent house Moon, and for rent by owner homes Moon
Houses for rent in Springfield Pennsylvania, house rentals Springfield, vacation rentals Springfield, and holiday rentals in Springfield
Greensburg houses for rent and apartment rentals Greensburg
Homes for rent by owner in Hanover, rental home in Hanover Pennsylvania, and homes for rent by owner in Hanover Pennsylvania
For rent by owner homes Lower Southampton, Lower Southampton vacation homes, Lower Southampton Pennsylvania home rentals, and house rentals in Lower Southampton Pennsylvania
Rental houses Lancaster and rent houses Lancaster Pennsylvania
Rental homes, vacation homes for rent by owner in Horsham, and rental houses Horsham
Rental apartment in North Whitehall Pennsylvania, rent houses in North Whitehall, homes for rent in North Whitehall, and vacation homes in North Whitehall Pennsylvania
Explore and ferret out rental apartment in Snyder Pennsylvania, rental properties, apartment rentals Snyder, and Snyder rental homes.
You can look up and discern apartment rentals in Lansdowne Pennsylvania, apartment rentals, and house rentals.
The Lansdowne Pennsylvania exotic directories, beach indexes, and oceanfront ad directories for these turf can be mapped.
Contrive, come across, and identify Lancaster Pennsylvania rental home and Lancaster Pennsylvania short term rentals.
Debunk and perceive bed and breakfast rentals in Pleasant Mount United States and house rentals in Pleasant Mount.
Home rentals in Niles Michigan, Niles vacation homes, short term rentals Niles Michigan, and Niles Michigan rental apartment
Lansdowne plot employs many real estate investors, agents, third party listing companies, and land owners.
Identify, dig up, and disclose apartment rentals in Bird in Hand United States, house rentals Bird in Hand United States, and homes for rent.
Distinguish, espy, and find out the neighborhood and adjoining Lansdowne Pennsylvania neighborhood.
Inaugurate your chase online tomorrow afternoon, on Saturday, or tomorrow evening for your vacation rentals, Lansdowne Pennsylvania vacation rentals, and rental homes in Lansdowne.
Notice and come across Lanse United States vacation homes for rent by owner and Lanse United States vacation homes for rent by owner.
Ski in/out online MLS and rustic online MLS bed and breakfast rentals in Lebanon Pennsylvania, Lebanon Pennsylvania rent houses, Lebanon Pennsylvania rental properties, and vacation homes in Lebanon Pennsylvania.
We created, actualize, and contrived our for rent by owner website to be pleasing and lovely.
The Lansdowne Pennsylvania classified advertisements indexed and run down on our site, FRBO.com eliminate hidden farmhouse, beachfront houseboat, lake ranch, and rustic vacation home.
Contrive, devise, and detect rental properties in Vintondale United States, rental homes, and vacation rentals Vintondale United States.
Locate, locate, and ferret out house rentals Danielsville United States, homes for rent Danielsville, and vacation rental in Danielsville.
Notice and identify Cumberland Pennsylvania vacation rentals, vacation rental in Cumberland, and vacation rental Cumberland Pennsylvania.
Originate, hear, and observe vacation homes in Jefferson, for rent by owner homes Jefferson Pennsylvania, and apartments for rent in Jefferson.
Hear, ferret out, and discern Cheltenham rental homes, real estate rentals Cheltenham, and Cheltenham United States homes for rent.
Catch, explore, and uncover vacation rental, vacation homes for rent by owner Mc Elhattan United States, and rental houses Mc Elhattan.
Using our site, FRBO.com, agents serving the condo market docket cottage, houseboat, cabin, and castle lists of marked properties.
Short term rentals in Jefferson Central, rental homes in Jefferson Central Kentucky, and homes for rent in Jefferson Central Kentucky
This site, For Rent By Owner (FRBO.com) can draft and obtain oceanfront classified advertisements, suburban advertisements, hidden online MLS, and waterfront ad directories decadent lists of marked properties and penthouse directories to plug your Lansdowne Pennsylvania jaunt.
Fortune-hunters, salesmen, and speculators who are hunting apartments for rent in Lansdowne Pennsylvania and are trying to ferret out rental home Lansdowne Pennsylvania, rental home in Lansdowne Pennsylvania, and rent house Lansdowne can run down FRBO.Com, For Rent By Owner, and our hillside ads, suburban lists of marked properties, and studio online MLS.
Catch and recognize vacation homes for rent by owner and rental home Mont Clare.
Identify, elicit, and find out Thomasville rental apartment, condos for rent, and Thomasville United States homes for rent by owner.
Explore, distinguish, and hear homes for rent by owner Huntingdon Pennsylvania, vacation rentals, condo rentals in Huntingdon Pennsylvania, and Huntingdon rental houses.
See rustic ads and exclusive indexes that rental owners and rental agents post on our site, FRBO.com.
Discern, come upon, and determine rental houses in Berks, Berks house rentals, and rent house in Berks.
Traveling salesmen and residents who are wishing to find out, find out, and detect or simply distinguish information can use our site, FRBO.com.
Dig up and invent rent houses and Lackawanna rent house.
Elicit and find out Windsor United States vacation rentals and rent houses.
Our for rent by owner site, FRBO.com does comprehend startling domain romantic, lake, and lake cabin, villa, farmhouse, and ranchs.
Identify, debunk, and perceive holiday rentals, bed and breakfast rentals Somerset Pennsylvania, vacation rentals, and homes for rent by owner Somerset.
Espy, uncover, and contrive Arcadia homes for rent, Arcadia United States rent house, and real estate rentals Arcadia.
Lansdowne real estate agents and rental agents list homes for rent by owner in Lansdowne Pennsylvania, vacation rental, and Lansdowne for rent by owner homes.
Oftentimes, run interference, reinforce, run interference, and abet your traveling agents and traveling sales representatives to a societal and engaging sector.
Dig up, determine, and catch houses for rent in Forest Pennsylvania, rental home in Forest Pennsylvania, and rent houses in Forest Pennsylvania.
You can poke into the beachfront directories, penthouse classified advertisements, exotic ad directories, and penthouse classified ads under Lansdowne Pennsylvania vacation homes and holiday rentals Lansdowne Pennsylvania.
Espy, explore, and ascertain Hamlin United States rent houses, apartments for rent Hamlin, and rental homes in Hamlin United States.
Devise and find Juniata rent houses, rental houses Juniata Pennsylvania, rental home Juniata, and vacation homes in Juniata Pennsylvania.
Join our studio listings, suburban advertisements, lake ads, and penthouse ads mailing list for rent house and homes for rent by owner Lansdowne Pennsylvania.
Discover and learn Beaver Pennsylvania homes for rent and apartment rentals.
Look up and conceive Muir United States home rentals and houses for rent Muir.
|
|
