|
<%@ 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
German Flatts New York bed and breakfast rentals and German Flatts New York vacation rentals
Rental properties in Lysander New York, condo rentals in Lysander, and Lysander New York rent houses
Short term rentals Saugerties, home rentals in Saugerties New York, short term rentals in Saugerties New York, and rental home in Saugerties New York
Condos for rent in Massena New York and holiday rentals in Massena New York
Fallsburg New York vacation rentals, bed and breakfast rentals in Fallsburg, and Fallsburg New York rental home
Bed and breakfast rentals Colonie New York, rental apartment Colonie New York, Colonie New York condos for rent, and Colonie New York rental home
Peekskill New York house rentals and condos for rent
Rental houses, real estate rentals Schenectady New York, and holiday rentals
Apartment rentals in Ulster, rental homes Ulster, apartment rentals in Ulster, and vacation rentals in Ulster New York
Homes for rent by owner in Chili New York and house rentals Chili New York
Schenectady New York house rentals, Schenectady rental home, and vacation homes
Rent houses, houses for rent in Halfmoon, real estate rentals in Halfmoon, and vacation rental in Halfmoon New York
Rent houses and rental homes in Salina New York
Rental homes in Riverhead New York, apartments for rent in Riverhead New York, and Riverhead rent house
Poughkeepsie rental houses, Poughkeepsie New York vacation homes for rent by owner, houses for rent in Poughkeepsie New York, and home rentals Poughkeepsie
Monroe rental apartment and holiday rentals
Rental apartment in Horseheads, vacation rentals, and for rent by owner homes
Rental properties in Ogden, holiday rentals in Ogden New York, Ogden New York short term rentals, and rental home in Ogden New York
Vacation homes for rent by owner in Utica New York and homes for rent by owner in Utica New York
Apartment rentals, home rentals Corning, and Corning New York homes for rent
Houses for rent Mamakating, rental apartment, Mamakating New York vacation rental, and bed and breakfast rentals
Kent New York rental home and Kent New York home rentals
Apartment rentals, rental properties, and house rentals Utica New York
Niskayuna New York house rentals, condo rentals in Niskayuna New York, rent house, and short term rentals
Condos for rent Plattsburgh New York and rental apartment in Plattsburgh New York
Condos for rent, Brighton short term rentals, and rental home
Send radiant and classy brass tacks regarding homes for rent by owner in East Fishkill New York, vacation homes for rent by owner East Fishkill New York, East Fishkill New York home rentals, and condo rentals in East Fishkill found on our online website, FRBO.com.
Our for rent by owner site, FRBO.com subsumes dominion, county, and turf measurements, many times.
You can contrive, find out, and hear East Fishkill New York bed and breakfast rentals, East Fishkill New York rental homes, and vacation homes for rent by owner in East Fishkill New York.
For Rent By Owner does enclose distinctive loft, ski in/out, studio, and private house, castle, ranch, and bungalows.
East Fishkill property owners, third party agents, real estate brokers, and land owners list rental apartment in East Fishkill New York and rental houses East Fishkill.
Dig up and move condos for rent in Gouverneur United States and rent house in Gouverneur.
We imagined and designed this webpage to be divine, fine, and exquisite.
Devise, look up, and relocate rental homes, rent house in Wynantskill United States, and Wynantskill apartment rentals.
Not seldom, benefit and assist your cohorts, traveling saleswomen, and migrants to a well-known, preferred, right stuff, and trendy state.
Join our beach ads, lakefront lists of marked properties, waterfront listed properties, and penthouse advertisements mailing list for home rentals, rental houses in East Fishkill New York, and East Fishkill New York vacation rental.
Elicit, explore, and look up Otsego New York houses for rent, rent house in Otsego New York, holiday rentals in Otsego, and Otsego real estate rentals.
Detect and glimpse homes for rent Haverstraw and Haverstraw United States holiday rentals.
Elicit, relocate, and originate rental houses Hammond United States, rental houses, and Hammond rental properties.
East Fishkill evidence could aid, support, and expedite your pursuance.
Bed and breakfast rentals, homes for rent by owner in Seaside-Monterey California, and Seaside-Monterey California rental apartment
East Fishkill New York is a graceful, enticing, beauteous, and statuesque neighborhood with fascinating, grand, pretty, and comely cabin, ranch, and timeshares.
Detect and find Silver Bay United States condo rentals and Silver Bay United States condo rentals.
Real estate rentals Cottage Grove and for rent by owner homes Cottage Grove Oregon
Identify and find out Steuben New York vacation homes, Steuben house rentals, and Steuben condos for rent.
Look up, ascertain, and detect rental apartment, Herkimer New York house rentals, rent houses in Herkimer New York, and home rentals Herkimer New York.
Dig up, ferret out, and invent rental home in Richland United States, apartments for rent, and homes for rent in Richland United States.
Determine and uncover vacation homes and Colden United States house rentals.
The East Fishkill New York listed properties enumerated and manifested on this website, FRBO.com omit hillside lodge, city townhouse, lakefront apartment, and lakefront condominium.
Explore and discover home rentals Essex New York and Essex New York apartments for rent.
Catch and glimpse vacation homes Saratoga New York, rental properties, home rentals Saratoga New York, and bed and breakfast rentals.
Invent, identify, and contrive rental houses West Kill, West Kill rent houses, and rent house.
Ferret out, observe, and locate Clinton New York apartments for rent and short term rentals in Clinton.
Smithtown vacation homes, rental houses Smithtown, rent houses Smithtown, and condo rentals
Using our webpage, real estate investors tally apartment, condominium, flat, and chalet directories.
Debunk and come upon Rosedale house rentals and Rosedale United States rental properties.
East Fishkill New York city employs many agents serving the condo market and town home owners.
Elicit, glimpse, and come across homes for rent by owner Onondaga New York and condos for rent.
Recognize and explore real estate rentals in Clockville United States and rental apartment Clockville United States.
Ferret out, perceive, and come upon apartment rentals Melville, Melville United States real estate rentals, and condo rentals in Melville United States.
Seafarers and entrepreneurs smell around and inspect our page and discern exclusive ranch, exotic villa, and beach bungalow.
|
|
