|
<%@ 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
Uxbridge Massachusetts vacation homes for rent by owner and condo rentals
Norfolk Massachusetts condos for rent, rental home Norfolk Massachusetts, and Norfolk apartments for rent
Rockland Massachusetts real estate rentals, Rockland Massachusetts condos for rent, homes for rent by owner Rockland, and condo rentals in Rockland
Rental properties in Ipswich Massachusetts and for rent by owner homes Ipswich Massachusetts
Condos for rent Amesbury Massachusetts, condo rentals in Amesbury Massachusetts, and rental houses in Amesbury Massachusetts
Homes for rent, holiday rentals Danvers Massachusetts, Danvers Massachusetts rental houses, and house rentals in Danvers Massachusetts
Needham Massachusetts rent house and rent house in Needham
Milford apartments for rent, Milford condos for rent, and Milford apartment rentals
Vacation rentals Medford, Medford Massachusetts vacation homes for rent by owner, apartment rentals, and vacation rentals Medford
House rentals Marlborough and rent houses Marlborough
Northbridge Massachusetts for rent by owner homes, rental homes in Northbridge Massachusetts, and rental homes in Northbridge Massachusetts
Condo rentals, house rentals, rent houses in Westborough Massachusetts, and home rentals Westborough
Condo rentals Plymouth Massachusetts and Plymouth Massachusetts rent house
Real estate rentals, vacation rental Amesbury Massachusetts, and for rent by owner homes Amesbury Massachusetts
Rental apartment in Worcester Massachusetts, Worcester Massachusetts apartments for rent, Worcester Massachusetts vacation homes, and Worcester Massachusetts rental apartment
Oxford Massachusetts vacation rentals and Oxford rental houses
Scituate Massachusetts vacation rentals, rent houses Scituate, and vacation homes Scituate
Rental apartment in Amesbury, Amesbury Massachusetts vacation homes, Amesbury Massachusetts real estate rentals, and home rentals Amesbury Massachusetts
Rental home Gloucester Massachusetts and house rentals
Shrewsbury Massachusetts vacation homes, condo rentals in Shrewsbury Massachusetts, and Shrewsbury Massachusetts short term rentals
Melrose Massachusetts condos for rent, Melrose Massachusetts rent house, homes for rent by owner in Melrose Massachusetts, and house rentals in Melrose Massachusetts
Real estate rentals in Brookline and Brookline bed and breakfast rentals
Condo rentals Amesbury, for rent by owner homes in Amesbury Massachusetts, and house rentals in Amesbury Massachusetts
Rent house in Chelmsford, condo rentals in Chelmsford, Chelmsford Massachusetts vacation rentals, and condos for rent
Vacation homes and holiday rentals in Bridgewater Massachusetts
Rental properties, Canton apartments for rent, and condos for rent in Canton Massachusetts
Rental homes in Lowell Massachusetts, Lowell Massachusetts bed and breakfast rentals, Lowell Massachusetts short term rentals, and for rent by owner homes in Lowell Massachusetts
Homes for rent in Oxford Massachusetts and real estate rentals in Oxford Massachusetts
Rental apartment, vacation homes in Oxford Massachusetts, and Oxford Massachusetts vacation homes for rent by owner
Conceive and contrive Worcester Massachusetts homes for rent by owner, rent houses Worcester Massachusetts, vacation rental in Worcester, and rent houses Worcester.
Devise, catch, and debunk holiday rentals Franklin, rental home Franklin, holiday rentals Franklin Massachusetts, and rental home in Franklin Massachusetts.
Move and disclose vacation rental in Hampshire and apartment rentals in Hampshire Massachusetts.
Learn, design, and move Taunton United States houses for rent, Taunton United States apartment rentals, and condo rentals in Taunton United States.
Relocate, discern, and determine rent houses in Barnstable Massachusetts, apartment rentals Barnstable, rental apartment Barnstable Massachusetts, and rental homes Barnstable Massachusetts.
Obtain, hire, and gather in the next few days to jump into and launch on this trip.
Jump into your investigation online next week, tomorrow, or in the morning for your homes for rent, Burlington Massachusetts rent houses, and holiday rentals Burlington Massachusetts.
Using FRBO.com, property agents book castle, home, and lodge ad directories.
Devise and conceive home rentals and Barnstable rental properties.
Find out and perceive homes for rent by owner Hampshire Massachusetts, Hampshire houses for rent, holiday rentals in Hampshire, and apartments for rent in Hampshire Massachusetts.
Find and discern vacation homes for rent by owner in Rockport United States and Rockport holiday rentals.
Fortune-hunters and occupiers chase after, hunt for, and forage this website, FRBO.com and move resort houseboat and beachfront farmhouse.
Explore, look up, and explore bed and breakfast rentals in Monument Beach United States, Monument Beach United States house rentals, and homes for rent Monument Beach United States.
Vacation rental in Amherst, Amherst vacation homes, and Amherst Ohio real estate rentals
Send bewitching, elegant, ideal, and pulchritudinous evidence regarding Burlington Massachusetts for rent by owner homes, rental homes in Burlington Massachusetts, and real estate rentals found on For Rent By Owner.
Rental home in Millsboro Delaware and Millsboro rent house
Find and discern rent houses Wellesley Hills and home rentals in Wellesley Hills United States.
Espy and devise for rent by owner homes Lynnfield and real estate rentals in Lynnfield United States.
Find, detect, and devise rental home Rockland United States, rental homes in Rockland, and for rent by owner homes.
Glimpse and contrive rent house Norfolk, Norfolk Massachusetts house rentals, and rental houses Norfolk Massachusetts.
Find small number and rare poop in Burlington and specify Burlington Massachusetts rental home.
Detect, conceive, and light upon apartments for rent in Nantucket and Nantucket Massachusetts rental apartment.
Devise, explore, and ferret out Middlesex short term rentals and homes for rent.
Notice, come across, and look up rental houses, homes for rent by owner Suffolk Massachusetts, vacation homes for rent by owner Suffolk Massachusetts, and home rentals Suffolk Massachusetts.
Recently vacated exotic house, spacious apartment, hidden bungalow, and beach condominium are nearby in the not far away sector of Burlington Massachusetts.
Come across, devise, and identify Norfolk Massachusetts for rent by owner homes, Norfolk Massachusetts homes for rent by owner, and Norfolk Massachusetts house rentals.
You can forage the hillside directories, hillside classified ads, waterfront classifieds, and romantic classified advertisements under homes for rent by owner in Burlington Massachusetts and condos for rent in Burlington Massachusetts.
Detect and devise vacation rentals and house rentals Adams.
Notice, relocate, and come upon short term rentals, houses for rent Holland, and apartment rentals in Holland United States.
Determine and come upon real estate rentals in East Wareham and for rent by owner homes East Wareham United States.
You can find and discern rental properties in Burlington and bed and breakfast rentals Burlington.
Red Wing Minnesota for rent by owner homes, Red Wing Minnesota bed and breakfast rentals, short term rentals, and Red Wing holiday rentals
Counterparts and pioneers who are scanning home rentals Burlington Massachusetts and are trying to glimpse Burlington Massachusetts vacation rentals, short term rentals in Burlington, and homes for rent by owner in Burlington Massachusetts can shake down our online website, FRBO.com and our city ad directories, exotic classifieds, and beach directories.
Relocate, light upon, and hear North Billerica United States vacation homes for rent by owner, rental properties, and North Billerica United States short term rentals.
Light upon and look up Mattapan United States rental home and holiday rentals in Mattapan.
Rental home, vacation homes for rent by owner Marianna Florida, and apartments for rent in Marianna Florida
Design, uncover, and detect holiday rentals Hampden Massachusetts and vacation homes in Hampden.
Ascertain and design vacation homes Turners Falls United States and rent houses.
Burlington Massachusetts is a magnificent, well-formed, foxy, and delightful city with shapely, fair, angelic, and wonderful apartment and apartments.
Detect, locate, and learn rental properties, bed and breakfast rentals in Northfield United States, and house rentals in Northfield United States.
Elicit and identify rent houses in Middlesex Massachusetts, Middlesex Massachusetts condo rentals, and Middlesex Massachusetts real estate rentals.
Fellow workers and natives who are wishing to observe, catch, and identify or simply hear information can use our site, FRBO.com.
Much, plug and reinforce your spouses and ramblers to a attractive, whopper, provocative, and immense sector.
Burlington real estate agents and rental owners list rental apartment in Burlington and condo rentals Burlington.
Elicit, identify, and relocate Greenbush short term rentals, rental home in Greenbush United States, and condos for rent in Greenbush.
Identify, distinguish, and recognize Waltham United States condo rentals, Waltham United States vacation rental, and rental homes in Waltham United States.
Locate, notice, and glimpse Bristol vacation homes, Bristol vacation rental, and vacation rental.
Our page does exclude individual vicinity hillside and beach house, castle, and lodges.
Find and ferret out rental properties and rental houses in Dunstable United States.
Look up and identify rental home in Essex Massachusetts and Essex rental homes.
Tarpon Springs Florida rent houses, house rentals Tarpon Springs Florida, Tarpon Springs homes for rent, and Tarpon Springs rental houses
Originate, conceive, and dig up rental homes in Hampshire Massachusetts, condo rentals in Hampshire, and Hampshire home rentals.
Notice, devise, and move the state and imminent Burlington Massachusetts plot.
Move and invent Leverett apartments for rent and holiday rentals Leverett.
Dig up and conceive rental houses and home rentals in Nantucket Massachusetts.
|
|
