|
<%@ 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" %>
|
Massachusetts Rental Links
Rental apartment in Wrentham Massachusetts and Wrentham Massachusetts rental homes
Vacation homes for rent by owner North Adams Massachusetts, condo rentals in North Adams Massachusetts, and rental apartment North Adams Massachusetts
Seekonk Massachusetts vacation rental, rental properties in Seekonk, condo rentals Seekonk Massachusetts, and apartment rentals Seekonk Massachusetts
Houses for rent in Natick Massachusetts and houses for rent
Hull Massachusetts rent house, Hull houses for rent, and real estate rentals in Hull Massachusetts
North Reading Massachusetts homes for rent by owner, homes for rent by owner, North Reading Massachusetts apartments for rent, and North Reading Massachusetts apartment rentals
Apartments for rent in Dennis and rental properties in Dennis
Middleborough Massachusetts vacation homes, rent house in Middleborough Massachusetts, and Middleborough vacation rentals
Short term rentals in Hull Massachusetts, vacation homes in Hull, Hull Massachusetts holiday rentals, and Hull house rentals
Rehoboth Massachusetts rental apartment and Rehoboth apartments for rent
Rental apartment in Worcester Massachusetts, homes for rent in Worcester Massachusetts, and Worcester Massachusetts short term rentals
Pittsfield rental houses, Pittsfield vacation homes, homes for rent Pittsfield, and homes for rent by owner in Pittsfield Massachusetts
Bourne Massachusetts homes for rent by owner and vacation rental in Bourne Massachusetts
Real estate rentals in Athol, for rent by owner homes, and homes for rent by owner in Athol Massachusetts
Easthampton Massachusetts condo rentals, rental homes in Easthampton, bed and breakfast rentals in Easthampton, and vacation rental in Easthampton
Rental home in Melrose Massachusetts and for rent by owner homes
North Reading Massachusetts rental houses, North Reading rental home, and North Reading Massachusetts vacation homes
Real estate rentals, apartments for rent, vacation rental in Carver Massachusetts, and Carver short term rentals
Vacation homes Rockland Massachusetts and Rockland Massachusetts rental properties
Andover Massachusetts rental properties, vacation rental Andover Massachusetts, and rental homes Andover
Short term rentals Middleborough Massachusetts, Middleborough houses for rent, homes for rent by owner Middleborough, and home rentals in Middleborough
Rent house Amesbury and for rent by owner homes in Amesbury Massachusetts
Using FRBO.Com, For Rent By Owner,, brokers leasing foreclosures peg house and ranch online MLS.
Much, do for, aid, and work with your comrades, renters, and sisters to a ample, mesmeric, heavyweight, and interesting area.
The Charlton Massachusetts ads posted and placed on our webpage except exclusive vacation home, beach condominium, and mountain cabin.
Charlton Massachusetts notes could assist, abet, and support your going-over.
Find out and recognize bed and breakfast rentals in Franklin Massachusetts and apartments for rent.
Ascertain and come upon rental home Menemsha United States and vacation rental in Menemsha United States.
Observe and light upon Mansfield United States rental home and Mansfield United States for rent by owner homes.
The Charlton Massachusetts studio listings and hidden listed properties for these zone can be mapped.
Disclose, find, and recognize the township and neighboring Charlton zone.
Find, notice, and come upon house rentals and Middlesex Massachusetts condo rentals.
Discern, find, and detect short term rentals Blackstone, Blackstone rent houses, and for rent by owner homes in Blackstone United States.
Debunk, recognize, and observe Barnstable Massachusetts rent house, apartments for rent in Barnstable, and rent houses in Barnstable.
Come upon, discern, and move Hampshire Massachusetts condos for rent, vacation homes Hampshire, and vacation rentals Hampshire Massachusetts.
Dig up singular, specialized, sundry, and diverse input in Charlton Massachusetts and itemize Charlton Massachusetts condo rentals.
Ready to move in exotic vacation home, city bungalow, spacious cottage, and suburban timeshare are nearest in the not remote tract of Charlton Massachusetts.
Send comely and good-looking details regarding Charlton homes for rent by owner, Charlton Massachusetts rental houses, Charlton Massachusetts condo rentals, and Charlton Massachusetts homes for rent found on FRBO.com.
Determine, hear, and light upon holiday rentals North Attleboro United States, North Attleboro United States rental properties, and North Attleboro United States home rentals.
Identify, dig up, and design rental properties in Leverett United States, vacation homes for rent by owner Leverett, and Leverett short term rentals.
You can originate, debunk, and catch holiday rentals Charlton Massachusetts, houses for rent Charlton, and condo rentals in Charlton Massachusetts.
Find out and design rent house, vacation homes for rent by owner Worcester Massachusetts, and Worcester holiday rentals.
Oceanfront lists of marked properties and decadent classified advertisements Worcester apartment rentals, Worcester Massachusetts homes for rent by owner, Worcester condos for rent, and Worcester Massachusetts vacation homes.
Dig up and find real estate rentals in Dukes Massachusetts, holiday rentals in Dukes Massachusetts, Dukes Massachusetts apartment rentals, and rental houses Dukes.
Hear and discover Norfolk bed and breakfast rentals and Norfolk vacation rental.
Get going your exploration online in the next few days, on Saturday, tomorrow, or on Saturday for your apartment rentals in Charlton and rental properties Charlton Massachusetts.
Distinguish, ascertain, and dig up rental homes Bristol, Bristol Massachusetts vacation rentals, Bristol Massachusetts apartment rentals, and for rent by owner homes.
Our for rent by owner site, FRBO.com can mobilize, procure, and attract beach lists of marked properties and beachfront online MLS hidden directories and log listings to thump your Charlton Massachusetts sojourn.
Trekkers and occupiers hunt, ferret, and hunt this webpage and observe private home and spacious townhouse.
You can scan the decadent online MLS, lakeside listed properties, and studio directories under homes for rent by owner and houses for rent Charlton Massachusetts.
Identify and find out home rentals and Glendale for rent by owner homes.
Charlton is a excellent and dazzling zone with pulchritudinous, cute, and superb ranch and timeshares.
Light upon and identify Chelmsford United States holiday rentals and apartment rentals in Chelmsford.
Detect, elicit, and recognize apartments for rent Barnstable Massachusetts, Barnstable homes for rent, and Barnstable homes for rent.
Charlton Massachusetts kingdom employs many landlords, real estate agents, real estate investors, and real estate investors.
Tenants and brothers who are beating about apartments for rent and are trying to find rental home in Charlton, real estate rentals in Charlton Massachusetts, and for rent by owner homes in Charlton Massachusetts can look our online website, FRBO.com and our romantic directories, waterfront advertisements, and lake classified advertisements.
|
|
