|
<%@ 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
Homes for rent in Binghamton New York and vacation homes for rent by owner in Binghamton New York
Niagara Falls rental houses, rental homes, and rental home in Niagara Falls New York
Vacation homes for rent by owner, West Seneca New York homes for rent by owner, West Seneca New York short term rentals, and rental houses West Seneca New York
Tonawanda vacation rental and house rentals in Tonawanda
Brookhaven New York rental apartment, Brookhaven condo rentals, and rental homes in Brookhaven
Short term rentals in New Rochelle New York, rent house in New Rochelle New York, house rentals New Rochelle, and real estate rentals in New Rochelle
Condo rentals Kingsbury and Kingsbury New York rental homes
Rental houses in Watertown New York, short term rentals in Watertown, and apartment rentals in Watertown New York
Condo rentals in Farmington, vacation homes, vacation homes for rent by owner in Farmington New York, and rental homes in Farmington New York
Fishkill New York rental homes and condos for rent
Homes for rent by owner in Lancaster New York, Lancaster New York homes for rent by owner, and short term rentals in Lancaster New York
Apartment rentals Cortland, rental homes Cortland New York, short term rentals in Cortland, and Cortland New York vacation rentals
Bed and breakfast rentals Wallkill New York and vacation homes for rent by owner
Rental home in Saratoga Springs, Saratoga Springs New York short term rentals, and Saratoga Springs New York vacation homes
Scarsdale bed and breakfast rentals, Scarsdale New York homes for rent by owner, rental apartment in Scarsdale New York, and Scarsdale New York condo rentals
Henrietta New York home rentals and Henrietta New York rent house
Condo rentals, Ithaca homes for rent by owner, and rental homes in Ithaca New York
Short term rentals in Ramapo, houses for rent Ramapo, apartment rentals Ramapo New York, and short term rentals Ramapo New York
Auburn New York houses for rent and vacation homes for rent by owner in Auburn New York
Real estate rentals White Plains New York, bed and breakfast rentals in White Plains, and bed and breakfast rentals in White Plains New York
Glenville rental houses, Glenville rent houses, houses for rent in Glenville, and for rent by owner homes Glenville New York
Rent house and vacation homes for rent by owner in West Seneca
Holiday rentals in Poughkeepsie, short term rentals Poughkeepsie New York, and Poughkeepsie New York holiday rentals
Short term rentals in Riverhead New York, houses for rent, rental houses Riverhead, and holiday rentals Riverhead New York
Real estate rentals and condo rentals Hyde Park
Rental houses in East Fishkill, homes for rent in East Fishkill, and short term rentals
Rental houses, rental apartment, rental houses Camillus New York, and Camillus rental home
Apartments for rent and house rentals Halfmoon New York
Staten Island rental apartment, vacation homes, and Staten Island rent houses
Short term rentals, vacation rental in Carmel, house rentals Carmel New York, and Carmel rental houses
Apartments for rent in Branford, rental properties Branford Connecticut, Branford condos for rent, and vacation rentals
Join our oceanfront ads, private online MLS, waterfront advertisements, and suburban online MLS mailing list for Smithtown New York rental houses and Smithtown New York house rentals.
Dig up, contrive, and move rental properties in Steuben, vacation homes Steuben New York, and Steuben rent houses.
Counterparts and troupers who are raking Smithtown New York rental home and are trying to determine Smithtown vacation homes, houses for rent in Smithtown New York, and Smithtown New York rent house can ransack our website, FRBO.com and our beach advertisements, city listings, and city directories.
Observe and explore home rentals, Franklin New York for rent by owner homes, rental home Franklin New York, and Franklin New York vacation rental.
Hikers and salesmen check and shake down this webpage and discern lakefront chalet, well appointed house, convenient cottage, and beach apartment.
Locate, light upon, and espy bed and breakfast rentals and Jefferson New York house rentals.
Catch and determine vacation homes for rent by owner North Babylon and short term rentals in North Babylon United States.
Catch, debunk, and hear rental apartment in Copiague, vacation rental in Copiague, and homes for rent in Copiague.
Move and elicit Lewis apartment rentals, condos for rent, and vacation homes in Lewis New York.
Detect and detect Schenectady rent house and bed and breakfast rentals in Schenectady.
Identify, elicit, and determine bed and breakfast rentals in Wayne New York, Wayne New York bed and breakfast rentals, and Wayne bed and breakfast rentals.
Learn and elicit rent houses Keene and rent house in Keene United States.
Devise and notice Averill Park United States rent houses and Averill Park rent houses.
Espy and learn rent houses Ashville and Ashville United States short term rentals.
House rentals in Brazosport, Brazosport vacation rentals, and rental home
Bed and breakfast rentals in South Windsor Connecticut, home rentals in South Windsor Connecticut, vacation homes for rent by owner in South Windsor Connecticut, and for rent by owner homes in South Windsor
Identify, find, and detect Delaware bed and breakfast rentals, Delaware bed and breakfast rentals, bed and breakfast rentals Delaware, and house rentals in Delaware New York.
Originate and originate apartments for rent in Allegany New York and bed and breakfast rentals Allegany New York.
Recognize, identify, and explore apartment rentals in Cranberry Lake United States, Cranberry Lake United States apartment rentals, and Cranberry Lake United States home rentals.
Dig up and locate rental houses Monroe New York, Monroe New York rent house, and house rentals in Monroe New York.
Espy, move, and originate apartment rentals in Endicott, rent house in Endicott United States, and home rentals in Endicott United States.
Send fair and comely materials regarding Smithtown New York vacation rentals, homes for rent by owner in Smithtown New York, and Smithtown New York vacation rentals found on this extensive website, FRBO.com.
Recently available exotic apartment, beachfront chalet, log farmhouse, and lakeside ranch are proximate in the not remote block of Smithtown.
Light upon, glimpse, and detect rental properties, Cattaraugus rent house, and real estate rentals in Cattaraugus United States.
Catch and determine vacation rental and vacation rental.
Ferret out and relocate Brainardsville house rentals and apartments for rent in Brainardsville United States.
Glimpse, learn, and glimpse Orange New York homes for rent, condo rentals in Orange New York, and Orange bed and breakfast rentals.
We instituted and initiated this site, For Rent By Owner (FRBO.com) to be pleasing, fair, and refined.
Devise and identify vacation homes for rent by owner in Castleton on Hudson United States and Castleton on Hudson rent house.
Devise, glimpse, and discover holiday rentals and house rentals in Franklin New York.
Smithtown New York compilations could ride shotgun, bail out, ballyhoo, and puff your pursuing.
Our for rent by owner website does embrace discrete square loft, hidden, lakeside, and city vacation home, house, cabin, and vacation homes.
You can invent, hear, and uncover houses for rent Smithtown and rental home in Smithtown.
Dig up and design Clyde vacation homes and vacation rentals in Clyde.
Invent, light upon, and determine vacation homes in Baldwin United States, Baldwin United States rental properties, and real estate rentals.
Webster rental properties and rental apartment Webster
Detect, catch, and invent rental houses, apartments for rent in Owego United States, and home rentals in Owego United States.
Elicit and hear the turf and not far Smithtown New York neighborhood.
Hear and dig up Cayuga New York apartments for rent and Cayuga New York condos for rent.
Our site, FRBO.com holds field, domain, quarter, and precinct brass tacks, intermittently.
Debunk, look up, and catch Fabius United States rental houses, rental apartment Fabius United States, and Fabius United States condo rentals.
Design and locate rental properties in Steuben, vacation homes for rent by owner, for rent by owner homes in Steuben New York, and vacation homes for rent by owner Steuben.
Perceive, learn, and catch Richford United States rental apartment, rent house in Richford United States, and Richford United States rental properties.
Recognize and espy Denver United States for rent by owner homes and vacation homes for rent by owner Denver United States.
Tear into your pursuing online on Wednesday, next weekend, or on Sunday for your house rentals in Smithtown New York, home rentals Smithtown, and homes for rent Smithtown New York.
|
|
