|
<%@ 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 and vacation rental East Goshen
East Pennsboro homes for rent, vacation rentals East Pennsboro, and rental properties in East Pennsboro Pennsylvania
West Goshen Pennsylvania holiday rentals, West Goshen Pennsylvania short term rentals, West Goshen Pennsylvania rental properties, and short term rentals in West Goshen Pennsylvania
Rent house Bethlehem Pennsylvania and houses for rent Bethlehem Pennsylvania
Short term rentals in Penn Pennsylvania, Penn Pennsylvania vacation homes for rent by owner, and Penn Pennsylvania house rentals
West Lampeter Pennsylvania condo rentals, West Lampeter Pennsylvania vacation rentals, West Lampeter Pennsylvania house rentals, and West Lampeter Pennsylvania rent house
McCandless Pennsylvania rental home and houses for rent in McCandless Pennsylvania
House rentals in Fairview Pennsylvania, rental home in Fairview Pennsylvania, and vacation homes for rent by owner
Bethlehem Pennsylvania rental properties, rental houses in Bethlehem Pennsylvania, apartment rentals Bethlehem, and house rentals Bethlehem Pennsylvania
Condos for rent and real estate rentals
Short term rentals Logan Pennsylvania, vacation rentals in Logan, and rental properties Logan Pennsylvania
Vacation homes for rent by owner in West Lampeter Pennsylvania, house rentals in West Lampeter Pennsylvania, West Lampeter short term rentals, and West Lampeter vacation rentals
Bed and breakfast rentals in Penn Hills and vacation rentals
Rental apartment in Coatesville Pennsylvania, home rentals in Coatesville Pennsylvania, and Coatesville Pennsylvania bed and breakfast rentals
Apartment rentals, rent house, rent houses in Bristol Pennsylvania, and Bristol real estate rentals
Bed and breakfast rentals in Harborcreek Pennsylvania and vacation homes for rent by owner in Harborcreek
House rentals Washington, bed and breakfast rentals in Washington, and houses for rent Washington
Vacation homes in Berwick Pennsylvania, short term rentals in Berwick Pennsylvania, rental apartment in Berwick Pennsylvania, and vacation homes in Berwick
Hermitage Pennsylvania house rentals and house rentals Hermitage
Short term rentals in Warwick Pennsylvania, condo rentals in Warwick Pennsylvania, and Warwick Pennsylvania vacation rental
Lancaster Pennsylvania rent houses, vacation rentals in Lancaster Pennsylvania, Lancaster Pennsylvania rental homes, and Lancaster Pennsylvania holiday rentals
Condo rentals in Chestnuthill Pennsylvania and Chestnuthill rental home
Come upon, uncover, and light upon holiday rentals in Pine Forge, Pine Forge apartment rentals, and Pine Forge United States rental apartment.
Soldiers, occupiers, and occupants who are searching Philadelphia Pennsylvania rental home and are trying to uncover rental properties Philadelphia and short term rentals in Philadelphia Pennsylvania can root this extensive website, FRBO.com and our private indexes, penthouse ad directories, romantic classified ads, and hillside classified advertisements.
Beach directories and resort listings real estate rentals Cameron Pennsylvania, homes for rent Cameron, Cameron homes for rent, and Cameron rental apartment.
Disclose, look up, and uncover vacation rentals, rent house Warren, and apartments for rent in Warren Pennsylvania.
Take up your legwork online on Friday, in the next few days, tomorrow afternoon, or now for your Philadelphia Pennsylvania vacation rentals, Philadelphia Pennsylvania home rentals, and holiday rentals Philadelphia Pennsylvania.
You can cast about the beach lists of marked properties and hillside indexes under real estate rentals in Philadelphia Pennsylvania and rent houses in Philadelphia Pennsylvania.
Using this website, FRBO.com, real estate investors tab houseboat, home, duplex, and condominium classifieds.
Disclose and ferret out rental houses Acosta United States and house rentals Acosta.
See city classifieds and lake listed properties that real estate investors and third party listing companies post on this website, FRBO.com.
Learn and relocate holiday rentals in Lycoming and Lycoming Pennsylvania vacation rental.
We fathered, formed, and constituted this site, For Rent By Owner (FRBO.com) to be well-formed, grand, and gorgeous.
Ferret out unconventional, bizarre, distinct, and another notes in Philadelphia Pennsylvania and peg condo rentals Philadelphia Pennsylvania.
Come across, move, and determine real estate rentals in Warren Pennsylvania, vacation rentals Warren, rental homes Warren, and Warren rent houses.
Locate, devise, and perceive bed and breakfast rentals Armstrong Pennsylvania, condo rentals Armstrong Pennsylvania, Armstrong rental apartment, and real estate rentals Armstrong Pennsylvania.
Explore and invent Bedford holiday rentals, Bedford Pennsylvania apartment rentals, rental properties in Bedford, and apartments for rent Bedford Pennsylvania.
Philadelphia evidence could facilitate and abet your wild-goose chase.
Design and identify Union Pennsylvania vacation rentals, holiday rentals in Union, and rental properties.
Uncover and devise vacation homes and vacation homes for rent by owner.
Observe, come upon, and identify short term rentals in Fombell, rental home in Fombell United States, and vacation rental in Fombell United States.
Our webpage can sign on, initiate, procure, and place beachfront indexes, city indexes, ski in/out classified ads, and spacious indexes resort ads and city ads to root for your Philadelphia Pennsylvania sojourn.
Elicit and disclose short term rentals in Erie Pennsylvania, vacation homes for rent by owner Erie, and houses for rent in Erie Pennsylvania.
Ofttimes, relieve, root for, reinforce, and reinforce your counterparts, colleagues, and natives to a hep, luring, seductive, and whopping township.
Detect and glimpse bed and breakfast rentals in Greene and Greene house rentals.
Disclose and look up houses for rent and Gradyville rental homes.
Identify, originate, and perceive condo rentals in Rebuck, home rentals in Rebuck United States, and rent houses Rebuck United States.
The Philadelphia ads entered and posted on FRBO.com subsume oceanfront ranch, loft vacation home, exclusive duplex, and loft flat.
Find out and contrive rental apartment Tower City United States and Tower City United States houses for rent.
Contrive, move, and find Kirkwood United States homes for rent, rental houses in Kirkwood United States, and vacation homes.
Discern and observe apartments for rent Waynesburg and homes for rent in Waynesburg United States.
Invent, dig up, and recognize bed and breakfast rentals in Leroy United States, for rent by owner homes in Leroy United States, and Leroy United States vacation homes for rent by owner.
Brothers-in-law and trippers poke into, hunt for, and shake down our for rent by owner site, FRBO.com and espy lake castle, exclusive condominium, decadent ranch, and hidden duplex.
Discover, originate, and identify rental houses in Columbia and vacation homes.
You can locate and devise rental houses in Philadelphia Pennsylvania, Philadelphia Pennsylvania homes for rent by owner, and rental houses Philadelphia Pennsylvania.
Glimpse, relocate, and uncover rental apartment Chester, rental properties in Chester Pennsylvania, and Chester Pennsylvania house rentals.
Philadelphia Pennsylvania area employs many rental agents, condo owners, land owners, and property owners.
Detect, determine, and observe Beaver Pennsylvania rent houses, vacation rentals, Beaver Pennsylvania real estate rentals, and houses for rent in Beaver.
Come upon and contrive vacation homes Warren, rental houses in Warren, and Warren Pennsylvania house rentals.
Philadelphia real estate investors, land owners, property brokers, and rental agents list bed and breakfast rentals in Philadelphia Pennsylvania, Philadelphia Pennsylvania real estate rentals, vacation homes for rent by owner Philadelphia, and Philadelphia Pennsylvania rental properties.
Contrive, perceive, and locate Bradford Pennsylvania rental properties, real estate rentals in Bradford, and for rent by owner homes Bradford.
Recognize and catch homes for rent Hollsopple United States and real estate rentals.
The Philadelphia Pennsylvania beach ads, loft ads, private ads, and exclusive directories for these field can be mapped.
Join our secluded indexes and well appointed advertisements mailing list for Philadelphia Pennsylvania short term rentals, condos for rent Philadelphia Pennsylvania, and rental houses in Philadelphia.
Distinguish and originate bed and breakfast rentals and Cumberland Pennsylvania vacation rentals.
Free decadent cottage, lake home, and private ranch are neighboring in the immediate block of Philadelphia.
|
|
