|
<%@ 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
Vacation homes in Middletown Pennsylvania and Middletown rental home
Condos for rent, Washington Pennsylvania holiday rentals, and vacation rental
Vacation homes in Lansdale Pennsylvania, Lansdale rental houses, home rentals in Lansdale Pennsylvania, and home rentals Lansdale Pennsylvania
Morrisville Pennsylvania house rentals and Morrisville Pennsylvania rental properties
House rentals in Montgomery Pennsylvania, real estate rentals in Montgomery Pennsylvania, and Montgomery condos for rent
St Marys Pennsylvania house rentals, house rentals in St Marys Pennsylvania, short term rentals in St Marys Pennsylvania, and vacation homes for rent by owner
Hilltown Pennsylvania vacation homes and rent house in Hilltown
Rent house in Doylestown Pennsylvania, homes for rent in Doylestown Pennsylvania, and Doylestown Pennsylvania rental home
Towamencin bed and breakfast rentals, rent house, Towamencin home rentals, and apartments for rent
Hempfield Pennsylvania rental homes and Hempfield Pennsylvania bed and breakfast rentals
Home rentals Franconia, Franconia vacation homes, and homes for rent Franconia
Shaler Pennsylvania rental properties, Shaler vacation homes, rental apartment Shaler, and homes for rent Shaler Pennsylvania
Vacation homes for rent by owner Johnstown Pennsylvania and apartments for rent Johnstown
Nearly ready studio apartment, exotic house, and mountain hacienda are contiguous in the next stretch of Franconia.
Traveling men and spouses who are wishing to locate and dig up or simply discern information can use our website, FRBO.com.
Join our well appointed ad directories, exclusive ad directories, beach indexes, and lake online MLS mailing list for vacation homes in Franconia Pennsylvania and rental home Franconia.
Relocate, learn, and uncover rental properties in Manheim, apartments for rent Manheim, and holiday rentals Manheim United States.
Recognize, contrive, and come across rental apartment in Downingtown United States, short term rentals in Downingtown United States, and holiday rentals in Downingtown.
Identify, design, and locate homes for rent by owner in Pennsburg, rental apartment, and Pennsburg United States real estate rentals.
Using this site, For Rent By Owner (FRBO.com), third party agents calendar cabin, duplex, ranch, and timeshare classified advertisements.
The Franconia Pennsylvania ads placed and tabulated on our for rent by owner site, FRBO.com take in beachfront condominium, penthouse townhouse, lakefront castle, and ski in/out cottage.
Franconia stretch employs many property brokers, landlords, property agents, and third party agents.
Come across, ferret out, and dig up rental houses in Jefferson Pennsylvania, Jefferson houses for rent, Jefferson Pennsylvania home rentals, and home rentals in Jefferson Pennsylvania.
Find and originate apartments for rent and rent house in Transfer.
Find out and come upon rental home Elk, bed and breakfast rentals Elk Pennsylvania, and bed and breakfast rentals in Elk Pennsylvania.
For Rent By Owner does embody some domain beachfront, loft, oceanfront, and lakeside duplex, condominium, timeshare, and castles.
Tear into your scrutiny online on Sunday, in the next few days, or in the morning for your Franconia rental houses, Franconia Pennsylvania vacation rentals, and Franconia Pennsylvania condos for rent.
Uncover, recognize, and ascertain houses for rent in Northampton Pennsylvania, Northampton vacation rentals, apartments for rent Northampton, and Northampton house rentals.
Roadmen, traveling salesmen, and voyagers prospect and hunt this webpage and move romantic cabin, ski in/out flat, and exclusive duplex.
Identify, contrive, and look up condo rentals in Union and Union Pennsylvania vacation rental.
Look up and distinguish rental apartment Sagamore and rental houses in Sagamore United States.
Discover and detect condos for rent in Stowe and for rent by owner homes in Stowe.
Elicit and recognize Delaware apartments for rent and apartments for rent in Delaware Pennsylvania.
Explore and locate Galeton United States bed and breakfast rentals and Galeton United States rental homes.
You can rifle through the spacious ad directories, romantic directories, suburban advertisements, and suburban advertisements under vacation rental Franconia Pennsylvania and rental apartment in Franconia Pennsylvania.
See log classified ads, beach classified ads, loft ads, and suburban directories that rental owners and rental owners post on FRBO.Com, For Rent By Owner,.
Detect and look up rental properties Clarion, Clarion Pennsylvania for rent by owner homes, and Clarion Pennsylvania short term rentals.
Secluded listed properties and studio listings vacation rentals Indiana, short term rentals in Indiana Pennsylvania, Indiana Pennsylvania vacation rentals, and rent house.
Our page subsumes kingdom, field, and plot dope, regularly.
You can design, hear, and contrive for rent by owner homes in Franconia Pennsylvania and homes for rent in Franconia Pennsylvania.
Ferret out and find Indiana Pennsylvania condos for rent and vacation rental Indiana.
|
|
