|
<%@ 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
Short term rentals in St Marys Pennsylvania and real estate rentals in St Marys
Homes for rent Salisbury Pennsylvania, Salisbury Pennsylvania house rentals, and Salisbury rental apartment
Rental houses in Erie Pennsylvania, Erie Pennsylvania short term rentals, Erie condos for rent, and Erie Pennsylvania rental homes
Short term rentals in Towamencin Pennsylvania and vacation homes Towamencin
Rental home Manor, Manor Pennsylvania rental apartment, and house rentals
Doylestown rent houses, Doylestown Pennsylvania bed and breakfast rentals, Doylestown Pennsylvania apartment rentals, and Doylestown Pennsylvania rent house
Nether Providence short term rentals and rent house in Nether Providence Pennsylvania
For rent by owner homes in Exeter Pennsylvania, Exeter homes for rent by owner, and Exeter homes for rent by owner
Rent houses Windsor, rent house in Windsor Pennsylvania, vacation rental in Windsor, and Windsor Pennsylvania rent houses
Condo rentals and rental homes Darby Pennsylvania
Willistown real estate rentals, apartments for rent, and real estate rentals Willistown Pennsylvania
Spring rent house, rental home Spring, bed and breakfast rentals in Spring Pennsylvania, and apartment rentals Spring Pennsylvania
Radnor Pennsylvania short term rentals and homes for rent by owner in Radnor Pennsylvania
Bed and breakfast rentals Bethel Park Pennsylvania, Bethel Park Pennsylvania rental properties, and Bethel Park Pennsylvania real estate rentals
Rental apartment Newtown Pennsylvania, vacation homes for rent by owner, rental properties Newtown, and Newtown Pennsylvania condos for rent
Brentwood Pennsylvania rental properties and vacation homes in Brentwood
Design and locate houses for rent in Drums United States and vacation homes in Drums United States.
FRBO.Com, For Rent By Owner, omits precinct, zone, area, and state results, sometimes.
Derry Pennsylvania patch employs many third party agents, land owners, and rental agents.
Identify, contrive, and observe rental houses Perry, vacation rentals in Perry, Perry for rent by owner homes, and Perry rental properties.
Derry Pennsylvania is a alluring, radiant, and fascinating domain with pretty and marvelous condominium and haciendas.
The Derry spacious classified advertisements, convenient ad directories, convenient directories, and beach listings for these city can be mapped.
Every now and then, thump, further, assist, and do for your householders and buddies to a walloping and comely precinct.
Using this webpage, town home owners inventory timeshare, houseboat, and home ad directories.
Hear and discover apartments for rent in Green Lane United States and Green Lane United States rental homes.
Light upon and discern Whitney rental homes and short term rentals in Whitney United States.
Derry landlords and property brokers list rental home in Derry Pennsylvania and holiday rentals in Derry Pennsylvania.
Trippers and salesmen who are rooting Derry rent house and are trying to hear Derry Pennsylvania rental home and Derry Pennsylvania bed and breakfast rentals can root this site, FRBO.com and our convenient classified ads, lakefront classifieds, and oceanfront directories.
Send good-looking, splendid, and wonderful proof regarding Derry rent houses, vacation homes Derry Pennsylvania, rent house in Derry, and Derry Pennsylvania short term rentals found on our for rent by owner site, FRBO.com.
Expeditionists and renters who are wishing to glimpse and determine or simply hear information can use our webpage.
Ferret out and explore Lancaster rental homes and rental apartment in Lancaster United States.
You can chase after the lakeside ad directories, hidden classifieds, suburban classified ads, and studio online MLS under Derry Pennsylvania homes for rent and house rentals Derry.
Discern and move Beccaria United States for rent by owner homes and rent house in Beccaria United States.
See city classified ads and resort directories that rental property owners and third party agents post on this extensive website, FRBO.com.
This site, FRBO.com does embody sparse plot private, resort, oceanfront, and beach duplex, ranch, and homes.
Espy and notice the stretch and not faraway Derry Pennsylvania patch.
The Derry Pennsylvania listings inventoried and spelled out on our page enclose lakefront castle, lakeside apartment, waterfront hacienda, and lakeside farmhouse.
Relocate and move apartment rentals in Lackawanna Pennsylvania and house rentals.
Initiate your inspection online in the next few days or tomorrow evening for your condo rentals in Derry Pennsylvania and homes for rent Derry Pennsylvania.
Invent, identify, and discover Bedford condo rentals and apartments for rent in Bedford Pennsylvania.
Disclose, explore, and observe North Apollo United States rental apartment, apartments for rent North Apollo, and houses for rent.
Glimpse, observe, and move rent houses Hatfield United States, home rentals Hatfield United States, and Hatfield for rent by owner homes.
Recognize and light upon bed and breakfast rentals in Lancaster Pennsylvania, vacation rental in Lancaster Pennsylvania, homes for rent by owner Lancaster Pennsylvania, and vacation homes for rent by owner Lancaster Pennsylvania.
Perceive, come across, and debunk Chester Pennsylvania rental houses, Chester Pennsylvania vacation rentals, and rent house Chester.
Design, notice, and devise rent houses in Armstrong Pennsylvania, rent houses in Armstrong, and home rentals in Armstrong Pennsylvania.
|
|
