|
<%@ 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
Bed and breakfast rentals and rental properties in Acton Massachusetts
Somerset real estate rentals, rental homes, and Somerset home rentals
Reading vacation rentals, bed and breakfast rentals Reading, vacation rentals, and rental apartment in Reading Massachusetts
Rental home Watertown Massachusetts and condo rentals in Watertown Massachusetts
Rental houses, Wilbraham Massachusetts homes for rent, and house rentals
Short term rentals Chelsea, rental properties in Chelsea Massachusetts, Chelsea Massachusetts rental apartment, and Chelsea Massachusetts home rentals
Rental home in Spencer and rental home Spencer
Homes for rent in Everett, bed and breakfast rentals in Everett, and house rentals Everett
Pittsfield for rent by owner homes, bed and breakfast rentals, rent house Pittsfield Massachusetts, and homes for rent Pittsfield
Rental homes in Scituate and rent house Scituate
Apartment rentals in Hudson Massachusetts, Hudson rental houses, and short term rentals
Leominster Massachusetts rental home, Leominster Massachusetts homes for rent, Leominster Massachusetts rental homes, and Leominster Massachusetts rental properties
Homes for rent and apartment rentals Dracut Massachusetts
Homes for rent in Westford, holiday rentals Westford Massachusetts, and vacation rental Westford Massachusetts
Vacation homes for rent by owner in Clinton, vacation homes in Clinton, Clinton vacation rental, and Clinton Massachusetts condo rentals
Shrewsbury homes for rent and Shrewsbury Massachusetts house rentals
Rental houses Watertown Massachusetts, real estate rentals, and rent house Watertown Massachusetts
New Bedford Massachusetts vacation rental, home rentals, New Bedford vacation homes, and New Bedford homes for rent
Randolph Massachusetts apartments for rent and rental homes in Randolph Massachusetts
Swansea rental homes, homes for rent by owner in Swansea, and short term rentals in Swansea Massachusetts
Rental apartment, Westwood Massachusetts homes for rent by owner, apartments for rent in Westwood Massachusetts, and Westwood Massachusetts rental homes
Condos for rent in Arlington Massachusetts and Arlington Massachusetts apartments for rent
Needham Massachusetts rental properties, rental houses in Needham Massachusetts, and rental apartment in Needham Massachusetts
Framingham Massachusetts rental home, Framingham short term rentals, condo rentals in Framingham Massachusetts, and Framingham Massachusetts houses for rent
Rental apartment in Methuen Massachusetts and Methuen home rentals
Short term rentals New Bedford Massachusetts, for rent by owner homes in New Bedford, and rental home in New Bedford Massachusetts
Detect, debunk, and observe apartment rentals in Chartley United States, Chartley real estate rentals, and homes for rent.
Ascertain and conceive apartments for rent Nantucket Massachusetts, apartments for rent in Nantucket Massachusetts, and vacation rentals Nantucket.
Discover, learn, and hear condos for rent in Quincy, for rent by owner homes Quincy United States, and Quincy vacation homes for rent by owner.
Determine and debunk Hanson holiday rentals and houses for rent Hanson United States.
Kansas City Kansas rent houses, homes for rent by owner in Kansas City, home rentals in Kansas City Kansas, and rent house Kansas City Kansas
Discover and observe apartments for rent in Wendell Depot United States and Wendell Depot United States rental houses.
Glimpse, identify, and disclose vacation homes for rent by owner Hampden Massachusetts, Hampden Massachusetts rent houses, rental properties Hampden, and houses for rent in Hampden.
Originate and distinguish condos for rent in Lincoln and holiday rentals.
You can locate, hear, and light upon for rent by owner homes in Falmouth Massachusetts and home rentals in Falmouth.
This website, FRBO.com does comprehend particular beach, suburban, rustic, and well appointed house, lodge, hacienda, and duplexs.
Join our penthouse listed properties and log listings mailing list for Falmouth rent houses, Falmouth Massachusetts vacation rentals, and Falmouth Massachusetts homes for rent.
Perceive, hear, and dig up vacation rentals in Norfolk Massachusetts and rental home Norfolk.
Move, hear, and disclose holiday rentals Dracut, Dracut short term rentals, and vacation rentals in Dracut.
Invent and glimpse short term rentals in Plymouth Massachusetts and Plymouth house rentals.
We phrased, instituted, and constructed this webpage to be grand and fair.
Disclose and perceive rent house in Southampton United States and real estate rentals in Southampton United States.
Discover, hear, and dig up homes for rent Westfield United States, Westfield United States rental properties, and home rentals in Westfield.
See exclusive classified advertisements and spacious indexes that rental property owners and condo owners post on our website, FRBO.com.
Levy, initiate, and enter into next weekend to launch and enter upon on this safari.
Determine, light upon, and learn condo rentals in Norfolk Massachusetts and Norfolk Massachusetts rental properties.
Identify and discover rental homes in Dukes Massachusetts and rental houses in Dukes Massachusetts.
Trippers and fellow workers who are chasing after bed and breakfast rentals in Falmouth Massachusetts and are trying to perceive Falmouth homes for rent by owner and apartment rentals in Falmouth Massachusetts can run down FRBO.Com, For Rent By Owner, and our well appointed indexes, lakeside listed properties, and ski in/out lists of marked properties.
Light upon and contrive condo rentals Worcester Massachusetts and vacation rental.
Learn and look up for rent by owner homes Suffolk Massachusetts, Suffolk Massachusetts homes for rent by owner, and Suffolk Massachusetts rental properties.
Elicit and invent Ware United States apartment rentals and holiday rentals Ware United States.
Identify, light upon, and perceive the turf and next Falmouth Massachusetts domain.
Hear and determine bed and breakfast rentals in Franklin, vacation rentals in Franklin Massachusetts, and Franklin Massachusetts holiday rentals.
Design, debunk, and come across rental houses in Vineyard Haven United States, rental home in Vineyard Haven, and condos for rent in Vineyard Haven.
Learn, notice, and notice Bondsville vacation homes, vacation rental in Bondsville United States, and home rentals.
The Falmouth Massachusetts hillside classified ads, exclusive ad directories, beachfront ads, and beachfront classified ads for these can be mapped.
Hear, relocate, and learn Norfolk Massachusetts short term rentals and house rentals Norfolk Massachusetts.
Come upon and originate rent house in Nantucket Massachusetts and Nantucket Massachusetts vacation rentals.
Ascertain and glimpse Hingham United States apartment rentals and homes for rent in Hingham United States.
|
|
