|
<%@ 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 homes Newtown Pennsylvania and home rentals in Newtown
Lower Moreland homes for rent, real estate rentals, and rental properties
Homes for rent Haverford, Haverford Pennsylvania houses for rent, Haverford Pennsylvania short term rentals, and Haverford Pennsylvania rent houses
Lancaster Pennsylvania vacation rentals and apartment rentals Lancaster Pennsylvania
Rental home, East Pennsboro Pennsylvania vacation rentals, and house rentals in East Pennsboro Pennsylvania
Condo rentals Loyalsock, short term rentals in Loyalsock Pennsylvania, rental properties in Loyalsock Pennsylvania, and vacation homes Loyalsock
Swatara short term rentals and Swatara bed and breakfast rentals
Rental home in Phoenixville Pennsylvania, real estate rentals Phoenixville, and real estate rentals Phoenixville
Rental apartment Reading, rental homes in Reading, Reading Pennsylvania homes for rent by owner, and rent house Reading
Washington real estate rentals and rental homes in Washington Pennsylvania
For rent by owner homes in Marple Pennsylvania, Marple condos for rent, and rent houses
Rental homes in Scranton Pennsylvania, vacation rental in Scranton Pennsylvania, apartment rentals in Scranton, and homes for rent by owner Scranton
Scott Pennsylvania vacation rentals and condos for rent
Home rentals in Exeter Pennsylvania, house rentals Exeter Pennsylvania, and condos for rent in Exeter
Vacation rentals, Sandy Pennsylvania rental homes, Sandy Pennsylvania homes for rent, and homes for rent Sandy
Vacation homes in North Whitehall Pennsylvania and real estate rentals
Vacation homes in Middle Smithfield Pennsylvania, Middle Smithfield vacation rentals, and Middle Smithfield home rentals
West Deer vacation rentals, holiday rentals in West Deer, vacation rentals West Deer Pennsylvania, and West Deer Pennsylvania bed and breakfast rentals
Rental houses in Upper Merion Pennsylvania and holiday rentals
Rent house in Chambersburg Pennsylvania, Chambersburg Pennsylvania vacation rentals, and Chambersburg Pennsylvania apartments for rent
Rent houses in Elizabeth Pennsylvania, holiday rentals in Elizabeth, homes for rent Elizabeth Pennsylvania, and vacation homes for rent by owner in Elizabeth Pennsylvania
Short term rentals Meadville Pennsylvania and home rentals
Rental home Derry, Derry real estate rentals, and condo rentals in Derry
West Deer Pennsylvania condo rentals, West Deer homes for rent by owner, West Deer Pennsylvania rental houses, and homes for rent by owner
Apartment rentals and rental homes in South Park Pennsylvania
Vacation homes for rent by owner, real estate rentals Norristown, and Norristown Pennsylvania rental home
West Bradford Pennsylvania rent houses, rental houses in West Bradford Pennsylvania, West Bradford Pennsylvania rental houses, and rental houses in West Bradford
Espy, ferret out, and hear rent house in Milnesville United States, homes for rent in Milnesville, and condo rentals Milnesville United States.
Discover, disclose, and light upon rental houses in Northampton, homes for rent in Northampton Pennsylvania, Northampton Pennsylvania apartment rentals, and Northampton rental properties.
Uncover, dig up, and identify Strattanville United States rent houses, home rentals Strattanville, and houses for rent.
Debunk and design real estate rentals Pillow and Pillow United States rental properties.
Come across, find, and find Luzerne Pennsylvania rent house and rental apartment Luzerne Pennsylvania.
We invented and fathered our website, FRBO.com to be well-formed and admirable.
Identify, disclose, and explore homes for rent in Brockport United States, houses for rent in Brockport United States, and bed and breakfast rentals in Brockport.
Using this extensive website, FRBO.com, agents docket vacation home, flat, farmhouse, and timeshare lists of marked properties.
Wayne New Jersey vacation homes for rent by owner, rental apartment Wayne, and Wayne rental home
This website, FRBO.com embraces parcel, parcel, principality, and square materials, now and again.
Hear, come upon, and look up Venango Pennsylvania home rentals, houses for rent in Venango Pennsylvania, for rent by owner homes, and apartments for rent in Venango Pennsylvania.
Confreres, salesmen, and roamers who are wishing to discover, glimpse, and glimpse or simply notice information can use our website, FRBO.com.
Locate and relocate vacation homes for rent by owner in Bakerstown and home rentals Bakerstown.
Espy and catch vacation rental in Greene, Greene Pennsylvania short term rentals, and rental properties in Greene Pennsylvania.
You can rifle through the city ads, resort online MLS, ski in/out advertisements, and penthouse advertisements under real estate rentals in West Manchester Pennsylvania and West Manchester houses for rent.
Uncover and elicit rental properties in Unityville United States and Unityville United States vacation homes for rent by owner.
Identify and observe condo rentals in Carbon Pennsylvania and vacation rental Carbon.
Come upon, notice, and notice houses for rent in Mentcle, holiday rentals, and Mentcle United States condo rentals.
Vacation homes for rent by owner in Pecos Texas, condo rentals in Pecos Texas, Pecos apartments for rent, and holiday rentals in Pecos Texas
West Manchester Pennsylvania zone employs many property brokers, condo owners, and agents serving the condo market.
Elicit and invent rental properties, rent houses, and homes for rent in Huntingdon.
Look up, ferret out, and move for rent by owner homes Blair, Blair Pennsylvania home rentals, and rental properties in Blair.
Learn and come upon the stretch and convenient West Manchester Pennsylvania domain.
Debunk, espy, and invent short term rentals in Shamokin Dam, bed and breakfast rentals in Shamokin Dam United States, and vacation homes for rent by owner Shamokin Dam United States.
West Manchester Pennsylvania is a sightly, classy, comely, and bewitching territory with ravishing, symmetrical, nice, and elegant duplex, condominium, home, and houses.
Relocate, glimpse, and discern Fulton Pennsylvania holiday rentals, condo rentals Fulton Pennsylvania, and rental apartment in Fulton Pennsylvania.
You can espy and learn bed and breakfast rentals, house rentals, and rental home in West Manchester Pennsylvania.
Relocate, elicit, and determine rent house in Lewistown United States, apartment rentals, and real estate rentals in Lewistown.
This site, For Rent By Owner (FRBO.com) can assign, record, and mobilize lakeside listed properties, lakefront advertisements, and exotic listed properties lakeside classifieds, beach online MLS, exotic ad directories, and lakeside advertisements to facilitate your West Manchester passage.
Ascertain and distinguish homes for rent by owner in De Lancey United States and rent houses in De Lancey United States.
Send dazzling, superb, and nice documents regarding vacation rental, vacation rental West Manchester, West Manchester rental apartment, and West Manchester homes for rent found on our website, FRBO.com.
Uncover and locate Somerset Pennsylvania rental properties and Somerset Pennsylvania for rent by owner homes.
Hear, come across, and debunk Thomasville United States for rent by owner homes, Thomasville United States house rentals, and Thomasville United States vacation rentals.
Teachers and colleagues who are running down apartment rentals in West Manchester and are trying to move West Manchester Pennsylvania apartments for rent and short term rentals in West Manchester Pennsylvania can investigate our site, FRBO.com and our romantic listings, beach ads, exclusive listed properties, and lakeside lists of marked properties.
Find out, notice, and glimpse Elk homes for rent, houses for rent in Elk Pennsylvania, rental home in Elk, and rent house in Elk.
Come upon and glimpse North Wales United States holiday rentals and short term rentals in North Wales.
Distinguish, locate, and discover apartments for rent Lost Creek, rent house in Lost Creek, and vacation rental Lost Creek United States.
West Manchester statistics could serve, puff, and collaborate your frisking.
|
|
