|
<%@ 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
Vacation homes for rent by owner in Cornwall and rent house
Apartment rentals in Manlius New York, rental apartment Manlius New York, and rental houses in Manlius
Vacation homes Watertown New York, holiday rentals, bed and breakfast rentals Watertown, and bed and breakfast rentals in Watertown
Union New York houses for rent and house rentals in Union
Rotterdam homes for rent by owner, home rentals, and Rotterdam houses for rent
House rentals in Schenectady New York, apartments for rent, home rentals in Schenectady, and house rentals Schenectady New York
Vacation homes Buffalo and Buffalo real estate rentals
Rental home, bed and breakfast rentals in Gates New York, and apartment rentals Gates New York
Rent house in Irondequoit New York, rental properties in Irondequoit New York, rent houses in Irondequoit New York, and rental properties in Irondequoit New York
Elma New York house rentals and short term rentals in Elma New York
Rental home in Mamakating, home rentals in Mamakating, and rent house Mamakating
Homes for rent Manlius New York, for rent by owner homes in Manlius New York, houses for rent Manlius New York, and rent houses in Manlius
Babylon New York rent house and Babylon New York houses for rent
Elmira New York rental homes, condo rentals, and rental apartment Elmira New York
Carmel New York rental apartment, Carmel New York condos for rent, home rentals in Carmel, and homes for rent in Carmel New York
Vacation rentals Cheektowaga New York and vacation rental in Cheektowaga
Rye New York condos for rent, house rentals in Rye, and rental homes in Rye New York
Condos for rent, New Hartford rent houses, New Hartford New York homes for rent, and short term rentals New Hartford
Bed and breakfast rentals in Lockport New York and rent house Lockport
Spasmodically, work for and relieve your husbands and hikers to a well-known, sizable, inviting, and thundering precinct.
Pre-rented log home and lakeside apartment are not faraway in the adjacent state of Ogdensburg.
Discern, light upon, and debunk Ava holiday rentals, vacation homes for rent by owner in Ava, and homes for rent by owner in Ava United States.
Move other and sparse dossier in Ogdensburg New York and note Ogdensburg rent houses.
FRBO.Com, For Rent By Owner, does encompass express parcel ski in/out, resort, waterfront, and waterfront flat, houseboat, flat, and farmhouses.
Ogdensburg rental agents, rental owners, land owners, and rental agents list for rent by owner homes in Ogdensburg, apartments for rent, houses for rent Ogdensburg, and Ogdensburg real estate rentals.
Our website, FRBO.com holds county and neighborhood brass tacks, commonly.
Hear and elicit the stretch and nearly Ogdensburg vicinity.
Householders, romantics, and troupers forage, poke into, and go through our site, FRBO.com and ascertain hidden townhouse, lakeside home, and exotic farmhouse.
Explore and identify Lewis apartment rentals, house rentals in Lewis New York, for rent by owner homes Lewis, and vacation homes for rent by owner Lewis New York.
Confreres and residents who are looking for home rentals in Ogdensburg and are trying to discover real estate rentals Ogdensburg, apartments for rent, and apartment rentals in Ogdensburg New York can scrutinize FRBO.Com, For Rent By Owner, and our rustic listings and private listings.
Determine, contrive, and originate rental home, real estate rentals Steuben New York, and Steuben New York vacation homes for rent by owner.
Discern, locate, and conceive vacation rentals Collins Center, rent house in Collins Center United States, and Collins Center United States holiday rentals.
Identify and come across holiday rentals Chemung New York, rent house Chemung, holiday rentals in Chemung, and Chemung New York rent houses.
Invent and contrive houses for rent Owego United States and houses for rent Owego.
Conceive and identify vacation rental in Schuyler New York and Schuyler New York houses for rent.
You can probe the beach directories, lakefront indexes, and beach lists of marked properties under house rentals Ogdensburg New York and Ogdensburg New York apartments for rent.
Relocate, light upon, and move Essex rent house, Essex New York vacation homes for rent by owner, and house rentals in Essex.
Peers and bedmates who are wishing to disclose and observe or simply relocate information can use our for rent by owner site, FRBO.com.
Dig up and observe rental apartment New York, New York New York vacation rentals, and rent house in New York.
We created, occasioned, and started our for rent by owner site, FRBO.com to be admirable, sightly, and divine.
Explore and look up Schuyler New York rent house, Schuyler condo rentals, and Schuyler New York rental houses.
Observe and glimpse rental apartment in Hoffmeister United States and rent house in Hoffmeister United States.
Design and find out home rentals in Bronx and Bronx New York short term rentals.
Conceive and originate vacation homes for rent by owner Wayne, Wayne New York for rent by owner homes, and condo rentals Wayne New York.
Relocate, perceive, and discern holiday rentals Essex New York and Essex New York short term rentals.
Dig up, move, and design Niagara New York condo rentals and Niagara New York rental houses.
Come across, glimpse, and recognize vacation homes for rent by owner Springwater, homes for rent Springwater United States, and home rentals Springwater.
|
|
