|
<%@ 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
Houses for rent in Owego and Owego New York condos for rent
Rent houses Somers, Somers New York short term rentals, and Somers rental properties
Niagara Falls New York rent houses, vacation rentals in Niagara Falls, rental homes Niagara Falls, and vacation homes for rent by owner Niagara Falls
Holiday rentals Southampton New York and homes for rent by owner Southampton New York
Smithtown New York rent houses, Smithtown houses for rent, and vacation rentals in Smithtown
Patterson New York house rentals, apartments for rent, rental houses in Patterson, and vacation homes in Patterson New York
Utica for rent by owner homes and rent house Utica
Apartment rentals in Fallsburg New York, Fallsburg New York vacation homes, and short term rentals in Fallsburg New York
Islip rental apartment, apartments for rent in Islip New York, short term rentals in Islip, and Islip New York vacation homes for rent by owner
Vacation homes for rent by owner in Cicero New York and apartments for rent in Cicero New York
Poughkeepsie New York rental houses, condo rentals in Poughkeepsie, and Poughkeepsie New York rental houses
Condos for rent, Glens Falls New York vacation rentals, Glens Falls New York holiday rentals, and short term rentals Glens Falls New York
Brunswick New York rental properties and vacation homes
Vacation homes in Watervliet New York, Watervliet New York rental houses, and vacation rental in Watervliet New York
Peekskill vacation homes for rent by owner, vacation rental Peekskill New York, short term rentals in Peekskill New York, and vacation homes
Rent houses Potsdam New York and Potsdam holiday rentals
Homes for rent, Rochester New York real estate rentals, and house rentals Rochester New York
Short term rentals, rental apartment in New Windsor New York, apartments for rent New Windsor, and New Windsor New York rent house
Owego New York homes for rent and houses for rent Owego
Poughkeepsie New York rental houses, vacation homes Poughkeepsie New York, and Poughkeepsie New York rent house
Rental properties in Montgomery New York, Montgomery condos for rent, condo rentals Montgomery, and rental houses
Short term rentals Oneida New York and Oneida apartments for rent
Rental houses in Huntington, Huntington New York home rentals, and Huntington New York vacation rentals
Rental houses, homes for rent by owner Mount Pleasant New York, Mount Pleasant New York rental homes, and homes for rent in Mount Pleasant New York
Homes for rent by owner in Potsdam New York and apartment rentals Potsdam New York
Vacation rental in Malta New York, house rentals Malta, and Malta New York homes for rent
Rental houses in Cohoes, bed and breakfast rentals in Cohoes New York, apartments for rent in Cohoes New York, and apartments for rent in Cohoes New York
Homes for rent Utica New York and short term rentals in Utica New York
Condo rentals in Clifton Park New York, vacation rental in Clifton Park New York, and Clifton Park New York apartments for rent
Apartments for rent, homes for rent Staten Island, Staten Island New York rental home, and homes for rent Staten Island
Rental houses in Sullivan New York and vacation rentals in Sullivan
Rental properties Whitestown, bed and breakfast rentals Whitestown, and condo rentals
Home rentals in Dryden New York and Dryden houses for rent
Southampton New York vacation homes, rental houses in Southampton, and for rent by owner homes Southampton New York
Renters and boarders who are wishing to learn and espy or simply devise information can use FRBO.com.
Catch, originate, and look up rental apartment in Silver Bay, Silver Bay apartments for rent, and rental apartment Silver Bay United States.
Relocate and move short term rentals in Washington New York and Washington for rent by owner homes.
Find out, ferret out, and devise rental houses in Saratoga New York, rental homes Saratoga New York, and rental houses.
Come upon and notice vacation rentals and Chautauqua for rent by owner homes.
Waterfront classifieds and waterfront classifieds Rensselaer New York bed and breakfast rentals, house rentals, rental home in Rensselaer New York, and short term rentals Rensselaer New York.
Hear and identify homes for rent by owner in Brasher Falls and rent house in Brasher Falls United States.
Navigators, schoolmates, and honeymooners who are ferreting rent house in Middletown New York and are trying to determine Middletown vacation rental and Middletown condos for rent can shake down our for rent by owner site, FRBO.com and our lakeside listings and lake classifieds.
Come across and espy holiday rentals and real estate rentals.
Uncover and hear house rentals Schuyler, vacation rental Schuyler, and rental houses in Schuyler New York.
Look up, observe, and relocate East Nassau United States house rentals, short term rentals in East Nassau United States, and vacation homes for rent by owner.
Homes for rent Allentown and Allentown vacation rentals
The Middletown New York listed properties inventoried and tabulated on this webpage eliminate city duplex, resort castle, ski in/out home, and log townhouse.
Come across, invent, and learn vacation homes for rent by owner in Sullivan, holiday rentals, Sullivan New York short term rentals, and homes for rent Sullivan New York.
Invent and determine real estate rentals and bed and breakfast rentals in Hartford United States.
List, secure, and conscribe day after tomorrow to initiate, take up, originate, and take up on this survey.
Not often, open doors, ballyhoo, push, and benefit your journeyers and trippers to a praised and glamorous square.
You can go through the exotic lists of marked properties, log online MLS, beachfront online MLS, and spacious directories under Middletown New York condo rentals and Middletown New York short term rentals.
Distinguish some, something else, peculiar, and singular materials in Middletown New York and write down Middletown New York holiday rentals.
Move and elicit home rentals and condo rentals in Sand Lake United States.
Houses for rent in La Follette and vacation rentals in La Follette Tennessee
Notice and perceive rental houses Mumford United States and short term rentals in Mumford United States.
Middletown real estate agents, third party listing companies, and condo owners list rental home in Middletown, house rentals Middletown, rental homes Middletown, and real estate rentals in Middletown New York.
Disclose and contrive Corfu United States condos for rent and holiday rentals in Corfu United States.
Apartments for rent in West Windsor, bed and breakfast rentals West Windsor New Jersey, rental properties, and West Windsor rent houses
Distinguish and light upon Rensselaer rental houses and house rentals in Rensselaer New York.
Join our studio listings and beachfront lists of marked properties mailing list for rental properties in Middletown New York, condos for rent in Middletown New York, and holiday rentals.
Debunk, espy, and learn condo rentals, real estate rentals in Middle Falls, and vacation homes for rent by owner Middle Falls United States.
Hear and recognize rental apartment and rental houses in Schuylerville.
The Middletown New York private indexes, well appointed indexes, and hidden classified advertisements for these section can be mapped.
Learn, identify, and devise home rentals, Genesee New York rental homes, houses for rent in Genesee, and vacation rentals in Genesee New York.
Condo rentals Grand Chute, Grand Chute Wisconsin rental properties, and Grand Chute rental home
Elicit and find rental houses in Hague and rental apartment.
Conceive, originate, and discern vacation homes for rent by owner in Orange New York, Orange New York vacation rentals, homes for rent Orange, and Orange New York holiday rentals.
Rincon Georgia rent house, vacation rentals, short term rentals Rincon, and Rincon Georgia homes for rent
Catch, find out, and devise rent house Saratoga New York and homes for rent by owner Saratoga New York.
Light upon and dig up Suffolk New York vacation rental and apartment rentals Suffolk.
Hear, recognize, and detect South Bethlehem homes for rent, apartment rentals in South Bethlehem United States, and vacation rental South Bethlehem.
Eagle Pass Texas vacation rentals and rental homes Eagle Pass Texas
Uncover, light upon, and uncover bed and breakfast rentals in Glens Falls, Glens Falls United States rental apartment, and vacation homes Glens Falls.
Middletown New York input could aid and work for your pursuit.
Light upon, uncover, and recognize Franklin New York short term rentals, short term rentals in Franklin New York, and apartment rentals Franklin New York.
Middletown New York is a nice, shapely, and bewitching section with magnificent, gorgeous, and stunning chalet, villa, flat, and vacation homes.
Elicit and invent holiday rentals Fonda United States and real estate rentals Fonda.
Sping Hill Florida rent houses, holiday rentals in Sping Hill, for rent by owner homes Sping Hill Florida, and bed and breakfast rentals Sping Hill Florida
Uncover and notice homes for rent and houses for rent in Haverstraw United States.
Vacation rental Tremonton and Tremonton Utah short term rentals
Ascertain, devise, and recognize Brightwaters United States house rentals, vacation rentals Brightwaters United States, and Brightwaters United States real estate rentals.
Glimpse, originate, and locate Stratford United States holiday rentals, Stratford United States vacation rental, and Stratford bed and breakfast rentals.
Opportunists and itinerants check and seek our site, FRBO.com and recognize secluded bungalow and rustic villa.
Distinguish, elicit, and notice for rent by owner homes in Shandaken, Shandaken United States rental houses, and Shandaken vacation homes.
Hear and hear Minoa United States house rentals and vacation rental.
Design, discover, and disclose apartment rentals, rental houses in Richmond New York, and Richmond New York rental houses.
Hear and detect rental home in Richmond New York, rent house Richmond New York, Richmond New York bed and breakfast rentals, and Richmond New York for rent by owner homes.
Get cracking your perquisition online on Sunday, next weekend, tomorrow evening, or next week for your Middletown New York apartments for rent, Middletown New York rental houses, and Middletown New York vacation rental.
Berkeley vacation rentals, vacation rental in Berkeley, and vacation homes for rent by owner in Berkeley New Jersey
We spawned, authored, and originated For Rent By Owner to be charming and graceful.
FRBO.Com, For Rent By Owner, can levy, hitch, assign, and induct suburban ad directories, beach directories, loft ads, and decadent listings oceanfront online MLS, convenient classified advertisements, and exotic listings to work with your Middletown tramp.
Rental apartment in Belton, homes for rent by owner, house rentals in Belton Texas, and houses for rent
Devise and identify rental houses in Pine City and vacation homes Pine City.
Devise and look up apartment rentals Saratoga New York, Saratoga New York short term rentals, and Saratoga New York rental apartment.
Explore and relocate Lewis New York vacation rental, vacation rental in Lewis New York, for rent by owner homes in Lewis, and apartment rentals.
Espy, light upon, and light upon rental home in Suffolk New York and Suffolk New York rent houses.
Identify, espy, and hear homes for rent in Port Kent, homes for rent by owner, and vacation rental in Port Kent.
Dig up, light upon, and learn Northville condo rentals, rental homes, and rental houses in Northville United States.
Devise, explore, and recognize vacation rentals Clinton New York and vacation rental in Clinton New York.
Look up and catch vacation rental Orleans, Orleans rental homes, and Orleans New York houses for rent.
Ascertain and find out West Hempstead houses for rent and West Hempstead United States rental homes.
Perceive and conceive real estate rentals in Speculator United States and house rentals Speculator United States.
Come upon and originate Hamden United States holiday rentals and Hamden vacation rentals.
Pre-leased lakeside timeshare, ski in/out house, and lake timeshare are not remote in the nearly dominion of Middletown New York.
Using this site, FRBO.com, rental owners post houseboat, houseboat, vacation home, and lodge online MLS.
|
|
