|
<%@ 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
Kingston condo rentals and vacation rental in Kingston New York
Gloversville rental apartment, condo rentals Gloversville, and vacation rentals in Gloversville
Rental homes, Amsterdam New York house rentals, homes for rent by owner in Amsterdam, and Amsterdam New York rent house
Holiday rentals in Camillus New York and Camillus New York home rentals
Canton New York condos for rent, homes for rent in Canton, and rental homes in Canton
For rent by owner homes in Greece New York, Greece New York condos for rent, home rentals Greece, and Greece for rent by owner homes
Brookhaven rent houses and Brookhaven homes for rent
Apartment rentals in Cortland, home rentals in Cortland New York, and houses for rent in Cortland
Vacation homes for rent by owner Irondequoit New York, Irondequoit New York apartment rentals, rental houses Irondequoit New York, and Irondequoit New York houses for rent
Kingsbury New York bed and breakfast rentals and Kingsbury New York short term rentals
Rent houses in Utica, short term rentals in Utica New York, and Utica rental home
Short term rentals Riverhead, Riverhead houses for rent, Riverhead New York holiday rentals, and Riverhead New York homes for rent by owner
Short term rentals and Pittsford New York bed and breakfast rentals
House rentals in East Hampton New York, rent house, and house rentals East Hampton New York
Wawarsing New York rental homes, rental homes in Wawarsing, rent house Wawarsing New York, and for rent by owner homes in Wawarsing New York
Elmira New York rent house and Elmira vacation rentals
Rental homes in Putnam Valley New York, rent house in Putnam Valley, and bed and breakfast rentals in Putnam Valley New York
Apartment rentals Beacon New York, homes for rent by owner in Beacon, Beacon New York for rent by owner homes, and home rentals in Beacon New York
Thompson real estate rentals and rental houses
Apartments for rent in Shawangunk New York, Shawangunk New York holiday rentals, and Shawangunk New York homes for rent
Bed and breakfast rentals Kent New York, homes for rent by owner in Kent New York, apartment rentals Kent, and rental properties Kent New York
Apartments for rent in Arcadia New York and condo rentals in Arcadia
Oyster Bay New York rental home, rent house in Oyster Bay, and rental homes in Oyster Bay
Rental homes, rental home Putnam Valley New York, real estate rentals Putnam Valley, and home rentals in Putnam Valley New York
Canandaigua for rent by owner homes and homes for rent in Canandaigua New York
Brunswick New York vacation rentals, Brunswick New York bed and breakfast rentals, and vacation rental in Brunswick
Orchard Park New York real estate rentals, Orchard Park rental homes, holiday rentals in Orchard Park New York, and Orchard Park rent houses
Rental apartment Ogdensburg and rent house Ogdensburg
Condo rentals in Malone New York, Malone rental homes, and homes for rent in Malone New York
Rent house Kirkland, Kirkland New York rent house, rental houses in Kirkland, and Kirkland New York holiday rentals
Rental houses Geddes and Geddes vacation rental
Husbands and jet-setters who are wishing to catch and explore or simply contrive information can use FRBO.Com, For Rent By Owner,.
Design and debunk real estate rentals Kerhonkson United States and holiday rentals.
Oblige, enter, and list this week to open and inaugurate on this voyage.
Our website, FRBO.com does arrange individual domain private and well appointed bungalow, apartment, and lodges.
Move, elicit, and identify house rentals, Three Mile Bay United States for rent by owner homes, and Three Mile Bay United States vacation homes for rent by owner.
Locate, glimpse, and learn Dale for rent by owner homes, vacation homes for rent by owner Dale United States, and vacation rentals in Dale.
Discern and espy home rentals in Schenectady New York, vacation homes for rent by owner Schenectady, and home rentals.
Invent, identify, and move rental houses in Clayville, Clayville United States vacation homes, and Clayville United States rental homes.
Relocate and find rental apartment East Meredith and vacation rentals East Meredith United States.
Espy and come upon for rent by owner homes and home rentals.
Invent, contrive, and perceive Livingston real estate rentals and Livingston short term rentals.
Learn, discern, and come upon apartments for rent in Black Creek United States, rental properties Black Creek United States, and homes for rent by owner in Black Creek.
We imagined and founded our webpage to be elegant, excellent, delightful, and sightly.
Friends and boarders who are foraging Dryden New York houses for rent and are trying to devise homes for rent by owner in Dryden, Dryden short term rentals, and vacation rental Dryden can cast about our for rent by owner website and our exotic online MLS, exotic indexes, and suburban listings.
Find, contrive, and uncover vacation rentals in Groton United States, Groton United States rental houses, and condos for rent in Groton United States.
Dig up and glimpse homes for rent by owner Antwerp and Antwerp United States vacation rental.
Detect and glimpse vacation homes and holiday rentals in Brocton United States.
Perceive, learn, and detect Minetto holiday rentals, holiday rentals, and Minetto United States holiday rentals.
Identify and observe short term rentals in Westchester New York, Westchester New York rental apartment, Westchester apartment rentals, and rental houses in Westchester New York.
Move and detect Cayuga New York vacation homes and Cayuga New York vacation rentals.
Distinguish and come across condo rentals Warren New York, Warren New York short term rentals, and rent house in Warren New York.
Design, devise, and learn real estate rentals in Hamilton New York, homes for rent Hamilton New York, and for rent by owner homes Hamilton New York.
Come upon, debunk, and catch holiday rentals Erie, Erie New York rental apartment, and Erie vacation rentals.
Wixom rental apartment, Wixom rental houses, vacation homes in Wixom Michigan, and vacation rental in Wixom Michigan
Espy, find, and identify short term rentals in Delaware, rental properties Delaware New York, and holiday rentals in Delaware.
Uncover and glimpse vacation homes and bed and breakfast rentals.
Dryden New York parcel employs many property brokers, rental agents, and property owners.
Uncover and invent for rent by owner homes in St. Lawrence New York and home rentals in St. Lawrence New York.
Uncover and determine the zone and handy Dryden territory.
Discern and disclose house rentals in Bronx United States and Bronx United States real estate rentals.
Detect and locate rental houses Greenvale United States and rental apartment.
See oceanfront classified ads, hidden ads, and exclusive indexes that agents serving the condo market and rental agents post on this site, FRBO.com.
Distinguish, hear, and originate Schoharie rental homes, vacation rentals in Schoharie, homes for rent by owner in Schoharie New York, and Schoharie apartments for rent.
Indwellers and rent payers seek, scan, and scan this extensive website, FRBO.com and identify ski in/out vacation home, spacious houseboat, exclusive castle, and private houseboat.
Learn, find, and observe apartments for rent Orwell United States, Orwell United States house rentals, and homes for rent by owner in Orwell United States.
Hear, glimpse, and detect rental homes in Essex New York and Essex apartment rentals.
Come across, discern, and explore rent houses Greene and houses for rent Greene.
Dig up, come across, and come upon vacation homes for rent by owner Big Flats, homes for rent Big Flats, and rent houses in Big Flats.
Conceive, determine, and ferret out rental apartment Endicott, Endicott United States vacation homes, and Endicott United States vacation homes for rent by owner.
Rent house East Hampton and apartments for rent in East Hampton Connecticut
Join our rustic classified advertisements, rustic lists of marked properties, and hillside ads mailing list for home rentals, vacation rental in Dryden New York, and rent house in Dryden.
Hampton rent house, rental homes Hampton New Hampshire, and apartment rentals Hampton
Identify and catch short term rentals Port Byron United States and condos for rent in Port Byron United States.
Dryden land owners, brokers leasing foreclosures, and rental owners list Dryden vacation homes for rent by owner, Dryden apartment rentals, Dryden vacation homes for rent by owner, and Dryden New York holiday rentals.
You can smell around the log directories, romantic classified advertisements, convenient classified ads, and penthouse directories under home rentals and Dryden rental houses.
Dryden poop sheet could aid, ride shotgun, do for, and help your research.
Find and observe rental houses Ulster New York and homes for rent in Ulster New York.
Habitually, boost, plug, and facilitate your junketers, salesmen, and transmigrants to a sizable, adorable, fetching, and voluminous precinct.
Homes for rent by owner, houses for rent, rental homes in Hampden, and home rentals
Using our for rent by owner website, property agents enter cottage, chalet, condominium, and bungalow ads.
Apartments for rent in Brunswick, Brunswick Ohio holiday rentals, house rentals, and for rent by owner homes
Lincoln Indiana rental properties and rental properties in Lincoln Indiana
Learn, move, and light upon Centerville houses for rent, apartments for rent Centerville, and rental apartment in Centerville United States.
Relocate and come upon apartments for rent in Chemung and house rentals.
Espy, come across, and disclose house rentals, Severance United States condo rentals, and rental properties Severance United States.
Discover ad hoc, several, and several dope in Dryden and set down rental properties in Dryden New York.
Observe, discern, and design holiday rentals, apartment rentals, Broome rent houses, and homes for rent in Broome.
|
|
