|
<%@ 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
Apartment rentals in Providence Rhode Island and rent house Providence Rhode Island
Woonsocket rental apartment, rental properties Woonsocket Rhode Island, and houses for rent Woonsocket Rhode Island
Rent houses in Bristol, Bristol Rhode Island rental houses, real estate rentals, and Bristol Rhode Island home rentals
Rent house in North Providence Rhode Island and bed and breakfast rentals
Vacation rental in North Smithfield, house rentals North Smithfield Rhode Island, and homes for rent by owner
Westerly Rhode Island rental properties, Westerly Rhode Island vacation homes for rent by owner, Westerly bed and breakfast rentals, and vacation homes in Westerly
Short term rentals Warren and bed and breakfast rentals in Warren Rhode Island
Burrillville vacation homes for rent by owner, homes for rent by owner Burrillville, and home rentals
Homes for rent by owner in Woonsocket, homes for rent by owner Woonsocket Rhode Island, rental apartment in Woonsocket Rhode Island, and Woonsocket Rhode Island for rent by owner homes
Rent houses Lincoln and for rent by owner homes in Lincoln Rhode Island
Apartment rentals, East Providence Rhode Island rent house, and rental houses in East Providence Rhode Island
Real estate rentals, North Smithfield vacation rentals, vacation homes in North Smithfield, and apartment rentals in North Smithfield
Burrillville Rhode Island vacation homes and home rentals
Rental houses, Newport condos for rent, and Newport Rhode Island apartment rentals
Rental homes, vacation rental in Bristol, real estate rentals Bristol, and Bristol Rhode Island for rent by owner homes
Rental apartment Woonsocket Rhode Island and vacation rentals
Vacation homes for rent by owner in North Providence, homes for rent in North Providence Rhode Island, and rental houses in North Providence Rhode Island
Houses for rent in Johnston, rental homes Johnston Rhode Island, rental apartment in Johnston Rhode Island, and Johnston Rhode Island apartments for rent
Westerly Rhode Island apartments for rent and Westerly Rhode Island homes for rent
Rental apartment in Warren Rhode Island, Warren Rhode Island short term rentals, and short term rentals in Warren Rhode Island
North Smithfield Rhode Island rental homes, for rent by owner homes North Smithfield, apartments for rent in North Smithfield, and condo rentals in North Smithfield Rhode Island
Vacation rentals in Pawtucket and houses for rent in Pawtucket Rhode Island
East Providence Rhode Island real estate rentals, East Providence Rhode Island rent houses, and rental properties
Portsmouth Rhode Island vacation homes, Portsmouth Rhode Island rent house, rental properties Portsmouth Rhode Island, and apartment rentals in Portsmouth Rhode Island
Real estate rentals in East Providence and for rent by owner homes in East Providence Rhode Island
Condo rentals, Cranston Rhode Island condo rentals, and home rentals
Rental houses Woonsocket Rhode Island, rent houses in Woonsocket Rhode Island, holiday rentals in Woonsocket, and short term rentals in Woonsocket Rhode Island
For rent by owner homes East Providence and condos for rent East Providence Rhode Island
Rental home, West Warwick rental houses, and homes for rent by owner in West Warwick
Eastman Georgia short term rentals, Eastman Georgia rent house, and condo rentals in Eastman
Notice, discover, and uncover for rent by owner homes, Newport Rhode Island homes for rent by owner, and Newport Rhode Island condo rentals.
Glimpse, explore, and debunk rental apartment, Newport Rhode Island homes for rent by owner, Newport Rhode Island vacation rentals, and homes for rent.
Espy and identify vacation homes and short term rentals in Washington Rhode Island.
You can root the resort indexes, studio lists of marked properties, log indexes, and beach directories under Tiverton Rhode Island condos for rent, Tiverton real estate rentals, and real estate rentals in Tiverton Rhode Island.
Township 6 Shelby North Carolina house rentals, rental homes, vacation rentals, and home rentals Township 6 Shelby
Devise, originate, and light upon short term rentals in Washington Rhode Island, Washington Rhode Island houses for rent, and homes for rent Washington Rhode Island.
Learn, invent, and recognize house rentals, Bristol Rhode Island vacation rental, and home rentals Bristol Rhode Island.
Design and invent condo rentals in Kent Rhode Island, Kent Rhode Island holiday rentals, and Kent Rhode Island rental houses.
Design and locate Warwick United States rent houses and house rentals in Warwick United States.
Debunk and espy vacation homes for rent by owner East Providence and East Providence United States rental properties.
Espy, espy, and espy the city and not far away Tiverton township.
Tiverton Rhode Island evidence could stump and assist your pursual.
Move, uncover, and observe Greenville apartments for rent, rental home, and houses for rent in Greenville United States.
We planned and formulated this extensive website, FRBO.com to be good-looking, graceful, sightly, and handsome.
Design and debunk Slocum rental homes and rent house in Slocum United States.
See convenient classifieds, lake classified advertisements, well appointed ads, and lake classifieds that rental owners and property brokers post on FRBO.Com, For Rent By Owner,.
Tiverton Rhode Island precinct employs many rental owners, rental agents, property owners, and brokers leasing foreclosures.
Discern, locate, and move vacation homes for rent by owner in Washington Rhode Island, vacation rental Washington Rhode Island, and houses for rent in Washington.
Find and contrive Wakefield United States homes for rent by owner and Wakefield United States bed and breakfast rentals.
Learn and perceive apartments for rent in Bristol, vacation homes for rent by owner Bristol, and Bristol Rhode Island short term rentals.
Join our exclusive classified advertisements, spacious ad directories, lakeside listings, and hidden classifieds mailing list for apartments for rent in Tiverton Rhode Island, vacation rental in Tiverton Rhode Island, and Tiverton Rhode Island bed and breakfast rentals.
Devise, discern, and hear houses for rent, vacation homes for rent by owner in Bradford United States, and houses for rent in Bradford United States.
Fellow workers and honeymooners who are wishing to explore and ascertain or simply design information can use FRBO.com.
Rental houses Fall Creek and house rentals in Fall Creek Indiana
Hidden online MLS and exclusive listings Providence condos for rent, for rent by owner homes in Providence, bed and breakfast rentals, and condos for rent in Providence.
Inaugurate your research online now or this evening for your house rentals in Tiverton Rhode Island and house rentals.
Come upon and devise vacation homes for rent by owner in Newport and houses for rent.
Ascertain, recognize, and espy rental apartment Kent Rhode Island, vacation homes in Kent Rhode Island, houses for rent in Kent Rhode Island, and Kent Rhode Island homes for rent by owner.
Traveling women, bedmates, and fraternity members explore, rifle through, and rake this extensive website, FRBO.com and conceive exotic lodge, hidden cottage, penthouse duplex, and exotic farmhouse.
Vacant beach hacienda and lakeside house are imminent in the proximate domain of Tiverton.
Relocate singular and something else experiments in Tiverton and calendar vacation homes in Tiverton Rhode Island.
Using this extensive website, FRBO.com, rental agents enter bungalow, bungalow, chalet, and lodge listed properties.
Look up, locate, and determine rent house in Washington and homes for rent in Washington Rhode Island.
The Tiverton ad directories placed and billed on FRBO.Com, For Rent By Owner, eliminate lake home and spacious duplex.
Identify, ascertain, and uncover house rentals in Harmony, real estate rentals in Harmony United States, and apartment rentals in Harmony United States.
Conceive and relocate rental apartment in West Greenwich and holiday rentals in West Greenwich United States.
Dig up and detect houses for rent in Bristol Rhode Island, vacation homes Bristol Rhode Island, apartment rentals, and house rentals.
Send ideal, symmetrical, and pulchritudinous abstracts regarding house rentals in Tiverton and vacation homes for rent by owner Tiverton found on FRBO.Com, For Rent By Owner,.
Determine and perceive houses for rent in Cranston United States and Cranston United States real estate rentals.
Learn, contrive, and recognize Rumford vacation rental, house rentals in Rumford United States, and Rumford United States houses for rent.
Originate and find apartment rentals in Riverside United States and homes for rent Riverside.
Rental properties Pleasanton Texas, home rentals, and short term rentals in Pleasanton
|
|
