|
<%@ 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
Apartment rentals in Charlton Massachusetts and rental apartment Charlton Massachusetts
Hanover Massachusetts house rentals, rental homes Hanover, and condo rentals
Condos for rent in Hanover Massachusetts, real estate rentals in Hanover Massachusetts, Hanover Massachusetts rental houses, and house rentals Hanover
Rental houses Medway Massachusetts and Medway Massachusetts rent houses
Stoneham homes for rent, vacation rental in Stoneham, and Stoneham Massachusetts rental houses
Southbridge bed and breakfast rentals, Southbridge rent houses, house rentals Southbridge Massachusetts, and Southbridge rental houses
Home rentals in Swampscott Massachusetts and short term rentals in Swampscott Massachusetts
Hull vacation rentals, rent house Hull, and house rentals Hull
Rental home in Uxbridge Massachusetts, vacation rentals Uxbridge Massachusetts, rental properties in Uxbridge Massachusetts, and vacation rentals Uxbridge
Condo rentals and vacation rental in Peabody Massachusetts
Belmont Massachusetts rental home, bed and breakfast rentals in Belmont Massachusetts, and for rent by owner homes in Belmont
Home rentals in Easthampton Massachusetts, house rentals in Easthampton Massachusetts, bed and breakfast rentals Easthampton Massachusetts, and rent houses Easthampton Massachusetts
Revere Massachusetts holiday rentals and holiday rentals in Revere Massachusetts
Vacation homes Medway Massachusetts, houses for rent in Medway, and condo rentals in Medway Massachusetts
Somerville Massachusetts real estate rentals, Somerville Massachusetts for rent by owner homes, Somerville Massachusetts rental properties, and Somerville houses for rent
Rental properties in Haverhill Massachusetts and home rentals Haverhill Massachusetts
Rental properties in Acton Massachusetts, condo rentals in Acton Massachusetts, and bed and breakfast rentals
Rental properties Saugus, houses for rent in Saugus Massachusetts, rental home in Saugus Massachusetts, and Saugus Massachusetts rental homes
Condo rentals in Hull and Hull Massachusetts house rentals
Salem Massachusetts vacation rentals, Salem Massachusetts bed and breakfast rentals, and Salem Massachusetts rental apartment
Rent houses in Belmont Massachusetts, Belmont house rentals, Belmont rental houses, and Belmont Massachusetts rental apartment
Homes for rent in Rockland and vacation rental Rockland Massachusetts
North Attleborough Massachusetts bed and breakfast rentals, short term rentals in North Attleborough, and rental properties in North Attleborough Massachusetts
Apartments for rent, houses for rent in Somerville, Somerville Massachusetts vacation rentals, and house rentals
Rental properties Seekonk Massachusetts and homes for rent
Homes for rent in Mashpee Massachusetts, home rentals in Mashpee, and vacation homes for rent by owner in Mashpee Massachusetts
Real estate rentals Rehoboth Massachusetts, for rent by owner homes, house rentals, and rent houses Rehoboth Massachusetts
Bed and breakfast rentals and homes for rent by owner Chelsea
Notice and identify house rentals in Norfolk Massachusetts, Norfolk vacation rental, Norfolk Massachusetts condo rentals, and house rentals in Norfolk.
Look up, ferret out, and come across Holbrook United States houses for rent, house rentals in Holbrook United States, and condos for rent in Holbrook United States.
Send comely and admirable materials regarding North Attleborough Massachusetts holiday rentals, rental apartment North Attleborough, and rental homes North Attleborough found on our site, FRBO.com.
This webpage seats turf, neighborhood, square, and precinct figures, regularly.
The North Attleborough Massachusetts hidden classifieds, well appointed listings, and loft indexes for these can be mapped.
Perceive and identify homes for rent by owner in Richmond United States and real estate rentals.
Observe, notice, and espy rental home in Osterville United States, Osterville holiday rentals, and homes for rent by owner.
Rental properties in Manheim and condo rentals Manheim
Come across and look up apartment rentals and West Warren United States rental houses.
Discern, light upon, and observe Dukes rental apartment, condos for rent in Dukes Massachusetts, Dukes Massachusetts rental apartment, and holiday rentals Dukes.
You can investigate the lake online MLS, lake listings, and well appointed classifieds under rental home North Attleborough Massachusetts, vacation rentals in North Attleborough Massachusetts, and North Attleborough bed and breakfast rentals.
Levy, incorporate, and volunteer this evening to originate, launch, inaugurate, and initiate on this peregrination.
Recognize, identify, and contrive Essex Massachusetts homes for rent and Essex Massachusetts vacation rental.
Come across, come across, and come across homes for rent by owner in South Barre United States, rent house in South Barre United States, and vacation homes for rent by owner in South Barre United States.
Conceive and contrive rental homes in Warwick and homes for rent Warwick United States.
Find out and look up short term rentals in South Hamilton United States and rental homes in South Hamilton.
Notice and discern vacation homes for rent by owner and homes for rent in Mashpee United States.
The North Attleborough Massachusetts indexes detailed and manifested on our for rent by owner website enclose mountain home, hillside bungalow, rustic bungalow, and exotic house.
Look up and find out vacation rentals in Norfolk Massachusetts and rental homes Norfolk Massachusetts.
Devise, locate, and glimpse rent houses Ashfield United States, vacation homes for rent by owner in Ashfield, and rent houses Ashfield.
Spasmodically, puff and assist your fraternity members and explorers to a brimming, hulking, awash, and looker plot.
Identify and come across condo rentals in Plymouth and home rentals Plymouth.
Find and debunk North Reading rental apartment and North Reading United States vacation homes for rent by owner.
Condo rentals, rent house in Uniontown, rental home, and rental apartment in Uniontown Pennsylvania
North Attleborough Massachusetts notes could plug and back your inquiry.
Join our penthouse lists of marked properties, oceanfront ad directories, secluded online MLS, and loft listings mailing list for vacation rentals North Attleborough Massachusetts, North Attleborough apartments for rent, and vacation homes for rent by owner in North Attleborough Massachusetts.
Guthrie vacation rental, rental apartment in Guthrie Oklahoma, rental properties in Guthrie Oklahoma, and rental properties in Guthrie Oklahoma
Rent payers, voyagers, and subordinates investigate and shake down this site, For Rent By Owner (FRBO.com) and contrive private ranch and well appointed condominium.
Observe, glimpse, and detect vacation homes in Plymouth Massachusetts, Plymouth Massachusetts vacation rentals, and houses for rent Plymouth Massachusetts.
Originate, hear, and light upon bed and breakfast rentals in North Reading United States, North Reading apartments for rent, and North Reading vacation rental.
Ascertain, disclose, and hear rental homes, house rentals in Ashland United States, and Ashland United States homes for rent.
Debunk, dig up, and disclose Thorndike United States house rentals, rent house, and rental houses in Thorndike United States.
Open your perquisition online next weekend or tomorrow afternoon for your for rent by owner homes North Attleborough, rental apartment in North Attleborough Massachusetts, and rental apartment.
Discern and uncover Barnstable house rentals, house rentals Barnstable, and Barnstable short term rentals.
Locate, observe, and ferret out Norfolk Massachusetts rental home, condo rentals, and vacation homes in Norfolk.
Elicit and contrive Wendell vacation homes and Wendell condo rentals.
Ascertain, elicit, and detect Milton rental houses, Milton United States apartment rentals, and bed and breakfast rentals Milton.
Identify, devise, and discover condo rentals Kingston, Kingston United States condos for rent, and rental home in Kingston United States.
Distinguish and devise apartments for rent Franklin and Franklin Massachusetts houses for rent.
Rental properties in Americus and Americus apartment rentals
North Attleborough real estate investors and real estate investors list holiday rentals in North Attleborough Massachusetts, vacation rental North Attleborough Massachusetts, and house rentals.
We concocted, constituted, and produced our webpage to be lovely, grand, and angelic.
Rental houses Bridgeton, homes for rent in Bridgeton New Jersey, and vacation homes Bridgeton
Conceive and light upon vacation homes and rental properties in Westminster United States.
Invent, learn, and discern Franklin Massachusetts vacation homes and house rentals in Franklin.
Dig up, devise, and elicit for rent by owner homes Lancaster United States, rent house, and rental homes.
Relocate and uncover Northampton bed and breakfast rentals and Northampton rent houses.
You can notice, catch, and find out rental apartment in North Attleborough, houses for rent in North Attleborough, and vacation homes for rent by owner in North Attleborough.
Our webpage does except various waterfront, beach, hidden, and lakeside condominium, farmhouse, cottage, and townhouses.
Disclose and observe apartments for rent Plymouth Massachusetts and rental apartment in Plymouth Massachusetts.
Disclose, dig up, and ferret out vacation homes in Norfolk, Norfolk Massachusetts vacation homes for rent by owner, rental homes Norfolk, and rental homes Norfolk Massachusetts.
|
|
