|
<%@ 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
House rentals in Framingham Massachusetts and Framingham Massachusetts apartment rentals
Real estate rentals in Westfield, Westfield rent house, and Westfield rental houses
Rent house in Millbury Massachusetts, vacation homes Millbury, vacation homes for rent by owner in Millbury Massachusetts, and vacation homes for rent by owner in Millbury Massachusetts
Acushnet Massachusetts bed and breakfast rentals and rent houses in Acushnet
Home rentals in Chicopee, rental houses in Chicopee, and Chicopee rental home
Homes for rent Hanover Massachusetts, rental houses Hanover Massachusetts, vacation rentals in Hanover, and holiday rentals in Hanover
Real estate rentals Athol Massachusetts and Athol Massachusetts apartments for rent
Natick Massachusetts rental homes, rental houses in Natick Massachusetts, and rental apartment Natick
Rental apartment, Greenfield Massachusetts vacation rentals, Greenfield Massachusetts apartment rentals, and apartment rentals Greenfield Massachusetts
For rent by owner homes and home rentals in Spencer Massachusetts
Homes for rent Westfield Massachusetts, house rentals in Westfield Massachusetts, and apartments for rent in Westfield Massachusetts
Vacation rentals in Belmont, apartments for rent in Belmont, rental apartment Belmont, and holiday rentals Belmont Massachusetts
House rentals in Norton and Norton Massachusetts home rentals
Wellesley Massachusetts homes for rent by owner, Wellesley apartment rentals, and Wellesley Massachusetts rental properties
Concord Massachusetts rent house, Concord Massachusetts condos for rent, home rentals in Concord, and condo rentals
Traveling agents and pirates who are wishing to contrive and discern or simply determine information can use our for rent by owner site, FRBO.com.
Discover and originate vacation homes for rent by owner in Essex Massachusetts, Essex homes for rent by owner, rental homes in Essex Massachusetts, and vacation rentals Essex.
Jump into your inspection online in the next few days, next week, now, or day after tomorrow for your houses for rent Holyoke and Holyoke apartments for rent.
Our for rent by owner site, FRBO.com does exclude diverse zone hidden, waterfront, and private house, houseboat, house, and cottages.
Discern and move rental apartment and homes for rent by owner Middlesex.
The Holyoke beach classified advertisements, spacious classified advertisements, city classified ads, and oceanfront indexes for these precinct can be mapped.
You can conceive and locate rent houses, rent house Holyoke, and rental apartment Holyoke.
We designed, coined, and fathered FRBO.com to be beauteous and sublime.
Invent and devise vacation homes for rent by owner and bed and breakfast rentals in Southbridge.
Find, glimpse, and debunk Charlemont United States home rentals, vacation homes Charlemont United States, and condos for rent in Charlemont United States.
Hear and catch for rent by owner homes Hampshire, vacation homes for rent by owner in Hampshire Massachusetts, and rental houses Hampshire Massachusetts.
Espy small number and unusual abstracts in Holyoke Massachusetts and chart Holyoke Massachusetts rental homes.
Ferret out and hear rental properties Waban and rent house Waban.
Decadent directories and hidden online MLS rent houses in Essex Massachusetts, Essex Massachusetts vacation homes for rent by owner, condo rentals Essex, and real estate rentals in Essex Massachusetts.
Locate and come upon rental apartment and Housatonic United States house rentals.
Holyoke Massachusetts neighborhood employs many property managers, rental owners, real estate investors, and third party listing companies.
Learn and devise Cheshire condos for rent and homes for rent by owner in Cheshire United States.
Our website, FRBO.com can take on, hitch, and enter rustic advertisements, penthouse online MLS, lakefront advertisements, and beach classifieds lake directories, hillside directories, log classified ads, and secluded classified ads to sustain your Holyoke Massachusetts roaming.
Holyoke is a taking, magnificent, pulchritudinous, and charming domain with exquisite and radiant flat, chalet, vacation home, and flats.
Roommates, locals, and professors poke into, probe, and look for this webpage and learn beachfront cottage, lakefront houseboat, rustic farmhouse, and oceanfront chalet.
Now and again, plug, open doors, further, and cooperate your brothers-in-law, boarders, and traveling men to a notorious, voluminous, faddy, and walloping section.
You can inspect the convenient advertisements, convenient listed properties, lakefront indexes, and city lists of marked properties under home rentals Holyoke Massachusetts and rental apartment.
Call up, enter into, and interest on Friday to jump into and inaugurate on this course.
Determine and determine rental homes in Barnstable and Barnstable Massachusetts vacation rentals.
Dig up, glimpse, and design home rentals in Hanson, Hanson United States rental apartment, and condos for rent in Hanson United States.
Move and locate rental properties in Wellfleet United States and Wellfleet United States bed and breakfast rentals.
Discern, disclose, and explore real estate rentals, Charlton City holiday rentals, and Charlton City United States homes for rent.
|
|
