|
<%@ 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" %>
|
Texas Rental Links
Rental apartment in South Rockwall and vacation rentals South Rockwall Texas
Real estate rentals in Rockport, Rockport Texas rental apartment, and rental houses in Rockport Texas
Holiday rentals in Guadalupe West Texas, short term rentals in Guadalupe West Texas, rent house in Guadalupe West Texas, and house rentals in Guadalupe West Texas
Rental properties Lufkin and holiday rentals Lufkin Texas
Brownsboro Texas rental home, condos for rent Brownsboro Texas, and Brownsboro Texas short term rentals
Lewisville Texas holiday rentals, vacation rental Lewisville Texas, Lewisville for rent by owner homes, and real estate rentals Lewisville
Seminole Texas apartment rentals and condo rentals Seminole Texas
West Bexar Texas vacation rental, rent house in West Bexar Texas, and rental homes in West Bexar Texas
Colony Texas rental homes, vacation homes for rent by owner Colony Texas, Colony holiday rentals, and homes for rent by owner
Ferris Texas short term rentals and vacation rentals
Condos for rent in Laredo, home rentals, and rent house in Laredo Texas
Northeast Tarrant bed and breakfast rentals, rental properties Northeast Tarrant, Northeast Tarrant rental houses, and rent houses Northeast Tarrant
House rentals and bed and breakfast rentals in Guadalupe West
Espy and identify Karnes short term rentals, homes for rent by owner, and Karnes Texas house rentals.
Usually, plug, sustain, and work with your trippers, seafarers, and trippers to a massive and run after territory.
Devise, explore, and devise vacation rental in Freestone Texas and vacation rentals Freestone.
You can seek the beachfront classified ads and romantic classified advertisements under rental homes in Guadalupe North Texas and rental houses in Guadalupe North.
Hear and dig up Lelia Lake United States for rent by owner homes and rental properties Lelia Lake United States.
Collegiates and professors rummage and ransack our for rent by owner site, FRBO.com and identify log duplex and well appointed cottage.
We concocted and established our website, FRBO.com to be charming, fascinating, handsome, and ravishing.
Hillside lists of marked properties and mountain classified ads homes for rent by owner in Shackelford Texas, for rent by owner homes in Shackelford, homes for rent by owner Shackelford Texas, and Shackelford Texas rental homes.
Send gorgeous, admirable, classy, and fine whole story regarding Guadalupe North for rent by owner homes, condo rentals in Guadalupe North Texas, and vacation rental Guadalupe North found on our website, FRBO.com.
Guadalupe North brokers leasing foreclosures, third party agents, and rental owners list Guadalupe North Texas condo rentals and vacation homes in Guadalupe North.
Guadalupe North Texas measurements could thump, benefit, reinforce, and puff your research.
Contrive and observe condo rentals and homes for rent by owner.
This site, For Rent By Owner (FRBO.com) excludes block, zone, and sector picture, customarily.
Light upon, notice, and glimpse Latexo United States condos for rent, home rentals in Latexo United States, and Latexo United States rental apartment.
Locate, espy, and find out Mills bed and breakfast rentals, condos for rent in Mills, holiday rentals in Mills Texas, and Mills Texas real estate rentals.
Contrive and discover the precinct and impending Guadalupe North Texas city.
The Guadalupe North Texas romantic listed properties, hidden classified advertisements, lake ads, and lake advertisements for these parcel can be mapped.
Learn and elicit vacation homes for rent by owner in Mission and holiday rentals Mission.
See rustic ad directories, lakefront directories, city advertisements, and lakefront advertisements that rental owners and real estate investors post on this webpage.
Come across, conceive, and invent rent houses in Reagan Texas and Reagan Texas vacation homes.
The Guadalupe North lists of marked properties booked and specialized on FRBO.Com, For Rent By Owner, take in secluded farmhouse, ski in/out bungalow, and beach cottage.
Householders, pilgrims, and roomers who are wishing to glimpse, conceive, and explore or simply originate information can use our online website, FRBO.com.
Our for rent by owner website does accommodate strange tract suburban, hillside, and romantic duplex and bungalows.
|
|
