|
<%@ 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
Short term rentals in Framingham Massachusetts and bed and breakfast rentals in Framingham
Hopkinton Massachusetts house rentals, Hopkinton Massachusetts house rentals, and Hopkinton Massachusetts vacation rental
Vacation rentals in Saugus Massachusetts, rental apartment, condo rentals in Saugus, and rental properties in Saugus
Home rentals and rental houses in Lexington Massachusetts
Rental home in Wareham Massachusetts, holiday rentals in Wareham, and house rentals Wareham
Arlington Massachusetts house rentals, vacation homes, Arlington vacation homes, and rental apartment
Vacation homes Attleboro Massachusetts and condo rentals
Westford Massachusetts vacation homes for rent by owner, rental houses in Westford Massachusetts, and houses for rent
House rentals in Haverhill, rent house Haverhill Massachusetts, real estate rentals Haverhill, and Haverhill Massachusetts house rentals
Foxborough Massachusetts vacation rental and condos for rent
Apartment rentals in Oxford Massachusetts, Oxford house rentals, and rental homes
South Hadley houses for rent, South Hadley Massachusetts rental apartment, South Hadley Massachusetts rent house, and real estate rentals South Hadley Massachusetts
Short term rentals in South Hadley Massachusetts and for rent by owner homes
Condos for rent, homes for rent Quincy Massachusetts, and Quincy Massachusetts houses for rent
Randolph Massachusetts real estate rentals, condos for rent in Randolph, rental homes Randolph, and Randolph house rentals
Short term rentals in Maynard and Maynard houses for rent
Holliston Massachusetts rental apartment, Holliston Massachusetts rental home, and rent house
Ipswich for rent by owner homes, Ipswich Massachusetts vacation rentals, apartment rentals Ipswich Massachusetts, and Ipswich Massachusetts for rent by owner homes
Hull Massachusetts rental home and Hull Massachusetts condos for rent
Middleborough Massachusetts vacation homes for rent by owner, Middleborough for rent by owner homes, and apartment rentals in Middleborough
For rent by owner homes Gloucester Massachusetts, vacation homes for rent by owner, vacation homes, and Gloucester Massachusetts real estate rentals
Rent house Dartmouth and Dartmouth Massachusetts apartment rentals
North Attleborough apartment rentals, bed and breakfast rentals in North Attleborough Massachusetts, and real estate rentals North Attleborough Massachusetts
Real estate rentals, houses for rent Walpole Massachusetts, Walpole vacation homes, and vacation rental
Vacation homes Arlington and bed and breakfast rentals Arlington Massachusetts
Rental houses in Westport, rental homes Westport Massachusetts, and Westport Massachusetts for rent by owner homes
Framingham Massachusetts rent houses, home rentals, vacation rentals in Framingham Massachusetts, and for rent by owner homes Framingham Massachusetts
Winchester Massachusetts condos for rent and condos for rent in Winchester
Short term rentals, apartments for rent Uxbridge Massachusetts, and rent house in Uxbridge
Rental properties Acton, vacation rental, Acton apartments for rent, and vacation homes in Acton
Cambridge Massachusetts rental apartment and rent house Cambridge
Join our suburban online MLS, beach classified ads, and hidden classifieds mailing list for rental home in Agawam Massachusetts, Agawam condos for rent, and vacation homes for rent by owner.
Leavenworth real estate rentals, Leavenworth vacation homes for rent by owner, bed and breakfast rentals, and rental properties Leavenworth
Identify and identify South Hamilton United States vacation homes and homes for rent in South Hamilton United States.
Vacation homes in Bay City Texas, Bay City Texas rental apartment, holiday rentals in Bay City Texas, and Bay City Texas rental properties
Fortune-hunters and romantics who are raking short term rentals Agawam and are trying to invent Agawam homes for rent by owner and Agawam rental houses can go through our for rent by owner website and our private listings, convenient indexes, exclusive online MLS, and beach ad directories.
Find, distinguish, and find out vacation rental in Hampshire Massachusetts, vacation homes, and rental properties in Hampshire.
Light upon, uncover, and look up for rent by owner homes Bernardston United States, vacation homes for rent by owner in Bernardston, and vacation homes in Bernardston.
Find and explore rent houses Franklin, rental properties in Franklin Massachusetts, and short term rentals Franklin Massachusetts.
Co-workers, brothers-in-law, and junketers rake and chase after this extensive website, FRBO.com and glimpse lakeside vacation home, log castle, and beach houseboat.
We fashioned and contrived this webpage to be resplendent, ideal, classy, and shapely.
Agawam poop could further, sustain, and stump your inquest.
Espy and determine homes for rent and South Wellfleet bed and breakfast rentals.
Look up and disclose Upton United States rent house and Upton United States rental apartment.
Learn, explore, and discover real estate rentals Essex and Essex Massachusetts holiday rentals.
Uncover and come across apartment rentals Norfolk Massachusetts and apartment rentals Norfolk.
Recognize and move Nantucket Massachusetts short term rentals, house rentals in Nantucket Massachusetts, and homes for rent.
Disclose and glimpse condo rentals and rental properties in Plainville United States.
Come upon, discover, and locate Norfolk rental apartment, holiday rentals Norfolk, Norfolk Massachusetts vacation rental, and Norfolk Massachusetts vacation homes.
Distinguish and espy holiday rentals and for rent by owner homes.
Disclose and discover real estate rentals Franklin Massachusetts and Franklin Massachusetts rental houses.
Agawam Massachusetts sector employs many rental owners, real estate investors, third party listing companies, and real estate brokers.
Ascertain, discern, and notice Burlington rental houses, apartments for rent in Burlington United States, and Burlington rental properties.
Generally, hype, sustain, expedite, and run interference your pioneers and rovers to a packed, hefty, stylish, and awash city.
Convenient listings and penthouse advertisements home rentals Essex Massachusetts, rent house in Essex Massachusetts, rental apartment in Essex, and Essex Massachusetts condo rentals.
Locate and explore rental homes and rental apartment Shelburne Falls United States.
Find, identify, and find South Egremont United States for rent by owner homes, South Egremont United States rental apartment, and rental apartment in South Egremont United States.
Explore, discover, and find out rental apartment in Fall River United States, rental home in Fall River, and holiday rentals in Fall River United States.
Catch, perceive, and explore North Waltham vacation rental, apartments for rent in North Waltham, and North Waltham United States rental properties.
Real estate rentals and rental houses in Kissimmee Florida
Devise, perceive, and learn short term rentals in Winchester United States, Winchester rental apartment, and rental apartment in Winchester United States.
Explore and distinguish real estate rentals Ipswich United States and rental homes in Ipswich United States.
Find out, look up, and debunk Franklin Massachusetts rental homes and Franklin Massachusetts rent houses.
Look up and determine the domain and impending Agawam Massachusetts state.
Uncover, design, and discern real estate rentals Shutesbury United States, apartment rentals in Shutesbury United States, and Shutesbury vacation rentals.
Identify and discover house rentals and short term rentals Dighton United States.
Rental apartment in Killen Alabama, vacation homes for rent by owner in Killen Alabama, apartments for rent in Killen Alabama, and condos for rent
Glimpse and come upon rental home South Wellfleet United States and rental home in South Wellfleet United States.
See secluded online MLS, waterfront online MLS, rustic directories, and city directories that property brokers and agents post on our for rent by owner site, FRBO.com.
The Agawam indexes itemized and pegged on FRBO.com comprise exclusive apartment, lakeside timeshare, secluded hacienda, and log duplex.
Recently vacated waterfront bungalow, oceanfront farmhouse, suburban flat, and mountain cabin are not far away in the approaching precinct of Agawam.
Discern and discern Nantucket Massachusetts rental homes, vacation rentals, Nantucket Massachusetts rental homes, and vacation rentals Nantucket.
Locate and come upon rental apartment and Lee United States rental homes.
Using our page, landlords specify home, houseboat, ranch, and cottage classified advertisements.
Observe, perceive, and invent Gilbertville apartment rentals, rent houses in Gilbertville, and houses for rent in Gilbertville.
Notice and observe holiday rentals Suffolk and homes for rent by owner in Suffolk.
Detect and look up home rentals in Framingham and Framingham United States homes for rent.
Debunk, determine, and come across vacation rentals in Manchester United States, house rentals Manchester United States, and vacation homes in Manchester United States.
|
|
