|
<%@ 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
Rent house Chelmsford Massachusetts and Chelmsford rental properties
Braintree Massachusetts homes for rent by owner, rental houses in Braintree Massachusetts, and Braintree Massachusetts condos for rent
Norton Massachusetts house rentals, Norton Massachusetts rental properties, vacation rental Norton Massachusetts, and Norton Massachusetts holiday rentals
Rental properties and vacation homes for rent by owner Leicester
Vacation homes Holyoke, condo rentals Holyoke Massachusetts, and Holyoke Massachusetts rent houses
Short term rentals in Charlton Massachusetts, rent houses in Charlton Massachusetts, rent house in Charlton Massachusetts, and Charlton rental properties
House rentals in Hudson and rental properties Hudson Massachusetts
Bed and breakfast rentals, homes for rent in Leominster Massachusetts, and short term rentals Leominster Massachusetts
Real estate rentals in Ipswich Massachusetts, rental homes, Ipswich Massachusetts rent house, and Ipswich Massachusetts rental apartment
Bridgewater Massachusetts rental houses and Bridgewater short term rentals
Rental houses Barnstable Town Massachusetts, Barnstable Town Massachusetts vacation rentals, and rent house in Barnstable Town Massachusetts
Dedham Massachusetts condos for rent, holiday rentals in Dedham, Dedham apartment rentals, and rental home Dedham
Apartment rentals Duxbury Massachusetts and home rentals in Duxbury Massachusetts
Condo rentals in North Adams, rental properties in North Adams Massachusetts, and condos for rent in North Adams
Find out, relocate, and look up vacation rentals in Hampden Massachusetts, Hampden apartment rentals, and Hampden holiday rentals.
Locate and recognize Chatham United States short term rentals and Chatham United States home rentals.
Originate rare, distinctive, ad hoc, and specific figures in Sandwich Massachusetts and detail vacation rental.
Sandwich town home owners and real estate brokers list vacation rental in Sandwich Massachusetts and real estate rentals in Sandwich.
Ascertain, locate, and uncover holiday rentals South Harwich, vacation homes South Harwich, and South Harwich rental home.
Reserve, serve, and levy on Tuesday to embark on, begin, and get cracking on this tour.
Catch and glimpse rent houses and rent houses.
Originate and recognize Hubbardston United States rental homes and apartments for rent.
Distinguish and catch rent house Linwood and vacation homes in Linwood.
See lake listings, hidden listings, waterfront ad directories, and well appointed classified ads that town home owners and brokers leasing foreclosures post on our webpage.
Identify, find, and catch Dukes Massachusetts rental properties, rental properties in Dukes, Dukes real estate rentals, and vacation rentals in Dukes.
Often enough, reinforce and benefit your traveling agents, trippers, and co-workers to a handsome, captivating, and pretty stretch.
Determine, glimpse, and look up vacation rental in Shattuckville United States, Shattuckville United States houses for rent, and Shattuckville United States real estate rentals.
Espy, ferret out, and detect houses for rent in Gilbertville, Gilbertville United States rent houses, and rental apartment in Gilbertville United States.
You can root the ski in/out directories, well appointed classified advertisements, secluded classified advertisements, and suburban ads under bed and breakfast rentals Sandwich Massachusetts, Sandwich short term rentals, and Sandwich Massachusetts holiday rentals.
The Sandwich Massachusetts directories inventoried and chronicled on this site, FRBO.com encompass rustic townhouse, resort farmhouse, and studio villa.
Identify and catch real estate rentals Franklin Massachusetts and homes for rent Franklin.
Originate and learn Seekonk United States rent houses and holiday rentals in Seekonk United States.
FRBO.com does subsume various territory beach, lake, ski in/out, and convenient farmhouse, timeshare, ranch, and castles.
Sandwich Massachusetts plot employs many agents serving the condo market, real estate investors, third party agents, and real estate agents.
Sandwich Massachusetts brass tacks could work for, hype, relieve, and root for your examination.
You can come upon, observe, and invent Sandwich Massachusetts condo rentals and rental homes in Sandwich Massachusetts.
The Sandwich Massachusetts spacious ad directories and oceanfront ad directories for these territory can be mapped.
Honeymooners and speculators cast about, smell around, and shake down FRBO.Com, For Rent By Owner, and come across oceanfront bungalow and penthouse house.
|
|
