Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:41:48.547' ,`MLSNumber` = '12575327' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.987889' ,`Longitude` = '-95.505277' ,`PhotoCount` = '35' ,`PostalCode` = '77069' ,`RoomCount` = '3' ,`ListPrice` = '247000.00' ,`Status` = 'Active' ,`StreetName` = 'Cashel Forest' ,`StreetNumber` = '14201' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic 3 bedroom home in sought after Houston. The kitchen is equipped with updated countertops, ample cabinets. Flow into the living room featuring a cozy fireplace, perfect for entertaining. The main bedroom boasts a private en-suite with dual sinks. Other bedrooms offer plush carpet, ceiling fans, and sizable closets. Head to the backyard for the perfect private area to enjoy the outdoors. Don\'t wait! Make this beautiful home yours today.\r\n\r\nThis home has been virtually staged to illustrate its potential' ,`Acres` = '0.1125' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 3B BLK 5 017*C0362900-002-005-003B CASHEL FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4902' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cashel Forest Sec 02' ,`TaxAmount` = '5507' ,`TaxRate` = '2.61' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675215872' WHERE `Matrix_Unique_ID` = '208619084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T20:21:47.820' ,`MLSNumber` = '37684128' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.278701' ,`Longitude` = '-95.567934' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Bromley Square' ,`StreetNumber` = '308' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kepley is the 3 bedroom, 2.5 bathroom custom floor plan designed with the versatility for everything you need in a new home. The front study provides an ideal space for a work from home office. The gourmet kitchen includes a spacious walk in pantry. Relax into a quiet evening on the covered patio, or invite your friends over for a backyard cookout. The master bedroom features a deluxe walk in closet and luxury bathroom. You’ll love the little details that help make life easier, like the mudroom and the extra countertop in the laundry room.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodforest - Kingsley Square' ,`TaxAmount` = '' ,`TaxRate` = '2.793' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215872' WHERE `Matrix_Unique_ID` = '209494505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:04:08.263' ,`MLSNumber` = '40689473' ,`ListAgentFullName` = 'Wanda Taylor' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790168' ,`Longitude` = '-95.489666' ,`PhotoCount` = '10' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Archley' ,`StreetNumber` = '1201' ,`StreetSuffix` = 'Drive' ,`City` = 'Hilshire Village' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4686' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous lot in the heart of Hilshire Village on the corner of Archley and Ridgeley. Amazing opportunity to build you dream home. Existing home sold as is. Zoned to Valley Oaks, Spring Branch Middle, Memorial High. Hilshire Village is patrolled by Spring Valley Village Police.' ,`Acres` = '0.4591' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 47 BLK 5 RIDGELEY PLACE' ,`LotDesciption` = 'Corner,Ravine' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hilshire Village' ,`TaxAmount` = '22874' ,`TaxRate` = '2.4805' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215872' WHERE `Matrix_Unique_ID` = '210717289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T20:34:52.197' ,`MLSNumber` = '63789738' ,`ListAgentFullName` = 'Jon Lanclos' ,`ListOfficeName` = 'The Discovery Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.145422' ,`Longitude` = '-95.050266' ,`PhotoCount` = '34' ,`PostalCode` = '77554' ,`RoomCount` = '10' ,`ListPrice` = '989000.00' ,`Status` = 'Active' ,`StreetName` = 'Deaf P Smith' ,`StreetNumber` = '21820' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This vacation home is 4 stories tall. On the first floor there is a tiki bar with half bath and wet bar as well as a covered boat slip over the canal. Second floor has granite kitchen with living room, dining room and two guest bedrooms. On the third floor there is a game room, washer/dryer, guest bathroom, guest bedroom and master bedroom with bathroom. On the fourth floor there is a sky deck overlooking Galveston Bay. Subdivision amenities include tennis courts, boat launch, lighted fishing pier, neighborhood pool, bait shop, gas, store and restaurants.' ,`Acres` = '0.1398' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 14 & 15 LOT 1709 SEA ISLE 12TH EXTENSION' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6090' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '231' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Back,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle' ,`TaxAmount` = '8126' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215873' WHERE `Matrix_Unique_ID` = '210809615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:42:08.763' ,`MLSNumber` = '68171512' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599717' ,`Longitude` = '-95.520983' ,`PhotoCount` = '28' ,`PostalCode` = '77489' ,`RoomCount` = '3' ,`ListPrice` = '253000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Orchard' ,`StreetNumber` = '1855' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1964' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting for you! Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. The kitchen is ready for cooking with ample counter space and cabinets for storage. Head to the spacious primary suite with good layout and closet included. Extra bedrooms add nice flex space for your everyday needs. Take advantage of the extended counter space in the primary bathroom complete with double sinks and under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Don\'t wait! Make this beautiful home yours today. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1551' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS POINT ESTATES, BLOCK 3, LOT 52' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6756' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HUNTERS GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Point Estates' ,`TaxAmount` = '4651' ,`TaxRate` = '2.693' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675215873' WHERE `Matrix_Unique_ID` = '210978701' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:42:14.223' ,`MLSNumber` = '3412785' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930816' ,`Longitude` = '-95.564204' ,`PhotoCount` = '26' ,`PostalCode` = '77064' ,`RoomCount` = '4' ,`ListPrice` = '272000.00' ,`Status` = 'Active' ,`StreetName` = 'Opatrny Meadows' ,`StreetNumber` = '11147' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 4 bedroom and 2.5 bath home with a 2 car garage. Enjoy preparing meals in this impressive kitchen equipped with ample cabinets and generous counter space. Lighting, ceiling fans, and fixtures flow throughout. The main bedroom boasts a private ensuite with a separate tub and shower and dual sinks. Other bedrooms offer plush carpet, ceiling fans, and sizable closets. Relax with your favorite drink in the fenced in backyard with lush grass. Don\'t wait! Make this beautiful home yours today.\r\n This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1823' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 2 OPATRNY MEADOWS' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7943' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Opatrny Meadows' ,`TaxAmount` = '4176' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675215873' WHERE `Matrix_Unique_ID` = '211177411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:00:15.660' ,`MLSNumber` = '25009050' ,`ListAgentFullName` = 'Shelly Hyatt' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.245420' ,`Longitude` = '-95.127163' ,`PhotoCount` = '26' ,`PostalCode` = '77372' ,`RoomCount` = '9' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Colony' ,`StreetNumber` = '27960' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing home sits on 5+ acres of unrestricted land in sought-after Splendora ISD, only minutes away from major highways and shopping. Inside you will find a spacious living area with lots of natural sunlight that opens up to the kitchen/dining area that features upgraded appliances a beautifully enlarged, custom island, and a wood-burning fireplace. There are four large bedrooms and two full bathrooms. Outside you will find a shed and a barn offers endless possibilities due to its space and electricity. This is truly a diamond in the rough just needing your TLC to shine her up! Don\'t let this one get away! Schedule a private showing today!' ,`Acres` = '5.05' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY COLONY 82, LOT 21, PT LT 22, ACRES 5.05' ,`LotDesciption` = 'Cleared' ,`LotSize` = '219978' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Colony 82' ,`TaxAmount` = '4596' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675215873' WHERE `Matrix_Unique_ID` = '211281725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:03:21.730' ,`MLSNumber` = '28757870' ,`ListAgentFullName` = 'Wanda Taylor' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787981' ,`Longitude` = '-95.509199' ,`PhotoCount` = '10' ,`PostalCode` = '77055' ,`RoomCount` = '5' ,`ListPrice` = '719000.00' ,`Status` = 'Active' ,`StreetName` = 'Bace' ,`StreetNumber` = '8913' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring Valley Village' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Selling as is, great opportunity to renovate, add on, or tear down and build new! Cute 3 bedroom house with hardwood floors. Could possibly add on. Zoned to Valley Oaks Elementary, Spring Branch Middle, and Memorial High. Spring Valley Village is an amazing place to live, has it\'s own City Park, City Hall, and Police department.' ,`Acres` = '0.1882' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK B BONNIE OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Spring Valley Village' ,`TaxAmount` = '12096' ,`TaxRate` = '2.3056' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675215874' WHERE `Matrix_Unique_ID` = '213025217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T20:34:53.630' ,`MLSNumber` = '72215760' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.713179' ,`Longitude` = '-95.917754' ,`PhotoCount` = '24' ,`PostalCode` = '77441' ,`RoomCount` = '11' ,`ListPrice` = '499333.00' ,`Status` = 'Active' ,`StreetName` = 'Vineyard Creek' ,`StreetNumber` = '31522' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2987' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The stunning high curb appeal brick & stucco elevation on the popular 50\' STRASBURG is a show stopper. This new construction NEWMARK HOME is perfectly located just minutes from the major roads in CROSS CREEK WEST in the heart of FULSHEAR, TEXAS. This 2 story home features 5 bedrooms w/ 2 down and 4 full baths. The spacious formal dining leads to the chefs dream kitchen filled with hand selected architectural charms such as porcelain countertops & upgraded 42\' cabinetry. The breakfast room has a HUGE custom 3 panel sliding glass door that leads to the covered patio. The family room has a wall of windows & tall ceilings. The main suite has a deck mounted tub & a separate mud-set shower. The winding spiral staircase with open railings and stained trim leads to the upstairs game room entertainment hotspot. Energy saving spray foam insulation, a tankless hot water heater, full sprinklers, & full gutters are just a few key features of this PROFESSIONALLY DESIGNED masterpiece.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17, Block 5, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6309' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Call Occupant,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cross Creek West' ,`TaxAmount` = '' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215874' WHERE `Matrix_Unique_ID` = '213224452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:46:50.273' ,`MLSNumber` = '52578976' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787050' ,`Longitude` = '-95.330317' ,`PhotoCount` = '29' ,`PostalCode` = '77026' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Courtney' ,`StreetNumber` = '4019' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'So much has been updated in this home, it is just like a brand-new home! By far, it is the nicest home in the neighborhood! This fully renovated home features over 1600sf of living space with 4 bedrooms/3.5 baths and two of the bedrooms with their own private bathrooms. The kitchen has also been completely updated with white cabinets, granite countertops, all new SS appliances, and a walk-in pantry. Other updates include, roof, HVAC, siding, vinyl plank wood flooring, fresh interior paint, updated electrical, updated plumbing, new fixtures, stone driveway, covered parking for 3+ cars, covered patio, landscaping, and so much more! For your added security, there is privacy perimeter fencing around the entire property with an automatic gate, plus a security system with 10 security cameras. If that is not enough, there is a large custom outdoor kitchen\\outdoor BBQ area, outdoor half bath, and a huge laundry room\\storage\\workout room in the back. No MUD! No HOA! This home is a must see!' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 7 COMFORT PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Comfort Place' ,`TaxAmount` = '3599' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215874' WHERE `Matrix_Unique_ID` = '213444060' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:19:08.983' ,`MLSNumber` = '13584266' ,`ListAgentFullName` = 'Daniel Amaya' ,`ListOfficeName` = 'Jason Mitchell Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.011668' ,`Longitude` = '-95.296171' ,`PhotoCount` = '31' ,`PostalCode` = '77338' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Wood' ,`StreetNumber` = '8510' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own in the beautiful community of Kenswick in Humble! This Home sits in a cul-de-sac and features 3 bedrooms, 2 full bathrooms, tile and carpet flooring throughout, a wood burning fireplace, updated bathrooms, and a 2 car garage. Upon entering you are greeted by high ceilings, the fireplace in the living area, followed by a beautiful kitchen with breakfast bar. Beautiful ceramic tile in bathrooms, and epoxy flooring in the garage. Enjoy your private back yard area, great for hosting Family and Friends! Quick access I-59 freeway puts you minutes away from shopping and dining, Deerbrook Mall, and George Bush Intercontinental airport. Schedule your tour today!' ,`Acres` = '0.2125' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 13 KENSWICK SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9256' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '249' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Sec 02' ,`TaxAmount` = '4681' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215874' WHERE `Matrix_Unique_ID` = '213623088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:12:15.237' ,`MLSNumber` = '18207775' ,`ListAgentFullName` = 'June Onguko' ,`ListOfficeName` = 'Fortune Investment Properties' ,`SellingAgentFullName` = 'Javier Diaz' ,`SellingOfficeName` = 'J.D. Realty' ,`Latitude` = '29.859425' ,`Longitude` = '-95.704629' ,`PhotoCount` = '29' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '259000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Stockholm' ,`StreetNumber` = '6011' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride of ownership in this stunning 3 bed 2.5 bath home ideal for first time home buyer or great investment opportunity , strategically located in the Katy area. Amazing curb appeal with beautifully landscaped yard. Spacious open family room perfect for family evening gathering and entertaining. Enjoy the open spacious kitchen that boasts generous counter and cabinet space. The spacious primary suite offers a complete walk in closet and en-suite bathroom. Enjoy the well kept huge backyard perfect for entertaining, weekend barbecues and pet friendly. Call for your appointment today.' ,`Acres` = '0.1135' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 67 BLK 3 BRENWOOD TRAILS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4945' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCFEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brenwood Trls Sec 01' ,`TaxAmount` = '5192' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215874' WHERE `Matrix_Unique_ID` = '213633541' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T20:22:23.043' ,`MLSNumber` = '68898923' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.278701' ,`Longitude` = '-95.567934' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Bromley Square' ,`StreetNumber` = '312' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegance and sophistication combine with the genuine comforts that make each day delightful in this impressive new home in Woodforest – Kingsley Square! The study offers an opportunity to create that work from home office, craft room, or music studio you’ve been dreaming about. With a ceiling that rises to the second floor, the dining room makes a dynamic impression on guests. The kitchen includes a high capacity corner pantry. The spacious laundry room includes a convenient countertop. The master bathroom features a double sink vanity and an expansive walk in closet. Both upstairs bedrooms include their own walk in closets.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodforest - Kingsley Square' ,`TaxAmount` = '' ,`TaxRate` = '2.793' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215875' WHERE `Matrix_Unique_ID` = '213855514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:22:01.890' ,`MLSNumber` = '12996165' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965237' ,`Longitude` = '-95.493814' ,`PhotoCount` = '30' ,`PostalCode` = '77066' ,`RoomCount` = '14' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Grossmount' ,`StreetNumber` = '12434' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Priced so you can make this your own! Charming curb appeal welcomes you home. Over 2200+ sqft of living space to suit everyone\'s needs. Open floor plan layout. Natural lighting fills the dining area & family room, warming the atmosphere. Guests can eat in the dining area or in the eat-in kitchen. Hard surfaced floors are ideal for easy cleaning on the first floor. For extra privacy, all bedrooms are located on the second floor. An extra living space is available on the second floor & can be turned into an office, game room, or playroom – endless possibilities! The primary bedroom features a walk-in closet w/ built-in shelves for additional storage & an en-suite bath. Enjoy the outdoors in the private backyard with ample space to add a pool, garden, or playground – come make it your own! Grocery stores, restaurants & Willowbrook Mall are just up the road for your convenience.' ,`Acres` = '0.1012' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 7 TIMBER MEADOW SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KAISER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Mdw Sec 1' ,`TaxAmount` = '4489' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215875' WHERE `Matrix_Unique_ID` = '214125982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T20:49:41.370' ,`MLSNumber` = '92616539' ,`ListAgentFullName` = 'Ashley Uballe' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.011759' ,`Longitude` = '-95.545435' ,`PhotoCount` = '40' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Ridge' ,`StreetNumber` = '16910' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in a GREAT location! Close to the Vintage Park with a short commute to major freeways! Your future home will be great for a family that loves to entertain. Tile on all wet areas! Large game room on 2nd level leading to three bedrooms with amazing sized closets and both baths featuring double sinks. Primary bath is not to be confused for another room with its incredible size!! Worried about a repeated winter freeze? No worries when your own home features a gas fireplace for cozy conversations during the holidays. Microwave, dishwasher, and stove all included! As if it doesn\'t get any better, brand new backyard fence was just installed! Meticulously maintained home with lots of updates including renovated bathrooms, NEW bamboo wood floors, brand NEW carpet, and a completely updated kitchen with QUARTZ STONE countertops. What\'s not to love is the question!! Don\'t miss out and make this your home now! Oh, did I mention you are also in a cul-de-sac!? Run don\'t walk!' ,`Acres` = '0.1452' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 CHAMPION SPRINGS SEC 1 AMEND' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champion Spgs Sec 01 Amd' ,`TaxAmount` = '4761' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215875' WHERE `Matrix_Unique_ID` = '214499457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:20:07.810' ,`MLSNumber` = '4610476' ,`ListAgentFullName` = 'Joyce Keeble' ,`ListOfficeName` = 'Joyce Keeble' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731209' ,`Longitude` = '-95.320817' ,`PhotoCount` = '26' ,`PostalCode` = '77023' ,`RoomCount` = '4' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Pease' ,`StreetNumber` = '5334' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1022' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice older two bedroom home. Original Hardwoods through-out living area, bedrooms. Tile in bathroom. Recent roof replacement in 2020. recent insulation, sheetrock, texture, painted through-out (2022), electrical repairs (2022) along with other repairs. Cabinets, countertop, range, replaced -Previous owner had replaced windows and leveled foundation( 2019 Storage building, Move-in condition, Inside 610 Loop - Near downtown, good access to I-45, Downtown, Medical Center.' ,`Acres` = '0.124' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 8 & 9A BLK 14 DISSEN HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CARRILLO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dissen Heights' ,`TaxAmount` = '4312' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215875' WHERE `Matrix_Unique_ID` = '214632569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T20:11:23.073' ,`MLSNumber` = '13085175' ,`ListAgentFullName` = 'Tanya Schindler' ,`ListOfficeName` = 'South Central Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674610' ,`Longitude` = '-96.902027' ,`PhotoCount` = '36' ,`PostalCode` = '78956' ,`RoomCount` = '7' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'South' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Street' ,`City` = 'Schulenburg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderfully remodeled home on corner lot is ready for you to come inside and see all that this home has to offer. The home features tall ceilings, recent windows, new flooring, electrical, plumbing, HVAC! The electric recessed fireplace is a wonderful touch in the living room & provides nice heat or no heat if you just want to watch the flames. Feel at home in kitchen with double sink, stainless refrigerator with water and ice in the door as well as an ice maker in the freezer too. The range is gas and has a pot filler above it. Check out the cabinets as some are custom with the pull out trash receptacles, a slide tray, a true broom pantry with an outlet and soft close drawers. The breakfast island has led lights under it, a pop up charging station for plugs or usb ports and overlap on 2 sides to allow for seating. This is a well thought out multi-generational house where 3/4 of the house has 36\" openings for easy access with a wheelchair, walker or crutches.' ,`Acres` = '0.1768' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CITY OF SCHULENBURG (497) LOT FRC OF 1 BLK 54 .1767 100 X 77' ,`LotDesciption` = 'Corner' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '207 - Schulenburg' ,`SchoolElementary` = 'SCHULENBURG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCHULENBURG SECONDARY SCHOOL' ,`SchoolMiddle` = 'SCHULENBURG SECONDARY SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'City Of Schulenburg 497' ,`TaxAmount` = '1490' ,`TaxRate` = '1.7295' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675215876' WHERE `Matrix_Unique_ID` = '214822913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:44:52.870' ,`MLSNumber` = '10165411' ,`ListAgentFullName` = 'Alex White' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.031758' ,`Longitude` = '-95.790915' ,`PhotoCount` = '12' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '274990.00' ,`Status` = 'Active' ,`StreetName` = 'Simmental' ,`StreetNumber` = '23627' ,`StreetSuffix` = '' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One-story 2022 Build in the newly developed Resort-Style Windrow Community! Featuring an Open Floor Plan, Faux Plantation Shutters, Tall Ceilings, Private Office, Upgraded Kitchen with 42” cabinets, Spacious Family Room, and an Owners Suite with a Garden Tub & Shower. A short walk to the Basketball Court, Horseshoes, Playground, Tot Lot, Gated Dog Park, Recreational Pool, Covered Pavilion with a huge Fire Pit and Outdoor Kitchen. Quick access to Zube Park/Slash Pad/Disc Golf as well as Highway 290 & Grand 99 for shopping and restaurants! Move in Ready and Loaded with Upgrades. Book your tour today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 5 Windrow Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '880' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215876' WHERE `Matrix_Unique_ID` = '214981907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:44:30.920' ,`MLSNumber` = '76038502' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.978138' ,`Longitude` = '-95.403772' ,`PhotoCount` = '20' ,`PostalCode` = '77073' ,`RoomCount` = '4' ,`ListPrice` = '218000.00' ,`Status` = 'Active' ,`StreetName` = 'Verde Trails' ,`StreetNumber` = '1147' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this fabulous area! This home has fresh interior paint and partial flooring replacement. Windows create a light filled interior with well placed neutral accents. The kitchen is ready for cooking with ample counter space and cabinets for storage. You won’t want to leave the serene primary suite, the perfect space to relax. Other bedrooms provide nice flexible living space. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! A must see! This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.0595' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 REMINGTON RANCH SEC 12 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2592' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '830' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HOYLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Ranch Sec 12 Amendin' ,`TaxAmount` = '4563' ,`TaxRate` = '2.8804' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675215876' WHERE `Matrix_Unique_ID` = '215073372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:43:13.690' ,`MLSNumber` = '26657809' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.972512' ,`Longitude` = '-95.223839' ,`PhotoCount` = '17' ,`PostalCode` = '77396' ,`RoomCount` = '3' ,`ListPrice` = '237000.00' ,`Status` = 'Active' ,`StreetName` = 'Hannah Oaks' ,`StreetNumber` = '17435' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic home in sought after location! This home has fresh interior paint. Windows create a light filled interior with well placed neutral accents. Step into the kitchen, complete with an eye catching stylish backsplash. You won’t want to leave the serene primary suite, the perfect space to relax. Other bedrooms provide nice flexible living space. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Hurry, this won’t last long! This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1241' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 1 BLACKSTONE CREEK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5406' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIVER PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Blackstone Crk Sec 01' ,`TaxAmount` = '5121' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675215876' WHERE `Matrix_Unique_ID` = '215073385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T19:43:36.260' ,`MLSNumber` = '34878895' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043601' ,`Longitude` = '-95.397133' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '224000.00' ,`Status` = 'Active' ,`StreetName` = 'Cranberry' ,`StreetNumber` = '23103' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting for you! This home has fresh interior paint. Windows create a light filled interior with well placed neutral accents. Step into the kitchen, complete with an eye catching stylish backsplash. Head to the spacious primary suite with good layout and closet included. Other bedrooms provide nice flexible living space. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Finally, the backyard, a great space for entertaining and enjoying the outdoors. Don\'t miss this incredible opportunity. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1591' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 17 TIMBER LANE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane Sec 02' ,`TaxAmount` = '6198' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675215877' WHERE `Matrix_Unique_ID` = '215073449' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215117107','1675215877','215117107','2023-01-18T19:39:48.447','74803671','Darvita Mack','Darvita Mack Realty Group','','','29.599216','-95.537692','14','77489','5','245000.00','Active','Hickory Glen Dr','2004','Drive','Missouri City','2','0','3','1407','Single-Family','Beautiful home featuring 3 bedroom and 2 full baths. Formal dinning room with a view of the outdoor atrium. Updated floors, bathrooms, and kitchen. Tall gas brick fireplace. High ceilings with open floor plan perfect for entertaining.','0.1215','38','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Gas','1','HUNTERS GREEN, BLOCK 2, LOT 39','Subdivision Lot','5291','Appraisal District','','360','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','EDGAR GLOVER JR ELEMENTARY SCHOOL','MARSHALL HIGH SCHOOL (FORT BEND)','MISSOURI CITY MIDDLE SCHOOL','Appointment Required,Lockbox Right Side,Supra Keybox','Appraisal District','1','Traditional','Hunters Green','4224','2.5525','Water District','1985','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215120577','1675215877','215120577','2023-01-18T19:43:03.207','17946446','Feras Rachid','Opendoor Brokerage, LLC','','','29.808790','-95.146496','20','77049','4','254000.00','Active','Sonoma Park','16018','Drive','Houston','2','0','4','1954','Single-Family','Welcome to this fabulous area! This home has fresh interior paint and partial flooring replacement. Windows create a light filled interior with well placed neutral accents. This kitchen has everything you need! A center island, walk in pantry, and stylish backsplash accent will have you looking forward to cooking. You won’t want to leave the serene primary suite, the perfect space to relax. Extra bedrooms add nice flex space for your everyday needs. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Like what you hear? Come see it for yourself! This home has been virtually staged to illustrate its potential','0.1331','2','','','','','Sellers Disclosure','1','','0','North Channel','Central Gas','1','LT 14 BLK 4 SONOMA RANCH SEC 6','Subdivision Lot','5798','Appraisal District','','500','0','','2','','0','','','','','Other','8 - Channelview','Brown Elementary School (Channelview)','CHANNELVIEW HIGH SCHOOL','AGUIRRE JUNIOR HIGH','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Sonoma Ranch Sec 06','5504','2.518','Water District','2006','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215149187','1675215877','215149187','2023-01-18T19:42:54.390','32479058','Feras Rachid','Opendoor Brokerage, LLC','','','30.135067','-95.472483','24','77380','3','327000.00','Active','Red Cedar','11917','Circle','Spring','2','0','3','1574','Single-Family','Come see this charming home now on the market! This home has fresh interior paint throughout. A standout feature is the private, fenced-in deck where you can relax and enjoy the tranquility of the outdoors. Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. The kitchen is ready for cooking with ample counter space and cabinets for storage. You won’t want to leave the serene primary suite, the perfect space to relax. Additional bedrooms provide nice living or office space. Take advantage of the extended counter space in the primary bathroom complete with double sinks and under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Don\'t miss this incredible opportunity. This home has been virtually staged to illustrate its potential.','0.2864','15','','','','','Sellers Disclosure','','','1','The Woodlands','Central Gas','1','WDLNDS VIL GROGANS ML 03, BLOCK 1, LOT 10','Corner,Subdivision Lot','12474','Appraisal District','','0','0','','2','','0','','','','','Other','11 - Conroe','SAM HAILEY ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Wdlnds Village Grogans Ml 03','4484','2.0469','Water District','1973','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215554238','1675215877','215554238','2023-01-18T19:42:37.950','62271264','Feras Rachid','Opendoor Brokerage, LLC','','','30.056089','-95.357342','22','77373','3','256000.00','Active','Lost Cove','5103','Lane','Spring','3','0','3','2052','Single-Family','Welcome to this fabulous area! This home has partial flooring replacement. Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. The kitchen is ready for cooking with ample counter space and cabinets for storage. You won’t want to leave the serene primary suite, the perfect space to relax. Other bedrooms provide nice flexible living space. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Take it easy in the fenced in back yard. A must see! This home has been virtually staged to illustrate its potential','0.165','12','','','','','Sellers Disclosure','1','','1','Spring East','Central Gas','1','LT 20 BLK 2 VILLAGES OF SPRING OAKS SEC 3','Subdivision Lot','7187','Appraisal District','','325','0','','2','','0','','','','','Other','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Village of Spring Oaks Sec 03','6278','2.6068','Water District','2007','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215614269','1675215877','215614269','2023-01-18T19:43:21.363','53903297','Feras Rachid','Opendoor Brokerage, LLC','','','30.326058','-95.421462','21','77301','4','256000.00','Active','Shady Pine','2326','Drive','Conroe','3','1','4','2102','Single-Family','Come see this charming home now on the market! This home has fresh exterior paint. Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. The kitchen is ready for cooking with ample counter space and cabinets for storage. Head to the spacious primary suite with good layout and closet included. Additional bedrooms provide nice living or office space. In the primary bathroom you\'ll find a separate tub and shower, plus plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Don\'t miss this incredible opportunity.','0.1638','19','','','','','Sellers Disclosure','1','','1','Conroe Northeast','Central Gas','0','S874301 - SHADY WOODS 01 REPLAT, BLOCK 2, LOT 14','Cul-De-Sac,Subdivision Lot','7134','Appraisal District','','','0','','2','','0','','','','','Composition','11 - Conroe','PATTERSON ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Shady Woods','5069','2.1863','Public Water','2005','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215655699','1675215877','215655699','2023-01-18T20:22:30.890','31134933','Jace Bowlin','Real Broker, LLC','Evan Ballew','JLA Realty','30.274900','-94.932463','25','77327','4','450000.00','Pending Continue to Show','County Road 2286','679','','Cleveland','2','1','4','2338','Single-Family','Custom built on 4 acres, this beautiful home in Cleveland, TX offers 4 bedrooms, 2 bathrooms, plus an additional guest suite, and a half bathroom. Tarkington ISD. Superb curb appeal with the white painted brick and black trim, this home features tall ceilings and beautiful ceramic tile upon entry. This home\'s open floor plan will definitely impress you. With a beautiful island, granite countertops, stainless steel whirlpool appliances, and a large walk-in pantry, the kitchen is full of storage. With dual sinks, separate shower and bathtub, and a large walk-in closet with built-in storage, the main suite is spacious and ready for relaxation. Additionally, there are three more nice sized bedrooms and a full bath. The back yard has a large covered patio with fans and recessed lighting waiting for you to entertain. There is a guest suite with its own half bath located just off the patio. Zoned to TARKINGTON ISD! 20x10 shed included!','4','52','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','','Cleveland Area','Central Electric','0','000447 M TANNER, TRACT 69, ACRES 4.0','Wooded','174240','Appraisal District','','','0','','0','Single Oven','0','','','Electric Range','','Composition','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Ranch','M Tanner','4677','1.5226','Aerobic,Septic Tank,Well','2020','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215881396','1675215877','215881396','2023-01-18T20:19:35.503','85107185','Beverly Bradley','Weekley Homes','','','30.279456','-95.567858','50','77316','7','445000.00','Active','Bungalow','183','Drive','Montgomery','2','1','3','2408','Single-Family','Welcome home to the classic comfort and contemporary design combination of The Ziegler luxury home plan. Each upstairs bedroom provides a great place to grow and its own walk-in closet. The sunlit open floor plan is suited for daily life and hosting special occasions, and offers a beautiful backyard view. Easily prepare family meals and party spreads in the streamlined kitchen. Enjoy the outdoors from the comfort of your generous covered patio. Your owner\'s retreat gives you a beautiful place to begin and end every day in luxury with a deluxe bathroom with super shower and walk-in closet. The upstairs retreat and downstairs study and dining areas provide FlexSpace for you to design the specialty rooms you\'ve been dreaming of. Build your future together in this splendid new home plan.','','39','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Conroe Southwest','Central Gas,Zoned','1','Lot 5 Block 3','Cul-De-Sac,Subdivision Lot','5250','Survey','','1300','1','Never Lived In','2','Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','37 - Montgomery','LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','2','Contemporary/Modern','Woodforest','','3.356','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216119866','1675215877','216119866','2023-01-18T20:14:45.273','35357917','Beverly Bradley','Weekley Homes','','','30.209379','-95.750782','13','77354','7','349990.00','Active','Summer Crest','42522','Road','Magnolia','2','1','3','2413','Single-Family','NEW DAVID WEEKLEY HOME! Guaranteed heating and cooling usage for three years with our Environments for Living program! The Thornleigh is designed to provide plenty of FlexSpace? so the home can change to meet your family’s ever-changing needs. The open floor plan welcomes your design choices and personal style. Cook up culinary delights in the gourmet kitchen, featuring an elegant island. Your grand suite is an inviting everyday escape, and includes a luxury bathroom with super shower and a deluxe walk in closet. Each of the extra bedrooms provide a beautiful space with wide closets and plenty of personality. Kids of all ages will enjoy the upstairs gameroom. Enjoy a beautiful cul-de-sac homesite with room to grow.','','15','David Weekley Homes','','','','Home Protection Plan','1','','0','Magnolia/1488 West','Central Gas','1','Lot 20 Block 1','Cul-De-Sac,Subdivision Lot','','Survey','','900','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','2','Traditional','Magnolia Escondido','','3.22','Public Sewer','','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216281010','1675215877','216281010','2023-01-18T20:38:14.413','68634706','Suzy Pittman','Texas Made Realty','','','29.380139','-94.977305','16','77591','6','179900.00','Active','Bell','309','Drive','Texas City','2','0','2','1316','Single-Family','ONLY 22 MINUTES and you can have your toes in the sand!!! DELIGHTFUL COTTAGE STYLE home boasting FRESHLY PAINTED INTERIOR. ADDITIONAL UPGRADES INCLUDE RECENT CARPET AND LIGHT FIXTURES. The home benefits from 2 bedrooms and 2 full bathrooms. The entryway opens up to the living and dining areas with stylish chandelier, ceiling fan AND GORGEOUS WOOD-LIKE TILE FLOORING! The kitchen features RECENT OVEN AND RANGE, rich wood cabinets and plenty of counter space for meal preparation. The back yard is fully fenced with a recently build picket fence. The home is ideally located with easy access to Downtown Houston and Galveston Island.','0.1148','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Texas City','Central Electric','0','ABST 197 T TOBY SUR LOT 4 HERBERT BELL UNRECORDED SUB','Corner,Subdivision Lot','5000','Appraisal District','','','0','','0','Freestanding Oven','0','','','Electric Range','','Composition','52 - Texas City','SIMMS ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Bell H','3848','2.582','Public Water','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216335925','1675215877','216335925','2023-01-18T20:22:01.860','55078686','Jeremy Roberts','Value Roc','','','29.560968','-95.128363','38','77062','9','290000.00','Active','Reseda','16118','Circle','Houston','3','0','4','2366','Single-Family','Welcome to a RARE find in Clear Lake! This 3 bedroom, 2 bathroom home also boasts a garage apartment! All single story, the 1 bedroom, 1 bathroom garage apartment with kitchen is the PERFECT space for older children or in laws! NO CARPET in the main home. The entire property has neutral tones throughout to match any decor! The backyard is an entertainer\'s dream with a covered patio, wood deck, and lush green space! This home is situated on a corner lot of a cul-de-sac street and is a quick walk away from the beautiful Exploration Green! Restaurants, multiple grocery stores, and NASA\'S Johnson Space Center, and I-45 are all minutes away. To top it off, this home is zoned to award-winning CCISD schools. Don\'t miss out, schedule a showing today!','0.1791','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','','1','Clear Lake Area','Central Gas','1','LT 9 BLK 9 CLEAR LAKE CITY CORE D SEC 1','Cul-De-Sac,Subdivision Lot','7800','Appraisal District','','100','0','','0','Electric Oven','0','','','Gas Cooktop','','Composition','9 - Clear Creek','WHITCOMB ELEMENTARY SCHOOL','CLEAR LAKE HIGH SCHOOL','CLEARLAKE INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Clear Lake City Core D Sec 01','7129','2.5769','Public Sewer,Public Water','1968','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216339281','1675215877','216339281','2023-01-18T20:26:21.640','59574503','Beverly Bradley','Weekley Homes','','','30.223948','-95.780464','50','77354','7','422000.00','Active','Ivory Fort','1312','Street','Magnolia','3','0','4','2371','Single-Family','Remarkable gathering areas and superb bedrooms are just two of the inspirations that make The Artesian by David Weekley Homes a great new home plan. Your open family and dining rooms are surrounded by big, energy-efficient windows to allow every day to shine. A tasteful kitchen rests at the heart of this home, balancing impressive style with easy function, all while maintaining an open design that flows throughout the living spaces. Your Owner’s Retreat includes a contemporary en suite bathroom and a walk-in closet, making it easier to find the rest and refreshment you need at the end of each day. Two junior bedrooms and a guest suite provide ample privacy for every member of the family. The versatile study presents a great opportunity to create a welcoming lounge or home office. David Weekley’s World-class Customer Service will make the building process a delight with this impressive new home plan.','','15','David Weekley Homes','','','','Home Protection Plan','1','','0','Magnolia/1488 West','Central Gas','1','Lot 18 Block 1','Subdivision Lot','','Survey','','900','1','Never Lived In','4','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Escondido','','','Public Sewer','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216481380','1675215877','216481380','2023-01-18T19:19:29.403','3344271','Lea Jamandre','Keller Williams Realty - Memor','','','29.699596','-95.366895','32','77021','8','165000.00','Active','Cadillac','6635','Street','Houston','2','0','3','1683','Single-Family','Location, Location Location! Easy access to freeways, around 10min away from Texas Medical Center, Downtown Houston via the expanded Highway 288. One mile to Hermann Park golf course, the Houston Zoo and the Houston Museum District. Good project home for remodel or for new construction. Not in the flood zone. \r\n\r\nSeller Disclosure and Home Inspection are posted here.','0.1537','4','','','','','Sellers Disclosure','1','','','University Area','Central Electric','0','LT 9 BLK 5 SOUTHLAND PLACE','Other','6695','Appraisal District','','','0','','','Double Oven','0','','','Electric Range','','Composition','27 - Houston','THOMPSON ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front','Appraisal District','1','Other Style','Southland Place','3959','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216520163','1675215877','216520163','2023-01-18T20:11:52.480','37763802','Beverly Bradley','Weekley Homes','','','30.209379','-95.750782','49','77354','9','340000.00','Active','Quail Valley','42434','Lane','Magnolia','2','1','4','2552','Single-Family','NEW DAVID WEEKLEY HOME! Guaranteed heating and cooling usage for three years with our Environments for Living program! Breathtaking luxury and enchanting comforts make The Brinwood a once-in-a-lifetime family home plan. Craft your ideal specialty rooms in the sensational versatility of the downstairs study and the upstairs retreat. Each spare bedroom offers a walk-in closet and plenty of room for personal growth and decorative style. Your cheerful open floor plan is the perfect place for daily life and hosting unforgettable celebrations. The glamorous kitchen features a full-function island, a walk in pantry, and an abundance of cabinets and countertops. Your awe-inspiring Owner’s Retreat provides a serene way to begin and end each day with a modern bathroom and a wardrobe-expanding walk-in closet. Bonus features include a downstairs powder room and extra storage spaces. Build your future with the peace of mind that Our Industry-leading Warranty brings to this new home plan.','','15','David Weekley Homes','','','','Home Protection Plan','1','','0','Magnolia/1488 West','Central Gas','1','Lot 25 Block 2','Corner,Subdivision Lot','','Survey','','900','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','2','Traditional','Magnolia Escondido','','','Public Sewer','','Builder'); --> New record created successfully