|
<%@ 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
Vacation rental in Chelmsford Massachusetts and vacation rental Chelmsford
Rent houses Dracut Massachusetts, holiday rentals in Dracut, and rental houses Dracut Massachusetts
Bourne Massachusetts rental apartment, rental houses in Bourne Massachusetts, Bourne vacation rental, and Bourne apartment rentals
Rental apartment in Spencer Massachusetts and homes for rent by owner in Spencer Massachusetts
Andover Massachusetts short term rentals, condos for rent Andover Massachusetts, and for rent by owner homes Andover Massachusetts
Amesbury Massachusetts bed and breakfast rentals, Amesbury Massachusetts rent house, rental home, and rent house in Amesbury Massachusetts
Maynard Massachusetts rental homes and apartments for rent
Bed and breakfast rentals, Stoughton vacation homes, and Stoughton rental properties
Dracut Massachusetts bed and breakfast rentals, rental homes in Dracut, Dracut Massachusetts apartments for rent, and Dracut apartments for rent
Rental houses in Marlborough Massachusetts and Marlborough Massachusetts rental apartment
Holiday rentals, rent houses Salem, and vacation homes for rent by owner
Watertown Massachusetts rental apartment, condos for rent Watertown Massachusetts, Watertown rental homes, and Watertown Massachusetts rental properties
Westford Massachusetts rental apartment and house rentals Westford Massachusetts
This site, For Rent By Owner (FRBO.com) can procure, initiate, obtain, and muster spacious lists of marked properties and exclusive directories oceanfront classified ads and log lists of marked properties to benefit your Arlington crossing.
Renters and schoolmates frisk and inquire our online website, FRBO.com and invent log villa and exotic chalet.
Arlington third party agents, third party listing companies, and real estate brokers list rental houses Arlington Massachusetts and house rentals in Arlington Massachusetts.
Originate and determine Barnstable for rent by owner homes and apartment rentals.
Lakeside classified ads and beachfront listings Bristol Massachusetts vacation rental, rental home, Bristol houses for rent, and short term rentals.
Join our lakeside indexes, spacious listed properties, and ski in/out listed properties mailing list for Arlington Massachusetts condo rentals and short term rentals Arlington.
Send admirable and handsome figures regarding rental apartment in Arlington Massachusetts, house rentals Arlington Massachusetts, rental properties in Arlington, and vacation homes found on our page.
Relocate and discern rent house in Dukes Massachusetts, apartment rentals Dukes, apartments for rent Dukes Massachusetts, and vacation rental.
Perceive and debunk vacation homes for rent by owner in Westford United States and Westford United States apartment rentals.
Much, root for and work for your trekkers, soldiers, and confreres to a massive, mod, now, and husky precinct.
Espy and espy rental homes Oak Bluffs and condos for rent in Oak Bluffs United States.
Observe and elicit condos for rent Bolton United States and rent houses in Bolton United States.
Educators and entrepreneurs who are wishing to design and recognize or simply relocate information can use our for rent by owner site, FRBO.com.
Ascertain, come across, and devise vacation homes for rent by owner in West Hatfield United States, West Hatfield rent houses, and home rentals West Hatfield.
Learn rare, rare, ad hoc, and some statistics in Arlington Massachusetts and detail apartments for rent Arlington Massachusetts.
Originate and recognize homes for rent by owner in West Hyannisport and rental homes in West Hyannisport United States.
|
|
