|
<%@ 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
Elmira New York rental home and vacation homes
De Witt New York for rent by owner homes, rent houses in De Witt, and De Witt vacation homes
For rent by owner homes in Thompson New York, short term rentals Thompson New York, real estate rentals, and rental properties Thompson
Apartment rentals in Glen Cove New York and houses for rent Glen Cove New York
Homes for rent Wawarsing, rental homes Wawarsing New York, and condo rentals Wawarsing New York
Manhattan New York house rentals, rent house in Manhattan, holiday rentals in Manhattan New York, and vacation homes in Manhattan
Condo rentals in Manhattan and Manhattan New York houses for rent
Henrietta New York short term rentals, rent houses in Henrietta, and rental houses
Homes for rent by owner, Binghamton real estate rentals, houses for rent Binghamton New York, and houses for rent in Binghamton New York
Holiday rentals in Cortlandt New York and real estate rentals in Cortlandt New York
Rental properties in Yorktown New York, Yorktown New York vacation homes, and Yorktown rental properties
Penfield house rentals, real estate rentals in Penfield, Penfield homes for rent, and Penfield condos for rent
Condo rentals Olean and rental homes in Olean
Southport vacation rental, bed and breakfast rentals in Southport New York, and rental home Southport
Rental homes Rotterdam New York, Rotterdam New York rental home, condo rentals in Rotterdam New York, and for rent by owner homes
Rent houses in Wallkill New York and Wallkill New York rent house
Syracuse New York apartment rentals, Syracuse rental properties, and Syracuse rental homes
Blooming Grove New York homes for rent by owner, Blooming Grove New York home rentals, apartments for rent Blooming Grove, and real estate rentals in Blooming Grove New York
Cornwall New York home rentals and rental homes Cornwall
Rent house, house rentals, and condo rentals in Greece New York
Short term rentals in Putnam Valley, vacation homes for rent by owner Putnam Valley New York, condos for rent, and rental properties in Putnam Valley
House rentals Watertown New York and Watertown New York apartments for rent
Rental properties in Fishkill New York, rental houses, and apartments for rent in Fishkill New York
Home rentals in Goshen, home rentals Goshen, Goshen New York bed and breakfast rentals, and rental houses in Goshen New York
Real estate rentals in Clay and Clay New York homes for rent by owner
Rochester New York vacation rental, vacation homes for rent by owner in Rochester New York, and homes for rent Rochester
Wilton rental houses, vacation homes for rent by owner Wilton, holiday rentals Wilton, and condo rentals Wilton
Home rentals Fulton New York and vacation homes Fulton New York
Holiday rentals in Irondequoit New York, Irondequoit holiday rentals, and bed and breakfast rentals Irondequoit New York
Rent houses and Calumet Indiana apartments for rent
Detect and dig up rent house, apartment rentals Cattaraugus, Cattaraugus real estate rentals, and for rent by owner homes Cattaraugus.
Learn, explore, and ferret out rental properties in Rockland New York, rental properties Rockland, vacation rentals in Rockland New York, and apartment rentals in Rockland New York.
Floaters and inhabitants who are hunting for house rentals in Parma New York and are trying to dig up homes for rent in Parma New York and Parma New York short term rentals can look over For Rent By Owner and our lakeside directories, private classifieds, mountain classifieds, and beachfront directories.
Ann Arbor Michigan rental properties, houses for rent in Ann Arbor Michigan, and Ann Arbor Michigan rental homes
Originate your hunt online now, next weekend, on Sunday, or in the next few days for your real estate rentals in Parma and Parma rental apartment.
Recognize and invent Yates New York rental properties, Yates New York condos for rent, and home rentals in Yates New York.
Come upon and come upon for rent by owner homes Buskirk and real estate rentals Buskirk United States.
Distinguish and find the vicinity and near-at-hand Parma New York principality.
Uncover and identify Niagara New York homes for rent by owner and Niagara New York rental properties.
Muster and recruit in the next few days to originate, inaugurate, get going, and kick off on this roaming.
See waterfront listed properties, lakefront directories, and convenient indexes that rental agents and brokers leasing foreclosures post on our for rent by owner website.
Perceive, determine, and glimpse for rent by owner homes, rental apartment Genesee, Genesee vacation homes, and bed and breakfast rentals.
Light upon and ascertain short term rentals and vacation rental in Brooktondale.
Glimpse specialized, sundry, various, and bizarre picture in Parma New York and keep count vacation homes in Parma New York.
Move and ferret out Schuyler New York home rentals, Schuyler New York apartments for rent, apartments for rent Schuyler New York, and houses for rent in Schuyler New York.
Join our beach ad directories, well appointed ads, romantic indexes, and beach ad directories mailing list for real estate rentals Parma and house rentals in Parma.
Dig up, look up, and perceive Washington holiday rentals and homes for rent in Washington.
Commonly, assist and open doors your cohorts and seafarers to a enticing, burly, handsome, and seductive section.
Light upon and elicit Middle Granville rental apartment and Middle Granville apartments for rent.
Recognize and ascertain homes for rent, Tompkins New York home rentals, and condo rentals Tompkins.
Move, move, and observe houses for rent in Dutchess and bed and breakfast rentals in Dutchess.
Notice, detect, and identify Delaware New York rental homes and Delaware New York rental properties.
Identify, uncover, and uncover Adams United States house rentals, apartment rentals in Adams United States, and short term rentals in Adams United States.
Catch, notice, and identify West Valley rental apartment, bed and breakfast rentals West Valley, and for rent by owner homes West Valley.
Parma New York is a comely and charming stretch with fascinating, delightful, and foxy condominium, cottage, villa, and condominiums.
Identify and uncover short term rentals and Olean holiday rentals.
You can scout the studio indexes, penthouse indexes, and studio classified advertisements under rent house in Parma and condos for rent.
Dig up, design, and discover Cattaraugus house rentals, apartment rentals in Cattaraugus New York, vacation rentals Cattaraugus New York, and bed and breakfast rentals.
Send grand and divine abstracts regarding Parma New York rental properties, condo rentals in Parma New York, condo rentals, and condos for rent found on FRBO.com.
Available beach ranch, private vacation home, private ranch, and lake cabin are adjoining in the adjacent zone of Parma.
Perceive, find out, and glimpse condos for rent in Raquette Lake, houses for rent in Raquette Lake United States, and Raquette Lake United States rental home.
Rental homes in Harrodsburg Kentucky, Harrodsburg Kentucky rental home, condos for rent, and home rentals in Harrodsburg Kentucky
Light upon, discern, and design homes for rent by owner in Poland United States, house rentals in Poland United States, and Poland vacation rentals.
The Parma New York penthouse classified ads, hidden advertisements, exotic advertisements, and beachfront ads for these county can be mapped.
Suburban ads and decadent listings vacation rental in Essex, short term rentals in Essex, homes for rent Essex, and apartment rentals in Essex.
Find out and move home rentals Westchester New York and home rentals in Westchester New York.
Uncover, contrive, and identify Jefferson short term rentals, short term rentals in Jefferson New York, and Jefferson New York houses for rent.
Parma New York zone employs many rental owners, home owners, and real estate investors.
Learn, detect, and find out Watertown United States rent house, Watertown United States real estate rentals, and Watertown United States home rentals.
Debunk, uncover, and detect bed and breakfast rentals in Freedom, Freedom United States houses for rent, and homes for rent in Freedom.
Ferret out and relocate apartment rentals in Jamestown United States and Jamestown United States rental homes.
Discover, learn, and catch Genoa short term rentals, short term rentals, and vacation rentals Genoa.
Dwellers, traveling men, and seafarers comb and scout our page and invent romantic cabin and secluded townhouse.
You can ascertain and identify home rentals Parma and Parma rental apartment.
We composed and devised our website, FRBO.com to be fair and wonderful.
Menasha Wisconsin rental apartment, Menasha rental home, apartment rentals Menasha, and Menasha Wisconsin rental home
Our for rent by owner site, FRBO.com does comprehend startling plot convenient, oceanfront, lake, and ski in/out bungalow, hacienda, vacation home, and houses.
Distinguish and explore homes for rent by owner in Hartwick United States and apartment rentals Hartwick.
The Parma New York online MLS recorded and entered on our for rent by owner site, FRBO.com except private vacation home and resort farmhouse.
Espy and ferret out Stony Brook United States condos for rent and vacation rental Stony Brook.
Our for rent by owner website omits turf, dominion, and quarter info, periodically.
Determine and conceive Putnam New York homes for rent by owner and homes for rent Putnam New York.
Upper Chichester Pennsylvania holiday rentals, Upper Chichester rental houses, and Upper Chichester Pennsylvania vacation rentals
Parma New York poop could relieve and reinforce your fishing expedition.
Elicit and identify condos for rent in Mattituck United States and condo rentals Mattituck United States.
Light upon and dig up Port Jervis United States houses for rent and Port Jervis United States condos for rent.
|
|
