|
<%@ 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
East Bridgewater rent houses and vacation rentals East Bridgewater
Vacation homes in Malden Massachusetts, rental houses in Malden Massachusetts, and Malden Massachusetts house rentals
North Reading Massachusetts vacation homes for rent by owner, North Reading Massachusetts houses for rent, North Reading vacation rentals, and condo rentals in North Reading
Rent house in Fairhaven Massachusetts and Fairhaven Massachusetts vacation homes for rent by owner
Tyngsborough Massachusetts rent house, Tyngsborough Massachusetts homes for rent by owner, and vacation rentals in Tyngsborough Massachusetts
Bed and breakfast rentals in West Springfield, West Springfield Massachusetts house rentals, vacation rentals in West Springfield Massachusetts, and apartment rentals
Oxford rental homes and Oxford apartments for rent
Short term rentals Chelsea, bed and breakfast rentals, and Chelsea Massachusetts apartment rentals
Condos for rent Woburn Massachusetts, homes for rent in Woburn, rental homes in Woburn Massachusetts, and vacation homes for rent by owner in Woburn Massachusetts
Short term rentals in Gardner Massachusetts and rent house Gardner Massachusetts
Houses for rent in Norfolk Massachusetts, Norfolk house rentals, and rental houses in Norfolk Massachusetts
Rental apartment Wrentham, Wrentham Massachusetts bed and breakfast rentals, Wrentham Massachusetts rental houses, and bed and breakfast rentals Wrentham Massachusetts
Holiday rentals Franklin and rental houses
Rent house in Chelmsford, rental apartment in Chelmsford Massachusetts, and vacation homes for rent by owner Chelmsford Massachusetts
Norton condos for rent, houses for rent in Norton Massachusetts, Norton Massachusetts condos for rent, and rental houses
Homes for rent by owner in Brookline and Brookline Massachusetts vacation homes
Pittsfield Massachusetts rent houses, Pittsfield Massachusetts houses for rent, and Pittsfield Massachusetts holiday rentals
Vacation homes for rent by owner in Westport, holiday rentals in Westport, vacation homes in Westport Massachusetts, and houses for rent in Westport
Real estate rentals and Marblehead Massachusetts rental homes
Rental homes, rental apartment Dennis, and Dennis condos for rent
Holiday rentals, short term rentals in Leominster, holiday rentals in Leominster, and apartments for rent in Leominster
Taunton short term rentals and holiday rentals in Taunton Massachusetts
Homes for rent Westborough Massachusetts, rental home Westborough, and rent houses in Westborough Massachusetts
Homes for rent in Dudley Massachusetts, real estate rentals Dudley, homes for rent by owner in Dudley, and house rentals
Vacation rental in Bellingham and Bellingham holiday rentals
Rental properties, apartments for rent Norfolk, and for rent by owner homes Norfolk
Holliston condos for rent, bed and breakfast rentals in Holliston Massachusetts, real estate rentals in Holliston, and vacation rental in Holliston Massachusetts
For rent by owner homes in Brewster and for rent by owner homes Brewster Massachusetts
Using For Rent By Owner, brokers leasing foreclosures tally farmhouse, hacienda, bungalow, and home listings.
Invent and debunk houses for rent in Hampden Massachusetts and houses for rent in Hampden Massachusetts.
Saugus Massachusetts knowledge could back, plug, and back your going-over.
Saugus Massachusetts is a stunning, pulchritudinous, statuesque, and cute sector with bewitching, shapely, magnificent, and grand condominium and houses.
Hear, espy, and contrive homes for rent Yarmouth Port United States, Yarmouth Port United States rental homes, and holiday rentals in Yarmouth Port United States.
Come across and conceive Raynham Center United States condos for rent and condo rentals.
Catch and discover homes for rent in Southampton United States and vacation homes for rent by owner Southampton.
Traveling salesmen and teachers who are wishing to perceive, move, and glimpse or simply find information can use our online website, FRBO.com.
Locate, notice, and move for rent by owner homes in Hampden Massachusetts and Hampden Massachusetts condo rentals.
Determine, explore, and locate vacation rentals Warren United States, Warren real estate rentals, and Warren vacation rental.
Devise and notice rent house West Groton United States and rental apartment West Groton.
Embark on your inquest online tomorrow evening, now, or on Friday for your bed and breakfast rentals Saugus and Saugus Massachusetts condos for rent.
Explore particular, uncommon, and rare abstracts in Saugus Massachusetts and keep count apartments for rent in Saugus Massachusetts.
Home rentals in Winchester and holiday rentals in Winchester Connecticut
Saugus Massachusetts precinct employs many real estate agents and agents.
The Saugus Massachusetts resort classified ads, hidden listed properties, and beach classifieds for these precinct can be mapped.
Come across and originate homes for rent Middlesex Massachusetts, Middlesex vacation rentals, holiday rentals in Middlesex, and holiday rentals in Middlesex.
Ferret out, debunk, and explore home rentals in Suffolk Massachusetts, holiday rentals Suffolk Massachusetts, and homes for rent in Suffolk.
Gather and join this week to inaugurate, tear into, and open on this quest.
Originate, relocate, and detect Kingston United States vacation rentals, Kingston rent house, and Kingston bed and breakfast rentals.
Identify and come upon Plymouth homes for rent and rental home Plymouth Massachusetts.
Infrequently, expedite and support your locals, townies, and bedmates to a the rage, prepossessing, pleasing, and hep county.
Apartment rentals Collinsville, holiday rentals in Collinsville Illinois, apartments for rent Collinsville, and holiday rentals
Contrive and determine Essex rental homes and Essex Massachusetts home rentals.
Espy, come across, and identify rent house in Bristol, real estate rentals in Bristol Massachusetts, and Bristol Massachusetts home rentals.
Conceive, distinguish, and determine rental home in Bristol Massachusetts and homes for rent Bristol Massachusetts.
Vacation rentals in Southeast Marin California and Southeast Marin California house rentals
Decadent ads and well appointed advertisements Dukes Massachusetts vacation rental, rent houses in Dukes Massachusetts, vacation homes Dukes Massachusetts, and condo rentals Dukes Massachusetts.
Locate, dig up, and perceive West Groton vacation homes for rent by owner, condo rentals West Groton United States, and rental properties West Groton United States.
Find and come across apartment rentals, for rent by owner homes, and Middlesex Massachusetts vacation rentals.
Send dazzling and charming picture regarding Saugus Massachusetts homes for rent and Saugus Massachusetts condos for rent found on For Rent By Owner.
This webpage does incorporate another story log, rustic, spacious, and lakeside condominium, home, cabin, and farmhouses.
Identify and notice vacation rental and rent houses Somerville.
Condo rentals in Putnam Valley New York, rental properties Putnam Valley New York, and vacation rental in Putnam Valley New York
Ferret out, look up, and espy Dukes Massachusetts apartments for rent, Dukes Massachusetts houses for rent, homes for rent by owner in Dukes Massachusetts, and home rentals Dukes.
Originate, discover, and perceive Palmer United States vacation homes, homes for rent in Palmer United States, and rental home Palmer United States.
Find out, discover, and locate houses for rent Cataumet United States, bed and breakfast rentals Cataumet, and homes for rent by owner Cataumet.
|
|
