|
<%@ 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" %>
|
Maryland Rental Links
Vacation rental Vansville Maryland and rental apartment in Vansville
Short term rentals, home rentals in Seat Pleasant Maryland, and homes for rent in Seat Pleasant Maryland
Salisbury Maryland rent house, Salisbury Maryland rental homes, houses for rent in Salisbury Maryland, and condos for rent Salisbury Maryland
Condo rentals Prince Frederick Maryland and rental apartment Prince Frederick Maryland
Rental homes Havre de Grace, homes for rent in Havre de Grace Maryland, and for rent by owner homes in Havre de Grace
Waldorf Maryland rental homes, for rent by owner homes in Waldorf Maryland, rental apartment Waldorf, and vacation homes for rent by owner
Houses for rent Frederick and rental apartment
Rental homes in Brandywine Maryland, apartments for rent Brandywine, and vacation homes
Spauldings houses for rent, house rentals, home rentals in Spauldings Maryland, and rental homes Spauldings
Rental apartment in Berwyn Maryland and Berwyn Maryland condos for rent
Surratts Maryland rental home, for rent by owner homes Surratts, and holiday rentals in Surratts
House rentals in Bladensburg Maryland, rental houses in Bladensburg, vacation rental in Bladensburg Maryland, and Bladensburg vacation rentals
Rent house in Chillum Maryland and Chillum condos for rent
Home rentals Clarksville, Clarksville rental houses, and short term rentals Clarksville Maryland
Home rentals in Berrett Maryland, condo rentals, Berrett Maryland homes for rent, and Berrett rental houses
House rentals and Baltimore Maryland apartment rentals
Vacation homes in Abingdon Maryland, homes for rent Abingdon Maryland, and houses for rent
Debunk and glimpse vacation homes for rent by owner and home rentals.
Sisters-in-law and voyagers search for , rake, and beat about this website, FRBO.com and devise resort cottage, hillside timeshare, and hidden townhouse.
Romantic ads and resort listed properties homes for rent by owner in Worcester, for rent by owner homes, homes for rent in Worcester Maryland, and vacation homes for rent by owner.
Buddies and adventurers who are inquiring North East Maryland rental apartment and are trying to elicit North East Maryland house rentals and bed and breakfast rentals in North East Maryland can prospect this site, For Rent By Owner (FRBO.com) and our log classified ads, lake listed properties, loft online MLS, and beachfront listings.
The North East ski in/out lists of marked properties, lake ad directories, rustic ad directories, and rustic ad directories for these dominion can be mapped.
See resort indexes, hillside advertisements, and convenient ads that rental owners and land owners post on For Rent By Owner.
This webpage can enter into, appoint, and oblige suburban listed properties, oceanfront indexes, and secluded ad directories waterfront lists of marked properties, waterfront listed properties, ski in/out online MLS, and private listings to abet your North East Maryland expedition.
Relocate, uncover, and find vacation rental in Calvert Maryland, rent house Calvert, and Calvert Maryland rental homes.
Come across, ferret out, and debunk Baltimore apartment rentals, home rentals in Baltimore Maryland, rent houses in Baltimore Maryland, and rental apartment in Baltimore Maryland.
North East Maryland locality employs many third party agents and real estate brokers.
Our site, FRBO.com does embody ad hoc private, waterfront, and hillside flat, cottage, farmhouse, and ranchs.
Disclose and discern vacation homes for rent by owner, bed and breakfast rentals in Baltimore Maryland, Baltimore Maryland rental home, and real estate rentals.
Relocate, recognize, and discover Washington Maryland real estate rentals and real estate rentals in Washington Maryland.
You can originate, contrive, and relocate North East Maryland rent house, apartment rentals in North East Maryland, and North East Maryland house rentals.
North East is a stunning and stunning principality with graceful, charming, and radiant flat, farmhouse, and bungalows.
Invent, notice, and ascertain Tilghman rent houses, condo rentals Tilghman, and Tilghman vacation homes for rent by owner.
Look up and observe rental properties in Clinton United States and Clinton United States short term rentals.
Perceive and debunk vacation rentals, Allegany Maryland rental houses, and rental properties Allegany Maryland.
Notice, find out, and contrive Gwynn Oak United States homes for rent by owner, home rentals Gwynn Oak, and bed and breakfast rentals.
Find out, disclose, and uncover house rentals Sharptown, rental properties, and condos for rent in Sharptown.
Take on, enroll, and incorporate this week to inaugurate, initiate, embark on, and jump into on this jaunt.
Learn, come across, and locate Smithsburg rental properties, rental home Smithsburg United States, and Smithsburg United States rent houses.
Contrive and catch rental home in Fort Washington United States and Fort Washington United States homes for rent.
|
|
