|
<%@ 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
Rent houses and rent houses
Condo rentals in Lockport New York, Lockport New York homes for rent, and homes for rent Lockport
Fishkill home rentals, house rentals in Fishkill New York, Fishkill New York house rentals, and rental homes Fishkill
New Hartford New York vacation rentals and bed and breakfast rentals in New Hartford New York
Vacation rentals Evans New York, rental houses Evans, and Evans homes for rent by owner
Vacation rentals in Riverhead New York, condos for rent in Riverhead New York, Riverhead rental houses, and house rentals Riverhead New York
Condo rentals Peekskill New York and rent houses in Peekskill
Plattsburgh New York condo rentals, Plattsburgh homes for rent, and homes for rent Plattsburgh
Vacation rental Lysander, for rent by owner homes in Lysander, Lysander New York homes for rent, and houses for rent in Lysander
West Seneca New York apartment rentals and West Seneca New York apartments for rent
Apartments for rent in Ogdensburg, Ogdensburg New York holiday rentals, and homes for rent by owner
Bed and breakfast rentals in Kingston, rental home Kingston New York, Kingston New York for rent by owner homes, and short term rentals Kingston
Determine specific, ad hoc, and several poop sheet in Bronx New York and insert Bronx New York short term rentals.
Using our for rent by owner site, FRBO.com, agents serving the condo market run down houseboat, farmhouse, cabin, and ranch ads.
Move, espy, and recognize homes for rent by owner in Schoharie New York, Schoharie condo rentals, and Schoharie New York holiday rentals.
See spacious listings, decadent classifieds, secluded ad directories, and exclusive online MLS that landlords and rental agents post on FRBO.com.
Bronx New York vicinity employs many agents and third party agents.
Come across, notice, and identify St. Lawrence New York apartment rentals, rent house in St. Lawrence New York, and bed and breakfast rentals.
Bronx New York is a alluring, admirable, fascinating, and resplendent area with shapely, splendid, enticing, and enticing flat and farmhouses.
You can ascertain, identify, and glimpse rent house in Bronx New York, rental properties Bronx New York, and condo rentals Bronx New York.
Open your inspection online tomorrow, on Friday, or tomorrow for your house rentals, vacation homes Bronx New York, and rental properties Bronx.
Spacious classified ads and spacious classifieds rental home in Essex New York, homes for rent by owner Essex New York, Essex New York vacation homes for rent by owner, and Essex homes for rent.
Perceive and learn Essex rental home and Essex New York holiday rentals.
Join our ski in/out listings and oceanfront classifieds mailing list for rent house in Bronx New York and real estate rentals in Bronx.
Hear and disclose apartment rentals Franklin New York, rent houses Franklin, and real estate rentals Franklin New York.
Our site, FRBO.com does comprehend novel block oceanfront and beach chalet, cottage, and apartments.
Send bewitching and nice knowledge regarding vacation homes Bronx New York and Bronx vacation homes for rent by owner found on our online website, FRBO.com.
Householders and tenants who are looking for rent house in Bronx New York and are trying to move home rentals Bronx New York and vacation rentals in Bronx New York can ransack FRBO.Com, For Rent By Owner, and our exclusive advertisements, log directories, beach ads, and hillside indexes.
Find and hear Stella Niagara vacation homes for rent by owner and vacation homes for rent by owner.
Come upon, hear, and conceive vacation homes for rent by owner Shirley, for rent by owner homes, and Shirley rent houses.
Relocate, ascertain, and move Madison New York homes for rent by owner, Madison New York rental houses, Madison apartment rentals, and homes for rent by owner in Madison.
The Bronx New York ad directories billed and filed on our website, FRBO.com subsume rustic chalet, lakefront vacation home, and studio flat.
Light upon, come across, and design Brewster homes for rent by owner, rent house in Brewster, and condos for rent in Brewster United States.
You can scrutinize the romantic classifieds, oceanfront online MLS, beachfront directories, and exclusive ads under Bronx New York rental home, rental apartment in Bronx New York, and Bronx rental apartment.
Periodically, open doors and further your fraternity members, honeymooners, and rovers to a caught on and bewitching patch.
Contrive, uncover, and perceive Nassau rent house and vacation rental in Nassau New York.
Perceive, relocate, and originate for rent by owner homes Shushan United States, Shushan real estate rentals, and houses for rent Shushan United States.
Find out and relocate Tupper Lake rental houses and homes for rent by owner Tupper Lake United States.
Devise and contrive Wawarsing United States holiday rentals and for rent by owner homes in Wawarsing United States.
Our page can embody, record, and gather hillside classified ads and decadent classified advertisements beachfront directories and oceanfront online MLS to work with your Bronx odyssey.
|
|
