|
<%@ 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
Apartments for rent in Watertown Massachusetts and apartment rentals in Watertown
Rent house Weymouth, house rentals in Weymouth Massachusetts, and Weymouth Massachusetts condo rentals
Rental home in Natick Massachusetts, Natick Massachusetts home rentals, vacation rentals in Natick Massachusetts, and houses for rent
Rental houses in Bellingham Massachusetts and rental apartment Bellingham Massachusetts
Homes for rent in Pembroke, house rentals Pembroke, and rental houses in Pembroke Massachusetts
Condo rentals, apartment rentals in Peabody Massachusetts, rental homes in Peabody Massachusetts, and Peabody Massachusetts rental houses
Stoughton Massachusetts rental houses and Stoughton rental home
House rentals in Ipswich, rental apartment in Ipswich Massachusetts, and houses for rent Ipswich
Mashpee Massachusetts rent house, rental homes in Mashpee Massachusetts, apartment rentals, and Mashpee Massachusetts condos for rent
Fairhaven Massachusetts condos for rent and Fairhaven Massachusetts homes for rent
Rental houses in Concord Massachusetts, for rent by owner homes Concord Massachusetts, and Concord Massachusetts apartment rentals
For rent by owner homes, holiday rentals in Milton Massachusetts, Milton Massachusetts houses for rent, and Milton Massachusetts apartment rentals
Bed and breakfast rentals Whitman and Whitman Massachusetts rental homes
Pepperell Massachusetts vacation homes for rent by owner, Pepperell houses for rent, and Pepperell for rent by owner homes
Wellesley houses for rent, homes for rent by owner in Wellesley Massachusetts, vacation homes for rent by owner in Wellesley Massachusetts, and condo rentals in Wellesley
Short term rentals Bridgewater Massachusetts and bed and breakfast rentals Bridgewater Massachusetts
Condo rentals in New Bedford Massachusetts, New Bedford Massachusetts apartments for rent, and bed and breakfast rentals New Bedford
Real estate rentals Norfolk, rent houses in Norfolk Massachusetts, rent houses in Norfolk Massachusetts, and rent house Norfolk
Real estate rentals in Middleborough Massachusetts and Middleborough Massachusetts real estate rentals
Rental apartment Woburn Massachusetts, rental apartment in Woburn, and Woburn Massachusetts rent houses
Vacation homes Holden Massachusetts, home rentals, Holden Massachusetts rental homes, and vacation rentals in Holden Massachusetts
Rental apartment and Springfield Massachusetts real estate rentals
Vacation homes for rent by owner, North Adams apartment rentals, and North Adams Massachusetts rental houses
Rent houses Sandwich, Sandwich Massachusetts rental home, rent house Sandwich, and apartment rentals
Holiday rentals Pittsfield Massachusetts and condo rentals
Rental properties in Needham, Needham apartment rentals, and Needham Massachusetts rental home
Condo rentals in Hudson Massachusetts, Hudson Massachusetts house rentals, Hudson vacation rentals, and vacation rentals
Rent house Wrentham Massachusetts and home rentals Wrentham Massachusetts
Bellingham holiday rentals, short term rentals Bellingham Massachusetts, and rental houses in Bellingham
Rental properties Palmer Massachusetts, rent house in Palmer Massachusetts, Palmer Massachusetts vacation rentals, and vacation rentals in Palmer Massachusetts
Rental apartment in Westford Massachusetts and vacation rentals in Westford Massachusetts
Rehoboth Massachusetts condos for rent, holiday rentals in Rehoboth Massachusetts, and rental homes in Rehoboth Massachusetts
Distinguish, observe, and debunk rental houses, Nantucket Massachusetts rental apartment, and Nantucket condo rentals.
Come upon, conceive, and find Rowe United States vacation rentals, house rentals in Rowe, and rental apartment in Rowe United States.
Relocate and come across Charlemont United States holiday rentals and home rentals in Charlemont United States.
See lakeside ads, city listings, and spacious advertisements that agents and rental property owners post on our for rent by owner site, FRBO.com.
Adventurers and rovers inspect, quest, and search for FRBO.Com, For Rent By Owner, and find out convenient vacation home, hidden apartment, city chalet, and lake home.
Send refined, excellent, ideal, and pulchritudinous statistics regarding rental homes Winthrop, rental properties in Winthrop Massachusetts, and house rentals found on our webpage.
Devise and espy short term rentals in Hudson United States and bed and breakfast rentals in Hudson United States.
Uncover and find home rentals and for rent by owner homes.
Notice, locate, and catch West Groton United States vacation homes, homes for rent, and vacation rental in West Groton.
Catch startling and unique scoop in Winthrop Massachusetts and tabulate for rent by owner homes.
We performed, started, and parented For Rent By Owner to be pleasing, symmetrical, and exquisite.
Kick off your pursual online next weekend, tomorrow evening, or next week for your homes for rent in Winthrop Massachusetts, rental houses in Winthrop Massachusetts, and rent house Winthrop Massachusetts.
Relocate and catch West Barnstable homes for rent and real estate rentals.
Winthrop Massachusetts section employs many property agents, property owners, and rental property owners.
Rent houses Okmulgee Oklahoma, condo rentals in Okmulgee Oklahoma, and rental homes in Okmulgee Oklahoma
The Winthrop Massachusetts indexes specialized and filed on our website, FRBO.com omit rustic home, beach bungalow, convenient houseboat, and city villa.
Elmira New York vacation homes for rent by owner, Elmira New York apartment rentals, and bed and breakfast rentals in Elmira New York
Rent house Columbia Pennsylvania, rental houses Columbia Pennsylvania, houses for rent in Columbia, and rental properties Columbia
Espy, catch, and light upon Carver bed and breakfast rentals, apartments for rent in Carver, and Carver United States home rentals.
Our site, FRBO.com does incorporate special mountain, romantic, spacious, and suburban villa, hacienda, apartment, and flats.
Using our webpage, property managers tick off condominium and timeshare lists of marked properties.
Determine and design real estate rentals Bristol, Bristol Massachusetts vacation homes, and rental homes.
Holiday rentals Upper San Gabriel Valley California, apartments for rent in Upper San Gabriel Valley, and rental properties Upper San Gabriel Valley
Ready to move in log home and hillside home are nearest in the not to distant dominion of Winthrop Massachusetts.
Find, detect, and light upon Worcester Massachusetts for rent by owner homes, short term rentals Worcester, and Worcester Massachusetts short term rentals.
Our for rent by owner website can record, oblige, employ, and employ exclusive classified advertisements and secluded indexes ski in/out classified ads, private classified ads, beach online MLS, and waterfront directories to reinforce your Winthrop outing.
Beavercreek Ohio house rentals, Beavercreek Ohio homes for rent, Beavercreek Ohio rent house, and home rentals
Uncover, observe, and determine condos for rent, homes for rent in Deerfield, and Deerfield United States rent house.
Look up and devise homes for rent by owner Hampden, Hampden house rentals, condos for rent Hampden Massachusetts, and vacation rentals in Hampden Massachusetts.
Move and glimpse Nantucket condo rentals and rent house.
Distinguish and determine Indian Orchard real estate rentals and rental apartment Indian Orchard United States.
Discover, find, and debunk rental properties Worcester and rental houses in Worcester Massachusetts.
Identify and light upon Sturbridge United States condos for rent and vacation rental Sturbridge United States.
Winthrop property managers and land owners list Winthrop Massachusetts house rentals and house rentals in Winthrop.
Distinguish and invent Middlesex rent houses, Middlesex Massachusetts rent houses, and real estate rentals Middlesex.
Detect, look up, and identify East Taunton apartment rentals, vacation rentals in East Taunton United States, and rental houses East Taunton.
Invent and originate houses for rent in Millville United States and house rentals in Millville United States.
Once in a while, work for and ride shotgun your colleagues and students to a in-thing, notorious, and mod kingdom.
|
|
