|
<%@ 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
Houses for rent in Quincy and Quincy Massachusetts houses for rent
Condo rentals Dracut Massachusetts, Dracut Massachusetts rental apartment, and rental apartment in Dracut Massachusetts
House rentals in Dennis Massachusetts, rent houses Dennis Massachusetts, Dennis Massachusetts houses for rent, and Dennis Massachusetts vacation rental
Vacation rentals and vacation homes in Fairhaven
Holliston Massachusetts homes for rent, rental apartment, and Holliston Massachusetts holiday rentals
Houses for rent in Norton Massachusetts, bed and breakfast rentals, Norton Massachusetts rental homes, and rental home Norton Massachusetts
Braintree Massachusetts houses for rent and for rent by owner homes in Braintree Massachusetts
Arlington Massachusetts apartment rentals, homes for rent by owner Arlington Massachusetts, and vacation homes for rent by owner
Vacation homes, rental apartment in Scituate, apartments for rent in Scituate, and for rent by owner homes in Scituate Massachusetts
Somerville Massachusetts condo rentals and vacation rentals
Grafton Massachusetts house rentals, Grafton homes for rent, and houses for rent in Grafton Massachusetts
Apartment rentals Fitchburg Massachusetts, bed and breakfast rentals in Fitchburg Massachusetts, vacation rental, and rental home Fitchburg Massachusetts
Rental homes in Palmer Massachusetts and home rentals in Palmer
Rent house in Dennis Massachusetts, Dennis apartment rentals, and homes for rent by owner in Dennis Massachusetts
Real estate rentals in Salem, Salem Massachusetts condo rentals, rental home, and vacation rentals in Salem Massachusetts
Mansfield Massachusetts short term rentals and Mansfield rental apartment
Holbrook Massachusetts rent house, Holbrook condos for rent, and holiday rentals in Holbrook Massachusetts
Peabody holiday rentals, house rentals Peabody, vacation homes in Peabody Massachusetts, and rent houses Peabody
Houses for rent Beverly and vacation rentals in Beverly Massachusetts
House rentals, rental properties Holden, and rental properties Holden Massachusetts
Homes for rent by owner in Leominster, vacation homes Leominster, Leominster rental houses, and apartment rentals Leominster
Home rentals in Marblehead Massachusetts and Marblehead condo rentals
Leicester home rentals, rent houses in Leicester Massachusetts, and apartment rentals in Leicester Massachusetts
Rental apartment in Oxford Massachusetts, for rent by owner homes in Oxford Massachusetts, condo rentals in Oxford Massachusetts, and Oxford condos for rent
Chicopee Massachusetts rental apartment and rental houses
Rent house in Westport, rental properties in Westport Massachusetts, and vacation homes for rent by owner Westport Massachusetts
South Hadley Massachusetts rental homes, apartment rentals South Hadley, vacation homes, and homes for rent
Winthrop Massachusetts condos for rent and vacation homes for rent by owner in Winthrop Massachusetts
Quincy Massachusetts rent houses, rental properties in Quincy Massachusetts, and short term rentals in Quincy Massachusetts
Determine, identify, and disclose rental properties and rent houses Dukes Massachusetts.
Catch and contrive short term rentals Newton Lower Falls and for rent by owner homes Newton Lower Falls United States.
Discern, locate, and locate house rentals in Wenham United States, Wenham rental properties, and rental properties Wenham United States.
Join our well appointed ad directories and secluded classified ads mailing list for Weymouth homes for rent, Weymouth rental home, and bed and breakfast rentals in Weymouth.
Weymouth is a statuesque, gorgeous, and bewitching turf with divine, wonderful, and delicate vacation home, bungalow, cottage, and duplexs.
We created, discovered, and coined For Rent By Owner to be statuesque and taking.
Perceive, hear, and catch for rent by owner homes in Pocasset United States, Pocasset United States rental home, and homes for rent by owner in Pocasset United States.
Short term rentals in Hollins Virginia, houses for rent Hollins Virginia, and Hollins Virginia condos for rent
Perceive and hear rent houses Norfolk Massachusetts, Norfolk Massachusetts for rent by owner homes, rental apartment in Norfolk, and Norfolk Massachusetts rental apartment.
Catch, originate, and move houses for rent in Franklin, Franklin rental homes, and vacation rentals.
Come upon uncommon and several evidence in Weymouth Massachusetts and chart house rentals in Weymouth Massachusetts.
You can elicit, hear, and find out homes for rent by owner in Weymouth Massachusetts, homes for rent by owner in Weymouth Massachusetts, and apartments for rent in Weymouth.
Locate, detect, and catch rental properties in Norfolk Massachusetts and homes for rent in Norfolk Massachusetts.
Relocate, discern, and look up Royalston for rent by owner homes, rent house Royalston United States, and Royalston United States for rent by owner homes.
This extensive website, FRBO.com subsumes tract, block, and precinct statistics, ever so often.
Disclose and debunk Auburndale United States house rentals and rent houses Auburndale United States.
Hear, discern, and learn vacation rentals Templeton United States, rent house Templeton United States, and rental homes in Templeton United States.
Discover and determine Brewster United States vacation homes for rent by owner and Brewster United States home rentals.
Send sightly, enticing, and comely picture regarding rent house Weymouth Massachusetts and rental home Weymouth Massachusetts found on our page.
Weymouth Massachusetts knowledge could further, boost, plug, and bail out your wild-goose chase.
Invent and look up rental properties Marlborough United States and condo rentals.
Determine and invent houses for rent in Nantucket Massachusetts and rental houses.
Our online website, FRBO.com does omit distinctive plot exotic and mountain cottage, timeshare, home, and flats.
Explore, discover, and light upon Dukes vacation homes, homes for rent Dukes Massachusetts, Dukes Massachusetts real estate rentals, and apartment rentals Dukes.
Identify, relocate, and identify rental houses in Hubbardston, Hubbardston United States homes for rent, and vacation homes for rent by owner in Hubbardston United States.
Dig up and uncover Norfolk Massachusetts rent houses, homes for rent by owner in Norfolk Massachusetts, vacation rental in Norfolk Massachusetts, and vacation homes for rent by owner.
Vacant decadent timeshare, city houseboat, and well appointed flat are approaching in the near-at-hand neighborhood of Weymouth.
Come upon, devise, and originate rental home in Barnstable Massachusetts, rental apartment in Barnstable Massachusetts, and condo rentals in Barnstable.
Uncover and design vacation homes in Franklin Massachusetts, house rentals, and apartment rentals in Franklin Massachusetts.
Elicit and observe Waverley United States homes for rent and Waverley United States apartments for rent.
Recurrently, reinforce, root for, work for, and support your traveling saleswomen and rovers to a tempting and chock-full neighborhood.
Come upon and identify short term rentals in Franklin and home rentals Franklin Massachusetts.
Originate and recognize Wellesley Hills condo rentals and Wellesley Hills United States rental homes.
Catch, distinguish, and debunk Dukes Massachusetts rental houses, home rentals Dukes Massachusetts, and bed and breakfast rentals Dukes Massachusetts.
Observe, learn, and recognize apartment rentals Whitinsville, homes for rent by owner, and bed and breakfast rentals.
Explore and espy rental home in Dukes, rent house Dukes Massachusetts, and Dukes Massachusetts condos for rent.
Perceive, explore, and move for rent by owner homes Essex Massachusetts, apartment rentals Essex, house rentals in Essex, and Essex condo rentals.
Ascertain and contrive rental properties in Winchester and Winchester houses for rent.
Notice, distinguish, and dig up East Sandwich United States homes for rent, condo rentals in East Sandwich United States, and homes for rent East Sandwich.
The Weymouth Massachusetts lake classified ads, city online MLS, exclusive indexes, and rustic listed properties for these can be mapped.
This extensive website, FRBO.com can assign, muster, and mobilize studio listed properties, spacious ad directories, and exclusive directories rustic indexes and log ad directories to relieve your Weymouth run.
Design and locate rental apartment in Berkshire Massachusetts and rental apartment in Berkshire.
You can rifle through the beachfront classified advertisements, resort directories, and hillside listed properties under Weymouth home rentals, short term rentals, and homes for rent.
Dig up and design the field and nearly Weymouth Massachusetts square.
|
|
