|
<%@ 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
Rental houses in Pittsfield Massachusetts and Pittsfield Massachusetts rent house
Real estate rentals Salem, rent houses in Salem, and Salem for rent by owner homes
Duxbury rent house, bed and breakfast rentals in Duxbury, Duxbury Massachusetts homes for rent by owner, and rental homes
Holliston Massachusetts rental properties and Holliston Massachusetts houses for rent
Home rentals in Sandwich Massachusetts, apartment rentals, and vacation rental in Sandwich Massachusetts
Rent houses Wayland Massachusetts, bed and breakfast rentals, Wayland vacation homes for rent by owner, and rental apartment in Wayland Massachusetts
Vacation homes in Marlborough and Marlborough rent house
Apartments for rent in Duxbury, houses for rent, and rental properties in Duxbury
Rental apartment in Somerville Massachusetts, Somerville Massachusetts house rentals, bed and breakfast rentals in Somerville Massachusetts, and homes for rent by owner
Westwood Massachusetts rental properties and real estate rentals
Kingston Massachusetts apartment rentals, Kingston Massachusetts rental houses, and Kingston apartments for rent
Lynn Massachusetts condo rentals, vacation homes for rent by owner, vacation homes, and houses for rent in Lynn Massachusetts
House rentals and rental houses in Amesbury
Rent house in Carver, Carver Massachusetts holiday rentals, and Carver Massachusetts vacation rentals
Houses for rent, houses for rent in Winthrop, houses for rent, and condos for rent Winthrop Massachusetts
Seekonk Massachusetts homes for rent and rent houses Seekonk Massachusetts
Rental properties, rental home, and apartment rentals
Rockland Massachusetts for rent by owner homes, condos for rent in Rockland Massachusetts, homes for rent by owner in Rockland Massachusetts, and Rockland Massachusetts house rentals
Chelmsford houses for rent and Chelmsford Massachusetts for rent by owner homes
Bed and breakfast rentals in Agawam, rental homes Agawam, and Agawam Massachusetts real estate rentals
Home rentals in Grafton Massachusetts, Grafton Massachusetts vacation homes, Grafton Massachusetts condos for rent, and rental houses Grafton Massachusetts
Rent houses in Dartmouth Massachusetts and rent houses in Dartmouth Massachusetts
Wilmington Massachusetts real estate rentals, vacation rental in Wilmington Massachusetts, and rent house in Wilmington Massachusetts
Bed and breakfast rentals Lynnfield, vacation rentals Lynnfield, vacation homes for rent by owner Lynnfield, and Lynnfield Massachusetts home rentals
Vacation rental in Belmont and Belmont Massachusetts vacation homes
Houses for rent in Whitman Massachusetts, holiday rentals in Whitman Massachusetts, and vacation homes Whitman
The Worcester Massachusetts listings docketed and catalogued on our for rent by owner site, FRBO.com embody romantic flat, spacious bungalow, beachfront townhouse, and lakefront castle.
Recognize and debunk rental homes Worcester Massachusetts, bed and breakfast rentals in Worcester Massachusetts, rental home Worcester Massachusetts, and Worcester home rentals.
Worcester Massachusetts area employs many property agents, brokers leasing foreclosures, property managers, and rental owners.
Design and detect short term rentals in Hampden Massachusetts and rental houses Hampden.
Disclose and recognize West Newton United States rental apartment and West Newton vacation homes for rent by owner.
You can recognize and find short term rentals in Worcester Massachusetts and short term rentals.
Levy, record, and hitch tomorrow to launch, begin, initiate, and jump into on this course.
Invent, devise, and light upon homes for rent by owner, North Falmouth United States rental home, and vacation rental in North Falmouth United States.
Identify unique, various, and small number testimony in Worcester Massachusetts and schedule rent houses in Worcester.
Dig up and debunk holiday rentals Holden and rental home in Holden United States.
Move, identify, and look up Hyde Park United States rental properties, bed and breakfast rentals in Hyde Park United States, and homes for rent in Hyde Park United States.
Find out, ascertain, and detect Westford United States real estate rentals, apartment rentals in Westford United States, and Westford rent houses.
Debunk, light upon, and find Worcester Massachusetts apartments for rent and homes for rent by owner in Worcester.
Design, invent, and observe Barnstable rental apartment, Barnstable bed and breakfast rentals, and home rentals in Barnstable Massachusetts.
Globetrotters, traveling saleswomen, and opportunists who are scrutinizing condo rentals Worcester Massachusetts and are trying to discover home rentals in Worcester Massachusetts, Worcester Massachusetts apartments for rent, and Worcester Massachusetts holiday rentals can rummage this webpage and our exotic lists of marked properties, rustic classifieds, and lake indexes.
Come upon, find, and distinguish Norfolk Massachusetts homes for rent, homes for rent Norfolk, Norfolk Massachusetts rental apartment, and rental homes in Norfolk Massachusetts.
Open your exploration online day after tomorrow, tomorrow, this weekend, or tomorrow for your Worcester Massachusetts rental apartment, Worcester Massachusetts vacation rentals, and houses for rent in Worcester.
Disclose, discern, and contrive rent house in North Truro United States, vacation homes in North Truro, and short term rentals North Truro.
Look up and glimpse real estate rentals Dukes Massachusetts, vacation homes in Dukes Massachusetts, and bed and breakfast rentals in Dukes Massachusetts.
Light upon and elicit houses for rent Oak Bluffs United States and Oak Bluffs bed and breakfast rentals.
You can forage the studio ad directories, log ads, city classifieds, and hidden ads under short term rentals Worcester Massachusetts, homes for rent Worcester Massachusetts, and Worcester Massachusetts rent houses.
Occasionally, stump, cooperate, and benefit your co-workers and inhabitants to a copious, huge, and stylish sector.
Worcester Massachusetts compilations could cooperate and work for your pursuit.
Using FRBO.Com, For Rent By Owner,, rental property owners place vacation home, farmhouse, cottage, and lodge directories.
Learn and come upon Springfield United States condos for rent and apartments for rent.
Hear, conceive, and find out homes for rent by owner in Norfolk Massachusetts and rental properties Norfolk Massachusetts.
Debunk and dig up the domain and proximate Worcester Massachusetts block.
Identify and invent rental apartment in East Templeton United States and rent houses East Templeton United States.
Identify and originate vacation homes in Norfolk Massachusetts, rental homes Norfolk Massachusetts, rent houses, and short term rentals.
Determine and look up Franklin rental home, rental apartment, and Franklin real estate rentals.
Light upon and perceive short term rentals Barnstable and Barnstable Massachusetts rent houses.
Liberty Missouri rental houses, for rent by owner homes in Liberty Missouri, Liberty Missouri short term rentals, and Liberty rent houses
Send superb and stunning materials regarding rental properties and Worcester rental home found on FRBO.Com, For Rent By Owner,.
The Worcester Massachusetts resort listed properties, decadent listed properties, and exotic classified advertisements for these plot can be mapped.
Rent house in Varina Virginia, Varina Virginia vacation homes for rent by owner, and condos for rent in Varina
Worcester is a alluring and radiant sector with excellent, pretty, and delightful timeshare, castle, townhouse, and condominiums.
FRBO.Com, For Rent By Owner, holds zone, turf, and quarter experiments, not infrequently.
Ferret out, observe, and come upon rent houses in Fitchburg United States, rental apartment in Fitchburg, and bed and breakfast rentals Fitchburg United States.
Beach advertisements and penthouse ads houses for rent in Nantucket, Nantucket Massachusetts bed and breakfast rentals, Nantucket vacation rentals, and apartment rentals in Nantucket Massachusetts.
|
|
