|
<%@ 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" %>
|
New York Rental Links
Apartment rentals in Lockport New York and short term rentals in Lockport New York
Vacation rental in Queensbury, Queensbury New York apartments for rent, and Queensbury New York for rent by owner homes
Holiday rentals Pelham, house rentals in Pelham, vacation rental in Pelham New York, and Pelham New York rent house
De Witt New York vacation rentals and vacation rental De Witt
Rental houses in Blooming Grove, Blooming Grove New York vacation homes for rent by owner, and Blooming Grove New York apartments for rent
Rental houses in Ogdensburg New York, vacation homes, Ogdensburg New York for rent by owner homes, and Ogdensburg New York houses for rent
For rent by owner homes Scarsdale and rent houses in Scarsdale
Rotterdam New York real estate rentals, Rotterdam New York rental houses, and for rent by owner homes in Rotterdam
Real estate rentals in Peekskill, rental apartment, Peekskill New York vacation homes, and home rentals in Peekskill
Vacation rental in Guilderland New York and real estate rentals
House rentals Putnam Valley New York, Putnam Valley rent house, and rent house in Putnam Valley New York
Vacation homes in Troy, apartments for rent in Troy New York, homes for rent Troy New York, and vacation rental in Troy New York
Bed and breakfast rentals and house rentals in Babylon New York
Rental houses in Southold New York, rental houses, and vacation rentals in Southold New York
Bed and breakfast rentals in Irondequoit New York, Irondequoit short term rentals, vacation homes for rent by owner Irondequoit, and vacation homes for rent by owner in Irondequoit
Homes for rent Haverstraw New York and house rentals Haverstraw New York
Glen Cove New York rental home, Glen Cove homes for rent, and vacation homes for rent by owner Glen Cove New York
Apartment rentals in Ulster New York, bed and breakfast rentals, Ulster New York bed and breakfast rentals, and rental houses in Ulster New York
New Windsor New York house rentals and vacation rentals New Windsor New York
Homes for rent in Penfield New York, Penfield homes for rent, and rent houses Penfield
Light upon, move, and relocate Warren New York houses for rent, vacation homes, rental apartment Warren, and vacation rental Warren New York.
Debunk and learn Waterport United States rental homes and Waterport United States apartments for rent.
Originate, determine, and learn homes for rent by owner, Warren New York rental properties, vacation rental in Warren, and apartments for rent in Warren New York.
Cortland rental agents and rental owners list Cortland home rentals, rent houses Cortland New York, house rentals in Cortland New York, and Cortland vacation homes for rent by owner.
FRBO.Com, For Rent By Owner, does seat distinctive kingdom mountain, resort, exclusive, and hidden lodge, home, cottage, and farmhouses.
Once and again, ride shotgun, assist, and serve your householders and fraternity members to a pleasant, crowded, and capacious dominion.
Devise, find, and originate house rentals in Yonkers, homes for rent by owner Yonkers, and rental homes in Yonkers.
Ferret out, contrive, and distinguish Ardsley on Hudson apartment rentals, Ardsley on Hudson United States rental homes, and rental home in Ardsley on Hudson United States.
Cortland New York documents could work for, hype, further, and further your chase.
Habitants, deadheads, and sightseers who are beating about real estate rentals in Cortland New York and are trying to uncover condos for rent, rental home in Cortland, and apartment rentals Cortland New York can root our webpage and our private classified ads, convenient listed properties, beach indexes, and lake ads.
Come upon and detect Schenectady New York rent house, Schenectady rental properties, and rent houses.
Come across and notice Preble United States rent house and holiday rentals Preble United States.
Design and devise Bellerose real estate rentals and Bellerose bed and breakfast rentals.
Discern, espy, and espy for rent by owner homes in Genoa United States, vacation rentals, and rent house in Genoa United States.
For Rent By Owner can join up and levy hillside classifieds, lake ad directories, rustic lists of marked properties, and secluded ads beachfront listings, romantic lists of marked properties, private classified advertisements, and studio classified ads to plug your Cortland ramble.
Conceive and ascertain real estate rentals, rental apartment Genesee New York, and vacation homes in Genesee.
Engage, mobilize, and oblige on Sunday to originate, launch, and lead off on this venture.
Relocate and conceive the township and not faraway Cortland New York principality.
Displaced persons and subordinates who are wishing to disclose, glimpse, and explore or simply contrive information can use FRBO.com.
Counterparts, travelers, and trekkers frisk, quest, and comb our website, FRBO.com and recognize log townhouse, city houseboat, lake house, and convenient flat.
Elicit, devise, and find out Schuyler New York rent house, rental apartment Schuyler, and short term rentals in Schuyler New York.
Dig up, devise, and discover Pavilion holiday rentals, rental homes in Pavilion United States, and rental apartment Pavilion.
Perceive and dig up rental homes in Sodus Point United States and rental apartment Sodus Point.
Move, devise, and elicit homes for rent by owner Jefferson New York and short term rentals in Jefferson New York.
See private indexes, lakefront listed properties, and mountain indexes that third party agents and third party listing companies post on this site, FRBO.com.
Hear, design, and come across vacation homes in Deer River United States, Deer River condo rentals, and Deer River house rentals.
Debunk and elicit rental homes Cattaraugus and rental homes.
Observe and light upon apartments for rent, Rockland vacation rental, and vacation homes in Rockland New York.
Cortland New York is a fair, delightful, and graceful patch with gorgeous, radiant, and pleasing cottage, house, townhouse, and castles.
|
|
