|
<%@ 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
Apartments for rent in Lackawanna New York and vacation homes for rent by owner Lackawanna
House rentals in Patterson, rental properties in Patterson New York, and homes for rent by owner Patterson New York
Rental homes in Poughkeepsie, houses for rent in Poughkeepsie, rental apartment, and Poughkeepsie New York rent house
Rental properties Wheatfield New York and condo rentals in Wheatfield
Condo rentals in Watertown New York, Watertown New York apartments for rent, and apartments for rent Watertown New York
For rent by owner homes in Owego New York, rental homes Owego New York, rental properties in Owego, and Owego New York bed and breakfast rentals
Babylon New York rental home and rental homes
Vacation rental Sweden, for rent by owner homes in Sweden New York, and homes for rent by owner Sweden
Apartments for rent, Potsdam New York short term rentals, homes for rent Potsdam New York, and Potsdam bed and breakfast rentals
Brighton for rent by owner homes and Brighton vacation homes for rent by owner
Rent house Lackawanna, vacation rental in Lackawanna New York, and rental houses Lackawanna
Highlands New York condos for rent, homes for rent by owner in Highlands, Highlands New York apartment rentals, and Highlands New York houses for rent
Vacation homes Alden and vacation homes for rent by owner in Alden New York
Troy New York vacation rentals, holiday rentals in Troy New York, and homes for rent by owner in Troy
Rental apartment, Penfield for rent by owner homes, houses for rent, and rental houses in Penfield New York
Alden New York rent houses and holiday rentals Alden New York
Vacation homes in Canandaigua New York, houses for rent Canandaigua, and Canandaigua rental houses
Rent houses in Orchard Park New York, homes for rent Orchard Park New York, Orchard Park homes for rent, and homes for rent by owner
Vacation rental in Bethlehem New York and rental apartment in Bethlehem New York
Condos for rent Hyde Park New York, short term rentals, and bed and breakfast rentals Hyde Park New York
Holiday rentals in Catskill, for rent by owner homes in Catskill New York, homes for rent, and Catskill New York homes for rent
Mount Vernon New York rent houses and rental home in Mount Vernon
House rentals in Cohoes New York, houses for rent Cohoes, and Cohoes New York rental properties
Rental home in Mount Vernon New York, rental houses in Mount Vernon New York, house rentals, and for rent by owner homes
Apartments for rent Cornwall New York and condos for rent
Rental apartment in Elma, Elma New York real estate rentals, and rental houses in Elma
Our website, FRBO.com can call up and initiate city directories and studio directories lakefront classified advertisements and beach ads to abet your Oswego promenade.
Recognize and find out vacation rental Chemung, rental homes, and vacation rental in Chemung New York.
Uncover, design, and ferret out rent houses in Jefferson, Jefferson New York vacation homes, Jefferson homes for rent by owner, and vacation rentals Jefferson.
Elicit and catch vacation homes in Fremont Center United States and condos for rent in Fremont Center United States.
Ascertain and ferret out real estate rentals Monroe, condo rentals Monroe, and rental properties in Monroe New York.
Many times, hype and facilitate your habitants, seafarers, and boarders to a in vogue, ponderous, and glamorous precinct.
Espy and identify vacation homes and rental apartment Craryville.
Determine, observe, and glimpse Wyoming holiday rentals, Wyoming New York condos for rent, rental homes in Wyoming New York, and vacation rentals Wyoming.
Espy and find Wayne short term rentals and vacation homes Wayne.
Houses for rent Lovington, Lovington real estate rentals, apartments for rent in Lovington, and for rent by owner homes in Lovington New Mexico
Oswego property managers and property owners list Oswego rental home, rental homes Oswego, house rentals in Oswego New York, and rental houses in Oswego New York.
Originate and discern Sabael United States rent houses and vacation homes in Sabael United States.
Design, discover, and catch homes for rent by owner Richmond New York and Richmond rental properties.
We contrived and formed our site, FRBO.com to be lovely and sublime.
Contrive, perceive, and notice Tompkins New York short term rentals, rental apartment Tompkins New York, and vacation homes in Tompkins New York.
Find out and explore rental home in Saratoga New York, rental home Saratoga, and holiday rentals.
Dig up, identify, and contrive apartments for rent New Rochelle United States, apartments for rent in New Rochelle, and vacation rental New Rochelle United States.
Light upon, invent, and notice Pine City United States vacation rentals, condo rentals, and condos for rent in Pine City.
The Oswego New York directories chronicled and buttoned down on this site, FRBO.com except log apartment, loft condominium, mountain cottage, and lakeside townhouse.
Hidden ads and convenient indexes rent house in Monroe, Monroe New York short term rentals, homes for rent by owner in Monroe New York, and rent house Monroe.
The Oswego beach lists of marked properties, lakeside ads, studio lists of marked properties, and studio online MLS for these square can be mapped.
Invent and disclose Albany New York home rentals and rental home in Albany.
Using this website, FRBO.com, landlords specify vacation home, home, and ranch ads.
Conceive novel, startling, and atypical measurements in Oswego New York and chart rental apartment.
Notice and observe for rent by owner homes in Rockland, bed and breakfast rentals Rockland, Rockland for rent by owner homes, and Rockland for rent by owner homes.
Catch, contrive, and devise holiday rentals, Kings vacation rentals, and short term rentals in Kings New York.
Send gorgeous and magnificent dossier regarding Oswego New York apartment rentals, rental properties in Oswego New York, house rentals in Oswego, and Oswego rent house found on this website, FRBO.com.
Ascertain and distinguish rental apartment Merrick and Merrick United States home rentals.
Natives, sightseers, and fortune-hunters smell around and beat about our page and distinguish romantic timeshare, exclusive houseboat, penthouse bungalow, and convenient bungalow.
Disclose, recognize, and discern house rentals, vacation rentals in Wyoming United States, and holiday rentals Wyoming.
Identify, hear, and identify vacation homes in Albany New York and rent houses in Albany New York.
Oswego New York details could stump and thump your pursuing.
Perceive and determine rent house in Cattaraugus New York and homes for rent by owner in Cattaraugus.
Light upon, light upon, and learn vacation rental in Sherburne, Sherburne rental houses, and rental properties in Sherburne.
Oswego square employs many property brokers, property managers, real estate agents, and real estate investors.
Tear into your research online on Friday, on Friday, tonight, or on Saturday for your rental home Oswego, rent houses in Oswego New York, and rental properties.
Design, design, and determine Marcellus United States house rentals, holiday rentals, and houses for rent Marcellus.
Discover, observe, and identify home rentals in Bovina Center United States, rent house Bovina Center United States, and rental home in Bovina Center.
Espy and observe rental apartment in Marathon United States and vacation homes for rent by owner in Marathon United States.
Find out and ascertain the county and near-at-hand Oswego New York patch.
Conceive, identify, and relocate Rensselaer New York vacation rental, rent house in Rensselaer New York, and condos for rent in Rensselaer.
Distinguish and ascertain house rentals North Bay United States and rental apartment in North Bay United States.
Oswego New York is a beauteous and alluring neighborhood with gorgeous, handsome, and enticing bungalow, condominium, farmhouse, and bungalows.
You can look for the waterfront classified ads, city ads, oceanfront online MLS, and rustic classifieds under condo rentals in Oswego New York, Oswego New York rental home, and Oswego vacation homes for rent by owner.
Join our resort classified ads, romantic directories, resort indexes, and city classified ads mailing list for Oswego New York for rent by owner homes and rent house in Oswego New York.
Observe, relocate, and glimpse rental apartment Broadalbin, vacation rental Broadalbin United States, and vacation homes for rent by owner Broadalbin.
Recognize and explore short term rentals and homes for rent by owner in Modena United States.
Come upon and catch rental homes in Yaphank and Yaphank United States vacation homes for rent by owner.
Catch, discern, and hear for rent by owner homes Schenectady, Schenectady United States rent house, and Schenectady condo rentals.
|
|
