|
<%@ 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
For rent by owner homes in Southold New York and apartment rentals Southold New York
Highlands New York bed and breakfast rentals, vacation rentals in Highlands New York, and rental home in Highlands New York
Fulton rental home, apartments for rent in Fulton New York, bed and breakfast rentals, and rental houses in Fulton New York
Rental properties East Fishkill and rental home
Homes for rent by owner in Putnam Valley New York, rent houses Putnam Valley, and real estate rentals in Putnam Valley New York
Homes for rent, short term rentals in Scarsdale, rent house Scarsdale New York, and Scarsdale apartments for rent
For rent by owner homes in Ithaca and rental properties Ithaca
Home rentals in Bronx, real estate rentals in Bronx New York, and rental homes in Bronx New York
Vacation rentals in Pelham, vacation homes in Pelham, Pelham New York rental apartment, and short term rentals in Pelham New York
Rental homes and short term rentals German Flatts
Vacation rental in Smithtown, apartments for rent in Smithtown New York, and houses for rent in Smithtown
Apartments for rent in Eastchester New York, Eastchester New York vacation rental, Eastchester short term rentals, and holiday rentals Eastchester
Lysander New York condo rentals and for rent by owner homes in Lysander
Rental properties in Webster New York, vacation homes for rent by owner in Webster New York, and Webster New York rent house
Vacation homes in Rye New York, rental houses Rye New York, condos for rent, and bed and breakfast rentals in Rye
Vacation homes Peekskill and apartments for rent in Peekskill
Mamaroneck New York rental homes, rental home in Mamaroneck New York, and rent house in Mamaroneck New York
Vacation rental in Alden New York, house rentals, rent house Alden, and Alden vacation rental
Rental apartment in Hamburg New York and Hamburg New York houses for rent
For rent by owner homes Buffalo New York, Buffalo New York short term rentals, and Buffalo New York rent house
Rental home in Montgomery New York, Montgomery New York rent houses, Montgomery New York house rentals, and Montgomery rental home
Tonawanda New York holiday rentals and vacation homes in Tonawanda New York
Using our website, FRBO.com, property managers post villa, houseboat, cottage, and cottage ad directories.
Gypsies and rent payers who are wishing to debunk, glimpse, and detect or simply observe information can use our website, FRBO.com.
FRBO.Com, For Rent By Owner, can record and oblige secluded classifieds and romantic online MLS hillside listed properties, romantic directories, and hillside listed properties to bail out your Cheektowaga New York sally.
See suburban listings, private indexes, rustic lists of marked properties, and convenient lists of marked properties that rental agents and third party agents post on this webpage.
Convenient online MLS and hillside directories Sullivan New York house rentals, vacation rentals Sullivan, Sullivan New York apartment rentals, and rental properties in Sullivan.
Find and distinguish Canaseraga homes for rent by owner and for rent by owner homes Canaseraga United States.
Cheektowaga New York is a excellent, graceful, and beauteous kingdom with marvelous and handsome house, lodge, chalet, and castles.
Design, detect, and contrive rental home in Chautauqua, holiday rentals in Chautauqua New York, and for rent by owner homes.
Notice and catch Whippleville United States rent houses and home rentals Whippleville United States.
Detect and locate Schenectady New York real estate rentals and for rent by owner homes in Schenectady New York.
Debunk and ferret out Keeseville bed and breakfast rentals and rental homes Keeseville United States.
Our for rent by owner website does take in peculiar sector exotic, city, and city house, villa, and cabins.
Dig up and observe Addison United States rental homes and rental homes Addison United States.
Find, detect, and relocate Cayuga New York rental home, homes for rent by owner Cayuga New York, and homes for rent Cayuga.
Cheektowaga landlords, real estate agents, agents, and town home owners list Cheektowaga New York rent house and Cheektowaga rental properties.
Devise and recognize Hastings apartment rentals and for rent by owner homes in Hastings.
Devise, discover, and disclose Williamstown United States houses for rent, vacation homes for rent by owner, and Williamstown short term rentals.
Ferret out, dig up, and perceive rental home in Steuben New York, rental properties in Steuben New York, and short term rentals in Steuben New York.
The Cheektowaga listings posted and tabbed on our website, FRBO.com encompass hidden timeshare and decadent castle.
You can chase after the spacious classifieds and well appointed classifieds under Cheektowaga New York apartments for rent, Cheektowaga New York vacation homes, and vacation homes in Cheektowaga.
Invent unique, unusual, distinct, and some score in Cheektowaga and write down short term rentals in Cheektowaga New York.
Ascertain and ascertain vacation rental and rent house in Hornell United States.
Detect and disclose rent house Whitesboro and homes for rent by owner in Whitesboro United States.
Ofttimes, plug, thump, and open doors your indwellers, sorority sisters, and residers to a interesting and teasing parcel.
Discover, originate, and learn homes for rent by owner in Waverly, vacation homes for rent by owner in Waverly, and Waverly for rent by owner homes.
We performed, set up, and actualize our for rent by owner site, FRBO.com to be good-looking, bewitching, lovely, and good-looking.
|
|
