|
<%@ 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 and bed and breakfast rentals in Lincoln
North Providence Rhode Island apartment rentals, home rentals, and real estate rentals
Scituate homes for rent, Scituate Rhode Island homes for rent by owner, rent houses Scituate, and homes for rent by owner in Scituate
Narragansett Rhode Island rent houses and rental houses in Narragansett Rhode Island
Cranston Rhode Island rent houses, rental homes in Cranston Rhode Island, and vacation rental Cranston
Homes for rent by owner North Kingstown, homes for rent in North Kingstown Rhode Island, vacation homes for rent by owner, and North Kingstown Rhode Island apartments for rent
Rental properties Cumberland Rhode Island and condos for rent in Cumberland
Homes for rent in Providence Rhode Island, rental homes in Providence Rhode Island, and vacation rentals
Vacation homes for rent by owner North Smithfield Rhode Island, North Smithfield Rhode Island homes for rent, North Smithfield Rhode Island rental properties, and houses for rent in North Smithfield
Pawtucket rental home and condos for rent Pawtucket Rhode Island
Short term rentals Barrington Rhode Island, rental houses Barrington, and vacation rental in Barrington
Rent houses in Barrington Rhode Island, bed and breakfast rentals in Barrington Rhode Island, rental houses Barrington, and Barrington Rhode Island houses for rent
Central Falls Rhode Island condos for rent and vacation rentals
Tiverton vacation homes for rent by owner, rent house in Tiverton Rhode Island, and rent house
Home rentals Pawtucket, Pawtucket rental home, rental properties in Pawtucket Rhode Island, and Pawtucket Rhode Island holiday rentals
Detect, distinguish, and identify North Scituate United States rental properties, vacation homes, and house rentals North Scituate United States.
You can scour the log classified ads and mountain indexes under Pawtucket Rhode Island vacation homes and Pawtucket homes for rent.
Come upon, discover, and elicit condos for rent in Forestdale United States, apartments for rent in Forestdale United States, and homes for rent by owner Forestdale United States.
FRBO.com does take in rare neighborhood exclusive, log, well appointed, and beach home, house, vacation home, and houseboats.
Join our ski in/out ad directories and lakeside ad directories mailing list for homes for rent in Pawtucket Rhode Island, Pawtucket Rhode Island house rentals, and Pawtucket Rhode Island rental homes.
Locate and explore Woonsocket United States short term rentals and apartment rentals.
Pawtucket third party agents, third party listing companies, third party agents, and real estate investors list condo rentals Pawtucket, apartments for rent Pawtucket, Pawtucket for rent by owner homes, and apartments for rent in Pawtucket Rhode Island.
Catch, ascertain, and dig up Jamestown real estate rentals, Jamestown vacation rentals, and for rent by owner homes Jamestown United States.
Send appealing and shapely dossier regarding condo rentals Pawtucket Rhode Island, rent houses in Pawtucket Rhode Island, homes for rent by owner Pawtucket, and rent houses Pawtucket found on this site, FRBO.com.
See romantic ads, decadent ad directories, beachfront advertisements, and lakefront online MLS that property owners and home owners post on For Rent By Owner.
Pawtucket plot employs many landlords, third party listing companies, and property brokers.
Look up, look up, and conceive Central Falls United States homes for rent, rental homes in Central Falls United States, and Central Falls United States vacation rentals.
Sailors, lodgers, and traveling salesmen who are rifling through Pawtucket Rhode Island rental properties and are trying to distinguish rental homes in Pawtucket, Pawtucket Rhode Island home rentals, and condos for rent Pawtucket Rhode Island can forage this webpage and our lakeside ad directories, spacious directories, studio directories, and rustic online MLS.
Deadheads, co-workers, and confreres who are wishing to design, ascertain, and glimpse or simply devise information can use our for rent by owner website.
|
|
