|
<%@ 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
Ogdensburg New York bed and breakfast rentals and Ogdensburg New York homes for rent by owner
Rent house Colonie, Colonie New York rental houses, and bed and breakfast rentals in Colonie
North Tonawanda house rentals, apartment rentals in North Tonawanda New York, home rentals in North Tonawanda New York, and North Tonawanda New York rent houses
Home rentals Rotterdam and homes for rent by owner in Rotterdam
Southold New York bed and breakfast rentals, Southold New York holiday rentals, and short term rentals Southold New York
Condos for rent in Amsterdam, for rent by owner homes in Amsterdam New York, rental houses in Amsterdam New York, and condo rentals in Amsterdam New York
Real estate rentals and rent house Rye
Rental houses in Thompson New York, rental homes, and rent houses Thompson New York
Bed and breakfast rentals Patterson, homes for rent by owner Patterson New York, rental homes in Patterson New York, and Patterson bed and breakfast rentals
Rental houses in Lancaster New York and house rentals
Rental houses in Hyde Park New York, short term rentals in Hyde Park, and Hyde Park New York for rent by owner homes
Rental home East Hampton, bed and breakfast rentals in East Hampton New York, East Hampton New York short term rentals, and for rent by owner homes East Hampton New York
Long Beach New York holiday rentals and rental homes Long Beach New York
Ithaca New York rental apartment, apartments for rent in Ithaca New York, and vacation homes in Ithaca New York
Short term rentals in Rochester, houses for rent in Rochester New York, for rent by owner homes Rochester, and rental houses Rochester New York
Vacation homes for rent by owner and real estate rentals in Highlands
Rental homes in Union New York, apartment rentals in Union, and Union New York real estate rentals
Condo rentals Ogden New York, Ogden New York short term rentals, vacation homes for rent by owner in Ogden New York, and apartment rentals Ogden New York
Rental homes in De Witt New York and De Witt New York homes for rent by owner
Rental properties in Kingston New York, bed and breakfast rentals Kingston, and short term rentals
Wappinger vacation rentals, Wappinger vacation rentals, rent houses Wappinger New York, and rent houses Wappinger
Light upon, devise, and discover Livingston New York apartments for rent, Livingston New York house rentals, and Livingston bed and breakfast rentals.
Manlius New York neighborhood employs many real estate agents, rental owners, rental property owners, and land owners.
Recognize and hear Warren homes for rent by owner, Warren New York rent house, and vacation homes for rent by owner.
Send fine and lovely measurements regarding real estate rentals in Manlius and short term rentals Manlius found on our for rent by owner website.
Ferret out, glimpse, and uncover short term rentals in Roslyn, Roslyn United States apartment rentals, and rental properties in Roslyn.
Relocate, come across, and observe Stottville United States rent house, Stottville United States home rentals, and Stottville United States rental home.
Catch, dig up, and conceive vacation homes for rent by owner in Bovina Center United States, vacation rentals, and rental apartment in Bovina Center United States.
FRBO.Com, For Rent By Owner, can appoint, secure, interest, and volunteer studio ads, lakefront advertisements, and lake lists of marked properties beach online MLS, beach online MLS, oceanfront lists of marked properties, and beach listed properties to work for your Manlius New York run.
Identify and contrive vacation homes for rent by owner Schuyler, vacation rental in Schuyler, homes for rent in Schuyler New York, and home rentals Schuyler.
Espy, ascertain, and come across short term rentals, apartments for rent, and rental apartment in Mount Morris United States.
Our webpage does comprise another kingdom log, waterfront, and private home and houses.
Determine and locate rental home and rent house Friendship.
Come across, invent, and elicit house rentals in Jefferson New York and rent house in Jefferson.
Find out and distinguish apartments for rent Sullivan and short term rentals in Sullivan.
Invent and find out Scottsville rental apartment and Scottsville United States real estate rentals.
Detect, dig up, and espy home rentals Breezy Point, short term rentals in Breezy Point, and rent house.
Design and detect vacation rental Hauppauge and house rentals Hauppauge.
Place, mobilize, initiate, and assign tonight to begin and take up on this junket.
Join our penthouse ads, rustic classified advertisements, hidden indexes, and city indexes mailing list for Manlius New York condos for rent and vacation homes in Manlius New York.
Identify and distinguish East Norwich rent houses and homes for rent.
We coined, shaped, and imagined our online website, FRBO.com to be marvelous, nice, and angelic.
You can rake the resort online MLS, lakeside lists of marked properties, waterfront ad directories, and beachfront listings under rental houses Manlius and vacation rentals Manlius.
Determine, observe, and look up Endwell United States bed and breakfast rentals, Endwell United States rental properties, and rental properties in Endwell United States.
Dig up and discern Chautauqua United States house rentals and home rentals Chautauqua United States.
Identify and perceive Chestertown home rentals and vacation rentals in Chestertown United States.
The Manlius New York exotic directories, lakefront classifieds, and lake advertisements for these vicinity can be mapped.
Uncover and ferret out the patch and nearly Manlius kingdom.
|
|
