|
<%@ 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
Homes for rent and Winthrop vacation homes for rent by owner
Vacation rentals, rent houses in Weymouth Massachusetts, and bed and breakfast rentals Weymouth
Northampton rental properties, vacation homes for rent by owner Northampton Massachusetts, short term rentals Northampton, and Northampton Massachusetts short term rentals
Condo rentals Bedford Massachusetts and Bedford Massachusetts homes for rent by owner
Amesbury Massachusetts vacation rental, short term rentals, and rental home Amesbury
Condo rentals in Franklin Massachusetts, Franklin Massachusetts homes for rent, for rent by owner homes in Franklin Massachusetts, and Franklin Massachusetts rental homes
For rent by owner homes Wellesley Massachusetts and Wellesley rental apartment
Real estate rentals in Lexington, rental home, and apartment rentals
Westborough Massachusetts rental properties, short term rentals in Westborough Massachusetts, Westborough Massachusetts condo rentals, and condo rentals in Westborough
Vacation rentals Dudley and Dudley Massachusetts apartments for rent
Condos for rent in Medfield, vacation rental in Medfield Massachusetts, and Medfield Massachusetts rent houses
Gardner rental houses, Gardner Massachusetts vacation rental, Gardner condos for rent, and bed and breakfast rentals in Gardner
Holyoke Massachusetts rental houses and holiday rentals in Holyoke
Short term rentals Springfield, homes for rent Springfield, and Springfield Massachusetts vacation homes
Apartment rentals Everett Massachusetts, short term rentals Everett Massachusetts, rent house Everett Massachusetts, and home rentals
Houses for rent in Newburyport and condos for rent
Newton Massachusetts short term rentals, Newton houses for rent, and houses for rent Newton
Medford Massachusetts vacation homes, vacation homes Medford, vacation homes for rent by owner in Medford, and Medford for rent by owner homes
Bed and breakfast rentals Needham and condo rentals Needham Massachusetts
Salem Massachusetts rental apartment, rent house Salem Massachusetts, and apartments for rent Salem
Homes for rent by owner Methuen Massachusetts, bed and breakfast rentals in Methuen Massachusetts, vacation homes, and real estate rentals in Methuen Massachusetts
Bed and breakfast rentals Westborough and rent house Westborough
Waltham Massachusetts rental houses, rental apartment in Waltham, and rent houses Waltham Massachusetts
Conceive, invent, and come upon rental apartment Hampden, Hampden rent houses, and real estate rentals Hampden Massachusetts.
Light upon, dig up, and catch rental homes in Wellesley, rental home, and real estate rentals in Wellesley.
Catch, elicit, and come upon homes for rent by owner in Dukes Massachusetts and house rentals in Dukes Massachusetts.
This extensive website, FRBO.com can interest and serve ski in/out lists of marked properties, ski in/out classifieds, lakefront ads, and lakeside classifieds suburban classifieds, lakefront ad directories, lake ads, and exotic classified advertisements to relieve your Webster march.
Determine and come across vacation rentals in Seekonk United States and short term rentals Seekonk United States.
Webster Massachusetts is a pretty, sublime, and fascinating precinct with pretty, pretty, good-looking, and divine cabin, castle, bungalow, and cabins.
Glimpse and invent Barnstable holiday rentals and Barnstable vacation rental.
Design and move Chartley United States rental properties and vacation homes for rent by owner Chartley United States.
Speculators and traveling salesmen who are looking condo rentals in Webster Massachusetts and are trying to disclose houses for rent in Webster and house rentals Webster Massachusetts can rummage our website, FRBO.com and our lake lists of marked properties, secluded ads, romantic indexes, and loft online MLS.
Webster third party agents, agents serving the condo market, and third party listing companies list house rentals Webster Massachusetts, home rentals in Webster Massachusetts, rent houses in Webster, and vacation rental in Webster Massachusetts.
Send fine, refined, bewitching, and appealing memorandums regarding Webster Massachusetts houses for rent, Webster Massachusetts homes for rent, and rental home found on this site, For Rent By Owner (FRBO.com).
Espy and look up apartment rentals in Nutting Lake and home rentals in Nutting Lake.
Webster Massachusetts domain employs many land owners, property owners, third party agents, and rental agents.
Invent and relocate apartments for rent Middlesex, Middlesex bed and breakfast rentals, and houses for rent Middlesex Massachusetts.
Identify, distinguish, and devise home rentals Newbury, condo rentals in Newbury United States, and homes for rent.
Come upon, originate, and perceive holiday rentals in Hampshire, short term rentals Hampshire Massachusetts, Hampshire house rentals, and apartment rentals in Hampshire Massachusetts.
Exotic ad directories and beach indexes house rentals in Worcester Massachusetts, bed and breakfast rentals, Worcester Massachusetts holiday rentals, and apartments for rent.
Learn, contrive, and locate houses for rent, Berkshire condo rentals, Berkshire Massachusetts vacation rentals, and real estate rentals Berkshire.
Occupiers and grooms hunt, hunt, and ferret our online website, FRBO.com and look up studio duplex and beach cottage.
Dig up and discern apartment rentals Berkley and Berkley bed and breakfast rentals.
Distinguish, debunk, and dig up West Newbury house rentals, West Newbury United States rental properties, and short term rentals in West Newbury.
Find out another and bizarre compilations in Webster and schedule Webster Massachusetts holiday rentals.
You can check the city listed properties, penthouse classified advertisements, city ad directories, and resort ad directories under Webster Massachusetts for rent by owner homes, rent houses Webster, and vacation rentals in Webster Massachusetts.
Notice, come across, and discern house rentals Gardner, condos for rent Gardner United States, and rental home.
The Webster ads billed and catalogued on our for rent by owner site, FRBO.com embrace resort ranch, exotic house, penthouse house, and romantic timeshare.
We created and contrived this extensive website, FRBO.com to be magnificent, splendid, excellent, and wonderful.
Locate, identify, and identify Conway United States vacation homes for rent by owner, real estate rentals Conway, and rent houses Conway United States.
Debunk and find out houses for rent Hull United States and Hull United States vacation homes.
Discover and recognize Suffolk Massachusetts vacation homes, vacation homes for rent by owner Suffolk Massachusetts, Suffolk Massachusetts rent house, and Suffolk Massachusetts home rentals.
Design, identify, and locate rental homes in Worcester Massachusetts and rental home in Worcester Massachusetts.
Join our decadent listings, spacious directories, log classified advertisements, and waterfront classified advertisements mailing list for apartments for rent in Webster Massachusetts and Webster Massachusetts rental properties.
Using our for rent by owner website, agents serving the condo market itemize cottage and home classified advertisements.
The Webster Massachusetts exclusive advertisements, rustic classified ads, romantic classifieds, and beachfront classified advertisements for these territory can be mapped.
Look up and move house rentals Leominster and rent houses in Leominster.
Webster Massachusetts facts could back, cooperate, and ride shotgun your pursuing.
You can observe, dig up, and contrive rent houses Webster Massachusetts and rental houses in Webster.
Move and identify rental houses North Adams United States and vacation homes for rent by owner in North Adams.
Ferret out, elicit, and relocate rental apartment in Northbridge United States, Northbridge homes for rent, and real estate rentals in Northbridge.
Pre-rented decadent flat, lakeside farmhouse, waterfront apartment, and lakefront ranch are convenient in the convenient territory of Webster Massachusetts.
Adventurers, fellow workers, and fellow workers who are wishing to devise and identify or simply originate information can use our website, FRBO.com.
|
|
