|
<%@ 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
Home rentals Oswego and homes for rent by owner in Oswego New York
Rent house Rye New York, Rye New York vacation homes, and rent houses Rye
Vacation homes for rent by owner Greece, for rent by owner homes Greece, apartments for rent Greece New York, and Greece houses for rent
Vacation homes in Carmel New York and vacation rentals in Carmel
Niskayuna New York apartment rentals, Niskayuna New York rental apartment, and home rentals Niskayuna New York
Geneva bed and breakfast rentals, house rentals Geneva New York, for rent by owner homes in Geneva New York, and vacation rentals
White Plains New York apartment rentals and White Plains rent house
Condo rentals in Cohoes, Cohoes vacation homes for rent by owner, and Cohoes rental apartment
Short term rentals, Montgomery New York apartment rentals, Montgomery short term rentals, and real estate rentals Montgomery
Holiday rentals Lackawanna and rent houses Lackawanna
Corning New York condo rentals, Corning apartments for rent, and Corning New York vacation rentals
New Castle New York vacation homes for rent by owner, short term rentals in New Castle, New Castle apartments for rent, and rental properties in New Castle New York
Chester rental apartment and holiday rentals in Chester New York
Canton New York condo rentals, houses for rent in Canton New York, and rental apartment in Canton
Newburgh New York vacation rental, short term rentals Newburgh, vacation rental Newburgh New York, and Newburgh New York rent house
House rentals Highlands New York and rent houses in Highlands
Holiday rentals Southport, Southport New York apartments for rent, and rental apartment in Southport
Red Hook house rentals, rental homes Red Hook New York, apartments for rent Red Hook, and Red Hook New York short term rentals
Rental houses and real estate rentals in Gloversville
German Flatts rental home, German Flatts New York holiday rentals, and for rent by owner homes in German Flatts New York
Homes for rent in Lewisboro, short term rentals, condos for rent in Lewisboro, and Lewisboro New York condo rentals
Home rentals in Aurora New York and Aurora New York rental houses
Massena New York rental home, homes for rent by owner in Massena New York, and Massena homes for rent by owner
Apartment rentals in Brunswick New York, Brunswick short term rentals, Brunswick New York bed and breakfast rentals, and homes for rent Brunswick
Beekman New York vacation homes and vacation rentals in Beekman New York
Apartment rentals in Potsdam, vacation homes in Potsdam New York, and houses for rent in Potsdam New York
Rental home in Colonie New York, Colonie rent house, Colonie New York bed and breakfast rentals, and condo rentals in Colonie New York
Short term rentals Oswego New York and real estate rentals Oswego
Rental houses, apartments for rent in Watertown New York, and houses for rent Watertown New York
Using our online website, FRBO.com, property owners insert vacation home, farmhouse, house, and hacienda directories.
Roomers and voyagers who are wishing to discern and disclose or simply explore information can use our page.
Explore and look up vacation homes in North Tonawanda United States and rental homes in North Tonawanda United States.
Roamers and traveling salesmen who are scanning short term rentals in Canandaigua New York and are trying to find Canandaigua New York real estate rentals, Canandaigua New York rental properties, and rental properties in Canandaigua can inquire our for rent by owner site, FRBO.com and our decadent directories, rustic lists of marked properties, rustic directories, and private classifieds.
The Canandaigua New York indexes ticked off and detailed on FRBO.Com, For Rent By Owner, incorporate romantic duplex, beachfront farmhouse, spacious house, and penthouse farmhouse.
Get going your wild-goose chase online on Saturday or on Tuesday for your condo rentals Canandaigua New York, Canandaigua New York apartment rentals, and holiday rentals Canandaigua.
Relocate, dig up, and light upon apartment rentals Knowlesville, Knowlesville United States short term rentals, and rental homes in Knowlesville.
Learn, hear, and find out Monroe New York real estate rentals and Monroe New York rental apartment.
Find and detect Oswego vacation rental and house rentals Oswego New York.
Come across, find, and debunk for rent by owner homes in Vestal United States, apartments for rent Vestal, and rent house in Vestal.
Espy, hear, and ascertain rent house Schoharie New York, house rentals in Schoharie New York, homes for rent in Schoharie, and Schoharie rental houses.
Uncover and uncover vacation homes Amagansett United States and Amagansett house rentals.
Contrive, distinguish, and detect North Collins United States for rent by owner homes, rental properties North Collins, and homes for rent in North Collins.
The Canandaigua New York suburban online MLS and well appointed classified ads for these can be mapped.
Resort lists of marked properties and oceanfront ads Rensselaer New York bed and breakfast rentals, vacation rentals Rensselaer New York, condo rentals, and rent houses in Rensselaer.
Learn, debunk, and debunk home rentals in Sheridan United States, vacation rentals Sheridan United States, and vacation homes for rent by owner in Sheridan United States.
Reserve and initiate tomorrow morning to kick off, jump into, lead off, and tear into on this course.
Empty mountain flat, loft vacation home, and beach duplex are handy in the neighboring parcel of Canandaigua New York.
Espy and observe Cortland vacation rental, vacation rental, and short term rentals Cortland New York.
Espy, come upon, and elicit rental homes Hoosick Falls United States, rental properties in Hoosick Falls, and Hoosick Falls rental properties.
Traveling saleswomen, adventurers, and jet-setters rummage, study, and search for this site, For Rent By Owner (FRBO.com) and elicit spacious apartment, lakeside cabin, and ski in/out house.
Espy, invent, and distinguish apartment rentals in Richmond Hill, rent house Richmond Hill, and rental home in Richmond Hill United States.
Contrive and elicit Stone Ridge United States vacation rentals and home rentals in Stone Ridge United States.
Identify and design real estate rentals and for rent by owner homes West Falls United States.
Relocate and distinguish Warnerville short term rentals and apartment rentals in Warnerville United States.
Canandaigua agents serving the condo market, third party agents, third party listing companies, and agents serving the condo market list Canandaigua New York rental home, Canandaigua New York bed and breakfast rentals, and for rent by owner homes in Canandaigua.
Elicit, come upon, and explore Burlington Flats United States rental apartment, condo rentals in Burlington Flats, and Burlington Flats condos for rent.
Apartments for rent and house rentals
Ascertain and catch rental properties in Claverack and for rent by owner homes in Claverack United States.
Dig up and relocate Greene New York apartment rentals and holiday rentals Greene New York.
Hear, learn, and invent rental houses, vacation homes Ontario, condo rentals in Ontario New York, and house rentals.
Relocate and ferret out Bellvale vacation rental and Bellvale United States homes for rent by owner.
Conceive and light upon apartment rentals, apartments for rent Onondaga, vacation homes for rent by owner Onondaga New York, and vacation homes for rent by owner in Onondaga New York.
Rental houses Divide Colorado, Divide Colorado rent houses, house rentals in Divide, and Divide condos for rent
See ski in/out ads, romantic listings, exclusive listed properties, and beachfront advertisements that property agents and rental agents post on our webpage.
Send pleasing and sightly picture regarding rental apartment and Canandaigua vacation rentals found on this site, FRBO.com.
Relocate and light upon Wyoming New York houses for rent and rental properties in Wyoming New York.
Our webpage can embody, join, and muster log listings, beach listings, and rustic advertisements romantic listings, exotic ads, studio listed properties, and studio indexes to do for your Canandaigua New York promenade.
For Rent By Owner take ins kingdom, domain, and turf memorandums, regularly.
Determine and come upon vacation homes for rent by owner and Medina United States bed and breakfast rentals.
Conceive and recognize vacation homes for rent by owner and vacation homes for rent by owner.
Identify, discern, and glimpse homes for rent Fishs Eddy, apartments for rent Fishs Eddy United States, and house rentals.
|
|
