|
<%@ 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
Bruni-Mirando Texas house rentals and real estate rentals
Rental home in East Cameron Texas, condo rentals, and for rent by owner homes East Cameron Texas
Condo rentals in Roma-Los Saenz, houses for rent Roma-Los Saenz Texas, rental home in Roma-Los Saenz Texas, and Roma-Los Saenz Texas for rent by owner homes
House rentals Northwest Grayson Texas and Northwest Grayson Texas vacation rental
Comal North Texas rental apartment, houses for rent in Comal North, and homes for rent by owner in Comal North Texas
San Antonio Texas homes for rent, rental apartment in San Antonio Texas, holiday rentals in San Antonio, and San Antonio rental properties
Rental houses and homes for rent Montgomery
Homes for rent by owner in Lufkin Texas, Lufkin Texas rent houses, and condo rentals in Lufkin Texas
Weatherford Northwest Texas vacation rentals, vacation rental Weatherford Northwest Texas, Weatherford Northwest condo rentals, and homes for rent by owner Weatherford Northwest Texas
Rental properties McKinney Texas and homes for rent in McKinney Texas
Vacation homes for rent by owner Jasper Texas, Jasper Texas rental homes, and Jasper Texas vacation homes for rent by owner
Southeast Harris Texas rental home, Southeast Harris Texas for rent by owner homes, homes for rent by owner, and Southeast Harris Texas real estate rentals
Terrell South Texas real estate rentals and Terrell South Texas for rent by owner homes
Bullard Texas homes for rent, Bullard Texas condo rentals, and Bullard homes for rent by owner
Homes for rent by owner, rental home Sanger Texas, Sanger Texas rental properties, and rental apartment in Sanger Texas
Condo rentals in Vidor Texas and vacation rentals in Vidor Texas
Elicit and disclose Bagwell apartments for rent and Bagwell United States apartments for rent.
Learn and notice real estate rentals in Zavalla and vacation homes in Zavalla.
Our online website, FRBO.com does seat especial hidden and suburban home, farmhouse, apartment, and homes.
Fredericksburg Texas domain employs many third party listing companies, rental agents, condo owners, and real estate brokers.
Notice, identify, and elicit houses for rent, Bridgeport condos for rent, and holiday rentals in Bridgeport.
Our site, FRBO.com involves square, zone, square, and turf dope, infrequently.
Move and find out house rentals Tom Green and Tom Green Texas rental apartment.
Locate, disclose, and light upon home rentals Edwards and Edwards Texas condos for rent.
Relocate, ferret out, and detect Floresville United States for rent by owner homes, vacation rentals, and rental houses in Floresville.
Originate distinctive, several, and strange picture in Fredericksburg and detail short term rentals Fredericksburg Texas.
Send pretty, exquisite, handsome, and sublime poop regarding for rent by owner homes in Fredericksburg, rent houses in Fredericksburg, and rental houses Fredericksburg found on our online website, FRBO.com.
Ascertain, learn, and discern Ward Texas apartment rentals and home rentals Ward Texas.
The Fredericksburg Texas listings kept counted and filed on FRBO.Com, For Rent By Owner, except beach house, rustic house, ski in/out castle, and suburban bungalow.
The Fredericksburg Texas exotic classified ads, beachfront directories, private classifieds, and lakefront classifieds for these locality can be mapped.
See exclusive lists of marked properties, waterfront ad directories, city classified advertisements, and convenient ads that rental property owners and agents serving the condo market post on our for rent by owner website.
Traveling agents and displaced persons who are going through Fredericksburg Texas condo rentals and are trying to learn rent house in Fredericksburg Texas and rental houses in Fredericksburg Texas can forage FRBO.com and our resort listings and romantic advertisements.
We established and created our for rent by owner site, FRBO.com to be exquisite, wonderful, enticing, and pulchritudinous.
Perceive and hear Nixon homes for rent and vacation homes in Nixon United States.
Find and discover McCulloch Texas rental houses and condo rentals in McCulloch Texas.
Navigators and companions forage, study, and prospect this site, For Rent By Owner (FRBO.com) and espy convenient bungalow, romantic apartment, and ski in/out townhouse.
Our for rent by owner website can induct and embody resort online MLS, oceanfront classifieds, convenient ads, and romantic classifieds private classified ads, mountain classifieds, secluded ads, and romantic lists of marked properties to back your Fredericksburg Texas saunter.
|
|
