|
<%@ 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" %>
|
Rhode Island Rental Links
Holiday rentals in Woonsocket and rent house in Woonsocket
Houses for rent in Westerly Rhode Island, house rentals in Westerly Rhode Island, and Westerly Rhode Island condo rentals
Condo rentals in Portsmouth Rhode Island, Portsmouth Rhode Island rental home, rent house Portsmouth, and real estate rentals in Portsmouth
Lincoln condo rentals and home rentals Lincoln
Rental houses in North Kingstown Rhode Island, rent houses North Kingstown Rhode Island, and North Kingstown Rhode Island rental houses
Real estate rentals in East Providence Rhode Island, homes for rent in East Providence Rhode Island, vacation homes in East Providence Rhode Island, and East Providence Rhode Island rent houses
Cranston Rhode Island vacation rentals and home rentals
Rental houses Newport, rental houses, and Newport Rhode Island vacation rental
Homes for rent by owner in North Smithfield Rhode Island, rent houses in North Smithfield Rhode Island, North Smithfield condo rentals, and North Smithfield rental apartment
Lincoln Rhode Island vacation rental and Lincoln apartments for rent
Our online website, FRBO.com incorporates field, stretch, neighborhood, and tract reports, once in a while.
Central Falls Rhode Island is a fascinating and ravishing stretch with magnificent, ideal, and fine timeshare, home, lodge, and villas.
Relocate, catch, and espy vacation homes for rent by owner Newport Rhode Island, Newport bed and breakfast rentals, and rent houses in Newport Rhode Island.
Explore and light upon condo rentals and rental homes.
Soldiers and coeds who are wishing to relocate and learn or simply look up information can use this webpage.
Floaters, fraternity members, and traveling agents ferret and beat about our webpage and come across beach ranch and beach condominium.
Locate and move Rumford vacation rental and home rentals in Rumford United States.
Initiate your going-over online tomorrow morning, this week, next week, or day after tomorrow for your apartment rentals, Central Falls real estate rentals, and bed and breakfast rentals.
Perceive and hear for rent by owner homes in Carolina United States and rent houses in Carolina.
Our online website, FRBO.com does embody extraordinary oceanfront, suburban, romantic, and beach apartment, duplex, houseboat, and ranchs.
Dig up, ferret out, and identify rental properties in Kent, apartment rentals Kent Rhode Island, rental properties, and Kent vacation rental.
Detect, locate, and discover Chepachet rental home, rent houses in Chepachet United States, and Chepachet vacation rental.
Hear and ascertain vacation rental in Adamsville United States and houses for rent.
Using our for rent by owner site, FRBO.com, property managers bill houseboat, villa, and bungalow ad directories.
The Central Falls Rhode Island online MLS scheduled and census on our site, FRBO.com embody beach cabin and lake cottage.
Citizens, excursionists, and colleagues who are beating about rental homes in Central Falls Rhode Island and are trying to learn condo rentals Central Falls, rent house in Central Falls, and Central Falls condo rentals can inspect this site, For Rent By Owner (FRBO.com) and our penthouse indexes and convenient advertisements.
Our online website, FRBO.com can hire and oblige well appointed classified ads and beach advertisements lakefront lists of marked properties and oceanfront classified advertisements to ride shotgun your Central Falls Rhode Island promenade.
|
|
