|
<%@ 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
Rental apartment in North Fayette and vacation rental North Fayette Pennsylvania
Homes for rent by owner in Franconia Pennsylvania, vacation rental in Franconia Pennsylvania, and for rent by owner homes Franconia Pennsylvania
Rental home in State College Pennsylvania, homes for rent by owner in State College, State College Pennsylvania houses for rent, and home rentals in State College Pennsylvania
Holiday rentals Spring Garden and houses for rent Spring Garden
Patton Pennsylvania rental houses, homes for rent in Patton Pennsylvania, and Patton homes for rent by owner
Rental home, real estate rentals in Whitpain, Whitpain Pennsylvania rental houses, and Whitpain rent house
House rentals in Ferguson and rent house Ferguson
Vacation homes for rent by owner, Lancaster Pennsylvania short term rentals, and apartment rentals Lancaster
Whitemarsh Pennsylvania rental homes, vacation homes for rent by owner in Whitemarsh, Whitemarsh Pennsylvania real estate rentals, and rental apartment in Whitemarsh Pennsylvania
Apartment rentals and vacation rentals
Rent houses in West Norriton Pennsylvania, bed and breakfast rentals West Norriton, and rental houses West Norriton Pennsylvania
York Pennsylvania real estate rentals, rental home York Pennsylvania, York Pennsylvania condos for rent, and York Pennsylvania apartments for rent
Rent houses Elizabethtown Pennsylvania and real estate rentals in Elizabethtown Pennsylvania
Lancaster apartment rentals, Lancaster Pennsylvania short term rentals, and rent houses in Lancaster Pennsylvania
Real estate rentals Hampden, rental properties in Hampden, holiday rentals, and apartment rentals Hampden
Homes for rent by owner in Silver Spring Pennsylvania and apartment rentals in Silver Spring Pennsylvania
Rental home in Uwchlan Pennsylvania, Uwchlan homes for rent, and rental home Uwchlan Pennsylvania
Abington Pennsylvania homes for rent by owner, house rentals Abington Pennsylvania, Abington Pennsylvania homes for rent by owner, and short term rentals in Abington Pennsylvania
Apartment rentals West Norriton and West Norriton Pennsylvania condos for rent
Vacation rentals West Hempfield, West Hempfield Pennsylvania home rentals, and West Hempfield homes for rent
Vacation rental Montgomery, vacation rental in Montgomery Pennsylvania, homes for rent by owner, and rental properties Montgomery Pennsylvania
York houses for rent and real estate rentals
Houses for rent Washington, vacation rental Washington, and home rentals
Rental houses, vacation rentals, homes for rent Bethlehem Pennsylvania, and Bethlehem real estate rentals
Condo rentals Uniontown Pennsylvania and rental properties Uniontown
Bethlehem vacation rentals, rental apartment Bethlehem Pennsylvania, and for rent by owner homes Bethlehem Pennsylvania
Williamsport Pennsylvania vacation homes for rent by owner, Williamsport rent houses, apartments for rent, and rental home
Houses for rent in Manchester Pennsylvania and rent houses in Manchester Pennsylvania
Vacation homes, Westtown holiday rentals, and rental apartment Westtown
Aston is a admirable, comely, and divine patch with radiant and pulchritudinous lodge and townhouses.
Relocate and light upon Breinigsville houses for rent and Breinigsville house rentals.
Condo rentals, Chowchilla California rental home, and homes for rent in Chowchilla California
Aston Pennsylvania brass tacks could bail out, cooperate, further, and do for your pursuing.
This site, For Rent By Owner (FRBO.com) embodys dominion, tract, stretch, and locality dope, occasionally.
Ascertain, glimpse, and contrive apartment rentals in Roulette United States, condo rentals in Roulette United States, and rent houses Roulette.
We erected, fabricated, and invented this extensive website, FRBO.com to be fair, well-formed, and pulchritudinous.
Invent and learn bed and breakfast rentals in Lionville United States and rental houses in Lionville United States.
Aston condo owners, real estate investors, and third party listing companies list rental apartment Aston Pennsylvania and house rentals in Aston.
Aston Pennsylvania turf employs many land owners, agents serving the condo market, condo owners, and rental agents.
Discover, dig up, and look up apartment rentals in Hutchinson United States, holiday rentals in Hutchinson, and house rentals Hutchinson.
Contrive, learn, and identify vacation homes in Long Pond United States, vacation homes in Long Pond United States, and home rentals.
You can look for the beachfront classified advertisements, beachfront indexes, and loft ad directories under condo rentals Aston Pennsylvania and rent house in Aston Pennsylvania.
Come across, light upon, and dig up the tract and not remote Aston Pennsylvania locality.
Learn and find Schuylkill Haven United States home rentals and rental houses Schuylkill Haven.
Glimpse, originate, and devise apartments for rent, rental home in York Pennsylvania, rent house York Pennsylvania, and vacation rental.
Find, dig up, and originate rental homes in Warren Pennsylvania, Warren vacation homes, and Warren Pennsylvania holiday rentals.
Determine and glimpse house rentals in Reading United States and house rentals in Reading United States.
Ascertain, invent, and disclose vacation homes in Elk, vacation homes for rent by owner, and Elk Pennsylvania condos for rent.
Identify atypical, particular, and individual brass tacks in Aston and tick off rent house Aston Pennsylvania.
Fallbrook California holiday rentals, Fallbrook California real estate rentals, Fallbrook California vacation homes, and vacation homes in Fallbrook
You can come across and look up house rentals in Aston Pennsylvania, rent house in Aston Pennsylvania, and Aston apartments for rent.
Determine and find Loysburg United States rental homes and real estate rentals in Loysburg United States.
Come across, observe, and come across Fleetville United States rental houses, real estate rentals, and house rentals Fleetville.
Identify and ascertain house rentals Clarion Pennsylvania and bed and breakfast rentals.
Invent, perceive, and identify for rent by owner homes Northumberland Pennsylvania and Northumberland Pennsylvania rental home.
The Aston Pennsylvania log listings, beach classifieds, and lake listings for these county can be mapped.
Look up and dig up rental properties Clinton Pennsylvania, homes for rent, home rentals in Clinton, and Clinton Pennsylvania vacation homes.
Identify and perceive Danielsville United States apartment rentals and holiday rentals Danielsville United States.
Invent and debunk real estate rentals East Prospect and East Prospect United States short term rentals.
Recognize, ascertain, and invent condo rentals in Clymer United States, apartments for rent Clymer, and vacation rentals.
Look up, devise, and disclose Clarion Pennsylvania condo rentals and bed and breakfast rentals Clarion Pennsylvania.
Catch and recognize vacation rentals Lycoming Pennsylvania and Lycoming Pennsylvania apartments for rent.
Glimpse, hear, and uncover rental properties Delaware, rental home in Delaware, and Delaware Pennsylvania holiday rentals.
Join our lake indexes, oceanfront ads, and beach indexes mailing list for apartment rentals and Aston Pennsylvania apartment rentals.
Often, assist and open doors your pilgrims, lodgers, and hikers to a hulking, enormous, stuffed, and colossal plot.
See lake advertisements and lakeside classified advertisements that real estate agents and property agents post on this website, FRBO.com.
Determine and relocate for rent by owner homes and Mount Wolf United States homes for rent.
Contrive, dig up, and hear rental home in Mifflin Pennsylvania and Mifflin Pennsylvania vacation rental.
|
|
