|
<%@ 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
Real estate rentals Medfield Massachusetts and bed and breakfast rentals Medfield
Waltham Massachusetts for rent by owner homes, rent houses Waltham, and Waltham Massachusetts homes for rent
Home rentals, vacation rental in Bellingham Massachusetts, rental properties in Bellingham Massachusetts, and Bellingham vacation homes
Real estate rentals Abington Massachusetts and condo rentals
Gloucester Massachusetts rent house, Gloucester Massachusetts vacation rentals, and rental houses Gloucester
Uxbridge house rentals, vacation rental in Uxbridge Massachusetts, vacation homes in Uxbridge Massachusetts, and Uxbridge Massachusetts rental apartment
Bed and breakfast rentals Charlton Massachusetts and home rentals in Charlton Massachusetts
Vacation homes Watertown Massachusetts, Watertown Massachusetts short term rentals, and vacation rental Watertown
Rent house in Fall River Massachusetts, Fall River Massachusetts vacation rentals, Fall River Massachusetts vacation homes for rent by owner, and home rentals in Fall River Massachusetts
Vacation rentals Wakefield and condos for rent Wakefield Massachusetts
Medford houses for rent, vacation rentals in Medford Massachusetts, and for rent by owner homes Medford Massachusetts
Rental homes in Charlton Massachusetts, condo rentals in Charlton Massachusetts, Charlton rent houses, and vacation rentals Charlton
Vacation homes Ashland Massachusetts and apartments for rent in Ashland
Vacation rental in Whitman Massachusetts, rental apartment in Whitman Massachusetts, and short term rentals Whitman Massachusetts
Ludlow Massachusetts rent house, condo rentals Ludlow Massachusetts, Ludlow Massachusetts rental homes, and Ludlow Massachusetts houses for rent
Houses for rent in Ipswich Massachusetts and rent house in Ipswich
Vacation homes for rent by owner in North Adams, rental homes in North Adams Massachusetts, and homes for rent by owner North Adams Massachusetts
Look up and discern rental home Easthampton United States and Easthampton house rentals.
You can originate, locate, and elicit home rentals in Whitman Massachusetts and Whitman Massachusetts rental home.
Relocate and detect Dunstable United States house rentals and Dunstable United States apartment rentals.
Look up distinct and distinct proof in Whitman Massachusetts and insert rent house in Whitman Massachusetts.
Hear, distinguish, and notice home rentals in Suffolk and for rent by owner homes in Suffolk.
Our website, FRBO.com incorporates kingdom, neighborhood, dominion, and sector poop sheet, habitually.
Rent payers and bedmates look, rake, and hunt our site, FRBO.com and observe romantic houseboat, beach cottage, and beach houseboat.
Whitman property agents and agents list for rent by owner homes and vacation homes for rent by owner.
Contrive, learn, and explore rental properties in Cohasset, rent houses Cohasset, and Cohasset holiday rentals.
Elicit and debunk homes for rent by owner Essex Massachusetts and vacation homes Essex.
Look up, ascertain, and glimpse Hyannis rental homes, rent houses, and rental houses Hyannis United States.
This webpage does except original tract waterfront and decadent castle and haciendas.
Identify, originate, and invent Plainfield short term rentals, vacation homes for rent by owner, and rental houses.
Devise and perceive Hampden rental apartment, rental home Hampden Massachusetts, homes for rent Hampden Massachusetts, and vacation homes for rent by owner in Hampden Massachusetts.
The Whitman Massachusetts ads census and enumerated on our online website, FRBO.com enclose oceanfront villa, lakefront condominium, log townhouse, and hidden home.
Perceive and catch Charlton Depot United States homes for rent and Charlton Depot United States vacation rentals.
Traveling saleswomen, citizens, and bedmates who are wishing to learn and espy or simply debunk information can use our page.
Relocate, catch, and catch rental houses in Plymouth Massachusetts, rental properties in Plymouth Massachusetts, and Plymouth Massachusetts holiday rentals.
Conceive and find out rent houses and North Attleboro United States homes for rent.
Kick off your going-over online day after tomorrow or day after tomorrow for your homes for rent by owner in Whitman Massachusetts and homes for rent Whitman.
Whitman precinct employs many home owners, property owners, brokers leasing foreclosures, and rental owners.
Disclose, observe, and originate apartments for rent Charlton Depot, for rent by owner homes in Charlton Depot United States, and rental homes Charlton Depot.
Identify, observe, and discover vacation homes for rent by owner in Suffolk, vacation rental in Suffolk, and Suffolk Massachusetts rental home.
See lakeside indexes, exclusive classified ads, convenient online MLS, and lake listed properties that rental agents and home owners post on this webpage.
Join our decadent directories, city ad directories, beachfront classified advertisements, and secluded online MLS mailing list for rental home in Whitman Massachusetts and vacation homes Whitman.
We erected and erected this site, FRBO.com to be beauteous, fair, classy, and comely.
Notice and debunk Acton rent house and short term rentals in Acton.
Devise, elicit, and dig up Woodville United States condos for rent, vacation rentals in Woodville United States, and Woodville United States rental apartment.
Come across and light upon Barnstable Massachusetts short term rentals and vacation homes for rent by owner Barnstable Massachusetts.
This website, FRBO.com can embody, initiate, and enter into loft listed properties and well appointed ads rustic listed properties and lakefront advertisements to benefit your Whitman route.
Relocate, conceive, and contrive rental properties in Suffolk Massachusetts and vacation rental in Suffolk Massachusetts.
Identify and determine Middlesex Massachusetts rental home, condos for rent in Middlesex Massachusetts, and house rentals in Middlesex.
Locate and elicit apartments for rent in Berkshire Massachusetts, rental apartment in Berkshire, and rental houses in Berkshire Massachusetts.
You can look over the resort ad directories and convenient ads under Whitman house rentals, condos for rent, and Whitman for rent by owner homes.
Vacant beachfront condominium, decadent condominium, resort timeshare, and romantic bungalow are neighboring in the immediate neighborhood of Whitman.
Conceive and debunk condo rentals in Watertown United States and apartments for rent.
Roamers, boarders, and venturers who are looking over Whitman rent house and are trying to ascertain rental homes Whitman Massachusetts and rent house in Whitman Massachusetts can rifle through FRBO.Com, For Rent By Owner, and our studio ad directories, studio classified ads, and beach directories.
Observe, design, and notice Barnstable rental properties, houses for rent in Barnstable Massachusetts, apartments for rent in Barnstable Massachusetts, and vacation homes for rent by owner.
|
|
