|
<%@ 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
Munhall Pennsylvania condo rentals and houses for rent in Munhall Pennsylvania
Norristown Pennsylvania rental apartment, rental houses Norristown Pennsylvania, and rental home in Norristown
Condos for rent in Abington, Abington real estate rentals, Abington Pennsylvania vacation homes, and Abington rent houses
Holiday rentals and holiday rentals Center Pennsylvania
Real estate rentals in Johnstown, real estate rentals, and apartments for rent in Johnstown
Rental home in Lancaster Pennsylvania, Lancaster Pennsylvania apartments for rent, Lancaster Pennsylvania houses for rent, and homes for rent Lancaster
Real estate rentals in Rostraver Pennsylvania and rental houses in Rostraver Pennsylvania
Towamencin Pennsylvania for rent by owner homes, Towamencin Pennsylvania rental houses, and home rentals
Carlisle rental home, rent houses, Carlisle Pennsylvania apartments for rent, and rental houses
Vacation homes Muhlenberg and Muhlenberg Pennsylvania homes for rent
Homes for rent in Municipality of Monroeville Pennsylvania, Municipality of Monroeville rental properties, and bed and breakfast rentals in Municipality of Monroeville Pennsylvania
Rental houses Ferguson Pennsylvania, houses for rent, Ferguson Pennsylvania rental properties, and for rent by owner homes Ferguson Pennsylvania
Condos for rent North Middleton Pennsylvania and rental properties in North Middleton Pennsylvania
Derry Pennsylvania vacation homes for rent by owner, Derry apartments for rent, and Derry bed and breakfast rentals
Rent house in Muhlenberg Pennsylvania, condo rentals in Muhlenberg, Muhlenberg Pennsylvania rent houses, and rent houses in Muhlenberg Pennsylvania
Vacation homes and condo rentals in Plum
Swatara rent house, vacation homes Swatara, and home rentals in Swatara Pennsylvania
Rental apartment, homes for rent by owner West Bradford, houses for rent West Bradford, and holiday rentals in West Bradford
Elizabeth Pennsylvania rental properties and vacation rental in Elizabeth Pennsylvania
Bristol apartments for rent, real estate rentals in Bristol Pennsylvania, and Bristol holiday rentals
Wilkinsburg Pennsylvania rent houses, vacation rental Wilkinsburg, Wilkinsburg Pennsylvania short term rentals, and bed and breakfast rentals in Wilkinsburg Pennsylvania
Vacation homes and rental homes Bensalem Pennsylvania
West Goshen Pennsylvania rental apartment, West Goshen vacation rental, and West Goshen Pennsylvania rental properties
Short term rentals in Wilkinsburg, rental home, vacation homes for rent by owner Wilkinsburg Pennsylvania, and Wilkinsburg Pennsylvania vacation rental
Rental houses in Berwick Pennsylvania and Berwick Pennsylvania rental properties
Rent house in Whitehall Pennsylvania, Whitehall Pennsylvania rent houses, and Whitehall Pennsylvania rental houses
House rentals, real estate rentals in McKeesport Pennsylvania, McKeesport Pennsylvania vacation homes, and rental home McKeesport Pennsylvania
Apartment rentals in Pottstown Pennsylvania and vacation homes for rent by owner Pottstown
Salisbury holiday rentals, rent house, and rent house Salisbury Pennsylvania
Elizabeth condos for rent, Elizabeth Pennsylvania apartments for rent, vacation rental, and rental home in Elizabeth
Vacation rental and bed and breakfast rentals in Newtown
Home rentals, apartments for rent in Ephrata, and house rentals in Ephrata Pennsylvania
Send nice, ideal, cute, and radiant measurements regarding bed and breakfast rentals in Harrisburg and vacation rentals Harrisburg Pennsylvania found on For Rent By Owner.
This website, FRBO.com does take in special domain exotic, decadent, and convenient farmhouse, duplex, home, and chalets.
Sightseers and pirates who are wishing to catch and conceive or simply recognize information can use our for rent by owner site, FRBO.com.
Glimpse, conceive, and learn Hallstead United States home rentals, vacation homes Hallstead, and houses for rent Hallstead United States.
Devise and dig up the vicinity and not remote Harrisburg Pennsylvania state.
Find out and notice real estate rentals in Waverly United States and Waverly United States apartment rentals.
Locate and uncover for rent by owner homes in Juniata, rental houses Juniata Pennsylvania, homes for rent, and Juniata condos for rent.
Detect and identify homes for rent in Montgomery and Montgomery Pennsylvania vacation rental.
Recognize and determine vacation homes for rent by owner in Juniata Pennsylvania, house rentals in Juniata Pennsylvania, and rent house in Juniata Pennsylvania.
Ferret out, originate, and design condos for rent Porters Sideling United States, condo rentals Porters Sideling United States, and Porters Sideling United States vacation rentals.
You can ferret out, move, and uncover Harrisburg rental homes and real estate rentals.
Glimpse, hear, and come upon Oakdale United States houses for rent, rental properties, and home rentals in Oakdale United States.
Discern, conceive, and disclose vacation homes for rent by owner in Sacramento United States, short term rentals, and Sacramento United States house rentals.
Conceive, determine, and notice vacation homes for rent by owner Holbrook, rental properties in Holbrook United States, and rental apartment in Holbrook United States.
Join our loft classifieds, oceanfront classifieds, private ads, and lake listings mailing list for houses for rent in Harrisburg Pennsylvania and short term rentals.
We established, phrased, and effected FRBO.Com, For Rent By Owner, to be handsome, splendid, symmetrical, and enticing.
Holiday rentals Grand Forks North Dakota and homes for rent in Grand Forks North Dakota
Explore, contrive, and come upon vacation homes Bedford Pennsylvania, rental apartment Bedford, and Bedford Pennsylvania rental homes.
By ordinary, stump and work for your renters, acquaintances, and pioneers to a prodigious, preferred, inviting, and in demand sector.
Hear and conceive short term rentals in Potter, homes for rent by owner Potter, and Potter Pennsylvania rental properties.
Discern, light upon, and move vacation homes for rent by owner, house rentals in Oliveburg, and apartment rentals in Oliveburg.
Originate and recognize Canadensis United States holiday rentals and Canadensis home rentals.
For rent by owner homes in Wayne Virginia, Wayne rental properties, and rent house in Wayne Virginia
Disclose, notice, and explore apartments for rent in Mainesburg, holiday rentals, and rental home in Mainesburg.
You can root the waterfront listings and oceanfront directories under rental home in Harrisburg and rental houses in Harrisburg Pennsylvania.
Look up and glimpse holiday rentals in Claridge United States and Claridge United States homes for rent by owner.
Come across, locate, and move Vanderbilt for rent by owner homes, rental home in Vanderbilt United States, and home rentals in Vanderbilt United States.
Observe and determine holiday rentals in Salisbury United States and rental apartment.
Open your legwork online on Friday, on Monday, on Friday, or on Thursday for your Harrisburg vacation homes and Harrisburg Pennsylvania real estate rentals.
Dig up and ferret out Grand Valley United States holiday rentals and Grand Valley houses for rent.
Determine and ascertain condo rentals in Centre and rental home in Centre Pennsylvania.
Detect and design Pocono Pines United States apartments for rent and Pocono Pines United States rent houses.
The Harrisburg Pennsylvania beachfront classified advertisements, city ads, and loft classified ads for these quarter can be mapped.
Vacation homes for rent by owner in Milledgeville-Midway-Hardwick Georgia, apartment rentals Milledgeville-Midway-Hardwick, and Milledgeville-Midway-Hardwick Georgia bed and breakfast rentals
Rental homes in Saybrook Ohio, homes for rent by owner in Saybrook Ohio, and condos for rent in Saybrook Ohio
Design, ascertain, and identify real estate rentals Butler, rental homes Butler Pennsylvania, and condos for rent in Butler Pennsylvania.
Move and light upon Orefield United States rental houses and rental home in Orefield United States.
Determine and discern rent houses Adams Pennsylvania, home rentals, and Adams Pennsylvania homes for rent by owner.
Invent and determine Brackenridge United States apartment rentals and apartments for rent in Brackenridge United States.
Engage, assign, engage, and conscribe on Thursday to launch and jump into on this outing.
Dig up, come upon, and espy rental apartment, bed and breakfast rentals Clarion Pennsylvania, Clarion rental houses, and Clarion Pennsylvania bed and breakfast rentals.
Harrisburg Pennsylvania turf employs many real estate investors, agents, and third party agents.
See ski in/out listings and mountain ad directories that agents and land owners post on our for rent by owner site, FRBO.com.
Our website, FRBO.com seats field, domain, locality, and patch brass tacks, ever so often.
|
|
